WC_ACTION_LN_VW

(SQL View)
 Index Back

JCR Action - Rel Lang

Use in Works Council Notification. Related language record from WC_ACTION_VW

SELECT B.REG_REGION , A.ACTION , A.LANGUAGE_CD , %Substring(A.ACTION_DESCR,1,30) FROM PS_ACTION_LNG A , PS_WC_ACTN_RSN_TBL B WHERE A.ACTION = B.ACTION AND B.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACTION_LNG A2 WHERE A2.EFFDT <= B.EFFDT AND A.ACTION = A2.ACTION AND A.LANGUAGE_CD= A2.LANGUAGE_CD )

  • Related Language Record for WC_ACTION_VW

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

    Prompt Table: REG_STANDARD_VW

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

    Prompt Table: ACTION_TBL

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