WC_ACTION_VW

(SQL View)
 Index Back

JCR Action

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

SELECT DISTINCT B.REG_REGION , A.ACTION , %Substring(A.ACTION_DESCR,1,30) FROM PS_ACTION_TBL 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_TBL A2 WHERE A2.EFFDT <= B.EFFDT AND A.ACTION = A2.ACTION ) AND A.EFF_STATUS = 'A'

  • Related Language Record: WC_ACTION_LN_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description