Patient_PatientInsurance_vw

Insurance custom primary key - Unique identifier for each custom insurance record

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

Insurance information update date - Date when insurance information was last updated

Parent consent flag - Indicates if parent has consented to insurance use

Insurance plan - Name or type of insurance plan

Insurance company name - Name of the insurance company

Insurance company phone - Phone number of the insurance company

Insurance company billing address - Billing address for the insurance company

Insurance name - Name or description of the insurance coverage

Policy holder name - Name of the insurance policy holder

Policy holder birth date - Date of birth of the policy holder

Policy holder gender - Gender of the policy holder

Policy holder address - Address of the policy holder

Policy holder phone - Phone number of the policy holder

Policy holder relationship to child - Relationship of policy holder to the patient

Policy holder employer name - Name of policy holder’s employer

Employer address - Address of the policy holder’s employer

Employer phone - Phone number of the policy holder’s employer

Policy for billing - Policy number or identifier for billing purposes

Group number - Insurance group number

Policy effective to date - End date of policy coverage

Is Child Health Plus plan - Indicates if this is a Child Health Plus plan

Is Medicaid managed care plan - Indicates if this is a Medicaid managed care plan

Is self-funded plan - Indicates if this is a self-funded insurance plan

Medicaid CIN number - Medicaid Client Identification Number

CIN effective from date - Start date for CIN validity

CIN effective to date - End date for CIN validity

Insurance record creation date - Date when insurance record was created

Insurance record update date - Date when insurance record was last updated

Insurance record created by - UserID of the person who created this insurance record

Insurance record updated by - UserID of the person who last updated this insurance record

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

Child member identification number - Member ID for the child on the insurance plan

Is insurance plan regulated - Indicates if the insurance plan is regulated

Is the insurance plan - Additional insurance plan classification

Policy effective from date - Start date of policy coverage

Type of insurance plan - Classification or type of insurance plan

Municipality - Municipality information for insurance coverage

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