PTAFAW_STEP(SQL Table) |
Index Back |
|---|---|
Approval StepApproval Step |
| # | 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_NBR |
Number(6,2) | DECIMAL(5,2) NOT NULL |
Sequence number of step in its path
Default Value: 1 |
| 7 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
| 8 | PTAFAPPROVER_LIST | Character(30) | VARCHAR2(30) NOT NULL |
List of Approvers
Prompt Table: PTAFUSER_LIST |
| 9 | PTAFAPPROVER_SW | Character(1) | VARCHAR2(1) NOT NULL |
All vs. Some Specified Number of Approvers Needed
N=Some Approvers Required Y=All Approvers Required Default Value: N |
| 10 | PTAFMIN_APPROVERS | Number(2,0) | SMALLINT NOT NULL |
Minimum Approvers
Default Value: 1 |
| 11 | PTAFROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Recipients have to be in this role in order to act as approvers
Prompt Table: PSROLEDEFN_VW |
| 12 | PTAFSELF_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Self Approval Option
N=No Y=Yes |
| 13 | PTAFSELF_CRTA_ID | Character(100) | VARCHAR2(100) NOT NULL | Self-approval Criteria Id |
| 14 | PTAFREVIEWER_LIST | Character(30) | VARCHAR2(30) NOT NULL |
List of Reviewers
Prompt Table: PTAFUSER_LIST |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | PTAFCRTA_ID | Character(100) | VARCHAR2(100) NOT NULL | Criteria ID |