WC_ACTN_RSN_VW

(SQL View)
 Index Back

JCR Action Reason

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

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

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