AICaseAndPatientSource_vw

Primary key - Case administration unique identifier for the patient’s enrollment and service episode

Patient reference - Links to the core patient record (foreign key to Patient.PatientID)

EI Hub identifier - Each child has an ID assigned by EI, stored in dbo.PatientIDList table. EI Hub ID corresponds to IdTypeID = 14. Lookup ID types in ics2.dbo.PatientIDTypes table for cross-system patient tracking

Patient first name - Patient’s given name for identification and care coordination

Patient middle name - Patient’s middle name for complete identification

Patient last name - Patient’s family name for identification and care coordination

Patient gender - Patient’s gender for demographic reporting and care planning

Patient birth date - Patient’s date of birth for age calculations and developmental milestone tracking

Patient address - Primary residential address for service delivery and communication

Patient state - State of residence for jurisdictional and regulatory compliance

Patient city - City of residence for local service coordination and provider assignment

Address line 2 - Additional address information such as apartment or unit number

Postal code - ZIP code for geographic service area determination and provider matching

Patient status - Current status of the patient in the system (Active=receiving services, Inactive=services suspended, Discharged=services completed)

Payment source - Paysource name with lookup reference to dbo.PaymentSource_vw table representing the county or funding source covering the patient’s services

Case creation date - When the case was initially created in the system

Last update date - When the case information was most recently modified

Aging out date - Date when the patient will age out of early intervention services (typically 3rd birthday)

Service decline date - Date when services were declined by the family or patient

Discharge date - Date when the patient was discharged from services

Discharge reason - Coded reason for service discharge (completion, family choice, aging out, etc.)

Case comments - Additional notes and comments related to the case management and service delivery

Program name - Name of the service program with lookup reference to ics2.dbo.ProgramType table or intervention type the patient is enrolled in

Case status - Current administrative status of the case with lookup reference to dbo.PatientStatus table (Open=active, Closed=completed, Pending=awaiting action)

School district - Display district of the kid. Bridge table: dbo.PatientInOutsideSource, Lookup table: dbo.OutsideSource. Educational district responsible for the patient, important for transition planning

Referral date - Date when the patient was initially referred to early intervention services

EI referral date - Date when the referral was processed within the Early Intervention system

Case site - Display site of the kid. Bridge table: dbo.CaseSite, Lookup table: dbo.AgencySite. Primary service delivery site or agency location managing the patient’s case

Rate type - Billing rate structure (Per Auth=authorization-based billing, Per Service=individual service billing)

Case type - Display Category of the Case with lookup reference to dbo.CaseCategory table, classification based on service needs or program category