EOAWMAPPRROOTVW(SQL View) |
Index Back |
|---|---|
Root record for mass approvals |
| SELECT ' ' , 'P' , ' ' , 'N' , 'N' , ' ' , 0 , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID | |
| 2 | EOAW_MASS_ACTION | Character(12) | VARCHAR2(12) NOT NULL | Mass Action |
| 3 | EOAWREASSIGNOPRID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Reassign Oprid |
| 4 | EOAW_ADMIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Is Administrative
N=False Y=True Y/N Table Edit Default Value: N |
| 5 | EOAW_PREVIEW_FLG | Character(1) | VARCHAR2(1) NOT NULL | Preview |
| 6 | COMMENTS | Long Character | CLOB | Comment |
| 7 | EOAWRESPONSESTATUS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Response Status |
| 8 | EOAWRESPONSETEXT | Character(254) | VARCHAR2(254) NOT NULL | Response Text |