QRY_RUN_TREEPRM

index back

Rcd for Treeprmpt params


  • Parent record: QUERY_RUN_CNTRL
  • PeopleSoft Field NameField TypeColumn TypeDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
    RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
    SELNUMNumber(2,0)SMALLINT NOT NULLSelect Number
    CRTNUMNumber(3,0)SMALLINT NOT NULLCriteria Number
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    EXPRESSIONTEXTLong CharacterCLOBExpression Text
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19