HCDL_SUMMDTL_VW

(SQL View)
 Index Back

AWE Summary Detail View

This record joins AWE summary table with summary detail table.

SELECT S.EOAWTHREAD_ID , S.EOAWPRCS_ID , D.oprid , S.ORIGINATORID , S.EOAWREQUESTOR_ID , S.EOAWTHREAD_STATUS , S.EOAWPARENT_THREAD , S.CREATEDTTM , S.EOAWDTTM_MODIFIED , S.LASTUPDDTTM , S.LASTUPDOPRID , S.EOAW_PUSHBACK , S.APPROVEOPRID , D.EOAWORIG_OPRID , D.EOAWSTEP_STATUS , D.EOAWSTEP_STATUS , %DatePart(D.EOAWDTTM_MODIFIED) , D.EOAWDTTM_MODIFIED , S.EOAWDTTM_MODIFIED , S.DESCR254 , S.DESCRLONG FROM PS_EOAW_SUMMARY S , ps_eoaw_userinst D , PS_EOAW_STEPINST st WHERE st.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND st.EOAWPRCS_ID = S.EOAWPRCS_ID AND d.eoawstep_instance=st.eoawstep_instance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 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

7 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
8 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
9 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 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.
11 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.
12 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback

Default Value: N

13 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
14 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
15 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial
16 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
17 EOAWSTART_DT Date(10) DATE Start Date
18 LAST_UPDATE_DTTM 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.
19 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
20 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
21 DESCRLONG Long Character CLOB Long Description