EOAWMSUMMTRANVW

(SQL View)
 Index Back

Approvals Transaction Message


SELECT D.EOAWAPPROVER_OPRID , S.EOAWPRCS_ID , ' ' , S.EOAWTHREAD_ID , S.EOAWPARENT_THREAD , S.ORIGINATORID , D.EOAWUSTEP_STATUS , D.EOAWPREV_STATUS , S.EOAWREQUESTOR_ID , S.EOAW_PUSHBACK , S.APPROVEOPRID , S.EOAWTHREAD_STATUS , S.DESCR254 , S.LASTUPDDTTM , S.LASTUPDOPRID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EOAW_SUMM_DTL D , PS_EOAW_SUMMARY S WHERE D.EOAWPRCS_ID = S.EOAWPRCS_ID AND D.EOAWTHREAD_ID = S.EOAWTHREAD_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 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
5 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
6 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
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 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
13 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
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 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.
16 EOAW_DATEPERIOD Character(2) VARCHAR2(2) NOT NULL Date Period
W0=This Week
W1=Last Week
W2=Two Weeks Ago
W3=Older
WA=All
17 EOAW_PRIORITY_FLAG Character(1) VARCHAR2(1) NOT NULL Priority
H=High Priority
L=Low Priority
M=Medium Priority
N=No Priority
18 EOAW_USTEPSSTATUS Character(1) VARCHAR2(1) NOT NULL Special status for fluid approval.
19 EOAW_STATUSLABEL Character(100) VARCHAR2(100) NOT NULL Status Label
20 HTMLAREA Long Character CLOB HTML Area
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