EOAWPRCS_IDEOAWTHREAD_IDDefault Value: %date
EOAW_WL_VW(SQL View) |
Index Back |
|---|---|
Approval Worklist View |
| SELECT EOAWPRCS_ID , EOAWTHREAD_ID , EOAWDEFN_ID , EFFDT , EOAW_EXTERN_FLAG FROM PS_EOAW_WL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | EOAWTHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 3 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EOAW_EXTERN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | External Approver |