EOAW_PATH

#	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_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Step Source - Static or Dynamic D=Dynamic S=Static Default Value: S
7	EOAWNUMBER_HOURS	Number(2,0)	SMALLINT NOT NULL	Number of Hours
8	EOAWNUMBER_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days
9	EOAWESCALATN_OPTN	Character(1)	VARCHAR2(1) NOT NULL	1-Notify Approver 2-Notify Supervisor 3-Notify Approver & Supervisor 4-Skip to Next Step 5-Skip to Next Step & Notify Appover 6-Skip to Next Step & Notify Appover 7-Skip to Next Step & Notify Appover & Supervisor A=Advance Approval C=Cancel Approval N=Notify Participant R=Reassign Approval
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	EOAWCRTA_ID	Character(100)	VARCHAR2(100) NOT NULL	Criteria ID Field
12	EOAWSKIP_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Skip Prior Steps For Requester N=Do Not Skip Prior Steps Y=Skip Prior Steps Default Value: N
13	EOAWAUTH_SW	Character(1)	VARCHAR2(1) NOT NULL	Check Authorization Default Value: N
14	EOAWFIRST_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Require at least one approver Default Value: N
15	EOAWREQUIREFIRST	Character(1)	VARCHAR2(1) NOT NULL	Used as the require at least one approver in Approvls. Default Value: N
16	EOAWSKIP_UNAUTHED	Character(1)	VARCHAR2(1) NOT NULL	Skip users that are not authorized to approve the req. Y/N Table Edit
17	DESCRLONG	Long Character	CLOB	Long Description
18	EOAWNOTIFY_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Notify Admin on No Approvers Y/N Table Edit Default Value: N