| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | J1PAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | J1QE1 | COBRA Qualifying Event 1 | String | UDC (08 QE) | 2 | 0 | Allow NULL? |
| 3 | J1QD1 | Date - Qualifying Event 1 | Date | Generic Edit | 6 | 0 | |
| 4 | J1AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 5 | J1RPA8 | Responsible Party Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | J1DCLS | Date - Regular Coverage Lost | Date | Generic Edit | 6 | 0 | |
| 7 | J1QDM1 | Date - Election Mailed Qual Event 1 | Date | Generic Edit | 6 | 0 | |
| 8 | J1DCE | Date - COBRA Elected or Rejected | Date | Generic Edit | 6 | 0 | |
| 9 | J1DEXP | Date - Election Period Expires | Date | Generic Edit | 6 | 0 | |
| 10 | J1DCST | Date - COBRA Coverage Starts | Date | Generic Edit | 6 | 0 | |
| 11 | J1DCX | Date - COBRA Expires | Date | Generic Edit | 6 | 0 | |
| 12 | J1DWV | Date - COBRA Coverage Waived | Date | Generic Edit | 6 | 0 | |
| 13 | J1DTC | Date - COBRA Terminated | Date | Generic Edit | 6 | 0 | |
| 14 | J1TRSC | COBRA Termination Reason | String | UDC (08 TM) | 2 | 0 | Allow NULL? |
| 15 | J1CVP | COBRA Coverage Period | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 16 | J1NPX | Number of Payments Remaining | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 17 | J1DTMI | Date - Medicare Entitlement | Date | Generic Edit | 6 | 0 | |
| 18 | J1DT | Date - Terminated | Date | Generic Edit | 6 | 0 | |
| 19 | J1TRS | Change Reason | String | UDC (06 T) | 3 | 0 | Allow NULL? |
| 20 | J1DTRA | Date - Reported Admin. | Date | Generic Edit | 6 | 0 | |
| 21 | J1DTER | Date - Event Reported | Date | Generic Edit | 6 | 0 | |
| 22 | J1DTNL | Date - Notice to Convert | Date | Generic Edit | 6 | 0 | |
| 23 | J1SKDH | Date - Strike | Date | Generic Edit | 6 | 0 | |
| 24 | J1UN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 25 | J1RTDT | Date - Retirement | Date | Generic Edit | 6 | 0 | |
| 26 | J1AN82 | Address Number - 2nd | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | J1HMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 28 | J1HMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 29 | J1JBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 30 | J1JBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 31 | J1SAL | Rate - Salary Annual | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 32 | J1MCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 33 | J1TARR | Tax Area (Residence) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | J1DTWR | Date - Waiver Revoked | Date | Generic Edit | 6 | 0 | |
| 35 | J1DIVC | Benefit Group | String | Generic Edit | 6 | 0 | Allow NULL? |
| 36 | J1DTDH | Date - Death | Date | Generic Edit | 6 | 0 | |
| 37 | J1DTNR | Date - Notice Received | Date | Generic Edit | 6 | 0 | |
| 38 | J1DTMR | Date - Remittance Mailed | Date | Generic Edit | 6 | 0 | |
| 39 | J1DTOD | Date - Disability | Date | Generic Edit | 6 | 0 | |
| 40 | J1DTOB | Date - Bankruptcy | Date | Generic Edit | 6 | 0 | |
| 41 | J1DTET | Date - Election Period Expires | Date | Generic Edit | 6 | 0 | |
| 42 | J1USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | J1EAP | Application ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | J1MACH | Workstation | String | Generic Edit | 12 | 0 | Allow NULL? |
| 45 | J1UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 46 | J1UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |