HRS_REC_STS_VW

(SQL View)
 Index Back

WC Recruitment Status

Works Council Recruitment Status.

SELECT A.WC_DECISION_ID , B.DESCR50 , D.WC_NOTIFY_HR_SW , D.WC_REASONS_REQ_SW FROM PS_HRS_REC_STATDEC A , PS_WC_DECISION_TBL B , PS_WC_DEC_GRP_TBL D WHERE A.STATUS_AREA = '3' AND A.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_HRS_REC_STATDEC F WHERE F.STATUS_AREA = A.STATUS_AREA) AND A.WC_DECISIONGRP_ID = 'KDH' AND A.WC_DECISION_ID = B.WC_DECISION_ID AND A.WC_DECISIONGRP_ID = D.WC_DECISIONGRP_ID AND D.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_WC_DEC_GRP_TBL E WHERE D.WC_DECISIONGRP_ID = E.WC_DECISIONGRP_ID AND E.EFFDT <= A.EFFDT) AND A.WC_DECISION_ID = D.WC_DECISION_ID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_WC_DECISION_TBL C WHERE A.WC_DECISION_ID = C.WC_DECISION_ID AND C.EFFDT<= A.EFFDT)

  • Related Language Record: HRS_RECSTS_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WC_DECISION_ID Character(3) VARCHAR2(3) NOT NULL Works Council Decision
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 WC_NOTIFY_HR_SW Character(1) VARCHAR2(1) NOT NULL Used by the functionnality Works Council Notification.

    Y/N Table Edit

    4 WC_REASONS_REQ_SW Character(1) VARCHAR2(1) NOT NULL Used by the functionnality Works Council Notification.

    Y/N Table Edit