HR_FULLPART_PNG

(SQL View)
 Index Back

EE Full/Part - Pending Txn Vw

This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.EMPLID ,A.EMPL_RCD ,A.ACTION_DT_SS ,A.EFFSEQ ,A.WF_STATUS ,C.EOAWSTEP_STATUS , C.EOAWTHREAD_ID ,A.ACTION ,A.ACTION_REASON ,A.FULL_PART_TIME_NEW ,A.ORIGINATORID ,A.TRANSACTION_NAME ,A.UPD_BY_USERID ,A.UPD_DTTM ,A.MANUAL_UPD_USERID ,A.MANUAL_UPD_DTTM ,A.SS_STAT_INDICATOR ,A.SS_WARNING_FLG ,A.SS_FUTURE_FLG ,D.OPRID ,D.EOAWORIG_OPRID ,%DatePart(D.EOAWDTTM_MODIFIED) FROM PS_HR_FULLPART_DAT A , PS_HR_FULLPAR_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.WF_STATUS IN ('S', 'I') AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD 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 AND A.EFFSEQ =1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 ACTION_DT_SS Date(10) DATE Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 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
6 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
7 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Default Value: RET

Prompt Table: ACTION_TBL

9 ACTION_REASON_SS Character(3) VARCHAR2(3) NOT NULL Action Reason field for use on Self Service panels.

Prompt Table: ACTN_REASON_TBL
Set Control Field: ACTION

10 FULL_PART_TIME_NEW Character(1) VARCHAR2(1) NOT NULL New Full/Part Time Status
D=On Demand
F=Full-Time
P=Part-Time
11 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
12 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
13 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
14 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
15 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
16 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
17 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
A=Approved
B=CI failed - Errors & Warnings
C=Cancelled
D=Denied
E=Errors Encountered
I=In Approval Process
M=Administrator Action Required
S=Success
W=Warnings Encountered

Default Value: I

18 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N

19 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

Y/N Table Edit

Default Value: N

20 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
21 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
22 EOAWSTART_DT Date(10) DATE Start Date