HR_MTRX_APPR_VW

(SQL View)
 Index Back

EE Promotion - Pending Txn Vw

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

SELECT A.HRMH_MATRIX_ID , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.HRMH_MATRIX_TYPE , A.HRMH_TITLE , A.HRMH_MEMBER_ROLE , A.SUPERVISOR_ID , A.SUPERVIS_EMPL_RCD , A.START_DT , A.END_DT , A.HRMH_NEW_START_DT , A.HRMH_NEW_END_DT , A.HRMH_MEMBER_ACTION , A.HRMH_MEMBER_STATUS , 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_HRMH_MATRX_MEMB A , PS_HR_MTRX_MEM_XRF B , PS_EOAW_STEPINST C , PS_EOAW_USERINST D WHERE A.HRMH_MATRIX_ID = B.HRMH_MATRIX_ID AND A.EFFDT = B.EFFDT AND A.EMPLID = B.EMPLID 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 HRMH_MATRIX_ID Character(15) VARCHAR2(15) NOT NULL Matrix Identifier
2 EFFDT_NEW Date(10) DATE New Effective Date
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: HRMH_EMPLID_VW

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 HRMH_MATRIX_TYPE Character(3) VARCHAR2(3) NOT NULL Matrix Type

Default Value: CFR

Prompt Table: HRMH_MTRX_TYPE

6 HRMH_TITLE Character(30) VARCHAR2(30) NOT NULL Hierarchy Member Employee Id
7 HRMH_MEMBER_ROLE Character(30) VARCHAR2(30) NOT NULL Member Role
8 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

Default Value: HRMH_MATRX_DEFN.HRMH_OWNER_EMPLID

Prompt Table: HRMH_REPTO_DVW

9 SUPERVIS_EMPL_RCD Number(3,0) SMALLINT NOT NULL Supervisor employee record.
10 START_DT Date(10) DATE Start Date

Default Value: %date

11 END_DT Date(10) DATE end date
12 HRMH_NEW_START_DT Date(10) DATE New Start Date
13 HRMH_NEW_END_DT Date(10) DATE New End Date
14 HRMH_MEMBER_ACTION Character(3) VARCHAR2(3) NOT NULL To capture Member Action like Add Member/Change Duration/Inactivate Member
A=Add Member
AM=Add Member
C=Change Duration
CD=Change Duration
I=Inactive Member
IM=Inactive Member
15 HRMH_MEMBER_STATUS Character(1) VARCHAR2(1) NOT NULL Matrix Member Status
A=Active
D=Denied
F=Draft
I=Inactive
P=Pending

Default Value: A

16 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
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

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