Data Extraction Process Detail
Requirements for File Transfer
After the on-site or virtual visit, the SO will:
- Export all data files to either a tab- or comma-delimited file
- Make sure there are consistent naming conventions between files
- Supplement data files with Microsoft Word or Excel data dictionary or file layout files, describing the details of each data file transferred, as seen in the example below
| Name | Description | Data Type/Length | Data Values | Calculation |
|---|---|---|---|---|
| M_ID | Member ID | Character (16) | N/A | Unique counts |
| DOR | Grievance Date of Receipt | Date (MMDDYYYY) | N/A | Date |
| M Status | Member Status | Numeric (2) | 01=Enrolled 02=Disenrolled | N/A |