WC_ACTNROLE_TBL

(SQL Table)
 Index Back

Job Change by Reg Region

Job Change by Reg Region - Roles : used by the functionnality Works Council Notification.

  • Parent record: WC_ACTN_RSN_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 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    7 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N