PatientInformationNew_VW

Patient identifier - Unique identifier for each patient/client in the system

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

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

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

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

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

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

Patient city - City of patient’s primary residence

Patient state - State/province of patient’s primary residence

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

Patient phone number - Primary telephone number for patient contact

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

Patient insurance reference - Links to Insurance table for primary insurance coverage

Patient enrollment date - Date when patient was first entered into the system

Patient prescription date - Date of medical prescription or referral for services

Patient agency reference - Links to Agency table for the healthcare provider serving this patient

ForestCare identifier - External system identifier for ForestCare integration

Patient comments - General comments and notes about the patient

Patient district - School or administrative district for the patient

Patient borough - Borough or administrative region for the patient

Prescription date - Date of medical prescription or referral

Patient billing type - Type of billing arrangement for the patient

Annual medical date - Date of annual medical examination

Audiological assessment date - Date of hearing/audiological evaluation

Vision test date - Date of vision screening or examination

Service coordination consent date - Date when service coordination consent was obtained

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

Evaluation consent date - Date when evaluation consent was obtained

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

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

45-day timeline date - Date related to 45-day service timeline requirements

Child information change date - Date when child information was last changed

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 record ID - Medical record number or identifier

HIPAA privacy notice date - Date when HIPAA privacy notice was received

Signature on file flag - Indicates if patient signature is on file

Signature date - Date when consent forms were signed

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

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

Patient death date - Date of death if applicable

Patient employment status - Employment status (for adult patients)

Patient record created by - UserID of the person who created this patient record

Patient record last update date - Timestamp of the most recent patient record update

Patient record updated by - UserID of the person who last modified this patient record

Patient pregnancy status - Pregnancy status indicator

Patient site reference - Links to AgencySite table for primary service location

Patient status - Current status of the patient in the system

Patient data source - Source of patient data entry

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

Patient internal ID - Internal system identifier

Patient email address - Patient or guardian email for communication

Patient import identifier - Reference ID for data migration and import tracking

Patient profile image - Patient profile photo or image

Patient classroom list - List of classrooms associated with the patient

Program name - Name of the healthcare program or service type

Status name - Descriptive name of the patient’s current status

Case status identifier - Unique identifier for the case status

Case admission identifier - Unique identifier for the case admission record

Case admission date - Date when the case was opened or admitted

Case name - Descriptive name for the case

Case identifier - Unique identifier for the case

Case coordinator identifier - Links to AccessUser table for the case coordinator

Case comments - Comments and notes about the case

Case open/closed status - Indicates whether the case is currently open or closed

Case declined date - Date when services were declined

Program type identifier - Links to ProgramType table for the type of program

Case discharge date - Date when the case was closed or discharged

Aging out date - Date when patient ages out of services

Discharge reason identifier - Links to DischargedReason table for reason for discharge

Case status - Current status of the case

Case entry date - Date when the case was entered into the system

Case grouping identifier - Links to CaseCategory table for case categorization

Rate type identifier - Links to RateType table for billing rate classification

Site name - Name of the service site or location (null in this view)

Early intervention referral date - Date when early intervention referral was made (null in this view)