PTAFAW_PATH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTAFPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
2	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	PTAFSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Stage Number
5	PTAFPATH_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Path ID
6	PTAFSTEP_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Step Source - Static or Dynamic D=Dynamic S=Static Default Value: S
7	PTAFNUMBER_HOURS	Number(2,0)	SMALLINT NOT NULL	Number of Hours
8	PTAFNUMBER_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of Days
9	PTAFESCALATN_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 N=Notify Participant R=Reassign Approval
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	PTAFCRTA_ID	Character(100)	VARCHAR2(100) NOT NULL	Criteria ID
12	PTAFSKIP_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	PTAFAUTH_SW	Character(1)	VARCHAR2(1) NOT NULL	Check Authorization Default Value: N
14	PTAFFIRST_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Require at least one approver Default Value: N
15	PTAFREQUIREFIRST	Character(1)	VARCHAR2(1) NOT NULL	Used as the require at least one approver in Approvls. Default Value: N
16	PTAFSKIP_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	PTAFNOTIFY_ADMIN	Character(1)	VARCHAR2(1) NOT NULL	Notify Admin on No Approvers Y/N Table Edit Default Value: N