| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | JEVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | JEPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | JEVER1 | Version 1 | String | Generic Edit | 10 | 0 | Allow NULL? |
| 4 | JEOVPC | Code - Overtime Processing Type | Character | UDC | 1 | 0 | Allow NULL? |
| 5 | JEPFRQ | Pay Frequency | Character | UDC (06 PF) | 1 | 0 | Allow NULL? |
| 6 | JEPTCT | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 7 | JEPT2C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 8 | JEPT3C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 9 | JEEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 10 | JEEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 11 | JERHPD | Hours Worked - Regular Per Day | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 12 | JEOHPD | Hours Worked - Overtime Per Day | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 13 | JERHPW | Hours Worked - Regular Per Week | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 14 | JEOHPW | Hours Worked - Overtime Per Week | Numeric | Generic Edit | 7 | 2 | Allow NULL? |
| 15 | JEPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 16 | JEOTPT | Pay/Deduction/Benefit Type | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 17 | JETCAL | Code - Type of Calculation | Character | UDC | 1 | 0 | Allow NULL? |
| 18 | JERTCN | Code - Overtime Rate Column | Character | UDC | 1 | 0 | Allow NULL? |
| 19 | JELBDS | Code - Labor Distribution Method | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | JEDTAB | Table Code | String | Generic Edit | 5 | 0 | Allow NULL? |
| 21 | JEPT4C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 22 | JEPT5C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 23 | JEPT6C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 24 | JEPT7C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 25 | JEPT8C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 26 | JEPT9C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 27 | JEPT0C | Pay Type Category | Character | UDC (06 PC) | 1 | 0 | Allow NULL? |
| 28 | JEPF1 | Processing Flag 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | JEPF2 | Overtime Account Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | JEPF3 | Processing Flag 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |