Skip to main content
CoBHRM uses enrollment flags and demographic data on the Admission and Client records to determine which child records and fields are required. This page documents every conditional trigger in the model.

Survey Trigger Rules

The Admission record contains enrollment flag fields. When set to 1 (true), they trigger the requirement for additional survey records.
Baby Data (BAB) is required when a birth occurs during a Special Connections enrollment. There is no separate flag — it is submitted per birth event.

Records Required for All Admissions

Regardless of enrollment flags, every admission requires:

Records Required for SUD and Co-Occurring Admissions

The following are required only when the Service Identifier indicates a Substance Use or co-occurring admission. They are not allowed for mental health-only records.
Primary, secondary, and tertiary substance types at discharge must match those at admission. If they differ, the admission SUD Survey record must be updated before proceeding with discharge.

Special Connections Decision Tree

The Special Connections program enrollment follows a specific decision tree based on demographic data.
1

Check Sex at Birth

Is SEX_AT_BIRTH = Female (01)?
  • No: Set PREGNANCY_STATUS = 0, WITHIN_1_YEAR_POSTPARTUM_STATUS = 0, SPECIAL_CONNECTIONS_ENROLLMENT = 0. No further checks needed.
  • Yes: Continue to next step.
2

Check Age Range

For PREGNANCY_STATUS: Is the client between 12 and 55 years old (based on DOB)? For WITHIN_1_YEAR_POSTPARTUM_STATUS: Is the client 12 or older (no upper age limit)?
  • No to both: Set PREGNANCY_STATUS = 0, WITHIN_1_YEAR_POSTPARTUM_STATUS = 0, SPECIAL_CONNECTIONS_ENROLLMENT = 0. No further checks needed.
  • Yes: Continue to next step.
3

Determine Pregnancy or Postpartum Status

Is the client currently pregnant?
  • Yes: Set PREGNANCY_STATUS = 1. Proceed to SC enrollment check.
  • No: Is the client within 1 year postpartum? If yes, set WITHIN_1_YEAR_POSTPARTUM_STATUS = 1. Proceed to SC enrollment check. If no, set both to 0.
4

Set Special Connections Enrollment

If PREGNANCY_STATUS = 1 or WITHIN_1_YEAR_POSTPARTUM_STATUS = 1, the client must be enrolled in Special Connections:
  • Set SPECIAL_CONNECTIONS_ENROLLMENT = 1
  • Pregnancy Risk Screening (PRS) record is required

Conditional Fields by Record Type

Client Record

Admission Record

Discharge Record

SUD Survey

The same conditional pattern applies to Secondary and Tertiary substance fields. If a substance is reported (not 00), the number of days used in the last 30 days is required at both admission and discharge, and the associated route of use and start age fields are required at admission.

Ascent Survey

ACT Survey

Pregnancy Risk Screening

Baby Data

Cross-Record Validation Rules

In addition to field-level conditions, CoBHRM enforces rules that span multiple record types.

Identifier Linking

  • Every Admission must reference a valid BHASO_CLIENT_IDENTIFIER that exists in the Client table
  • Every child record must reference a valid BHASO_ADMISSION_IDENTIFIER that exists in the Admission table

Diagnosis Pairing

  • Every completed admission requires both a DXA (admission) and DXD (discharge) diagnosis record
  • Both reference the same BHASO_ADMISSION_IDENTIFIER

SUD Survey Pairing

  • Every SUD or co-occurring admission requires both an SIA (admission) and SID (discharge) substance use record
  • SIA/SID are not allowed for mental health-only admissions
  • Both reference the same BHASO_ADMISSION_IDENTIFIER

Pregnancy / Postpartum Logic Chain

This logic chain spans Client, Admission, Pregnancy Risk Screening, and Baby Data:
1

Client: Sex at Birth

SEX_AT_BIRTH on the Client record determines eligibility
2

Admission: Pregnancy Status

If Female (01) and age 12-55, PREGNANCY_STATUS is collected on the Admission
3

Admission: Postpartum Status

If not pregnant, WITHIN_1_YEAR_POSTPARTUM_STATUS may be collected
4

Admission: SC Enrollment

If pregnant or postpartum, SPECIAL_CONNECTIONS_ENROLLMENT should be 1
5

PRS Record Required

If SC enrolled, a Pregnancy Risk Screening (PRS) record is required
6

Baby Data on Birth

If a birth occurs during SC enrollment, a Baby Data (BAB) record is required
Pending update: Both the Legal Status codes and Service Identifier codes have been renumbered. The matrix below references the previous numbering and is expected to be replaced before April 1, 2026 once the new mapping is finalized.
At Discharge, the Legal Status must be compatible with the Admission’s Service Identifier: See Cross-Tab Dependencies for the full referential integrity rules.
Last modified on March 26, 2026