PTAFAW_PATH |
index back |
---|---|
Approval Path Definition |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Definition ID |
EFFDT | Date(10) | DATE NOT NULL | Effective Date |
PTAFSTAGE_NBR | Number(3,0) | SMALLINT NOT NULL | Stage Number |
PTAFPATH_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Path ID |
PTAFSTEP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Step Source - Static or Dynamic
D=Dynamic S=Static Default: S |
PTAFNUMBER_HOURS | Number(2,0) | SMALLINT NOT NULL | Number of Hours |
PTAFNUMBER_DAYS | Number(3,0) | SMALLINT NOT NULL | Number of Days |
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 |
DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
PTAFCRTA_ID | Character(100) | VARCHAR2(100) NOT NULL | Criteria ID |
PTAFSKIP_PRIOR | Character(1) | VARCHAR2(1) NOT NULL |
Skip Prior Steps For Requester
N=Do Not Skip Prior Steps Y=Skip Prior Steps Default: N |
PTAFAUTH_SW | Character(1) | VARCHAR2(1) NOT NULL |
Check Authorization
Default: N |
PTAFFIRST_STEP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Require at least one approver
Default: N |
PTAFREQUIREFIRST | Character(1) | VARCHAR2(1) NOT NULL |
Used as the require at least one approver in Approvls.
Default: N |
PTAFSKIP_UNAUTHED | Character(1) | VARCHAR2(1) NOT NULL |
Skip users that are not authorized to approve the req.
Y/N Table Edit |
DESCRLONG | Long Character | CLOB | Long Description |
PTAFNOTIFY_ADMIN | Character(1) | VARCHAR2(1) NOT NULL |
Notify Admin on No Approvers
Y/N Table Edit Default: N |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |