EOAW_AUTH_DTL

(SQL Table)
Index Back

Authorization Detail

Authorization Detail for Approvals

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
2 EFFDT Date(10) DATE Effective Date
3 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
4 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

Prompt Table: EOAWROLEDEFN_VW

5 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

Prompt Table: PSROLEUSER_SRCH

6 EOAWCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID Field
7 EOAWSELF_CRTA_ID Character(100) VARCHAR2(100) NOT NULL Approval Framework Definition Self Approval Criteria