PTAFPRCS_IDPTAFDEFN_IDEFFDTDefault Value: %date
PTAFSTAGE_NBRDefault Value: 10
Default Value: 1
0=Header
1=Line
PTAFAW_STAGE(SQL Table) |
Index Back |
|---|---|
Approval StageApproval Stage |
| # | 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
Default Value: %date |
| 4 | PTAFSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL |
Stage Number
Default Value: 10 |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
Sequence Number
Default Value: 1 |
| 7 | PTAFLEVEL | Number(1,0) | SMALLINT NOT NULL |
Level e.g. Header = 0, Line = 1.
0=Header 1=Line |