ASA, ASQ, ASD - ASCENT

Ascent Colorado is a community-based program that provides treatment and support to youth and young adults 15-29 years old who may be experiencing an early onset of psychosis.

Record Types: ASA (Admission), ASQ (Quarterly Update), ASD (Discharge) | Version: CoBHRM 2026-Q3 | Parent: ADMISSION | Program: Ascent (First Episode Psychosis)

Overview

The ASCENT schema captures data for the First Episode Psychosis (FEP) program. It consists of three record types:

• ASA - Ascent Admission: Initial assessment at program entry
• ASQ - Ascent Quarterly Update: Quarterly progress assessments
• ASD - Ascent Discharge: Final assessment at program completion

This schema is only required for clients enrolled in Ascent/FEP programs (where ASCENT_ENROLLMENT = 1 on the Admission record). If a client has a previous discharge, they must open a new Admission (ASA) before proceeding to quarterly updates (ASQ).

Transaction Types: All record types support Add (A), Update (U), and Replace (R) transactions. See Transaction Types for details.

---

1. Schema Reference

Identifier Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
RECORD_TYPE	Record Type	x(3)	Y	ASA, ASQ, or ASD	See record type descriptions above
TRANSACTION_TYPE	Transaction Type	x(1)	Y	A, U, R	See Transaction Types
BHASO_ADMISSION_IDENTIFIER	Admission Identifier	x(-)	Y	Alphanumeric	Must exist in ADMISSION
EFFECTIVE_DATE	Effective Date	date	Y	YYYY-MM-DD

Program Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
PROGRAM	Program	9(2)	Y	See Program
ASCENT_ADMISSION_DATE	Date of Ascent Admission	date	Y	YYYY-MM-DD	Must be on or after 2016-01-01 and at least 13 years after Client DOB. Must be within same FYQTR as Assessment Date if ASA
REFERRAL_SOURCE	Referral Source	9(2)	Conditional	See Referral Sources	Required for admission records (ASA)
FIRST_EPISODE_DATE	Date of First Episode	date	Y	YYYY-MM-DD	Must be on or after 1980-01-01, after Client DOB, before Ascent Admission Date
ASSESSMENT_COMPLETION_DATE	Date of Assessment Completion	date	Y	YYYY-MM-DD	Used to calculate Fiscal Year and Quarter. Must be on or after 2016-01-01 and on or after Ascent Admission Date

Assessment Fields (Required for all record types)

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
CURRENT_EDUCATION_STATUS	Current Education Status	9(2)	Y	See Current Education Status
QOL	Quality of Life	9(2)	Y	See Quality of Life
SOCIAL_FUNCTIONING	Social Functioning	9(2)	Y	See Social Functioning
ROLE_FUNCTIONING	Role Functioning	9(2)	Y	See Role Functioning

MCSI Fields (Modified Colorado Symptom Index)

All MCSI fields are required. See MCSI (Modified Colorado Symptom Index) for valid values.

BHA Column Name	MCSI Question	Format	Required
MCSI_1	1. How often have you felt nervous, tense, worried, frustrated, or afraid?	9(2)	Y
MCSI_2	2. How often have you felt depressed?	9(2)	Y
MCSI_3	3. How often have you felt lonely?	9(2)	Y
MCSI_4	4. How often have others told you that you acted “paranoid” or “suspicious”?	9(2)	Y
MCSI_5	5. How often did you hear voices, or hear and see things that other people didn’t think were there?	9(2)	Y
MCSI_6	6. How often did you have trouble making up your mind about something, like deciding where you wanted to go or what you were going to do, or how to solve a problem?	9(2)	Y
MCSI_7	7. How often did you have trouble thinking straight or concentrating on something you needed to do (like worrying so much or thinking about problems so much that you can’t remember or focus on other things)?	9(2)	Y
MCSI_8	8. How often did you feel that your behavior or actions were strange or different from that of other people?	9(2)	Y
MCSI_9	9. How often did you feel out of place or like you did not fit in?	9(2)	Y
MCSI_10	10. How often did you forget important things?	9(2)	Y
MCSI_11	11. How often did you have problems with thinking too fast (thoughts racing)?	9(2)	Y
MCSI_12	12. How often did you feel suspicious or paranoid?	9(2)	Y
MCSI_13	13. How often did you feel like hurting yourself or killing yourself?	9(2)	Y
MCSI_14	14. How often have you felt like seriously hurting someone else?	9(2)	Y

