Patient

Primary key - Unique identifier for each patient/client in the system

First name - Patient’s given name for identification and communication

Middle name - Patient’s middle name or initial for complete identification

Last name - Patient’s surname for identification and alphabetical sorting

Gender - Patient’s gender for demographic reporting and appropriate care matching

Birth date - Patient’s date of birth for age calculations and eligibility determination

Primary address - Patient’s street address for service delivery and communication

City - City of patient’s primary residence

State - State/province of patient’s primary residence

Postal code - ZIP/postal code for patient’s address

Phone number - Primary telephone number for patient contact

Ethnicity - Patient’s ethnic background for demographic reporting and cultural considerations

Insurance reference - Links to Insurance table for primary insurance coverage

Enrollment date - Date when patient was first entered into the system

Prescription date - Date of medical prescription or referral for services

Agency reference - Links to iCS2.dbo.Agency for centralized healthcare provider organization management serving this patient

Forest Care ID - External system identifier for Forest Care integration

General comments - Administrative notes about the patient

School district - School district reference for educational service coordination

Borough - Geographic borough or region for service area management

Prescription date - Date of medical prescription or service order

Billing type - Reference to billing classification for this patient

Annual medical date - Date of annual medical examination

Audiological exam date - Date of hearing assessment

Vision test date - Date of vision screening

Service coordination consent - Date when service coordination consent was obtained

Information release consent - Date when consent to release information was obtained

Evaluation consent - Date when evaluation consent was obtained

Family info worksheet date - Date when family information worksheet was completed

Medical info worksheet date - Date when medical information worksheet was completed

45-day timeline - Date related to 45-day evaluation timeline requirements

Child info change date - Date when child information was last updated

Surrogacy form date - Date when surrogacy form was completed

Closure form date - Date when case closure form was completed

Other insurance flag - Indicates if patient has additional insurance coverage

Medical ID - Medical record number or identifier

HIPAA privacy date - Date when HIPAA privacy notice was received

Signature on file - Indicates if patient signature is on file

Signature date - Date when consent forms were signed

Current age - Patient’s current age (calculated field)

Marital status - Patient’s marital status (for adult patients)

Death date - Date of death if applicable

Employment status - Employment status (for adult patients)

Created by user - UserID of the person who created this patient record

Last update date - Timestamp of the most recent record update

Updated by user - UserID of the person who last modified this record

Pregnancy status - Pregnancy status indicator

Site reference - Links to AgencySite table for primary service location

Patient status - Current status of the patient in the system

Data source - Source of patient data entry

Address line 2 - Additional address information (apartment, suite, etc.)

Internal ID - Internal system identifier

Email address - Patient or guardian email for communication

Import identifier - Reference ID for data migration and import tracking

Profile image - Patient profile photo or image

Classroom list - List of classrooms or educational settings