GPBR_SERV_T_DTL

(SQL Table)
 Index Back

Service Taker Movements Detail

Service Taker Movements Detail

  • Parent record: GPBR_SERV_T_DTA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
    2 MONTHCD Character(2) VARCHAR2(2) NOT NULL 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
    3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: GPBR_EMP_EST_VW

    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Default Value: GPBR_EM_ES_R_VW.EMPL_RCD

    Prompt Table: GPBR_EM_ES_R_VW

    6 GPBR_SERVICE_TAKER Character(3) VARCHAR2(3) NOT NULL Service Taker

    Prompt Table: GPBR_ST_EST_VW

    7 GPBR_HRS_DAYS Character(2) VARCHAR2(2) NOT NULL Hours / Days Indicator
    10=Hours
    20=Days

    Default Value: 20

    8 GPBR_HOURS Number(3,0) SMALLINT NOT NULL Hours
    9 GPBR_DAYS Number(3,0) SMALLINT NOT NULL Days
    10 GPBR_EMP_PERC_CONT Number(3,0) SMALLINT NOT NULL Employee's percentage contribution to social security.

    Default Value: 0