EMPLIDPrompt Table: PERSON
EMPL_RCDGPGB_OVT_START_DTGPGB_OVERTM_FACTORDefault Value: %Date
Y/N Table Edit
GPGB_EE_OVRTIME(SQL Table) |
Index Back |
|---|---|
OvertimeCaptures Employee Overtime details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | GPGB_OVT_START_DT |
Date(10) | DATE NOT NULL | Overtime Start Date |
| 4 | GPGB_OVERTM_FACTOR |
Number(7,2) | DECIMAL(6,2) NOT NULL | Overtime Factor |
| 5 | GPGB_OVT_PAY_DT | Date(10) | DATE NOT NULL |
Date used by the Global Payroll Array to determine in which Pay period the overtime entry is to be processed.
Default Value: %Date |
| 6 | GPGB_OVT_END_DT | Date(10) | DATE | Overtime End Date |
| 7 | UNIT_HRS | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Hours per unit |
| 8 | GPGB_HRLY_RT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Salary Based
Y/N Table Edit |
| 9 | RATE_AMOUNT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | Rate Amount |