{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["MHCLD_Clean"],"read":"whole","date_system":"1900"}

{"sheet":"MHCLD_Clean","index":0,"n_rows":255,"n_cols":4,"rows_kept":255,"merged":[[2,0,2,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[9,0,9,3],[10,0,12,0],[10,1,10,2],[10,3,12,3],[11,1,11,2],[13,0,13,3],[16,0,17,0],[21,0,22,0],[23,0,26,0],[28,0,30,0],[32,0,33,0],[32,1,33,1],[32,2,33,2],[34,0,42,0],[43,0,46,0],[50,0,60,0],[61,0,68,0],[69,0,74,0],[75,0,88,0],[89,0,102,0],[103,0,105,0],[106,0,118,0],[119,0,131,0],[132,0,134,0],[135,0,139,0],[140,0,141,0],[142,0,144,0],[145,0,148,0],[149,0,152,0],[153,0,156,0],[157,0,160,0],[161,0,163,0],[164,0,166,0],[167,0,171,0],[172,0,184,0],[185,0,189,0],[190,0,200,0],[201,0,209,0],[210,0,216,0],[217,0,219,0],[220,0,224,0],[225,0,228,0],[229,0,232,0],[245,0,246,0],[245,1,246,1],[245,2,246,2],[247,0,254,0]]}
[{"$nulls":3},"OMB No. 0930-0335"]
[{"$nulls":3},"Expiration Date:  XX/XX/XXXX"]
["Public Burden Statement: An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number.  The OMB control number for this project is 0930-0335.  Public reporting burden for this collection of information is estimated to average XX hours per respondent, per year, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.  Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to SAMHSA Reports Clearance Officer, 5600 Fishers Lane, Room 15E57-A, Rockville, Maryland, 20857."]
[]
[]
["LEGEND"]
["Key field = must not be blank. Key fields, taken together, are used to uniquely identify and link records."]
["Data set classifications, i.e., SDS, MDS, and SuDS, apply to MH-TEDS admission variables only."]
[]
["MH-CLD"]
["Variable Name","Data Field Reference No.",null,"Categories"]
[null,"Data Files"]
[null,"BCI","SHR"]
[]
["Record Type","H-01",null,"H=Header Record"]
["Reporting State Code","H-02","H-01","2 Character State Abbreviation"]
["File Type","H-03","H-02","P=Production"]
[{"$nulls":3},"T=Test"]
["Start of the Report Period","H-04","H-03","YYYYMM - The numeric format for months 1-9 must have a zero as the leading digit."]
["End of the Report Period","H-05","H-04","YYYYMM - The numeric format for months 1-9 must have a zero as the leading digit."]
["Client Record Count","H-06","H-05","######## - Up to 8 digits"]
["Optional Data Elements Report Flag","H-07",null,"1=Yes"]
[{"$nulls":3},"2=No"]
["Diagnostic Code Identifier","H-08",null,"1=DSM-IV"]
[{"$nulls":3},"2=ICD-9"]
[{"$nulls":3},"3=ICD 10"]
[{"$nulls":3},"4=DSM-5"]
["This information is contained in the file name algorithm",null,null,"MMDDYYYY"]
["Transaction Type","C-00","R-00","A=Add"]
[{"$nulls":3},"C=Change"]
[{"$nulls":3},"D=Delete"]
["Client Identifier","C-01","R-01","1-15 Alphanumeric Characters (XXXXXXXXXXXXXXX -  if the states unique ID is fewer than 15 characters, fill the gap with blank spaces)"]
["Client Treatment Status at the Start of the Reporting Period","C-02 ",null," 1=New Client"]
[{"$nulls":3}," 2=Continuing Client"]
["Client Treatment Status at end of the reporting period","C-03",null,"01=Continuing Client"]
[{"$nulls":3},"12=Discharged with Treatment Completed"]
[{"$nulls":3},"22=Discharged Due to Lost Contact/ Administrative Discharge"]
[{"$nulls":3},"32=Discharged to Corrections, Jail"]
[{"$nulls":3},"42=Discharged Due to Death of Client"]
[{"$nulls":3},"52=Aged out"]
[{"$nulls":3},"62=Discharged Due To Other Specified Reasons"]
[{"$nulls":3},"72=Discharged, Reason Unknown"]
[{"$nulls":3},"82=Discharged, Reason Not Collected"]
["Sex","C-04",null,"1=Male "]
[{"$nulls":3},"2=Female "]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not Collected"]
["Age","C-05",null,"0-85=Any Number up to 85"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Race","C-06",null,"02=American Indian or Alaska Native"]
[{"$nulls":3},"03=Asian or Pacific Islander (Temporary code)"]
[{"$nulls":3},"13=Asian"]
[{"$nulls":3},"23=Native Hawaiian or Other Pacific Islander "]
[{"$nulls":3},"04= Black or African American"]
[{"$nulls":3},"05=White"]
[{"$nulls":3},"20=Some Other Race Alone "]
[{"$nulls":3},"21=Two or More Races"]
[{"$nulls":3},"22=Hispanic"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Ethnicity","C-07",null,"01=Hispanic Origin Regardless of Race"]
[{"$nulls":3},"11=Puerto Rican (Optional)"]
[{"$nulls":3},"12=Mexican (Optional)"]
[{"$nulls":3},"13=Cuban (Optional)"]
[{"$nulls":3},"14=Other Specific Hispanic (Optional)"]
[{"$nulls":3},"02=Not of Hispanic Origin"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["SMI/SED Status","C-08",null,"1=SMI"]
[{"$nulls":3},"2=SED"]
[{"$nulls":3},"3=At Risk for SED (Optional)"]
[{"$nulls":3},"4=Not SMI or SED"]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not Collected"]
["Competitive Employment Status (Aged 16+) – at Admission or Start of the Reporting Period","C-09 ",null,"01=Full Time"]
[{"$nulls":3},"02=Part Time"]
[{"$nulls":3},"03=Unemployed"]
[{"$nulls":3},"05=Employed - Full Time/Part Time Not Differentiated (Temporary Code)"]
[{"$nulls":3},"14=Homemaker"]
[{"$nulls":3},"24=Student"]
[{"$nulls":3},"34=Retired"]
[{"$nulls":3},"44=Disabled"]
[{"$nulls":3},"64=Other Reported Classification"]
[{"$nulls":3},"74=Sheltered/Non-Competitive Employment"]
[{"$nulls":3},"84=Not in the Labor Force, Classification not Specified (Temporary Code)"]
[{"$nulls":3},"96=Not Applicable"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Competitive Employment Status (Aged 16+) – at Discharge or End of the Reporting Period","C-10",null,"01=Full Time"]
[{"$nulls":3},"02=Part Time"]
[{"$nulls":3},"03=Unemployed"]
[{"$nulls":3},"05=Employed - Full time/Part Time not Differentiated (Temporary Code)"]
[{"$nulls":3},"14=Homemaker"]
[{"$nulls":3},"24=Student"]
[{"$nulls":3},"34=Retired"]
[{"$nulls":3},"44=Disabled"]
[{"$nulls":3},"64=Other Reported Classification"]
[{"$nulls":3},"74=Sheltered/Non-Competitive Employment"]
[{"$nulls":3},"84=Not in the Labor Force, Classification not Specified (Temporary Code)"]
[{"$nulls":3},"96=Not Applicable"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Competitive Employment Status Update Flag","C-11",null,"0=Data Reported in C-10 is Not an Update for Data Reported in C-09"]
[{"$nulls":3},"1=Data Reported in C-10 is an Update for Data Reported in C-09"]
[{"$nulls":3},"8=Update Status Unknown"]
["Residential Status – at Admission or Start of the Reporting Period","C-12",null,"01=Homeless"]
[{"$nulls":3},"02=Foster Home/Foster Care "]
[{"$nulls":3},"03=Residential Care "]
[{"$nulls":3},"04=Crisis Residence"]
[{"$nulls":3},"05=Institutional Setting "]
[{"$nulls":3},"06=Jail/Correctional Facility/Other Institutions under the Justice System "]
[{"$nulls":3},"07=Private Residence - Living Arrangement not Known (for adult use only)"]
[{"$nulls":3},"17=Private Residence - Independent Living (for adult use only)"]
[{"$nulls":3},"27=Private Residence - Dependent Living (for adult use only)"]
[{"$nulls":3},"37=Private Residence (for children use only)"]
[{"$nulls":3},"08=Other Residential Status"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Residential Status – at Discharge or End of Reporting Period","C-13",null,"01=Homeless"]
[{"$nulls":3},"02=Foster Home/Foster Care "]
[{"$nulls":3},"03=Residential Care "]
[{"$nulls":3},"04=Crisis Residence"]
[{"$nulls":3},"05=Institutional Setting "]
[{"$nulls":3},"06=Jail/Correctional Facility/Other Institutions under the Justice System "]
[{"$nulls":3},"07=Private Residence - Living Arrangement not Known (for adult use only)"]
[{"$nulls":3},"17=Private Residence - Independent Living (for adult use only)"]
[{"$nulls":3},"27=Private Residence - Dependent Living (for adult use only)"]
[{"$nulls":3},"37=Private Residence (for children use only)"]
[{"$nulls":3},"08=Other Residential Status"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Residential Status Update Flag","C-14",null,"0=Data Reported in C-13 is Not an Update for Data Reported in C-12"]
[{"$nulls":3},"1=Data Reported in C-13 is an Update for Data Reported in C-12"]
[{"$nulls":3},"8=Update Status Unknown"]
["Service Setting Status Throughout the Reporting Period ","C-15",null,"1=State Psychiatric Hospital"]
[{"$nulls":3},"2=SMHA-Funded/Operated Community-Based Program "]
[{"$nulls":3},"3=Residential Treatment Center "]
[{"$nulls":3},"4=Other Psychiatric Inpatient "]
[{"$nulls":3},"5=Institutions under the Justice System"]
["One Service Date Flag","C-16",null,"1=One Service Date"]
[{"$nulls":3},"2=Multiple Service Dates"]
["Mental Health Diagnosis - one","C-17",null,"XXX.XXXX=DSM-IV, DSM-5, ICD-9 or ICD-10 Mental Health Diagnosis Code "]
[{"$nulls":3},"999.9997=Unknown"]
[{"$nulls":3},"999.9998=Not collected"]
["Mental Health Diagnosis - Two","C-18",null,"XXX.XXXX=DSM-IV, DSM-5, ICD-9 or ICD-10 Mental Health Diagnosis Code "]
[{"$nulls":3},"999.9996=No Second Diagnosis"]
[{"$nulls":3},"999.9997=Unknown"]
[{"$nulls":3},"999.9998=Not Collected"]
["Mental Health Diagnosis - Three","C-19",null,"XXX.XXXX=DSM-IV, DSM-5, ICD-9 or ICD-10 Mental Health Diagnosis Code "]
[{"$nulls":3},"999.9996=No Third Diagnosis"]
[{"$nulls":3},"999.9997=Unknown"]
[{"$nulls":3},"999.9998=Not Collected"]
["Substance Use Diagnosis","C-20",null,"XXX.XXXX=DSM-IV, DSM-5, ICD-9 or ICD-10 Substance Use Diagnosis Code"]
[{"$nulls":3},"999.9996=No Substance Use Diagnosis "]
[{"$nulls":3},"999.9997=Unknown"]
[{"$nulls":3},"999.9998=Not Collected"]
["Substance Use Disorder","C-21",null,"1=Yes"]
[{"$nulls":3},"2=No"]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not collected"]
["Number of Arrests in Prior 30 Days – at Admission or Start of the Reporting Period","C-22 ",null,"00-96=Any Number up to 96"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Number of Arrests in Prior 30 Days – at Discharge or End of the Reporting Period","C-23",null,"00-96=Any Number up to 96"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["School Attendance Status – at Discharge or End of the Reporting Period","C-24",null,"1=Yes, client has attended school at any time in the past 3 months "]
[{"$nulls":3},"2=No, client has not attended school at any time in the  in the past 3 months "]
[{"$nulls":3},"6=Not Applicable"]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not Collected"]
["School Grade Level","C-25",null,"00=No Years of Schooling"]
[{"$nulls":3},"01-12=Grades 1 through 12"]
[{"$nulls":3},"13=Nursery School, Preschool (Inlcuding Head Start)"]
[{"$nulls":3},"14=Kindergarten"]
[{"$nulls":3},"15=Self-contained Special Education Class (No Equivalent Grade Level)"]
[{"$nulls":3},"16=Vocational School"]
[{"$nulls":3},"17=College Undergraduate Freshman (1st Year)"]
[{"$nulls":3},"18=College Undergraduate Sophomore (2nd Year)"]
[{"$nulls":3},"19=College Undergraduate Junior (3rd Year)"]
[{"$nulls":3},"20=College Undergraduate Senior (4th year) or Bachelor’s Degree"]
[{"$nulls":3},"21=Graduate or Professional School (e.g., Master's, Doctoral, Medical, or Law School)"]
[{"$nulls":3},"97 = Unknown"]
[{"$nulls":3},"98=Not Collected"]
["School Attendance Status – at Admission or Start of the Reporting Period   ","C-26",null,"1=Yes, client has attended school at any time in the past 3 months "]
[{"$nulls":3},"2=No, client has not attended school at any time in the  in the past 3 months "]
[{"$nulls":3},"6=Not Applicable"]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not Collected"]
["Gender Identity (Optional Reporting)","O-01",null,"01=Male"]
[{"$nulls":3},"02=Female"]
[{"$nulls":3},"03=Transgender (Male to Female)"]
[{"$nulls":3},"13=Transgender (Female to Male)"]
[{"$nulls":3},"23=Transgender [Temporary code]"]
[{"$nulls":3},"04=Two-Spirit [American Indian or Alaska Native only]"]
[{"$nulls":3},"06=Other"]
[{"$nulls":3},"16=I don't know"]
[{"$nulls":3},"26=Prefer not to answer"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Sexual Orientation (Optional Reporting)","O-02",null,"01=Straight or Heterosexual"]
[{"$nulls":3},"02=Lesbian or Gay"]
[{"$nulls":3},"03=Bisexual"]
[{"$nulls":3},"04=Two-Spirit [American Indian or Alaska Native only]"]
[{"$nulls":3},"06=Other"]
[{"$nulls":3},"16=I don't know"]
[{"$nulls":3},"26=Prefer not to answer"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Marital Status (Optional Reporting)","O-03",null,"01=Never Married"]
[{"$nulls":3},"02=Married/Living as Couple"]
[{"$nulls":3},"03=Separated"]
[{"$nulls":3},"04=Divorced"]
[{"$nulls":3},"05=Widowed"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Global Assessment of Functioning (Adults)/Children's Global Assessment Scale (Optional Reporting)","O-04",null,"0-100  GAF/CGAS Score"]
[{"$nulls":3},"997=Unknown"]
[{"$nulls":3},"998=Not Collected"]
["Type of Funding Support (Optional Reporting)","O-05",null,"01=Medicaid Only"]
[{"$nulls":3},"02=Medicaid and Non-Medicaid Sources"]
[{"$nulls":3},"03=Non-Medicaid Only"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Mental Health Block Grant-Funded Services (Optional Reporting)","O-06",null,"01=Yes, MHBG Used to Pay for Services & Supports"]
[{"$nulls":3},"02=No, MHBG Funds Were Not Used"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["Veteran Status  (Optional Reporting)","O-07",null,"1=Veteran"]
[{"$nulls":3},"2=Not a Veteran"]
[{"$nulls":3},"7=Unknown"]
[{"$nulls":3},"8=Not Collected"]
["SH-Discharge Sequence Number",null,"R-02","## - chronological order of discharge events from the earliest (numbering starts at 1 per client)"]
["SH-Discharge Reason",null,"R-03","01=Completed State Hospital Inpatient Treatment"]
[{"$nulls":3},"02=Released by or to Courts "]
[{"$nulls":3},"03=Left Against Medical Advice/Eloped or Failed to Return from Leave/Non-Compliance with Treatment and/or Policy                                                          "]
[{"$nulls":3},"04=Client Choice "]
[{"$nulls":3},"05=Extended Placement"]
[{"$nulls":3},"06=Death"]
[{"$nulls":3},"07=Discharged to Other Inpatient Provider"]
[{"$nulls":3},"08=Discharged to an Acute Medical Facility for Medical Services "]
[{"$nulls":3},"09=Discharged, Reason not Classified Elsewhere"]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]
["SH-Number of Days Elapsed Before State Hospital Readmission ",null,"R-04","### - calculated difference between the discharge date and next admission date"]
[{"$nulls":3},"998 = If readmission event did not occur after a discharge event"]
["State Hospital-Admission Legal Status ",null,"R-05","01=Voluntary - Self "]
[{"$nulls":3},"02=Voluntary - Others (by Guardian, Parents, etc.) "]
[{"$nulls":3},"03=Involuntary - Civil "]
[{"$nulls":3},"04=Involuntary - Criminal"]
[{"$nulls":3},"05=Involuntary - Juvenile Justice "]
[{"$nulls":3},"06=Involuntary - Civil - Sexual "]
[{"$nulls":3},"97=Unknown"]
[{"$nulls":3},"98=Not Collected"]