EOAWAPPROVER_OPRIDEOAWPRCS_IDN=False
Y=True
Y/N Table Edit
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
EOAWMSUMMPRCSVW(SQL View) |
Index Back |
|---|---|
Approvals Process Summary |
| SELECT X.EOAWAPPROVER_OPRID , T.EOAWPRCS_ID , ' ' , 'N' , ' ' , ' ' , ' ' , T.DESCR , ' ' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' FROM PS_EOAW_TXN T , ( SELECT DISTINCT D.EOAWAPPROVER_OPRID , D.EOAWPRCS_ID FROM PS_EOAW_SUMM_DTL D , PS_EOAW_SUMMARY S WHERE D.EOAWPRCS_ID = S.EOAWPRCS_ID AND D.EOAWTHREAD_ID = S.EOAWTHREAD_ID) X WHERE T.EOAWPRCS_ID = X.EOAWPRCS_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWAPPROVER_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID |
| 2 | EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 3 | EOAWPRCS_GROUP | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 4 | EOAW_ADMIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Is Administrative
N=False Y=True |
| 5 | EOPCOBJ_L1_E | Long Character | CLOB | Page HTML Field: Level 1_E |
| 6 | EOAW_EXCOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Exceed Limitation Count
Y/N Table Edit |
| 7 | EOAW_IMAGE_NAME | Character(254) | VARCHAR2(254) NOT NULL | The name of images |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | EOAWPRCSGROUPDESCR | Character(30) | VARCHAR2(30) NOT NULL | Approval Process Group Description |
| 10 | EOAW_ALLOW_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Approve
N=No Y=Yes |
| 11 | EOAW_ALLOW_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Deny
N=No Y=Yes |
| 12 | EOAW_ALLOW_PUSHBCK | Character(1) | VARCHAR2(1) NOT NULL |
Allow Pushback
N=No Y=Yes |
| 13 | EOAW_ALLOW_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Allow Hold
N=No Y=Yes |
| 14 | EOAW_ALLOW_REQINFO | Character(1) | VARCHAR2(1) NOT NULL |
Allow Request Information
N=No Y=Yes |
| 15 | EOAW_ALLOW_REASSGN | Character(1) | VARCHAR2(1) NOT NULL |
Allow Reassign
N=No Y=Yes |
| 16 | EOAW_ALLOW_RESUB | Character(1) | VARCHAR2(1) NOT NULL |
Allow Resubmit/Restart
N=No Y=Yes |
| 17 | EOAW_MASS_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Approve
N=No Y=Yes |
| 18 | EOAW_MASS_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Deny
N=No Y=Yes |
| 19 | EOAW_MASS_REASSIGN | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Reassign
N=No Y=Yes |
| 20 | EOAW_REQCOMM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Require Comments for fluid approval deny action |
| 21 | EOAW_SHOWTERM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Show terminated transactions in fluid approval flag |