| Table Name | AEMCDTL |
| Long Name | Medicaid Details |
| Description | Individual Transactions to be later transmitted to UNYSIS are stored in this file until the data is transmitted. |
| Prefix | MC |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| md_chid | 15 | char | Child ID | Key Field - links to child file |
| md_staff | 10 | char | Staff ID | |
| md_date | 8 | datetime | Service date | |
| md_enddate | 8 | datetime | End Date | |
| md_code | 7 | char | Service Type | |
| md_units | 5 | char | Units of service | |
| md_group | 5 | decimal | Number in Group | |
| md_comment | 254 | char | Comments | |
| md_positn | 3 | char | Position Code | |
| md_pgid | 3 | char | Program ID | |
| md_minutes | 5 | decimal | Minutes | |
| md_rate | 5 | decimal | ||
| md_pos | 2 | char | Medicaid Place of Service Code | |
| md_key | 10 | char | ||
| md_keymh | 10 | char |