ACT - Assertive Community Treatment

Assertive Community Treatment program data

Record Type: ACT | Version: CoBHRM 2026-Q3 | Parent: ADMISSION | Program: Assertive Community Treatment

Overview

The ACT (Assertive Community Treatment) schema captures data for intensive community-based mental health treatment programs. ACT teams provide comprehensive services to individuals with severe mental illness who require intensive support to live successfully in the community.

This schema is only required for clients enrolled in ACT programs (where ACT_ENROLLMENT = 1 on the Admission record). Submit ACT records for each reporting period during enrollment.

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	ACT	Must be exact, case-sensitive
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

Assessment Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
ASSESSMENT_COMPLETION_DATE	Date of Assessment Completion	date	Y	YYYY-MM-DD	Used to calculate Fiscal Year and Quarter. Must be on or after 2000-01-01 and on or after Admission Date
QTR_PSYCH_ER_DAYS	Psychiatric Hospital/ER Days This Quarter	9(3)	Y	0-99
QTR_JAIL_DOC_DAYS	Jail/DOC Days This Quarter	9(3)	Y	0-99

Discharge Fields (Conditional)

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
ACT_DISCHARGE_DATE	ACT Discharge Date	date	N	YYYY-MM-DD	Must be within same FYQTR as Assessment Date and on or after Admission Date
ACT_DISCHARGE_OUTCOME	ACT Discharge Outcome	9(2)	Conditional	See Discharge Outcomes	Required if ACT_DISCHARGE_DATE is provided; must be blank if no discharge date

Other Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
COMMENTS	Comments	x(750)	N	Text	Column must be present in the file; value can be blank

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

Minimal Valid Example

Quarterly update for an ACT-enrolled client with no psychiatric or incarceration days.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|ASSESSMENT_COMPLETION_DATE|QTR_PSYCH_ER_DAYS|QTR_JAIL_DOC_DAYS|ACT_DISCHARGE_DATE|ACT_DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ACT|A|ADM-000001|2024-01-31|2024-01-31|0|0||||2024-01-31 10:00:00|system|2024-01-31 10:00:00

Complete Example with Discharge

ACT discharge with outcome and comments. Discharge date must be within the same fiscal year quarter as the assessment date.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|ASSESSMENT_COMPLETION_DATE|QTR_PSYCH_ER_DAYS|QTR_JAIL_DOC_DAYS|ACT_DISCHARGE_DATE|ACT_DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ACT|A|ADM-000001|2024-03-31|2024-03-31|2|0|2024-03-31|01|Successfully transitioned to community-based outpatient services|2024-03-31 10:00:00|system|2024-03-31 10:00:00

Edge Case: High Utilization Quarter

Client experienced multiple psychiatric and incarceration days in the quarter.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|ASSESSMENT_COMPLETION_DATE|QTR_PSYCH_ER_DAYS|QTR_JAIL_DOC_DAYS|ACT_DISCHARGE_DATE|ACT_DISCHARGE_OUTCOME|COMMENTS|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
ACT|A|ADM-000001|2024-06-30|2024-06-30|12|5|||Client experienced crisis episode in April; stabilized by end of quarter|2024-06-30 16:00:00|jdoe|2024-06-30 16:00:00

---

3. Template

View ACT Template

ACT schema template with headers and sample row

---

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 Key

RECORD_TYPE + BHASO_ADMISSION_IDENTIFIER

Transaction Types

Type	Code	Behavior
Add	A	Creates new ACT 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