HRS_REC_STATDEC

(SQL Table)
 Index Back

WC Recruitment Status

Works Council Recruitment Status.

  • Parent record: HRS_REC_STS_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATUS_AREA Character(1) VARCHAR2(1) NOT NULL Defines an area in the system that track statuses.
    1=1-Job Opening
    2=2-Applicant
    3=3-Recruitment Summary
    4=4-Route
    5=5-Interview
    6=6-Offer
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 WC_DECISIONGRP_ID Character(3) VARCHAR2(3) NOT NULL Decision ID. Used by the functionnality Works Council Notification (Recruit Workforce).

    Prompt Table: WC_DECISGRP_TBL

    4 WC_DECISION_ID Character(3) VARCHAR2(3) NOT NULL Works Council Decision

    Prompt Table: WC_DECISION_TBL

    5 STATUS_CODE Character(3) VARCHAR2(3) NOT NULL Identifies a status.

    Prompt Table: HRS_STS_TBL

    6 STATUS_REASON Character(3) VARCHAR2(3) NOT NULL Identifies a reason associated with a particular status.

    Prompt Table: HRS_STSRSN_TBL

    7 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data
    8 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    9 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    10 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    11 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id