GPCH_ETFOT_NRVW

(SQL View)
 Index Back

Tarif Area Overtime T NPR View

Store Overtime rates by Tarif and Tarif area. This table used by Swiss payroll system.

SELECT TARIFF_GER , TARIFF_AREA_GER , EFFDT , GPCH_PS_EE_CATG , EFF_STATUS , PIN_NUM + 50000000 , GPCH_PIN_NUM + 50000000 , GPCH_ER_OT_RATE , GPCH_AL_ELEM_AMT , CURRENCY_CD , ENTRY_TYPE_ELEM , ENTRY_TYPE_ELEM2 FROM PS_GPCH_ER_TRF_OT

  • Parent record: GPCH_ER_TRF_EE

    • # 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
    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD7

    7 GPCH_PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD8

    8 GPCH_ER_OT_RATE Number(6,2) DECIMAL(5,2) NOT NULL Percent
    9 GPCH_AL_ELEM_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Amount
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: CHF

    Prompt Table: CURRENCY_CD_TBL

    11 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GP_ENT_NUMER_VW

    12 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_NUMER_VW