Additional Assessment Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
ENGAGEMENT_WITH_PROGRAM	Engagement with Program	9(2)	Y	See Engagement with Program
FAMILY_AND_OR_SUPPORT_SYSTEM	Family and/or Support System	9(2)	N	See Family and/or Support System
PRIOR_SUICIDE_ATTEMPTS	Prior Suicide Attempts (2 years)	9(2)	Conditional	0-99	Required when RECORD_TYPE = ASA; blank for ASQ/ASD
QTR_SUICIDE_ATTEMPTS	Suicide Attempts This Quarter	9(2)	Y	0-99
PRIOR_PSYCH_HOSP_DAYS	Prior Psychiatric Hospitalization Days	9(3)	N	0-731
QTR_PSYCH_HOSP_DAYS	Psychiatric Hospitalization Days This Quarter	9(2)	N	0-92
PRIOR_WIC_DAYS	Prior WIC Days	9(3)	N	0-731
QTR_WIC_DAYS	WIC Days This Quarter	9(2)	N	0-92
ANTIPSYCHOTIC_MEDS	Anti-Psychotic Medication Prescription	9(2)	Y	See Anti-Psychotic Medication
STAGE_OF_CHANGE	Stage of Change	9(2)	N	See Stage of Change	For individuals with SUD diagnosis

Discharge Fields (Conditional on Record Type)

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
DISCHARGE_DATE	Ascent Discharge Date	date	Conditional	YYYY-MM-DD	Required when RECORD_TYPE = ASD; must be blank for ASA/ASQ. Must be on or after 2016-01-01, on or after Ascent Admission Date, on or after Assessment Date, and within same FYQTR as Assessment Date
DISCHARGE_OUTCOME	Ascent Discharge Outcome	9(2)	Conditional	See Discharge Outcomes	Required when RECORD_TYPE = ASD; must be blank for ASA/ASQ

Optional Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
COMMENTS	Comments	x(750)	N	Text

System Metadata Fields

These fields are required in every submission and track record creation and modification:

BHA Column Name	Field Name	Format	Required	Notes
CREATED_DATE	Created Date	yyyy-mm-dd HH24:MI:SS.FF	Y	Date/time record was created
CREATED_BY	Created By	x(100)	Y	User/system that created the record
LAST_UPDATED_DATE	Last Updated Date	yyyy-mm-dd HH24:MI:SS.FF	Y	If TRANSACTION_TYPE = A, must equal CREATED_DATE

---

2. Examples

ASA - Admission Example

Initial Ascent (FEP) admission. Includes REFERRAL_SOURCE and PRIOR_SUICIDE_ATTEMPTS which are required only at admission. Client must be at least 13 years old.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|PROGRAM|ASCENT_ADMISSION_DATE|REFERRAL_SOURCE|FIRST_EPISODE_DATE|ASSESSMENT_COMPLETION_DATE|CURRENT_EDUCATION_STATUS|QOL|SOCIAL_FUNCTIONING|ROLE_FUNCTIONING|MCSI_1|MCSI_2|MCSI_3|MCSI_4|MCSI_5|MCSI_6|MCSI_7|MCSI_8|MCSI_9|MCSI_10|MCSI_11|MCSI_12|MCSI_13|MCSI_14|ENGAGEMENT_WITH_PROGRAM|FAMILY_AND_OR_SUPPORT_SYSTEM|PRIOR_SUICIDE_ATTEMPTS|QTR_SUICIDE_ATTEMPTS|PRIOR_PSYCH_HOSP_DAYS|QTR_PSYCH_HOSP_DAYS|PRIOR_WIC_DAYS|QTR_WIC_DAYS|ANTIPSYCHOTIC_MEDS|STAGE_OF_CHANGE|DISCHARGE_DATE|DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ASA|A|ADM-000001|2024-01-15|01|2024-01-15|01|2023-06-01|2024-01-15|01|01|01|01|01|01|01|01|01|01|01|01|01|01|01|01|01|01|01||0|0|||||01|||||2024-01-15 10:00:00|system|2024-01-15 10:00:00

ASQ - Quarterly Update Example

Quarterly assessment for the same client. REFERRAL_SOURCE and PRIOR_SUICIDE_ATTEMPTS are not required. Discharge fields must be blank.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|PROGRAM|ASCENT_ADMISSION_DATE|REFERRAL_SOURCE|FIRST_EPISODE_DATE|ASSESSMENT_COMPLETION_DATE|CURRENT_EDUCATION_STATUS|QOL|SOCIAL_FUNCTIONING|ROLE_FUNCTIONING|MCSI_1|MCSI_2|MCSI_3|MCSI_4|MCSI_5|MCSI_6|MCSI_7|MCSI_8|MCSI_9|MCSI_10|MCSI_11|MCSI_12|MCSI_13|MCSI_14|ENGAGEMENT_WITH_PROGRAM|FAMILY_AND_OR_SUPPORT_SYSTEM|PRIOR_SUICIDE_ATTEMPTS|QTR_SUICIDE_ATTEMPTS|PRIOR_PSYCH_HOSP_DAYS|QTR_PSYCH_HOSP_DAYS|PRIOR_WIC_DAYS|QTR_WIC_DAYS|ANTIPSYCHOTIC_MEDS|STAGE_OF_CHANGE|DISCHARGE_DATE|DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ASQ|A|ADM-000001|2024-04-15|01|2024-01-15||2023-06-01|2024-04-15|02|02|02|02|02|02|02|02|02|02|02|02|02|02|02|02|02|02|02|||0|||||01|||||2024-04-15 10:00:00|system|2024-04-15 10:00:00

