BAB - Special Connections Baby

Special Connections - Baby outcomes data

Record Type: BAB | Version: CoBHRM 2026-Q3 | Parent: ADMISSION | Program: Special Connections

Overview

The SC BABY schema captures birth and baby outcome data for the Special Connections (SC) program, which serves pregnant and postpartum women with substance use disorders. This record documents outcomes for babies born to program participants.

This schema is only required for Special Connections program participants who give birth during enrollment. Submit one BAB record per baby born.

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	BAB	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 (mother’s admission)
EFFECTIVE_DATE	Effective Date	date	Y	YYYY-MM-DD
BHASO_BABY_IDENTIFIER	BHASO Baby Identifier	x(-)	Y		Unique identifier for baby

Birth Outcome Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
LIVE_BIRTH	Live Birth	bit	Y	1 / 0
DOB	Baby Date of Birth	date	Conditional	YYYY-MM-DD	Required if LIVE_BIRTH = 1
WEIGHT_LBS	Baby Weight (Pounds)	9(2)	Conditional	00-25	Required if LIVE_BIRTH = 1
WEIGHT_OZ	Baby Weight (Ounces)	9(2)	Conditional	00-15	Required if LIVE_BIRTH = 1

Baby Identification Fields

BHA Column Name	Field Name	Format	Required	Valid Values	Notes
LAST_NAME	Baby Last Name	x(50)	Conditional	Text	Required if LIVE_BIRTH = 1. Regex: [\p{L} -']+
FIRST_NAME	Baby First Name	x(50)	Conditional	Text	Required if LIVE_BIRTH = 1. Regex: [\p{L} -']+
MIDDLE_NAME_INITIAL	Baby Middle Name or Initial	x(50)	N	Text	Regex: [\p{L} -']+
SEX_AT_BIRTH	Baby Sex at Birth	9(2)	Conditional	See Sex at Birth	Required if LIVE_BIRTH = 1

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 - Live Birth

Healthy baby born to a Special Connections participant. All conditionally required fields populated because LIVE_BIRTH = 1.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|BHASO_BABY_IDENTIFIER|LIVE_BIRTH|DOB|WEIGHT_LBS|WEIGHT_OZ|LAST_NAME|FIRST_NAME|MIDDLE_NAME_INITIAL|SEX_AT_BIRTH|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
BAB|A|ADM-000002|2024-06-15|BABY-ID-01|1|2024-06-15|07|04|Garcia|Sofia||01|2024-06-15 10:00:00|system|2024-06-15 10:00:00

Complete Example - Live Birth with Middle Name

All fields populated including optional MIDDLE_NAME_INITIAL.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|BHASO_BABY_IDENTIFIER|LIVE_BIRTH|DOB|WEIGHT_LBS|WEIGHT_OZ|LAST_NAME|FIRST_NAME|MIDDLE_NAME_INITIAL|SEX_AT_BIRTH|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
BAB|A|ADM-000002|2024-06-15|BABY-ID-01|1|2024-06-15|06|12|Garcia|Carlos|J|02|2024-06-15 10:00:00|jdoe|2024-06-15 10:00:00

Stillbirth Example

When LIVE_BIRTH = 0, the baby identification and weight fields are not required.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|BHASO_BABY_IDENTIFIER|LIVE_BIRTH|DOB|WEIGHT_LBS|WEIGHT_OZ|LAST_NAME|FIRST_NAME|MIDDLE_NAME_INITIAL|SEX_AT_BIRTH|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
BAB|A|ADM-000005|2024-07-20|BABY-ID-01|0||||||||2024-07-20 10:00:00|system|2024-07-20 10:00:00

Edge Case: Multiple Births

For twins or multiples, submit one BAB record per baby. Each record shares the same BHASO_ADMISSION_IDENTIFIER but has a different BHASO_BABY_IDENTIFIER.

RECORD_TYPE|TRANSACTION_TYPE|BHASO_ADMISSION_IDENTIFIER|EFFECTIVE_DATE|BHASO_BABY_IDENTIFIER|LIVE_BIRTH|DOB|WEIGHT_LBS|WEIGHT_OZ|LAST_NAME|FIRST_NAME|MIDDLE_NAME_INITIAL|SEX_AT_BIRTH|CREATED_DATE|CREATED_BY|LAST_UPDATED_DATE
BAB|A|ADM-000006|2024-08-10|BABY-ID-01|1|2024-08-10|05|08|Johnson|Ava||01|2024-08-10 10:00:00|system|2024-08-10 10:00:00
BAB|A|ADM-000006|2024-08-10|BABY-ID-02|1|2024-08-10|05|02|Johnson|Mia||01|2024-08-10 10:01:00|system|2024-08-10 10:01:00

---

3. Template

View SC BABY Template

SC BABY 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 + BHASO_BABY_IDENTIFIER

Transaction Types

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

---

Related Schemas

Schema	Relationship	Key Field
ADMISSION	Parent	BHASO_ADMISSION_IDENTIFIER
CLIENT	Grandparent (Mother)	BHASO_CLIENT_IDENTIFIER
SC PREGNANCY RISK	Sibling	BHASO_ADMISSION_IDENTIFIER