EOAW_PRCS

(SQL Table)
Index Back

Approval Process Definition

This table holds the Approval Process definition properties

  • Related Language Record: EOAW_PRCS_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

    Prompt Table: EOAW_TXN

    2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 EOAWADMIN_ROLENAME Character(30) VARCHAR2(30) NOT NULL Rolename of Approval Workflow Administrator

    Prompt Table: PSROLEDEFN_VW

    7 EOAWACT_LINE_LEVEL Character(1) VARCHAR2(1) NOT NULL Take Final Action at Line Level
    N=No
    Y=Yes

    Default Value: Y

    8 EOAWAUTO_APPROVE Character(1) VARCHAR2(1) NOT NULL Automatically Approve

    Default Value: N

    9 EOAWFIELD_LIST_ID Character(30) VARCHAR2(30) NOT NULL Field List ID

    Prompt Table: EOAWFIELD_LIST

    10 EOAWCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID Field
    11 EOAWDEFN_CRTA_ID Character(100) VARCHAR2(100) NOT NULL Approval Framework Definition Criteria
    12 EOAW_REQSTR_SW Character(1) VARCHAR2(1) NOT NULL Route to Requestor switch.

    Y/N Table Edit

    Default Value: N

    13 EOAW_INCL_REQSTR Character(1) VARCHAR2(1) NOT NULL Include Requester

    Y/N Table Edit

    14 EOAWDEFN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Process Definition

    Y/N Table Edit

    Default Value: N

    15 EOAWDEFN_PRIORITY Number(3,0) SMALLINT NOT NULL Approval Framework Definition Priority

    Default Value: 1

    16 EOAW_CALENDAR Character(10) VARCHAR2(10) NOT NULL Calendar ID

    Prompt Table: EOAW_CALENDAR

    17 EOAW_PRCS_ERRACT Character(1) VARCHAR2(1) NOT NULL Error Action for the process defintion
    E=Route to admin on error
    N=Route to next step on error

    Default Value: N

    18 EOAW_PRCS_NOTIFMG Character(1) VARCHAR2(1) NOT NULL Meger Notification Flag
    N=No
    Y=Yes

    Default Value: Y