PSQRYRECORD

index back

Query Record


  • Parent record: PSQRYSELECT
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
    RCDNUMNumber(2,0)SMALLINT NOT NULLRecord Number
    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
    JOINTYPENumber(1,0)SMALLINT NOT NULLJoin Type
    JOINRCDNUMNumber(2,0)SMALLINT NOT NULLJoin Record Number
    JOINFLDNUMNumber(3,0)SMALLINT NOT NULLJoin Field Number
    CORRNAMECharacter(5)VARCHAR2(5) NOT NULLCorrelation Name
    QRYRECPRUNABLECharacter(1)VARCHAR2(1) NOT NULLPrunable flag

    Default: N

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19