| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | JTDTAL | Data File Library | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | JTHRSS | HR Subsystem Name | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | JTEMPH | Employee History (Y/N) | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 4 | JTEH01 | Prompt - Track by Effective Date | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | JTEH02 | Prompt - Employee History 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 6 | JTEH03 | Prompt - Employee History 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 7 | JTEH04 | Prompt - Automatically Add Requisition | Character | UDC (05 AR) | 1 | 0 | Allow NULL? |
| 8 | JTEH05 | Prompt - Position Control Edit Method | Character | UDC (05A PC) | 1 | 0 | Allow NULL? |
| 9 | JTEH06 | Prompt - Employee History 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | JTEH07 | Prompt - Employee History 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 11 | JTEH08 | Prompt - Employee History 08 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | JTEH09 | Prompt - Employee History 09 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 13 | JTEH10 | Prompt - Employee History 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 14 | JTUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 15 | JTPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 16 | JTUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 17 | JTJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 18 | JTFLXC | Flex Credits per Dollar (Conversn Factr) | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 19 | JTYORN | Use Assignment Window | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 20 | JTPRSR | Pay Rate Source | Character | UDC (05A PS) | 1 | 0 | Allow NULL? |
| 21 | JTSPRS | Pay Grade Step Progression Rate Source | Character | UDC (05A PG) | 1 | 0 | Allow NULL? |
| 22 | JTPBF1 | Position Budget Edit - Salary | Character | UDC (08P ES) | 1 | 0 | Allow NULL? |
| 23 | JTPBF2 | Position Budget Edit - FTE | Character | UDC (08P EF) | 1 | 0 | Allow NULL? |
| 24 | JTPBF3 | Position Budget Edit - Hours | Character | UDC (08P HR) | 1 | 0 | Allow NULL? |
| 25 | JTPBF4 | Position Budget Edit - Headcount | Character | UDC (08P HC) | 1 | 0 | Allow NULL? |
| 26 | JTPRF1 | Pay Range/Step Edit | Character | UDC (05A PR) | 1 | 0 | Allow NULL? |
| 27 | JTSDFS | Salary Default Source | Character | UDC (08P SD) | 1 | 0 | Allow NULL? |
| 28 | JTSIP | Rate Change in Projections | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 29 | JTSALD | Salary Display | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | JTMNZ1 | Maintain ESS Timecard History | Character | UDC (05T Z1) | 1 | 0 | Allow NULL? |
| 31 | JTEDETCR | Enable Date Effective Timecard Rates | Character | UDC (05 DE) | 1 | 0 | Allow NULL? |