EOAWPRCS_IDEOAWDEFN_IDEFFDTDefault Value: %date
EOAWSTAGE_NBRDefault Value: 10
Default Value: 1
0=Header
1=Line
Default Value: 0
EOAW_STAGE(SQL Table) |
Index Back |
|---|---|
Approval StageApproval Stage |
| # | 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
Default Value: %date |
| 4 | EOAWSTAGE_NBR |
Number(3,0) | SMALLINT NOT NULL |
Approval Framework 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 | EOAWLEVEL | Number(1,0) | SMALLINT NOT NULL |
Level e.g. Header = 0, Line = 1.
0=Header 1=Line Default Value: 0 |