GPMX_OVRTM_PARM(SQL Table) | 
Index Back | 
|---|---|
Overtime parametersOvertime parameters GP Mexico | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | 
Global Payroll pay group
 Prompt Table: GP_PYGRP  | 
|
| 2 | Character(3) | VARCHAR2(3) NOT NULL | 
Country
 Default Value: MEX  | 
|
| 3 | 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 |