PatientAdmin_Allergies_vw


Description

Patient administration allergies view providing comprehensive patient information combined with allergy data. This view joins Allergies and PatientAdmin_vw tables to support clinical care coordination, allergy management, safety protocols, and comprehensive patient care planning. Essential for healthcare providers to access complete patient profiles including demographics, case information, and critical allergy information in a single consolidated view for safe and effective treatment delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Allergies_pkID int identity 4 null

Allergy primary key - Unique identifier for each allergy record
Allergies_fkAdmitID int 4 √ null

Allergy case reference - Links allergy to PatientAdministration case
Allergies_AllergieName nvarchar 1073741823 √ null

Allergy name - Name or type of the allergy
Allergies_Description nvarchar 1073741823 √ null

Allergy description - Detailed description of the allergy and reactions
Allergies_DateCreated datetime 16,3 √ null

Allergy creation date - Date when allergy record was created
Allergies_DateUpdated datetime 16,3 √ null

Allergy update date - Date when allergy was last updated
Allergies_CreatedBy int 4 √ null

Allergy created by - UserID who created the allergy record
Allergies_UpdatedBy int 4 √ null

Allergy updated by - UserID who last updated the allergy
Allergies_DeletedDate datetime 16,3 √ null

Allergy deletion date - Date when allergy was marked as deleted
PatientAdmin_vw_FirstName varchar 50 √ null

Patient first name - First name of the patient from patient administration view
PatientAdmin_vw_MiddleName varchar 50 √ null

Patient middle name - Middle name of the patient from patient administration view
PatientAdmin_vw_LastName varchar 50 √ null

Patient last name - Last name of the patient from patient administration view
PatientAdmin_vw_Sex varchar 20 √ null

Patient gender - Gender of the patient from patient administration view
PatientAdmin_vw_DateOfBirth datetime 16,3 √ null

Patient birth date - Date of birth of the patient from patient administration view
PatientAdmin_vw_Address varchar 50 √ null

Patient address - Primary address of the patient from patient administration view
PatientAdmin_vw_State varchar 50 √ null

Patient state - State of residence from patient administration view
PatientAdmin_vw_City varchar 50 √ null

Patient city - City of residence from patient administration view
PatientAdmin_vw_Address2 varchar 50 √ null

Patient address 2 - Secondary address line from patient administration view
PatientAdmin_vw_fkSourceID varchar 30 √ null

Patient source ID - Source identifier from patient administration view
PatientAdmin_vw_IDvalue varchar 30 √ null

Patient ID value - Patient identification value from patient administration view
PatientAdmin_vw_IDTypeID int 4 √ null

Patient ID type - Type of patient identification from patient administration view
PatientAdmin_vw_siteID int 4 √ null

Patient site ID - Site identifier from patient administration view
PatientAdmin_vw_fkCaseID int 4 √ null

Patient case reference - Case reference from patient administration view
PatientAdmin_vw_caseID int 4 √ null

Patient case ID - Case identifier from patient administration view
PatientAdmin_vw_CreatedBy int 4 √ null

Patient admin created by - UserID who created patient administration record
PatientAdmin_vw_DateCreated smalldatetime 16 √ null

Patient admin creation date - Date when patient administration record was created
PatientAdmin_vw_DateUpdated smalldatetime 16 √ null

Patient admin update date - Date when patient administration was last updated
PatientAdmin_vw_UpdatedBy int 4 √ null

Patient admin updated by - UserID who last updated patient administration
PatientAdmin_vw_ProgramTypeID int 4 √ null

Patient program type - Program type identifier from patient administration view
PatientAdmin_vw_groupingID int 4 √ null

Patient grouping ID - Grouping identifier from patient administration view
PatientAdmin_vw_PatientID int 4 √ null

Patient identifier - Patient ID from patient administration view
PatientAdmin_vw_AdmitID int 4 null

Patient admission ID - Admission identifier from patient administration view
PatientAdmin_vw_DateAgingOut datetime 16,3 √ null

Patient aging out date - Date when patient ages out of program from patient administration view
PatientAdmin_vw_CaseName varchar 255 √ null

Patient case name - Case name from patient administration view
PatientAdmin_vw_FullName varchar 101 √ null

Patient full name - Complete patient name from patient administration view
PatientAdmin_vw_ProgramName varchar 255 √ null

Patient program name - Program name from patient administration view
PatientAdmin_vw_ProgramID int 4 null

Patient program ID - Program identifier from patient administration view

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views