GPBR_EVNT_SETUP

(SQL Table)
Index Back

eSocial Event Setup

eSocial Event Setup

  • Related Language Record: GPBR_EVNT_S_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
    6 GPBR_EVNT_CATEGORY Character(1) VARCHAR2(1) NOT NULL eSocial- Event Category
    B=Basic Table
    N=Non Periodic
    P=Periodic
    Q=Totaling
    T=Termination
    7 GPBR_INITIAL_EVNT Character(1) VARCHAR2(1) NOT NULL eSocial- Initial Event Flag

    Y/N Table Edit

    Default Value: N

    8 GPBR_EVT_OVR_LVL Character(1) VARCHAR2(1) NOT NULL eSocial: Event Override Level.
    C=Company
    E=Establishment
    9 XML_SET Character(5) VARCHAR2(5) NOT NULL XML Set

    Prompt Table: GPBR_XML_SET_VW

    10 XML_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type

    Prompt Table: XML_TEMPLT_TBL

    11 GPBR_ALLOW_AFTER Character(1) VARCHAR2(1) NOT NULL eSocial- Allowed after period closed Flag

    Y/N Table Edit

    Default Value: N

    12 GPBR_TEMPLATE_ID Character(3) VARCHAR2(3) NOT NULL Template type

    Prompt Table: XML_TEMPLT_TBL

    13 GPBR_IMP_HIST_DATA Character(1) VARCHAR2(1) NOT NULL Import historical data flag.