| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | APACAD | ACA ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 2 | APVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 3 | APALE | Applicable Large Employer ID | String | UDC (08 LE) | 10 | 0 | Allow NULL? |
| 4 | APACAM | Calculation Method | Character | UDC (08 CM) | 1 | 0 | Allow NULL? |
| 5 | APLBSD | Measurement Period Start Date | Date | Generic Edit | 6 | 0 | |
| 6 | APLBED | Measurement Period End Date | Date | Generic Edit | 6 | 0 | |
| 7 | APADMS | Administration Period Start Date | Date | Generic Edit | 6 | 0 | |
| 8 | APADME | Administration Period End Date | Date | Generic Edit | 6 | 0 | |
| 9 | APSPSD | Stability Period Start Date | Date | Generic Edit | 6 | 0 | |
| 10 | APSPED | Stability Period End Date | Date | Generic Edit | 6 | 0 | |
| 11 | APACWK | Number of Measurement Period Weeks | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 12 | APACMO | Number of Measurement Period Months | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 13 | APACES | ACA Eligibility Status | String | UDC (08 SE) | 2 | 0 | Allow NULL? |
| 14 | APESEDF | Eligibility Status Effective Date From | Date | Generic Edit | 6 | 0 | |
| 15 | APSPADUSC1 | ACA Parameters Spare Date 1 | Date | Generic Edit | 6 | 0 | |
| 16 | APSPADUSC2 | ACA Parameters Spare Date 2 | Date | Generic Edit | 6 | 0 | |
| 17 | APSPASUSC1 | ACA Parameters Spare String 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 18 | APSPASUSC2 | ACA Parameters Spare String 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 19 | APSPANUSC1 | ACA Parameters Spare Numeric 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 20 | APSPANUSC2 | ACA Parameters Spare Numeric 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 21 | APSPACUSC1 | ACA Parameters Spare Char 1 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | APSPACUSC2 | ACA Parameters Spare Char 2 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | APUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | APPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 25 | APJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | APUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 27 | APUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
