EOAW_CONTPNLAVW(SQL View) |
Index Back |
---|---|
Content 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 W=Canceled 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 W=Canceled X=Deleted Y=Bypassed |
8 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
9 | EOAW_PUSHBACK | Character(1) | VARCHAR2(1) NOT NULL | Pushback |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | EOAWPRCSGROUPDESCR | Character(30) | VARCHAR2(30) NOT NULL | Approval Process Group Description |
12 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
13 | 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. |
14 | 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. |
15 | EOAW_DATEPERIOD | Character(2) | VARCHAR2(2) NOT NULL |
Date Period
W0=This Week W1=Last Week W2=Two Weeks Ago W3=Older WA=All |
16 | EOAWGROUPBOX | Character(1) | VARCHAR2(1) NOT NULL | Discussion Groupbox |
17 | NODE_NAME | Character(40) | VARCHAR2(40) NOT NULL | Node Name |
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 |