Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MedicalConditions_pkID | int identity | 4 | null |
|
|
Medical condition primary key - Unique identifier for each medical condition record |
||
| MedicalConditions_fkAdmitID | int | 4 | √ | null |
|
|
Medical condition case reference - Links medical condition to PatientAdministration case |
|
| MedicalConditions_MedicalName | nvarchar | 1073741823 | √ | null |
|
|
Medical condition name - Name or title of the medical condition |
|
| MedicalConditions_Description | nvarchar | 1073741823 | √ | null |
|
|
Medical condition description - Detailed description of the medical condition |
|
| MedicalConditions_DateCreated | datetime | 16,3 | √ | null |
|
|
Medical condition creation date - Date when medical condition record was created |
|
| MedicalConditions_DateUpdated | datetime | 16,3 | √ | null |
|
|
Medical condition update date - Date when medical condition was last updated |
|
| MedicalConditions_CreatedBy | int | 4 | √ | null |
|
|
Medical condition created by - UserID who created the medical condition record |
|
| MedicalConditions_UpdatedBy | int | 4 | √ | null |
|
|
Medical condition updated by - UserID who last updated the medical condition |
|
| MedicalConditions_DeletedDate | datetime | 16,3 | √ | null |
|
|
Medical condition deletion date - Date when medical condition was marked as deleted |
|
| MedicalConditions_Link | nvarchar | 1073741823 | √ | null |
|
|
Medical condition link - External link or reference for additional medical condition information |
|
| 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 |
||
| PatientAdmin_vw_ZipCode | varchar | 10 | √ | null |
|
|
Patient zip code - Zip code from patient administration view |
|
| PatientAdmin_vw_patientStatus | varchar | 30 | √ | null |
|
|
Patient status - Patient status from patient administration view |
|
| PatientAdmin_vw_pkID | int | 4 | null |
|
|
Patient admin primary key - Primary key from patient administration view |
||
| PatientAdmin_vw_Status | int | 4 | √ | null |
|
|
Patient admin status - Status code from patient administration view |
|
| PatientAdmin_vw_DateDischarge | smalldatetime | 16 | √ | null |
|
|
Patient discharge date - Discharge date from patient administration view |
|
| PatientAdmin_vw_DistrictId | int | 4 | √ | null |
|
|
Patient district ID - School district identifier from patient administration view |
|
| PatientAdmin_vw_SchoolDistrict | varchar | 50 | √ | null |
|
|
Patient school district - School district name from patient administration view |
|
| PatientAdmin_vw_YearsOld | numeric | 20 | √ | null |
|
|
Patient age in years - Calculated age in years from patient administration view |
|
| PatientAdmin_vw_ThirdBirthDay | datetime | 16,3 | √ | null |
|
|
Patient third birthday - Third birthday date from patient administration view |
Relationships
Close relationships within degrees of separation
