EOAW_STEP

(SQL Table)
 Index Back

Approval Step

Approval Step

  • Related Language Record: EOAW_STEP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number
    5 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
    6 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path

    Default Value: 1

    7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

    Default Value: 1

    8 EOAWAPPROVER_LIST Character(30) VARCHAR2(30) NOT NULL List of Approvers

    Prompt Table: EOAWUSER_LIST

    9 EOAWAPPROVER_SW Character(1) VARCHAR2(1) NOT NULL All vs. Some Specified Number of Approvers Needed
    N=Some Approvers Required
    Y=All Approvers Required

    Default Value: N

    10 EOAWMIN_APPROVERS Number(2,0) SMALLINT NOT NULL Minimum Approvers

    Default Value: 1

    11 EOAWROLENAME Character(30) VARCHAR2(30) NOT NULL Recipients have to be in this role in order to act as approvers

    Prompt Table: PSROLEDEFN_VW

    12 EOAWSELF_APPROVAL Character(1) VARCHAR2(1) NOT NULL Self Approval Option
    N=No
    Y=Yes
    13 EOAWSELF_CRTA_ID Character(100) VARCHAR2(100) NOT NULL Approval Framework Definition Self Approval Criteria
    14 EOAWREVIEWER_LIST Character(30) VARCHAR2(30) NOT NULL List of Reviewers

    Prompt Table: EOAWUSER_LIST

    15 EOAW_REQSTR_SW Character(1) VARCHAR2(1) NOT NULL Route to Requestor switch.

    Y/N Table Edit

    16 EOAW_FILTER_REQ Character(1) VARCHAR2(1) NOT NULL Filter Requester from step

    Y/N Table Edit

    Default Value: N

    17 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    18 EOAWCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID Field
    19 EOAW_EXTERN_FLAG Character(1) VARCHAR2(1) NOT NULL External Approver

    Y/N Table Edit

    Default Value: N

    20 EOAW_STEP_ERRACT Character(1) VARCHAR2(1) NOT NULL Error Action for the step defintion
    E=Route to admin on error
    N=Route to next step on error
    P=Use process defintion setting

    Default Value: P