PTAFCRTA

index back

Criteria Definition

Criteria used primerily for Approvals.

  • Related language record: PTAFCRTA_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAFCRTA_IDCharacter(100)VARCHAR2(100) NOT NULLCriteria ID
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PTAFCRTA_SOURCECharacter(1)VARCHAR2(1) NOT NULLCriteria Source i.e. Query, SQL, Application Class
    C=Application Class
    Q=Query
    S=SQL Definition
    T=Always True
    U=User Entered

    Default: U

    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: QRY_NAME_VW

    SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL 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

  • PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID

    Prompt Table: PTAFPACKAGE_VW

    APPCLASS_PATHCharacter(254)VARCHAR2(254) NOT NULLApplication Class Full Path

    Prompt Table: PTAFAPCLSPTH_VW

    APP_CLASSCharacter(254)VARCHAR2(254) NOT NULLImplementation App Class
    PTAFCRITERIA_FLGCharacter(1)VARCHAR2(1) NOT NULLFlag for whether all criteria are needed or any
    A=All
    O=One

    Default: A

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