EOAW_INTPNL2VW(SQL View) |
Index Back |
|---|---|
Integration Panel View Level 2 |
| 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 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 4 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |
| 5 | EOAWTHREAD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Thread Status
A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated X=Suspended/Pending Denial Default Value: N |
| 6 | EOAWAPPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID |
| 7 | EOAWUSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approver Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=Hold K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending S=Skipped T=Terminated U=Auto approved X=Deleted Y=Bypassed |
| 8 | EOAWPREV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approver Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending S=Skipped T=Terminated U=Auto approved W=Canceled X=Deleted Y=Bypassed |
| 9 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 10 | EOAW_PUSHBACK | Character(1) | VARCHAR2(1) NOT NULL | Pushback |
| 11 | APPROVEOPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver's Oper ID |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 14 | DESCRLONG | Long Character | CLOB | Long Description |
| 15 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 16 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 17 | EOAW_DATEPERIOD | Character(2) | VARCHAR2(2) NOT NULL |
Date Period
W0=This Week W1=Last Week W2=Two Weeks Ago W3=Older WA=All |
| 18 | EOAW_PRIORITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Priority
H=High Priority L=Low Priority M=Medium Priority N=No Priority |
| 19 | EOAW_USTEPSSTATUS | Character(1) | VARCHAR2(1) NOT NULL | Special status for fluid approval. |
| 20 | EOAW_STATUSLABEL | Character(100) | VARCHAR2(100) NOT NULL | Status Label |
| 21 | EOPCNAMEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 22 | EOPCVALUEHASH | Character(28) | VARCHAR2(28) NOT NULL | Value Hash |
| 23 | EOPCCOMPNAMEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 24 | EOPCCOMPVALUEHASH | Character(28) | VARCHAR2(28) NOT NULL | Field Name Hash |
| 25 | EOAWAPPKEYS | Long Character | CLOB | EOAW App Keys |
| 26 | EOAWAPPKEYSVALUE | Long Character | CLOB | EOAW App Keys Value |
| 27 | EOPCOBJ_L2ROW | Long Character | CLOB | Page HTML Field: Level 2 Row |
| 28 | EOPCOBJ_L2ROW_A | Long Character | CLOB | Page HTML Field: Level 2 Row_A |
| 29 | EOPCOBJ_L0 | Long Character | CLOB | Page HTML Field: Level 0 |
| 30 | EOPCOBJ_L0_A | Long Character | CLOB | Page HTML Field: Level 0_A |
| 31 | EOPCOBJ_L0_B | Long Character | CLOB | EOPCOBJ_L0_B |
| 32 | EOPCOBJ_L0_C | Long Character | CLOB | EOPCOBJ_L0_C |
| 33 | EOPCOBJ_L0_D | Long Character | CLOB | EOPCOBJ_L0_D |
| 34 | COMMENTS | Long Character | CLOB | Comment |
| 35 | EOAW_PREVIEWSTATUS | Character(1) | VARCHAR2(1) NOT NULL | Preview |
| 36 | EOAWERROR_MSG_TXT | Long Character(256) | VARCHAR2(256) | Error Message |
| 37 | EOAW_MA_LABELMSG | Character(254) | VARCHAR2(254) NOT NULL | Label Messaage |
| 38 | EOAW_MA_DISPLAYTLE | Character(254) | VARCHAR2(254) NOT NULL | Display Title |
| 39 | EOAW_MA_CONFIRMMSG | Character(254) | VARCHAR2(254) NOT NULL | Confirm Msg |