GPMX_OVRTM_PARM

(SQL Table)
Index Back

Overtime parameters

Overtime parameters GP Mexico

  • Parent record: GPMX_OV_PARM_HD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

    Prompt Table: GP_PYGRP

    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: MEX

    3 BGN_DT Date(10) DATE NOT NULL Begin Date

    Default Value: %date

    4 END_DT Date(10) DATE end date
    5 GPMX_TIME_PER_WK Number(2,0) SMALLINT NOT NULL Maximum Times per Week GP Mexico

    Default Value: 3

    6 GPMX_HRS_PER_DAY Number(2,0) SMALLINT NOT NULL Maximum Hours per Day GP Mexico

    Default Value: 3

    7 GPMX_HRS_PER_WK Number(2,0) SMALLINT NOT NULL Maximum Hours per Week GP Mexico

    Default Value: 9

    8 GPMX_INXS_HRS Character(4) VARCHAR2(4) NOT NULL In Excess Hrs. per Day
    0010=Double
    0020=Triple

    Default Value: 0010

    9 GPMX_DBL_MIN_CEIL Number(1,0) SMALLINT NOT NULL Double Minimum Ceiling GP Mexico