WC_ACTNAREA_TBL

(SQL Table)
 Index Back

Job Change by Reg Region

Job Change by Reg Region - Collapsible Areas : used by the functionnality Works Council Notification. Child table from WC_ACTNROLE_TBL.

  • Parent record: WC_ACTNROLE_TBL

    • # 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 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    3 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 WC_JCR_PARTICIPANT Character(1) VARCHAR2(1) NOT NULL Used by the functionnality Works Council Notification.
    1=HR Administrator
    2=Current Manager
    3=New Manager
    4=Works Council
    6 WC_COLLAPS_AREA_ID Character(3) VARCHAR2(3) NOT NULL Collapsible Area : used by the functionnality Works Council Notification.
    1=1. Organization Information
    2=2. Job Information
    3=3. Salary Plan
    35=4. Payroll
    4=5. Request Job Change
    5=6. Manager Decision
    6=7. HR Decision
    7=8. Request WC Approval
    8=9. Works Council Decision
    9=10. Process Job Change
    7 WC_SHOW_CURRENT_SW Character(1) VARCHAR2(1) NOT NULL Used by the functionnality Works Council Notification.

    Y/N Table Edit

    Default Value: Y

    8 WC_SHOW_NEW_SW Character(1) VARCHAR2(1) NOT NULL Used by the functionnality Works Council Notification.

    Y/N Table Edit

    Default Value: Y

    9 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type CD
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N