EOAWUSER_LIST

(SQL Table)
 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: EOAWUSER_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWUSER_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 EOAWUSER_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: EOAW_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 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: EOAWPACKAGE_VW

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

    Prompt Table: EOAWAPCLSPTH_VW

    9 APP_CLASS Character(254) VARCHAR2(254) NOT NULL Implementation App Class
    10 EOAWROLENAME Character(30) VARCHAR2(30) NOT NULL Recipients have to be in this role in order to act as approvers

    Prompt Table: PSROLEDEFN_VW

    11 INPUT_OPTN Number(3,0) SMALLINT NOT NULL Input Option
    12 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN_VW2

    13 RTE_CNTL_PROFILE Character(30) VARCHAR2(30) NOT NULL Route Control Profile

    Prompt Table: RTE_CNTL_PROF