| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | JPVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | JPPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | JPRPE1 | Date - Pay Period Ending 1 | Date | Generic Edit | 6 | 0 | |
| 4 | JPRPE2 | Date - Pay Period Ending 2 | Date | Generic Edit | 6 | 0 | |
| 5 | JPDWK1 | Date - Worked 01 | Date | Generic Edit | 6 | 0 | |
| 6 | JPDWK2 | Date - Worked 02 | Date | Generic Edit | 6 | 0 | |
| 7 | JPDWK3 | Date - Worked 03 | Date | Generic Edit | 6 | 0 | |
| 8 | JPDWK4 | Date - Worked 04 | Date | Generic Edit | 6 | 0 | |
| 9 | JPPDBA | DBA Code | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 10 | JPRETP | Retro Pay Type | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | JPPHRW | Hours Worked | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 12 | JPGPA | Amount - Gross Pay | Numeric | Generic Edit | 9 | 2 | Allow NULL? |
| 13 | JPICC | Interim Check Code | Character | UDC (07 IC) | 1 | 0 | Allow NULL? |
| 14 | JPICT | Interim Check Type | Character | UDC | 1 | 0 | Allow NULL? |
| 15 | JPDOCM | Document - Matching(Payment or Item) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | JPCKDT | Date - Pay Check | Date | Generic Edit | 6 | 0 | |
| 17 | JPCYGR | Pay Cycle Group Code | String | UDC (06 PG) | 2 | 0 | Allow NULL? |
| 18 | JPRPM | Payment Method | Character | UDC | 1 | 0 | Allow NULL? |
| 19 | JPANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 20 | JPRLDM | Code - Labor Distribution Method | Character | UDC | 1 | 0 | Allow NULL? |
| 21 | JPRRRC | Rate Retrieval Code | Character | UDC | 1 | 0 | Allow NULL? |
| 22 | JPPF0 | Processing Flag 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | JPPF1 | Processing Flag 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | JPPF2 | Overtime Account Number | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 25 | JPPF3 | Processing Flag 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 26 | JPPF4 | Processing Flag 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 27 | JPPF5 | Processing Flag 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 28 | JPPF6 | Processing Flag 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | JPPF7 | Processing Flag 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 30 | JPPF8 | Processing Flag 08 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 31 | JPPF9 | Processing Flag 09 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 32 | JPRCC1 | Code - Rate Column 01 | Character | UDC | 1 | 0 | Allow NULL? |
| 33 | JPRCC2 | Code - Rate Column 02 | Character | UDC | 1 | 0 | Allow NULL? |
| 34 | JPRCC3 | Code - Rate Column 03 | Character | UDC | 1 | 0 | Allow NULL? |
| 35 | JPRCC4 | Code - Rate Column 04 | Character | UDC | 1 | 0 | Allow NULL? |
| 36 | JPRCC5 | Code - Rate Column 05 | Character | UDC | 1 | 0 | Allow NULL? |
| 37 | JPHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 38 | JPHMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 39 | JPMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 40 | JPMCUO | Business Unit - Chargeout | String | Generic Edit | 12 | 0 | Allow NULL? |
| 41 | JPSG | Last Job Worked | String | Generic Edit | 12 | 0 | Allow NULL? |
| 42 | JPMAIL | Routing Code - Check | String | UDC (06 CR) | 10 | 0 | Allow NULL? |
| 43 | JPUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 44 | JPJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 45 | JPJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 46 | JPSHFT | Shift Code | Character | UDC (06 SH) | 1 | 0 | Allow NULL? |
| 47 | JPSALY | Pay Class (H/S/P) | Character | UDC (05A PK) | 1 | 0 | Allow NULL? |
| 48 | JPPFRQ | Pay Frequency | Character | UDC (06 PF) | 1 | 0 | Allow NULL? |
| 49 | JPP001 | Category Codes - Payroll1 | String | UDC (06 01) | 3 | 0 | Allow NULL? |
| 50 | JPP002 | Category Codes - Payroll2 | String | UDC (06 02) | 3 | 0 | Allow NULL? |
| 51 | JPP003 | Category Codes - Payroll3 | String | UDC (06 03) | 3 | 0 | Allow NULL? |
| 52 | JPP004 | Category Codes - Payroll4 | String | UDC (06 04) | 3 | 0 | Allow NULL? |
| 53 | JPPYST | Pay Status Code | Character | UDC | 1 | 0 | Allow NULL? |
| 54 | JPTARA | Tax Area (Work) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 55 | JPBRDS | Summary Code - Burden History | Character | UDC (06 SU) | 1 | 0 | Allow NULL? |
| 56 | JPICU | Batch Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 57 | JPPCCD | Pay Cycle Code | String | UDC (06 PY) | 5 | 0 | Allow NULL? |
| 58 | JPAMRT | Amount or Rate | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 59 | JPRTTP | Retro Time Processing | Character | UDC | 1 | 0 | Allow NULL? |
| 60 | JPRTOP | Retro Other Processing | Character | UDC | 1 | 0 | Allow NULL? |
| 61 | JPRTJE | Retro Journal Processing | Character | UDC | 1 | 0 | Allow NULL? |
| 62 | JPRTRO | Retro Report Only | Character | UDC | 1 | 0 | Allow NULL? |
| 63 | JPRTFU | Retro Final Update | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | JPSL01 | Selection 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 65 | JPSL02 | Selection 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 66 | JPSL03 | Selection 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 67 | JPSL04 | Selection 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 68 | JPSL05 | Selection 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 69 | JPSL06 | Selection 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 70 | JPSL07 | Selection 07 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 71 | JPSL08 | Selection 08 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 72 | JPSL09 | Selection 09 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 73 | JPSL10 | Selection 10 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 74 | JPSL11 | Selection 11 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 75 | JPSL12 | Selection 12 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 76 | JPSL13 | Selection 13 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 77 | JPSL14 | Selection 14 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 78 | JPSL15 | Selection 15 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 79 | JPSL16 | Selection 16 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 80 | JPSL17 | Selection 17 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 81 | JPJCTY | Payroll Expense Type | Character | UDC (07 PJ) | 1 | 0 | Allow NULL? |
| 82 | JPRRP | Code - Retro Reallocation Code | Character | UDC (05 YN) | 1 | 0 | Allow NULL? |
| 83 | JPAGDT | Date - Payroll Journals | Date | Generic Edit | 6 | 0 | |
