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