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 | EOAWAPPROVER_OPRID | 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 |