WC_RG_REGION_VW

(SQL View)
Index Back

JCR Reg Region

Job Change Request : prompt view for Job Change Request Search page. Use in Works Council Notification.

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

  • Related Language Record: WC_REGION_LN_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 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50