PSQRYRECORD

index back

Query Record


  • Parent record: PSQRYSELECT
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    SELNUM Number(2,0) SMALLINT NOT NULL Select Number
    RCDNUM Number(2,0) SMALLINT NOT NULL Record Number
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    JOINTYPE Number(1,0) SMALLINT NOT NULL Join Type
    JOINRCDNUM Number(2,0) SMALLINT NOT NULL Join Record Number
    JOINFLDNUM Number(3,0) SMALLINT NOT NULL Join Field Number
    CORRNAME Character(5) VARCHAR2(5) NOT NULL Correlation Name
    QRYRECPRUNABLE Character(1) VARCHAR2(1) NOT NULL Prunable flag

    Default: N

    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20