4-Attachment C - CRISIS and STABILIZATION SPEC 2023 (DHHS26085).pdf
PDF 297 KB Posted
- Attached to
- Stabilization and Mobile Response
- Solicitation number
- DHHS26085
- Issued by
- Utah
About this file
This is a data specification document issued by the Utah Department of Human Services defining file format and data field requirements for Crisis and Stabilization Services reporting, effective July 1, 2022. The specification applies to Local Mental Health Authorities and other agencies contracted by the Department of Human Services and the Division of Substance Abuse and Mental Health (DSAMH) to provide regional administration for the Stabilization and Mobile Response (SMR) program, Mobile Crisis Outreach Team (MCOT) services, and crisis services through Receiving Centers (RC). Providers must submit comma-separated values (CSV) files containing monthly records by the 20th of each month for SMR administrators or by the last day of each month for MCOT and RC providers. The document establishes file generation guidelines, sort rules, and a specific filename protocol format (CrisisStab_NN_YYYYQQ_YYYYMMDD_01.CSV) to ensure consistent data submission and processing across regional administrators and service providers.
The specification defines 37 data fields required for reporting crisis and stabilization service events, including client identifiers, demographic information (name, gender, date of birth, language preference, insurance status), service delivery details (program indicator, stage of engagement, service event ID), and outcome measures (outcome assessment scores, perception of alternative outcomes, law enforcement involvement). Client name validation rules specify that legal names must be used with hyphens as the only allowable punctuation character, spaces prohibited in last names, and no numeric characters or titles permitted. The document establishes protocols for handling unknown clients in MCOT and Receiving Center services by using default identifiers and allows for system transaction type coding (Add, Delete, Change) to track data modifications. All files must be submitted without header rows, free of commas within data fields, without quotation marks, and without blank lines between rows to ensure proper automated processing and data integrity.
View the file
Other files
Show all 11
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CRISIS and STABILIZATION SERVICES
File Format and Definitions
FY2023
Effective 7/1/2022
Department of Human Services
Created 6/12/2018
Change Log
DATE AUTHOR VERSION NOTES
6/30/2021 Kristin Swenson, Terry Barker .04 Added 13 (returned home) option to End_of_service_location field
7/10/2020 Kristin Swenson, Terry Barker .03 Made the County field required
6/19/2020 Kristin Swenson, Terry Barker .02 Removed the 97 (unknown) option from Emergency Indicator Field.
6/19/2020 Kristin Swenson .01 Removed requirement to round time to the nearest quarter hour
Introduction
This data specification is for information gathered by
• Local Mental Health Authorities and other agencies contracted by Department of Human Services to provide regional administration for the Stabilization and Mobile Response (SMR) program;
• Local Mental Health Authorities and other agencies contracted by DSAMH to provide Mobile Crisis Outreach Team (MCOT) services; and
• Local Mental Health Authorities providing crisis services through Receiving Centers (RC).
Comma-separated values (CSV) files, containing all records from the previous month, will be transferred from the regional administrator (SMR) on or before the 20th day of each month, or from Local Authorities or other providers (MCOT and RC) to Division of Substance Abuse and Mental Health on or before the last day of each month.
CSV File Generation Guidelines
1. All files should be submitted without a header row.
2. Non-required fields must either be blank or contain a valid value.
3. Commas are not allowed within the data in any field. (Commas are column delimiters.)
4. Do not use quotation marks in any fields.
5. Do not insert blank lines between rows of data.
File Processing Sort Rules
Sort as follows with subsequent sort rules applying within the ‘parent’ sort rule:
-Sy_trans_type_cd (Delete, Add and then Change)
-ProviderID (numeric ascending)
-SMR_ClientID (alphanumeric ascending)
-Provider_ClientID (alphanumeric ascending)
-EventDate (descending)
Filename Protocol
Uploaded filenames will be formatted to identify the service (CrisisStab), followed by the mental health or SMR-MCOT provider ID, followed by the fiscal year and quarter, followed by the year and date of the upload, followed by the daily sequence (upload attempt number for the given date), with underscore separators. The file name format is CrisisStab_NN_YYYYQQ_YYYMMDD_01.CSV. A filename example for a first file sent from Davis Behavioral Health during January of 2020 is CrisisStab_03_2020Q3_20200105_01.csv.
Upload will only be allowed only if a filename is valid. Only Contracted SMR Administrators can submit SMR data. All providers with MCOT services or Receiving Center services may submit MCOT data or RC data.
Definitions
Identified Client
SMR--Calls to the SMR phone line may be made by parents, caregivers or other concerned parties. SMR callers must identify a child, age 20 or younger, as the identified client who is the focus of the intervention.
MCOT--Identified Client for MCOT may include anyone in crisis across the lifespan that receives services from MCOT.
RC—Identified Client for RC may include anyone in crisis across the lifespan that received services from a Receiving Center.
Event
SMR--An SMR event is a transaction between a SMR staff member, or contracted provider of an SRM regional administrative agency and the identified SMR client or identified client’s caregiver(s). Every call to the SMR phone line is an event, as is every mobile response, stabilization and post-stabilization contact associated with the SMR program.
MCOT--Event for MCOT entails either a mobile crisis response from a team including a licensed mental health clinician and a peer support specialist or equivalent, or a follow-up service offered for a minimum of 60 days post-crisis.
RC—Event for RC entails any service provided, in person, at a Receiving Center.
Resolution
At the end of each SMR event, the staff member or contracted provider will code the event as resolved or unresolved. Events coded as resolved indicate that no further action is anticipated by the SMR team.
Unresolved events are open cases in which Mobile Response teams are deployed, referrals are made to Stabilization services or Stabilization services are on-going.
Stage of Engagement
● Stage 01: Triage (SMR only)—any phone call made to the SMR line about an identified client not yet referred to either Mobile Response or Stabilization services or about a previously identified client who was coded as Resolved at the last event.
● Stage 02: Mobile Response—SMR: any open-case event related to an identified client after the identified client received a triage code initiating a Mobile Response service (i.e., 1-hour response, 24-hour response or 72-hour response) and prior to any Stabilization events.
MCOT: any MCOT service provided as a crisis response by a two-person MCOT team.
● Stage 03: Stabilization (SMR only)—any open-case event in which the identified client has been referred to Stabilization services but has not yet entered the Post-Stabilization phase.
● Stage 04: Post-Stabilization—SMR: any open-case event after the Identified Client completes stabilization services and agrees to post-stabilization follow-up and before a subsequent event is marked as resolved. MCOT: any post-crisis stabilization services provided w/in 60 days of the Mobile Response service.
Emergency Indicator
This indicator should be set to yes when a service is provided on an immediate or unscheduled basis and deals with a psychological emergency of a patient. Routine informational calls handled by crisis staff are not to be reported as crisis/emergency. Examples of behaviors targeted by crisis/emergency services are suicide attempts, violent family fights, panic attacks, uncontrollable behavior and other behaviors that are a threat to self or others.
Client Name Validation Rules:
**Same as DSMH mental health spec FY2020** *Use legal names rather than nicknames*
SMR file will have fields for the following parts of a name:
● Last name
● First name
● Middle name
Names can be entered in either upper case, lower case, or a mix.
Spaces: Allowed in first and middle names. NOT allowed in last names.
Example: Mc Donald should be entered as McDonald D La Cruz should be entered as DeLaCruz Example: Le Ann Mary Ann Mc Cartney Can be entered as:
First: Le Ann Middle: Mary Ann Last: McCartney
Hyphens: Allowed in first, middle, and last names. The hyphen is only allowable punctuation character allowed.
Examples:
(last name) Smith-Jones should be entered as Smith-Jones (first name) Jo-Ann should be entered as Jo-Ann (last name) O’Rilley should be entered as ORilley (last name) St. James should be entered as StJames (first name) D’Ann should be entered as Dann or D Ann
Numeric characters: Not allowed in any names
First name is an initial: The initial can be entered in the first name field but no periods.
Middle name: If there is no middle name or it is not available, leave blank. Supply the full legal middle name where possible and the middle initial if that is all that is available. Periods are not allowed.
Second name: Enter the second name in the middle name filed
Example: J. Edgar Hover First name: J (no period) Middle name: Edgar Last name: Hoover
Titles, Prefixes, Suffixes: not allowed
Naming rules synopsis:
Character Last Name First and Middle Names
Alpha characters Allowed Allowed
Hyphens Allowed Allowed
Spaces Not allowed Allowed
Apostrophe Not allowed Not allowed
Numeric characters Not allowed Not allowed
Unknown Clients:
Occasionally, the nature of the crisis will result in a situation where the identity of a client receiving MCOT services or services at a Receiving Center is unknown. In situations were the identity of a client cannot be determined prior to the end of the episode, the following identifiers may be entered as default. Provider_ClientID(3) = 66666666; FirstName(5) = “AKA”; LastName(6) = “Alias”; Gender(8)= 3;
DOB(9) = “01/01/1919”; County(10)= 097.
Applies to: Field Field Name Description Codes/Allowed
Values Format Required Notes
ALL 1
Program_Indicator
Identifies the service recipient as an SMR client ( 1), an MCOT client ( 2) or a receiving center client (3)
1 = SMR
2 = MCOT
3=RC
Numeric(1) Yes
SMR ONLY 2 SMR_ClientID Client identifier unique to SMR services
String varchar(15) No Required if (1) Program_Indicator =1
Client ID to be unique within the provider. It must not be reassigned to another client of the same provider.
MCOT and RC 3 Provider_ClientID Client identifier unique to service provider
String varchar(15) No Required if
(1)Program_Indic ator>1
ALL 4 Service_Event_ID Provider event record ID number
String value that uniquely identifies a client string(50) Yes Use a unique ID for every event record.
Format Required Notes event for the provider.
ALL 5 FirstName First name of the individual who is the focus of the intervention.
Only characters specified in MH Data Definitions string(25) Yes See client name validation rules.
ALL 6 LastName Last name of the individual who is the focus of the intervention.
Only characters specified in MH Data Definitions string(30) Yes See client name validation rules.
ALL 7 MiddleName Middle name of the individual who is the focus of the intervention.
Only characters specified in MH Data Definitions string(25) No See client name validation rules.
ALL 8 Gender Gender of the individual who is the focus of the intervention.
1=Male
2=Female
3=Non-binary number(1) Yes
ALL 9 DOB Date of birth of the individual who is the focus of the intervention.
Legal date
01/01/0007 if “unknown” string(10)
MM/DD/YYYY
Yes Unknowns required to be <5%
Format Required Notes
ALL 10 County County of residence at time of initial call
001=Beaver 003=Box Elder 005=Cache 007=Carbon 009=Daggett 011=Davis 013=Duchesne 015=Emery 017=Garfield 019=Grand 021=Iron 023=Juab 025=Kane 027=Millard 029=Morgan 031=Piute 033=Rich 035=Salt Lake 037=San Juan 039=Sanpete 041=Sevier 043=Summit 045=Tooele 047=Uintah 049=Utah 051=Wasatch 053=Washington 055=Wayne 057=Weber 097=Unknown string(3) Yes
Format Required Notes
ALL 11 Race Race of the individual who is the focus of the intervention.
01=Alaskan Native 02=American Indian 03=Asian 04=Native Hawaiian or Other Pacific Islander 05=Black/African American 06=White 07=Unknown 08=Two or more races 00=Other single race number(2) No Required if (1)Program indicator=3 or if (15) Stage_of_Engagm ent>1
ALL 12 Hispanic Hispanic or Latino origin of the individual who is the focus of the intervention.
Y=Yes N=No 97=Unknown string(2) No Required if (1)Program indicator=3 or if (15)Stage_of_Enga gment>1
Format Required Notes
ALL 13 Language Preferred language of the family (SMR) or individual (MCOT) who is the focus of the intervention.
00-English 01=American sign language 02=Arabic 03=Bosnian 04=Cambodian 05=Chinese 06=Croatian 07=Farsi 08=French 09=Greek 10=German 11=Italian 12=Japanese 13=Kurdish 14=Laotian 15=Native American: Navajo 16=Native American: Ute 17=Russian 18=Samoan 19=Serbian 20=Somali 21=Spanish 22=Swahili 23=Tibetan 24=Tongan 25=Vietnamese 26=Zulu 27=Other 97=Unknown string(2) No Required if (1)Program indicator=3 or if (15)Stage_of_Enga gment>1
Format Required Notes
ALL 14 Insurance Medical insurance category of the individual who is the focus of the intervention.
01=Private insurance 03=Medicare 04=Medicaid 06=Other 07=Unknown 08=None
09=CHIP
number(2) No Required if (1)Program indicator=3 or if (15)Stage_of_Enga gment>1
SMR and MCOT 15 Stage_of_Engageme nt
Phase of engagement when service was provided
01=Triage 02=Mobile crisis outreach 03=Stabilization 04=Follow up number(2) No Required if (1)
<3.
If
Program_Indicator =2, (15) Stage_of_Engage ment must =2 or
MCOT and RC
16 Primary Presenting Concerns
Primary reason for MCOT call out or admission to receiving center
1= Suicidal risk 2=Harm to self 3=Harm to others 4=substance use 5=Psychosis or grave disability concern number(2) No Required if (1) Program-Indicator =2 and (16)Stage_of_enga gement=2
Format Required Notes
6=Situational stress 7=Informational 8=Other or
If(1) Program-indicator =3
MCOT and RC
17 Secondary Presenting Concerns
Primary reason for MCOT call out or admission to receiving center
1= Suicidal risk 2=Harm to self 3=Harm to others 4=substance use 5=Psychosis or grave disability concern 6=Situational stress 7=Informational 8=Other number(2) No
SMR ONLY 18 Triage_Assessment Assessment of need at time of triage call.
01=911 emergency 02=1-hour response 03=24-hour response 04=72-hour response 05=Stabilization only number(2) No Required if (15) Stage_of_Engage ment =1.
Format Required Notes
06=Information only
07=MCOT crisis 98=Not Applicable
SMR ONLY 19 Resolved At the end of the event, was the case closed (resolved=Yes) or were further actions expected (resolved=No)?
Y=Yes N=No string(2) No Required if (1)Program_indica tor=1
ALL 20 ProviderID Provider Identifier (DSAMH Facility Identifier or other created for contractors)
State assigned MH Provider ID string(15) Yes
Identifies the provider of the service using the state assigned provider ID. IDs are always at least 2 characters in length.
ALL 21 EventDateTime Date and time of service
Legal date and time string(19)
MM/DD/YYYY
hh:mm:ss
Yes EventDateTime for receiving centers is time of arrival
Format Required Notes
ALL 22 EventDuration Duration of service in hours
Number of hours Number(6,2)
00NN.NN
Yes Hours must be expressed as decimal fractions (i.e., one hour and 45 minutes=1.75).
MCOT ONLY 23 ResponseTimeToDe stination
Elapsed time from request to arrival at destination
Numbers Number(6,2)
00NN.NN
No Required if (1) Program_Indicator ) = 2 and (15) Stage_of_engage ment =2 and (24) Service Delivery = 2 or 4.
Hours must be expressed as decimal fractions (i.e., one hour and minutes=1.75).
ALL 24 Service Delivery Manner and setting through which service was delivered.
01=Phone -service delivered via phone 02=Client's home—mobile response to client’s home 03=In office-client treated in-person at provider’s number(2) No Required if (1)Program_indica tor<3
Format Required Notes office or facility 04=In community-mobile response to any place other than the client’s home 05=Virtual/telehe alth-service delivered via remote technology including telehealth
SMR ONLY 25 Emergency Indicator Emergency Indicator
Y=Yes N=No string(2) No Required if (1)Program_Indica tor=1
See Emergency Indicator description under Definitions.
ALL 26 Initiator_of_episode person who made the initial call for SMR, Source of call-out for MCOT, or brought client to receiving center for RC
01 = Parent 02 = Identified client 03 = Other family member or friend 04 = Physician or medical facility number(2) No Required if (1) Program_Indicator =1 and (15) Stage_of_engage ment =1
Or if
Format Required Notes
05 = Social or community agency 06 = Educational system 16=law enforcement officer 17=courts or corrections 08 = Private psychiatric/menta l health program 09 = Public psychiatric/menta l health program 10 = Clergy 11 = Private practice mental health professional 12= Stabilization worker 13=Utah Crisis Line 14=Dispatch/911 15 = Other persons or organizations 97 = Unknown 98= Not Applicable
=2 and (15)Stage_of_Enga gement=2
Or if
(1)
= 3
Format Required Notes
SMR ONLY 27 UFACET_completed Has a UFACET been completed?
Y=Yes N=No string(2) No Required if (15)Stage_of_Enga gment=3
SMR ONLY 28 Outcome_assessme nt_completed
Was the Outcome assessment completed during this service?
Y=Yes N=No string(2) No Required if (15)Stage_of_Enga gment=3
ALL 29 End_of_service_loca tion
At the end of the service, where was the client or where was the client expected to go?
13=Went home 01=Remained at home 02=Went to Hospital/ER 31=Went to Residential (substance Use) 32=Went to residential (mental health) 04=Went to Detention/Jail 05=Went to Emergency shelter/Homeless shelter 06=Went to home of friend or family 07=Went to Foster/Proctor placement 08=Individual went missing or number(2) No Required if (1)Program_Indica tor=1 And (15)Stage_of_Enga gement>1 and
(24) Service Delivery >1
Or if
(1)Program_Indica tor=2 and ment=2
(1)Program_Indica tor=3
Format Required Notes left without discharging 09=Went to other 10=Went to Access center/23 hour crisis bed
(MCOT
only)/receiving center 11=Went to Detox (outside of ER) 12=Remained in place
(29) End of service location is not Null
All 30 End of service location2
If answer to (29) End of service location was 9 please clarify response string(30) No Required if (1) (29)End of service location=9 (other)
ALL 31 Law_enforcement_i nvolved
SMR: Between end of previous service (if applicable) and the end of current service, what was the interaction with LE?
MCOT: Between taking the call and ending the client interaction, what
01=No law enforcement was involvement 02=Law enforcement was involved but no charges are filed 03=Law enforcement was involved and charges were filed 04=Family (or provider) doesn't know if law number(2) No Required if (1)Program_Indica tor=1 And Stage_of_Engage ment>1 and (24) Service Delivery >1
Or if
(1)Program_Indica tor=2 and ment=2
Format Required Notes was LE involvement?
RC: Between the client’s arrival and discharge, what was LE involvement?
enforcement was involved or not
Or if (1)Program_Indica tor=3 or if
Or if (31) Law_enforcement _involved is not Null
ALL 32 Perception_of_alter native
"If this service were not available , what do you think the most likely result would have been? "
01=Remain at home 02=Call law enforcement or 03=Hospital/ER 04=Detention/Jail 05=Emergency Shelter/Homeless Shelter 06=Foster or proctor home 07=Youth run away 08=Youth stay with other family member 09=Seek information in another way 27=Other 10=Call child welfare number(2) No Required if (1)SMR_Flag=Y(es) Program_Indicator =1 And Stage_of_Engage ment>1 and (24) service delivery >1
Or if
(1) Program_Indicator =2 and (15)Stage_of_Enga gement=2
Or if (1)Program_Indica tor=3
Or if (32) perception of
Format Required Notes alternative is not Null
ALL 33 Peception_of_altern ative2
If answer to Perception_of_Alt ernative was 27 please answer response string(30) No Required if (32)Perception_of _Alternative=27 (other)
SMR ONLY 34 Outcome_ladder_pr esent
Item score from outcome assessment
1 through 10 =item score number(2) No Required if (28)Outcome_asse ssment_complete d=Y(Yes)
SMR ONLY 35 Outcome_ladder_fu ture
Item score from outcome assessment
1 through 10 =item score number(2) No Required if (28)Outcome_asse ssment_complete d=Y(Yes)
RC ONLY 36 Drop_Off_Time How long the law enforcement officer spent at the receiving center
Number of hours Number(6,2)
00NN.NN
No Required if (1)Program_Indica tor=3 and (26) Initiator of episode =16
Hours must be expressed as decimal fractions (i.e., one hour and
Format Required Notes minutes=1.75).
ALL 37 sy_trans_type_cd System Transaction Type Code
A-Add D-Delete C-Change string(1) Yes
File details come from the government source that posted it. Updated .