File Uploads
Project Description
The New Mexico State Behavioral Health Services Division (BHSD) requires behavioral health data from the MCOs on both adults and children served. Data loads will be completed for every 12month period and must include all individuals who received at least one behavioral or mental health service. This document describes the requirements for data that the BHSD is requesting from the MCOs. It describes the sources of the data and the format of the required data.
File Information
File Transfer Options
Files must be uploaded manually to the Falling Colors SFTP site and then an email sent to support@fallingcolors.com letting FC know the file is ready to be uploaded manually to the STAR web application.
File Format
All files are .csv file type. A separate file per MCO is required. The file name should be named like: Molina_CSS2018.csv. Each MCO file should contain enough clients to meet the defined goal for that MCO for that survey year taking into account clients that do not want to participate after being contacted or cannot be reached. A header row is required.
Data Files
MCO Client FileÂ
Field Name | Field Length | Is Required? | Field Format/Allowable Values |
EntityConsumerId | 30 | Yes | VARCHAR |
FirstName | 30 | Yes | VARCHAR |
LastName | 30 | Yes | VARCHAR |
MiddleInitial | 1 | No | VARCHAR |
Suffix | 30 | No | VARCHAR |
GuardianFirstName | 30 | Yes | VARCHAR If not known use Unknown |
GuardianLastName | 30 | Yes | VARCHAR If not known use Unknown |
PhoneNumber | 10 | Yes | Numeric XXXXXXXXXX |
AgeGroup | 1 | Yes | A = Adult F = Family |
Gender | 1 | Yes | M = Male F = Female U = Unknown |
Ethnicity | 2 | Yes | HS = Hispanic NH = Not of Hispanic or Latino or Spanish origin UK = Unknown |
Race | 30 | Yes | African American Asian Caucasian Native American Other Unknown |
Ccl | 4 | No | CC-1 CC-2 CC-3 CC-4 CC-5 CC-6 CC-7 |
PrimaryLanguage | 10 | No | English Spanish Other Unknown |
Geo | 11 | Yes | Urban Rural Frontier Unspecified |
AddressLine1 | 200 | No | VARCHAR |
AddressLine2 | 200 | No | VARCHAR |
City | 50 | No | VARCHAR |
State | 2 | No | VARCHAR |
ZipCode | 10 | No | XXXXX-XXXX |
County | 30 | No | VARCHAR |
LeadAgencyID | 20 | No | VARCHAR |
DateOfBirth | 10 | Yes | DD-MM-YYYY |