PSQRYSELECT

index back

Query Select


  • Parent record: PSQRYDEFN
  • 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
    SELECTTYPE Number(1,0) SMALLINT NOT NULL Selection Type
    PARENTSELNUM Number(2,0) SMALLINT NOT NULL Parent Select Number
    RCDCOUNT Number(2,0) SMALLINT NOT NULL Record Count
    FLDCOUNT Number(3,0) SMALLINT NOT NULL Field Count
    CRTCOUNT Number(3,0) SMALLINT NOT NULL Criteria Count
    QRYDISTINCT Character(1) VARCHAR2(1) NOT NULL Distinct
    HAVECRTCOUNT Number(3,0) SMALLINT NOT NULL Having Criteria Count
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19