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 |