ASD - Discharge Example

Final discharge record. DISCHARGE_DATE and DISCHARGE_OUTCOME are required for ASD. Discharge must be within the same FYQTR as the assessment.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|PROGRAM|ASCENT_ADMISSION_DATE|REFERRAL_SOURCE|FIRST_EPISODE_DATE|ASSESSMENT_COMPLETION_DATE|CURRENT_EDUCATION_STATUS|QOL|SOCIAL_FUNCTIONING|ROLE_FUNCTIONING|MCSI_1|MCSI_2|MCSI_3|MCSI_4|MCSI_5|MCSI_6|MCSI_7|MCSI_8|MCSI_9|MCSI_10|MCSI_11|MCSI_12|MCSI_13|MCSI_14|ENGAGEMENT_WITH_PROGRAM|FAMILY_AND_OR_SUPPORT_SYSTEM|PRIOR_SUICIDE_ATTEMPTS|QTR_SUICIDE_ATTEMPTS|PRIOR_PSYCH_HOSP_DAYS|QTR_PSYCH_HOSP_DAYS|PRIOR_WIC_DAYS|QTR_WIC_DAYS|ANTIPSYCHOTIC_MEDS|STAGE_OF_CHANGE|DISCHARGE_DATE|DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ASD|A|ADM-000001|2024-09-30|01|2024-01-15||2023-06-01|2024-09-30|02|03|03|03|02|02|02|01|01|02|01|01|01|02|01|01|01|02|03|||0|||||01||2024-09-30|01|Client completed program successfully|2024-09-30 10:00:00|system|2024-09-30 10:00:00

Complete Example with Optional Fields

ASA with all optional fields populated including family support, hospitalization history, WIC days, and stage of change.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|PROGRAM|ASCENT_ADMISSION_DATE|REFERRAL_SOURCE|FIRST_EPISODE_DATE|ASSESSMENT_COMPLETION_DATE|CURRENT_EDUCATION_STATUS|QOL|SOCIAL_FUNCTIONING|ROLE_FUNCTIONING|MCSI_1|MCSI_2|MCSI_3|MCSI_4|MCSI_5|MCSI_6|MCSI_7|MCSI_8|MCSI_9|MCSI_10|MCSI_11|MCSI_12|MCSI_13|MCSI_14|ENGAGEMENT_WITH_PROGRAM|FAMILY_AND_OR_SUPPORT_SYSTEM|PRIOR_SUICIDE_ATTEMPTS|QTR_SUICIDE_ATTEMPTS|PRIOR_PSYCH_HOSP_DAYS|QTR_PSYCH_HOSP_DAYS|PRIOR_WIC_DAYS|QTR_WIC_DAYS|ANTIPSYCHOTIC_MEDS|STAGE_OF_CHANGE|DISCHARGE_DATE|DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ASA|A|ADM-000002|2024-03-01|01|2024-03-01|01|2023-09-15|2024-03-01|01|01|01|01|03|03|02|02|03|02|03|02|01|02|01|02|01|03|01|02|1|0|14|0|0|0|01|01|||Initial assessment completed at intake|2024-03-01 11:00:00|jdoe|2024-03-01 11:00:00

---

3. Template

View ASCENT Template

ASCENT schema template with headers and sample rows

---

4. Parsing Rules

CSV Parsing Rules

Property	Value
Encoding	UTF-8
Delimiter	Pipe (|)
Quote Character	Double quote (")
Escape	Backslash (\)
Date Format	YYYY-MM-DD
Timestamp Format	YYYY-MM-DD HH24:MI:SS.FF (Mountain Time)
Null Representation	Empty field (||)

See File Format Requirements for full details on encoding, quoting, data types, and null handling.

---

5. Update Semantics

Primary Keys

Record Type	Primary Key
ASA	RECORD_TYPE + BHASO_ADMISSION_IDENTIFIER
ASQ	RECORD_TYPE + BHASO_ADMISSION_IDENTIFIER
ASD	RECORD_TYPE + BHASO_ADMISSION_IDENTIFIER

Transaction Types

Type	Code	Behavior
Add	A	Creates new record
Update	U	Updates existing record
Replace	R	Overwrites record

---

Related Schemas

Schema	Relationship	Key Field
ADMISSION	Parent	BHASO_ADMISSION_IDENTIFIER
CLIENT	Grandparent	BHASO_CLIENT_IDENTIFIER