WC_ACTNRSNLN_VW

(SQL View)
 Index Back

JCR Action Reason

Job Change Request Related language record from WC_ACTN_RSN_VW Use in Works Council Notification.

SELECT A.REG_REGION , A.ACTION , A.ACTION_REASON , B.LANGUAGE_CD , B.DESCR FROM PS_WC_ACTN_RSN_TBL A , PS_ACTN_RSN_LANG B WHERE A.ACTION = B.ACTION AND A.ACTION_REASON = B.ACTION_REASON AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_ACTN_RSN_LANG C WHERE B.ACTION = C.ACTION AND B.ACTION_REASON = C.ACTION_REASON AND B.LANGUAGE_CD = C.LANGUAGE_CD AND C.EFFDT <= A.EFFDT)

  • Related Language Record for WC_ACTN_RSN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    2 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    3 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description