PatientAdmin_vw

Patient first name - First name of the patient

Patient middle name - Middle name of the patient

Patient last name - Last name of the patient

Patient gender - Gender of the patient

Patient birth date - Date of birth of the patient

Patient address - Primary address of the patient

Patient state - State of residence for the patient

Patient city - City of residence for the patient

Patient address 2 - Secondary address line for the patient

Payment source ID - Payment source identifier from PaysourceInCase

Patient ID value - Patient identification value from PatientIDList

Patient ID type - Type of patient identification from PatientIDList

Site identifier - Site ID from CaseSite table

Payment case reference - Case reference from PaysourceInCase

Case identifier - Case ID from CaseSite table

Created by user - UserID who created the patient administration record

Creation date - Date when patient administration record was created

Last update date - Date when patient administration was last updated

Updated by user - UserID who last updated the patient administration

Program type reference - Links to program type configuration

Grouping identifier - Grouping ID for patient administration

Patient reference - Links to Patient table

Admission identifier - Primary key from PatientAdministration table

Aging out date - Date when patient ages out of the program

Case name - Name assigned to the case

Patient full name - Concatenated last name and first name

Program name - Name of the program from getProgramTypes function

Program identifier - Program ID from getProgramTypes function

Patient zip code - Zip code for the patient’s address

Patient status - Current status of the patient

Primary key - AdmitID used as primary key for the view

Administration status - Status of the patient administration record

Discharge date - Date when patient was discharged

School district ID - School district identifier from PatientInOutsideSource

School district name - Name of the school district from OutsideSource

Patient age - Calculated age in years based on date of birth

Third birthday - Date of patient’s third birthday

Referral date - Date of referral from PatientReferral

EI referral date - Date of Early Intervention referral from PatientReferral

Case site name - Name of the site from CaseSite and AgencySite tables

Rate type reference - Links to rate type configuration

Administration comments - Comments about the patient administration

Case coordinator ID - Identifier for the case coordinator