PTAFCRTA

 index back

Criteria Definition

Criteria used primerily for Approvals.

  • Related language record: PTAFCRTA_LNG

    • PeopleSoft Field Name Field Type Column Type Description
    PTAFCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    PTAFCRTA_SOURCE Character(1) VARCHAR2(1) NOT NULL Criteria Source i.e. Query, SQL, Application Class
    C=Application Class
    Q=Query
    S=SQL Definition
    T=Always True
    U=User Entered

    Default: U

    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: QRY_NAME_VW

    SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: SQLID_VW

    • PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: PTAFPACKAGE_VW

    APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path

    Prompt Table: PTAFAPCLSPTH_VW

    APP_CLASS Character(254) VARCHAR2(254) NOT NULL Implementation App Class
    PTAFCRITERIA_FLG Character(1) VARCHAR2(1) NOT NULL Flag for whether all criteria are needed or any
    A=All
    O=One

    Default: A

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