HR_RETIRE_MPNDG

(SQL View)
 Index Back

EE Retire-Mobil Pending Txn Vw

COPIED FROM HR_RETIRE_PNDG with modified SQL and additional field - used in mobil approvals only

SELECT A.EMPLID ,A.EMPL_RCD ,A.ACTION_DT_SS ,A.EFFSEQ ,A.WF_STATUS ,A.ACTION ,A.ACTION_REASON_SS ,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.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 FROM PS_HR_RETIRE_DAT A , PS_HR_RETIRE_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE 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

# 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 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Default Value: RET

Prompt Table: ACTION_TBL

7 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

8 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
9 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
10 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
11 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
12 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
13 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
14 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

15 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

16 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

17 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
18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
19 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
20 EOAWSTART_DT Date(10) DATE Start Date
21 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
22 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
23 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
24 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
25 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
26 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
27 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
28 EFFDT Date(10) DATE Effective Date

Default Value: %date