GPBR_EVTP_TBL

(SQL Table)
 Index Back

eSocial Period Control

Record the events pending to event S-1299

  • Related Language Record: GPBR_EVTP_LNG

    • # 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_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 GPBR_EVNT_CATEGORY Character(1) VARCHAR2(1) NOT NULL eSocial- Event Category
    B=Basic Table
    N=Non Periodic
    P=Periodic
    Q=Totaling
    T=Termination
    6 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
    7 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date
    8 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
    9 GPBR_ESOC_YEAR Number(4,0) SMALLINT NOT NULL Competency Year
    10 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