HR_ACTN_USERLST

(SQL View)
 Index Back

HR action list NLD

HR action list NLD. Contains User List Used by The Action List process for the Netherlands.

SELECT PTAFUSER_LIST_ID ,DESCR ,PTAFUSER_SOURCE ,QRYNAME ,SQLID ,ROLENAME ,APP_CLASS ,PTAFROLENAME ,INPUT_OPTN FROM PS_PTAFUSER_LIST WHERE PTAFUSER_SOURCE <> 'Q'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAFUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 PTAFUSER_SOURCE Character(1) VARCHAR2(1) NOT NULL User List Source
C=Application Class
Q=Query
R=Role
S=SQL Definition

Default Value: R

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

Prompt Table: QRY_NAME_VW

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

    • 6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: PSROLEDEFN_VW

    7 APP_CLASS Character(254) VARCHAR2(254) NOT NULL Implementation App Class
    8 PTAFROLENAME Character(30) VARCHAR2(30) NOT NULL Recipients have to be in this role in order to act as approvers

    Prompt Table: PSROLEDEFN_VW

    9 INPUT_OPTN Number(3,0) SMALLINT NOT NULL Input Option