GPBR_SEFIP_PARM

(SQL Table)
Index Back

SEFIP Parameters

SEFIP Parameters

  • Parent record: GPBR_SEFIP_EFDT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
    2 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
    3 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
    4 GPBR_NAME_CIAEST Character(1) VARCHAR2(1) NOT NULL Social Reason by Company or Establishment
    C=Company
    E=Establishment

    Default Value: C

    5 GPBR_SPORT_SPONS_V Number(18,2) DECIMAL(17,2) NOT NULL Sports Sponsorship
    6 GPBR_INCOME_SOURCE Character(1) VARCHAR2(1) NOT NULL Income Source
    A=Earnings from Events & Sponsor
    E=Earnings from Events
    N=N/A
    P=Earnings from Sponsorship

    Default Value: N

    7 GPBR_RURAL_PROD_PH Number(18,2) DECIMAL(17,2) NOT NULL Rural Production Physical Person
    8 GPBR_RURAL_PROD_JU Number(18,2) DECIMAL(17,2) NOT NULL Rural Production Juridic Person
    9 GPBR_OTH_YEAR Number(4,0) SMALLINT NOT NULL Other Information Year
    10 GPBR_CORRECT_COMP Number(18,2) DECIMAL(17,2) NOT NULL Corrected Compensation
    11 GPBR_START_YEAR Number(4,0) SMALLINT NOT NULL Start Year
    12 GPBR_START_MONTH Number(2,0) SMALLINT NOT NULL Start Month
    13 GPBR_END_YEAR Number(4,0) SMALLINT NOT NULL End Year
    14 GPBR_END_MONTH Number(2,0) SMALLINT NOT NULL End Month
    15 GPBR_COMP_VAL_INSS Number(18,2) DECIMAL(17,2) NOT NULL INSS Competency Value
    16 GPBR_COMP_VAL_PREV Number(18,2) DECIMAL(17,2) NOT NULL Previous Competency Value
    17 GPBR_COMP_VAL_RURL Number(18,2) DECIMAL(17,2) NOT NULL Rural Competency Value
    18 GPBR_COMP_VAL_R_PR Number(18,2) DECIMAL(17,2) NOT NULL Competency Value
    19 GPBR_COMP_VAL_SPON Number(18,2) DECIMAL(17,2) NOT NULL Sponsorship Competency Value
    20 GPBR_COOP_PAY_VAL Number(18,2) DECIMAL(17,2) NOT NULL Work Cooperatives Pay