GPBR_ES_PER_RC

(SQL Table)
 Index Back

eSocial - Termination Events

eSocial - Termination Events run control page.

  • Parent Record Of GPBR_IDCAL2_VW GPBR_IDCALT2_VW GPBR_IDCALT_VW GPBR_IDCAL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
    4 GPBR_ESOC_MONTHCD Character(2) VARCHAR2(2) NOT NULL eSocial Competency Month
    01=01 - January
    02=02 - February
    03=03 - March
    04=04 - April
    05=05 - May
    06=06 - June
    07=07 - July
    08=08 - August
    09=09 - September
    10=10 - October
    11=11 - November
    12=12 - December
    5 GPBR_ESOC_GRPBOX1 Character(1) VARCHAR2(1) NOT NULL eSocial Pre-Hiring Monitor page (Search)
    6 GPBR_ESOC_SRCH_CMP Character(2) VARCHAR2(2) NOT NULL eSocial Selectiom Criteria
    01=Company
    02=All Companies
    03=Employee

    Default Value: 02

    7 GPBR_EVENT_1300 Character(1) VARCHAR2(1) NOT NULL eSocial - Event Code

    Default Value: N

    8 GPBR_EVENT_1200 Character(1) VARCHAR2(1) NOT NULL eSocial - Event Code

    Y/N Table Edit

    Default Value: N

    9 GPBR_EVENT_1210 Character(1) VARCHAR2(1) NOT NULL eSocial - Event Code

    Y/N Table Edit

    Default Value: N

    10 GPBR_EVENT_1280 Character(1) VARCHAR2(1) NOT NULL eSocial - Event Code

    Y/N Table Edit

    Default Value: N

    11 GPBR_ES_CALENDAR Character(1) VARCHAR2(1) NOT NULL eSocial - Calendar Flag - Run Control Periodics Events

    Y/N Table Edit

    Default Value: N

    12 GPBR_ES_VALIDATE Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    13 GPBR_ES_PREPARE Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    14 GPBR_ES_CANCEL Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    15 GPBR_ES_FINALIZE Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    16 GPBR_ES_REPROCESS Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    17 GPBR_ES_SKIP_ER Character(1) VARCHAR2(1) NOT NULL Initial Loading - Reprocess

    Y/N Table Edit

    Default Value: N

    18 GPBR_EXCL_1200 Character(1) VARCHAR2(1) NOT NULL Exclusion 1200
    N=No
    Y=Yes
    19 GPBR_EXCL_1210 Character(1) VARCHAR2(1) NOT NULL Exclusion 1210
    N=No
    Y=Yes
    20 GPBR_EXCL_1280 Character(1) VARCHAR2(1) NOT NULL Exclusion 1280
    N=No
    Y=Yes
    21 GPBR_EXCL_1300 Character(1) VARCHAR2(1) NOT NULL Exclusion 1300
    N=No
    Y=Yes
    22 GPBR_ES_PERIOD_TP Character(1) VARCHAR2(1) NOT NULL eSocial Period Type
    1=Monthly
    2=Annual

    Default Value: 1

    23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: GPBR_CMP_FLG_VW