HR_SALCHG_PNDG

(SQL View)
 Index Back

AdHoc Sal Chg - 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.TRANSACTION_NAME , A.SS_GRP_ID , A.SS_TRANS_ID , A.EMPLID , A.EMPL_RCD , A.SUBMITTED_DT , EFF.EFFDT , A.LAST_PROC_ACTION , A.ORIGINATORID , 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 , C.EOAWPRCS_ID , C.EOAWDEFN_ID , C.EFFDT , D.OPRID , D.EOAWORIG_OPRID , %DatePart(D.EOAWDTTM_MODIFIED) , C.EOAWTHREAD_ID , D.EOAWDTTM_COMPLETE , B.EOAWREQUESTOR_ID , B.EOAWTHREAD_STATUS , B.EOAWDTTM_MODIFIED FROM PS_SS_KEYS A , PS_HR_SALCHG_EFF_V EFF , PS_HR_SALCHG_XREF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.SS_TRANS_ID = 1 AND A.TRANSACTION_NAME = EFF.TRANSACTION_NAME AND A.SS_GRP_ID = EFF.SS_GRP_ID AND A.SS_TRANS_ID = EFF.SS_TRANS_ID AND A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID 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 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
3 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 SUBMITTED_DT Date(10) DATE Used in SS Framework
7 ASOF_DATE Date(10) DATE As of Date
8 LAST_PROC_ACTION Character(1) VARCHAR2(1) NOT NULL Used in SS Framework
A=Approve
D=Deny
R=Recycle
S=Submit
9 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
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
15 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
16 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
19 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
20 EFFDT Date(10) DATE Effective Date
21 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
22 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
23 EOAWSTART_DT Date(10) DATE Start Date
24 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
25 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
26 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
27 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
28 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified