EOAW_INTPNL_VW(SQL View) |
Index Back |
|---|---|
Integration Panel View level 1 |
| SELECT EOAWPRCS_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EOAW_TXN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 2 | EOAWPRCS_GROUP | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | EOAWPRCSGROUPDESCR | Character(30) | VARCHAR2(30) NOT NULL | Approval Process Group Description |
| 5 | EOAW_ADMIN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Is Administrative
N=False Y=True |
| 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 | EOPCNAMEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 9 | EOPCVALUEHASH | Character(28) | VARCHAR2(28) NOT NULL | Value Hash |
| 10 | EOPCCOMPNAMEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 11 | EOPCCOMPVALUEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 12 | EOPCOBJ_L1_E | Long Character | CLOB | Page HTML Field: Level 1_E |
| 13 | EOAW_ALLOW_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Approve
N=No Y=Yes |
| 14 | EOAW_ALLOW_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Deny
N=No Y=Yes |
| 15 | EOAW_ALLOW_PUSHBCK | Character(1) | VARCHAR2(1) NOT NULL |
Allow Pushback
N=No Y=Yes |
| 16 | EOAW_ALLOW_HOLD | Character(1) | VARCHAR2(1) NOT NULL |
Allow Hold
N=No Y=Yes |
| 17 | EOAW_ALLOW_REQINFO | Character(1) | VARCHAR2(1) NOT NULL |
Allow Request Information
N=No Y=Yes |
| 18 | EOAW_ALLOW_REASSGN | Character(1) | VARCHAR2(1) NOT NULL |
Allow Reassign
N=No Y=Yes |
| 19 | EOAW_ALLOW_RESUB | Character(1) | VARCHAR2(1) NOT NULL |
Allow Resubmit/Restart
N=No Y=Yes |
| 20 | EOAW_MASS_APPROVE | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Approve
N=No Y=Yes |
| 21 | EOAW_MASS_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Deny
N=No Y=Yes |
| 22 | EOAW_MASS_REASSIGN | Character(1) | VARCHAR2(1) NOT NULL |
Allow Mass Reassign
N=No Y=Yes |
| 23 | EOAW_REQCOMM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Require Comments for fluid approval deny action |
| 24 | EOAW_SHOWTERM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Show terminated transactions in fluid approval flag |