HR_GEND_APPR_VW

(SQL View)
 Index Back

EE Gender - Pending Txn Vw

This view is intended to select all rows that are in the approval process.

SELECT A.EMPLID , A.ACTION_DT_SS , A.EFFSEQ , A.WF_STATUS , D.EOAWSTEP_STATUS , D.OPRID , D.EOAWORIG_OPRID , %DatePart(D.EOAWDTTM_MODIFIED) , C.EOAWTHREAD_ID , D.EOAWDTTM_COMPLETE , B.EOAWREQUESTOR_ID , B.EOAWTHREAD_STATUS , B.EOAWDTTM_MODIFIED , C.EOAWPRCS_ID , C.EOAWDEFN_ID , C.EFFDT , C.EOAWSTEP_NBR FROM PS_HR_GENDER_DAT A , PS_HR_GENDER_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.EMPLID = B.EMPLID AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.EFFSEQ = B.EFFSEQ AND B.EOAWPRCS_ID = C.EOAWPRCS_ID AND B.EOAWDEFN_ID = C.EOAWDEFN_ID AND B.EOAWTHREAD_ID = C.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = C.EOAWSTEP_INSTANCE ORDER BY C.EOAWTHREAD_ID DESC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HRMH_EMPLID_VW

2 ACTION_DT_SS Date(10) DATE Termination Date
3 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
4 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
A=Approved
C=Cancelled
D=Denied
E=Error. Contact Administrator.
F=Awaiting final approval
I=In Approval Process
M=Administrator is Processing
N=Not Available
P=Rework
S=Submitted
V=Data Saved
5 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
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
8 EOAWSTART_DT Date(10) DATE Start Date
9 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
10 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
11 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor 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
W=Canceled
X=Suspended/Pending Denial
13 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
14 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
15 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
16 EFFDT Date(10) DATE Effective Date

Default Value: %date

17 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path