GPFR_URS_RATES

(SQL Table)
Index Back

URSSAF rates

Stores all the URSSAF rates Linked to GP by an ARRAY

  • Related Language Record: GPFR_URS_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SS_REGIM_CD_GPFRA Number(3,0) SMALLINT NOT NULL This field is used as a System Element in Global Payroll. It is a French specific field.
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 GPFR_URS_ILL_P0 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Illness Rate
    6 GPFR_URS_ILL_E0 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Illness Rate
    7 GPFR_URS_ILL_P1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Illness Rate payee for SMIC greater than 2.5.
    8 GPFR_URS_ILL_E1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Illness Rate employer for SMIC greater than 2.5.
    9 GPFR_URS_WID_P0 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Widow Rate
    10 GPFR_URS_FAM_E0 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Family Allowance
    11 GPFR_URS_FAM_E1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Family Allowance
    12 GPFR_URS_RET_E0 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Retirment Rate
    13 GPFR_URS_RET_P1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Retirment Rate
    14 GPFR_URS_RET_E1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF Retirment Rate
    15 GPFR_URS_FNAL_E1 Number(7,3) DECIMAL(6,3) NOT NULL URSSAF FNAL Rate
    16 GPFR_URS_ASS_REL Number(1,0) SMALLINT NOT NULL Indicates if an associated regime is present or not
    17 GPFR_URS_ASS_CD Number(3,0) SMALLINT NOT NULL Associated Regime code

    Prompt Table: GPFR_URS_RATES

    18 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: GP_PIN_VR2_VW

    19 GPFR_URS_FUND Character(1) VARCHAR2(1) NOT NULL Use funding base or not
    1=Complete Funding Base
    2=Differential

    Default Value: 1

    20 GPFR_URS_NONREL Character(1) VARCHAR2(1) NOT NULL URSSAF Low Salary Reduction indicator

    Y/N Table Edit

    Default Value: N

    21 GPFR_URS_NONRELN Number(1,0) SMALLINT NOT NULL URSSAF Low Salary Reduction indicator
    22 GPFR_AT_REDUCTION Number(7,3) DECIMAL(6,3) NOT NULL Work Accident Reduction Rate
    23 GPFR_DUCS_CON_TYP1 Character(3) VARCHAR2(3) NOT NULL GPFR: Contribution Type
    24 GPFR_URS_SOL_E0 Number(7,3) DECIMAL(6,3) NOT NULL Solidarity Employer Rate