WC_REGION_LN_VW

(SQL View)
 Index Back

JCR Reg Region

Use in Works Council Notification. Related language record from WC_RG_REGION_VW

SELECT DISTINCT A.REG_REGION , B.LANGUAGE_CD , B.DESCR50 FROM PS_WC_ACTN_RSN_TBL A , PS_REG_REGION_LANG B WHERE A.REG_REGION = B.REG_REGION AND A.EFF_STATUS='A'

  • Related Language Record for WC_RG_REGION_VW

    • # 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: REG_STANDARD_VW

    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50