| Table Name | AEMCM |
| Long Name | Medicaid Download From DHS |
| Description | This file would be downloaded on a regular basis from Medicaid to update medicaid numbers which exist but have eluded entry into AEAIMS. |
| Prefix | MC |
| Field Name | Length | Type | Description | Comments |
|---|---|---|---|---|
| mm_last | 13 | char | Last Name | |
| mm_first | 8 | char | First Name | |
| mm_dob | 8 | datetime | Birthdate | |
| mm_ssn | 9 | char | Social Security Number | |
| mm_medi | 8 | char | Medicaid Number | |
| mm_county | 2 | char | County | |
| mm_sex | 1 | char | Gender | |
| mm_m1 | 1 | char | Eligible Current Month -3 | |
| mm_m2 | 1 | char | Eligible Current Month -2 | |
| mm_m3 | 1 | char | Eligible Current Month -1 | |
| mm_m4 | 1 | char | Eligible Current Month |