EOAW_CONTPNL_VW(SQL View) |
Index Back |
|---|---|
Content Panel View Level 1 |
| SELECT EOAWPRCS_ID , ' ' , ' ' , ' ' , ' ' , ' ' , 99 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' 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 | NODE_NAME | Character(20) | VARCHAR2(20) NOT NULL | Name of node in Tree Manager |
| 6 | EOAW_IMAGE_NAME | Character(254) | VARCHAR2(254) NOT NULL | The name of images |
| 7 | COUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | AUS WGEA counts |
| 8 | EOAW_EXCOUNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Exceed Limitation Count
Y/N Table Edit |
| 9 | EOAWGROUPBOX | Character(1) | VARCHAR2(1) NOT NULL | Discussion Groupbox |
| 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 |