GPCH_ER_TRF_EE

(SQL Table)
 Index Back

Tarif/Area/EmplCat Factors

This table stores tarif information by tarif area and employee category. It was created for use in Swiss Payroll processing.

  • Parent record: GPCH_ER_TRF_FCT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TARIFF_GER Character(2) VARCHAR2(2) NOT NULL Tariff
    01=Metal Processing
    02=Banking
    03=Building and Civil Engineering
    04=Clothing Industry
    05=Chemical Industry
    06=Printing Industry
    07=Retail Trade
    08=Fossil Oil and Gas Extraction
    09=Glass Industry
    10=Wholesale and Foreign Trade
    11=Wood Processing
    12=Rubber Processing
    13=Ceramics
    14=Agriculture
    15=Leather Processing
    16=Public Sector
    17=Paper Industry
    18=Paper Processing
    19=Sawing Industry
    20=German Seaports
    21=Hard-Coal Mining
    22=Textile Industry
    23=Insurance
    24=Housing Industry
    25=Periodical Publishers
    26=Newspaper Publishers
    27=Tobacco Industry
    2 TARIFF_AREA_GER Character(3) VARCHAR2(3) NOT NULL Tariff Area
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GPCH_PS_EE_CATG Character(3) VARCHAR2(3) NOT NULL Employee Category
    01=Wage Earner
    02=Salaried Employee
    03=Apprentice
    04=Retiree
    05=Retiree Over Tariff
    06=Without Employee Status
    07=Half Orphan
    08=Company Pensioner
    09=Widower/Orphan
    11=Student Writing Thesis
    12=Doctorant Writing dissertation
    13=Award Holder
    14=Industrial Trainee
    15=Retrainee
    16=Hired Help
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 GPCH_ER_CAPACC_AMT Number(6,2) DECIMAL(5,2) NOT NULL Capital Accumulation Maximum
    7 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 GPCH_ER_CAPACCWAIT Number(2,0) SMALLINT NOT NULL Waiting Period in Months
    9 GPCH_ER_VACNBONPCT Number(6,2) DECIMAL(5,2) NOT NULL Vacation Bonus %
    10 GPCH_ER_ACCT_FEE Number(8,2) DECIMAL(7,2) NOT NULL Bank Account Fee
    11 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    12 GPCH_TXG_PROC_PRD Character(4) VARCHAR2(4) NOT NULL Processing Period
    M=Monthly
    N=None
    Y=Yearly

    Default Value: N

    13 GPCH_ER_PY_MM_ONLY Character(1) VARCHAR2(1) NOT NULL Pay Month Only

    Y/N Table Edit

    14 GPCH_DE_PE_SCHED Character(3) VARCHAR2(3) NOT NULL Pay Schedule
    15 GPCH_ER_BASE_MMSTD Number(2,0) SMALLINT NOT NULL Regular Monthly Pay
    16 GPCH_ER_BASE_MMVAR Number(2,0) SMALLINT NOT NULL Variable Monthly Pay
    17 GPCH_ER_MID_YY_PCT Number(6,2) DECIMAL(5,2) NOT NULL Prorate Midyear Percent
    18 GPCH_ER_SICK_PCNT Number(6,2) DECIMAL(5,2) NOT NULL Addlitional Sick %
    19 GPCH_AB_ENTITLEMNT Character(10) VARCHAR2(10) NOT NULL Entitlement Plan

    Prompt Table: GPCH_AB_ENTITLE