Patient_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 custom primary key - Unique identifier for each custom patient record

Patient custom reference - Links to Patient table for the associated patient

School district - School district where the patient attends or is enrolled

Medical diagnosis - Detailed medical diagnosis information for the patient

Patient allergies - Known allergies and allergic reactions

Child’s medications - Current medications the child is taking

Regular check-ups - Information about regular medical check-ups

Last check-up date - Date of the most recent medical check-up

Birth location - Location where the patient was born

County of birth - County where the patient was born

Hospital of birth - Hospital where the patient was born

Hospital of discharge - Hospital from which the patient was discharged

Weeks gestation - Number of weeks of gestation at birth

Birth weight - Patient’s weight at birth

Days in NICU - Number of days spent in Neonatal Intensive Care Unit

Patient race - Patient’s racial background for demographic reporting

Patient ethnicity - Patient’s ethnic background (custom field)

Client description - Detailed description of the client/patient

What goes well on most days - Family assessment of positive daily experiences

What is difficult on most days - Family assessment of daily challenges

What would make life easier - Family input on needed support or resources

Medical history - Comprehensive medical history information

Custom comments - Additional comments and notes about the patient

Custom record creation date - Date when custom patient record was created

Custom record created by - UserID of the person who created this custom record

Custom record update date - Date when custom patient record was last updated

Custom record updated by - UserID of the person who last updated this custom record

Custom record deletion date - Soft delete timestamp for audit trail purposes

Lead date - Date related to lead or referral tracking

Market - Market or service area designation

Custom notes - Additional notes and observations about the patient

Number of users - Number of users or family members involved

Test signature - Test signature or signature verification information

Findings plan - Assessment findings and service plan information