PTAFUSER_LIST

index back

User List Definition

Maps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions.

  • Related language record: PTAFUSER_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAFUSER_LIST_IDCharacter(30)VARCHAR2(30) NOT NULLIdentifies the user list to be used when creating the approval process.
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PTAFUSER_SOURCECharacter(1)VARCHAR2(1) NOT NULLUser List Source
    C=Application Class
    Q=Query
    R=Role
    S=SQL Definition

    Default: R

    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: PTAF_SQLID_VW

  • ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_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
    PTAFROLENAMECharacter(30)VARCHAR2(30) NOT NULLRecipients have to be in this role in order to act as approvers

    Prompt Table: PSROLEDEFN_VW

    INPUT_OPTNNumber(3,0)SMALLINT NOT NULLInput Option
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19