| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | JSPAN8 | Participant Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | JSQE1 | COBRA Qualifying Event 1 | String | UDC (08 QE) | 2 | 0 | Allow NULL? |
| 3 | JSQD1 | Date - Qualifying Event 1 | Date | Generic Edit | 6 | 0 | |
| 4 | JSRPA8 | Responsible Party Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | JSPLAN | Plan ID | String | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | JSAOPT | Plan Additional Option | String | Generic Edit | 3 | 0 | Allow NULL? |
| 7 | JSUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 8 | JSJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 9 | JSJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 10 | JSFDBA | Employee DBA ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 11 | JSSDBA | Employer DBA ID | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 12 | JSCP | Rate - Company Portion | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | JSPREP | Amount - Premium Payment | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | JSQBA | Rate - Qualified Ben. Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | JSPBL | Amount - Premium Balance Due | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 16 | JSPHCD | Premium Handling Charge Due | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 17 | JSPAHC | Payment Handling Charge Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | JSCPD | COBRA Company Portion Duration | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 19 | JSCVP | COBRA Coverage Period | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 20 | JSCPC1 | Continuation Period Code - 01 | Character | UDC | 1 | 0 | Allow NULL? |
| 21 | JSNPR | Number of Payments Received | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 22 | JSNPX | Number of Payments Remaining | Numeric | Generic Edit | 2 | 0 | Allow NULL? |
| 23 | JSDLP | Date - Last Paid | Date | Generic Edit | 6 | 0 | |
| 24 | JSFOC | Code- File Origination | Character | UDC (08 FO) | 1 | 0 | Allow NULL? |
| 25 | JSCBCI | Cobra Coverage Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | JSDWV | Date - COBRA Coverage Waived | Date | Generic Edit | 6 | 0 | |
| 27 | JSDTWR | Date - Waiver Revoked | Date | Generic Edit | 6 | 0 | |
| 28 | JSCYST | Cobra Processed Code | Character | UDC (08 ZK) | 1 | 0 | Allow NULL? |
| 29 | JSEFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 30 | JSEFTE | Date - Ending Effective | Date | Generic Edit | 6 | 0 | |
| 31 | JSCPPC | COBRA Payment Priority | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | JSDTET | Date - Election Period Expires | Date | Generic Edit | 6 | 0 | |
| 33 | JSRPTR | Coverage Termination Reason | String | UDC (08 TP) | 2 | 0 | Allow NULL? |
| 34 | JSDCE | Date - COBRA Elected or Rejected | Date | Generic Edit | 6 | 0 | |
| 35 | JSAN82 | Address Number - 2nd | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | JSUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | JSEAP | Application ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | JSMACH | Workstation | String | Generic Edit | 12 | 0 | Allow NULL? |
| 39 | JSUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | JSUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 41 | JSDCR | Date - COBRA Rejected | Date | Generic Edit | 6 | 0 | |
| 42 | JSDCPT | Date Cobra Plan Terminated | Date | Generic Edit | 6 | 0 | |