Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SpecialConditions_pkID | int identity | 4 | null |
|
|
Special condition identifier - Primary key for the special condition record |
||
| SpecialConditions_fkAdmitID | int | 4 | √ | null |
|
|
Case reference - Links to the patient case (AdmitID) associated with this special condition |
|
| SpecialConditions_SpecialConditionName | nvarchar | 1073741823 | √ | null |
|
|
Condition name - Name or title of the special condition |
|
| SpecialConditions_Description | nvarchar | 1073741823 | √ | null |
|
|
Condition description - Detailed description of the special condition and its implications |
|
| SpecialConditions_DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the special condition record was created |
|
| SpecialConditions_DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the special condition record was last modified |
|
| SpecialConditions_CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the special condition record |
|
| SpecialConditions_UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the special condition record |
|
| SpecialConditions_DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the special condition was soft-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 for the patient from patient administration view |
|
| PatientAdmin_vw_City | varchar | 50 | √ | null |
|
|
Patient city - City of residence for the patient from patient administration view |
|
| PatientAdmin_vw_Address2 | varchar | 50 | √ | null |
|
|
Patient address line 2 - Secondary address line for the patient from patient administration view |
|
| PatientAdmin_vw_fkSourceID | varchar | 30 | √ | null |
|
|
Payment source reference - Links to the payment source from patient administration view |
|
| PatientAdmin_vw_IDvalue | varchar | 30 | √ | null |
|
|
Patient ID value - Patient identifier value from patient administration view |
|
| PatientAdmin_vw_IDTypeID | int | 4 | √ | null |
|
|
ID type reference - Links to the type of patient identifier from patient administration view |
|
| PatientAdmin_vw_siteID | int | 4 | √ | null |
|
|
Service site reference - Links to the service delivery site from patient administration view |
|
| PatientAdmin_vw_fkCaseID | int | 4 | √ | null |
|
|
Case reference - Links to the case from patient administration view |
|
| PatientAdmin_vw_caseID | int | 4 | √ | null |
|
|
Case identifier - Case ID from patient administration view |
|
| PatientAdmin_vw_CreatedBy | int | 4 | √ | null |
|
|
Case created by user - UserID of the person who created the case from patient administration view |
|
| PatientAdmin_vw_DateCreated | smalldatetime | 16 | √ | null |
|
|
Case creation date - Date when the case was created from patient administration view |
|
| PatientAdmin_vw_DateUpdated | smalldatetime | 16 | √ | null |
|
|
Case update date - Date when the case was last updated from patient administration view |
|
| PatientAdmin_vw_UpdatedBy | int | 4 | √ | null |
|
|
Case updated by user - UserID of the person who last updated the case from patient administration view |
|
| PatientAdmin_vw_ProgramTypeID | int | 4 | √ | null |
|
|
Program type reference - Links to the program type from patient administration view |
|
| PatientAdmin_vw_groupingID | int | 4 | √ | null |
|
|
Grouping identifier - Grouping ID for case organization from patient administration view |
|
| PatientAdmin_vw_PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to the patient record from patient administration view |
|
| PatientAdmin_vw_AdmitID | int | 4 | null |
|
|
Admission identifier - Unique identifier for the patient admission/case from patient administration view |
||
| PatientAdmin_vw_DateAgingOut | datetime | 16,3 | √ | null |
|
|
Aging out date - Date when the patient ages out of services from patient administration view |
|
| PatientAdmin_vw_CaseName | varchar | 255 | √ | null |
|
|
Case name - Descriptive name for the case from patient administration view |
|
| PatientAdmin_vw_FullName | varchar | 101 | √ | null |
|
|
Patient full name - Concatenated full name of the patient from patient administration view |
|
| PatientAdmin_vw_ProgramName | varchar | 255 | √ | null |
|
|
Program name - Name of the program type from patient administration view |
|
| PatientAdmin_vw_ProgramID | int | 4 | null |
|
|
Program identifier - Program ID from patient administration view |
Relationships
Close relationships within degrees of separation
