WC_MY_JCR_HR_VW

(SQL View)
 Index Back

Review My JCR inquiry - HR

Review My Job Change Request inqury. HR Administrator.

SELECT DISTINCT A.REG_REGION , A.ACTION , A.ACTION_REASON , A.EFFDT , A.WC_JCR_STATUS FROM PS_WC_JCR_STATUS A WHERE A.WC_JCR_STATUS_DTTM = ( SELECT MAX(B.WC_JCR_STATUS_DTTM) FROM PS_WC_JCR_STATUS B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.REG_REGION = B.REG_REGION AND A.ACTION = B.ACTION AND A.ACTION_REASON = B.ACTION_REASON AND A.EFFDT =B.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

Default Value: OPR_DEF_TBL_HR.REG_REGION

Prompt Table: WC_RG_REGION_VW

2 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: WC_ACTION_VW

3 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: WC_ACTN_RSN_VW

4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 WC_JCR_STATUS Character(1) VARCHAR2(1) NOT NULL Job Change Request status. Used by the functionnality Works Council Notification.
A=Requested by Manager
B=Requested by HR
C=Approved by Current Manager
D=Denied by Current Manager
E=Works Cncl Approval Requested
F=Denied by HR
G=Approved by Works Council
H=Denied by Works Council
I=Works Council Overridden by HR
J=Job Change Complete
K=Default Approval by Works Cncl
L=CI Failed
N=New

Default Value: A