GPBR_HIR_ACTREA

(SQL Table)
Index Back

eSocial:Hire Action/Reason

eSocial:Hire Action/Reason

  • Parent record: GPBR_HIR_AR_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    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 EMPLOYEE_IND Character(1) VARCHAR2(1) NOT NULL Employee indicator.

    Y/N Table Edit

    Default Value: N

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 GPBR_HIRE_CODE Character(1) VARCHAR2(1) NOT NULL eSoical : Hire legal code
    0=Reinstatement
    1=Hire
    2=Transfers -Same Economic Group
    3=Transfers- Consortium
    4=Transfer-Merger/Demeger/Incorp
    7=Transfer-Prev Employer Inapt
    7 GPBR_FIRST_JOB Character(1) VARCHAR2(1) NOT NULL eSocial: First Job Indicator.
    N=No
    Y=Yes
    8 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code

    Prompt Table: GPBR_EVT_ACT_VW