Patient_PatientAdministration_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

Patient custom primary key - Unique identifier for each custom patient record

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

Patient custom creation date - Timestamp when the custom record was created

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

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

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

Patient custom deletion date - Soft delete timestamp for audit trail purposes

Patient allergies - Patient’s known allergies and adverse reactions

Patient birth location - Location where patient was born

Patient birth weight - Patient’s weight at birth

Patient medications - Current medications the patient is taking

Patient custom comments - Additional clinical observations and notes

Patient county of birth - County where patient was born

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

Patient description - Detailed description of the patient/client

Patient daily challenges - Description of difficulties experienced on most days

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

Patient findings plan - Clinical findings and care plan

Patient daily strengths - Description of what goes well on most days

Patient birth hospital - Hospital where patient was born

Patient discharge hospital - Hospital from which patient was discharged

Patient last checkup date - Date of most recent medical checkup

Patient lead screening date - Date of lead exposure screening

Patient market - Market or service area designation

Patient medical diagnosis - Primary medical diagnoses

Patient medical history - Comprehensive medical history

Patient custom notes - Additional clinical notes and observations

Patient care team size - Number of people involved in patient’s care

Patient race - Patient’s racial background

Patient regular checkups - Frequency of regular medical checkups

Patient school district - School district for educational coordination

Patient test signature - Digital signature for testing purposes

Patient gestational age - Gestational age at birth in weeks

Patient life improvements - What would make patient’s life easier

Admin custom primary key - Unique identifier for each custom administration record

Admin custom case reference - Links to PatientAdministration table for the case

Admin referral date - Date when patient was referred for services

Admin referral source - Source of the referral (doctor, agency, etc.)

Admin referral contact name - Name of person making the referral

Admin referral phone - Phone number of referral source

Admin developmental concerns - Specific developmental concerns noted at referral

Admin case status - Current status of the administrative case

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

Admin age out date - Date when patient will age out of services

Admin other programs - Other programs or services the patient is involved with

Admin referral concerns - Detailed concerns noted in the referral

Admin payment type - Type of payment arrangement for services

Admin custom creation date - Timestamp when the custom administration record was created

Admin custom created by - UserID of the person who created this administration record

Admin custom last update date - Timestamp of the most recent administration record update

Admin custom updated by - UserID of the person who last modified this administration record

Admin custom deletion date - Soft delete timestamp for audit trail purposes

Admin allergies - Patient’s known allergies (administration context)

Admin birth location - Location where patient was born (administration context)

Admin birth weight - Patient’s weight at birth (administration context)

Admin medications - Current medications (administration context)

Admin comments - Administrative comments and notes

Admin county of birth - County where patient was born (administration context)

Admin CPSE meeting date - Date of Committee on Preschool Special Education meeting

Admin CPSE service location - Location where CPSE services are provided

Admin CSPE IEP program - Committee on Special Education IEP program details

Admin CSPE location - Location where CSPE services are provided

Admin CSPE notes - Notes related to Committee on Special Education services

Admin CSPE service - Type of Committee on Special Education service

Admin CSPE start date - Start date for Committee on Special Education services

Admin transition date - Date when patient will transition to next level of care

Admin NICU days - Number of days spent in NICU (administration context)

Admin client description - Administrative description of the patient/client

Admin daily challenges - Administrative notes on daily challenges

Admin EI transition - Early intervention transition planning information

Admin ethnicity - Patient’s ethnic background (administration context)

Admin daily strengths - Administrative notes on daily strengths

Admin group sessions per week - Number of group therapy sessions per week

Admin birth hospital - Hospital where patient was born (administration context)

Admin discharge hospital - Hospital from which patient was discharged (administration context)

Admin IFSP section 7 - Individualized Family Service Plan section 7 information

Admin IFSP date - Date of Individualized Family Service Plan

Admin IFSP completion date - Date when IFSP was completed

Admin IFSP plan of care - Individualized Family Service Plan care details

Admin IFSP type - Type of Individualized Family Service Plan

Admin individual sessions per week - Number of individual therapy sessions per week

Admin last checkup date - Date of most recent medical checkup (administration context)

Admin medical diagnosis - Medical diagnoses (administration context)

Admin medical history - Medical history (administration context)

Admin notes - Administrative notes and observations

Admin other information - Additional administrative information

Admin parent major outcome - Major outcomes identified by parents

Admin person responsible - Person responsible for case management

Admin provider - Healthcare provider assigned to the case

Admin race - Patient’s racial background (administration context)

Admin regular checkups - Frequency of regular checkups (administration context)

Admin school district - School district (administration context)

Admin gestational age - Gestational age at birth (administration context)

Admin life improvements - What would make life easier (administration context)

Admin print name ID - Identifier for printed name on forms

Admin test signature - Digital signature for testing (administration context)

Admin findings plan of care - Clinical findings and care plan (administration context)

Admin IFSB insurance changed - Indicator if IFSB insurance information changed

Admin first service date - Date of first service delivery

Admin note date - Date when administrative note was created

Admin priority - Priority level for case management

Admin client zip code - Client’s zip code for administrative purposes

Admin text time - Time-related text field for administrative use

Admin classrooms - Classroom assignments for the patient

Admin date value - Generic date field for administrative use

Admin date type - Type or category of the date value

Admin center location - Location of service center

Admin test date field - Date field for testing purposes

Admin county of residence - County where patient resides

Admin evaluation date - Date of patient evaluation

Admin choice field - Administrative choice or selection field

Admin view first name - Patient’s first name from administration view

Admin view middle name - Patient’s middle name from administration view

Admin view last name - Patient’s last name from administration view

Admin view gender - Patient’s gender from administration view

Admin view birth date - Patient’s date of birth from administration view

Admin view address - Patient’s address from administration view

Admin view state - Patient’s state from administration view

Admin view city - Patient’s city from administration view

Admin view address line 2 - Patient’s secondary address from administration view

Admin view source ID - Source identifier from administration view

Admin view ID value - ID value from administration view

Admin view ID type - ID type identifier from administration view

Admin view site ID - Site identifier from administration view

Admin view case ID - Case identifier from administration view

Admin view case reference - Case reference from administration view

Admin view created by - User who created the record from administration view

Admin view creation date - Creation date from administration view

Admin view update date - Last update date from administration view

Admin view updated by - User who last updated the record from administration view

Admin view program type - Program type identifier from administration view

Admin view grouping ID - Grouping identifier from administration view

Admin view patient ID - Patient identifier from administration view

Admin view admit ID - Admission identifier from administration view

Admin view aging out date - Date when patient ages out from administration view

Admin view case name - Case name from administration view

Admin view full name - Patient’s full name from administration view

Admin view program name - Program name from administration view

Admin view program ID - Program identifier from administration view

Admin view zip code - Zip code from administration view

Admin view patient status - Patient status from administration view

Admin view primary key - Primary key from administration view

Admin view status - Status from administration view

Admin view discharge date - Discharge date from administration view

Admin view district ID - District identifier from administration view

Admin view school district - School district from administration view

Admin view years old - Patient’s age in years from administration view

Admin view third birthday - Third birthday date from administration view

Admin view referral date - Referral date from administration view

Admin view EI referral date - Early intervention referral date from administration view

Admin view case site - Case site from administration view

Admin view rate type ID - Rate type identifier from administration view

Admin view comments - Comments from administration view

Admin view case coordinator ID - Case coordinator identifier from administration view