GPMX_OVRTM_PARM(SQL Table) |
Index Back |
---|---|
Overtime parametersOvertime parameters GP Mexico |
# | 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 |