Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
CreatedUserId | int | Not Null | UserId of the user who created the row. |
StaffAssociation_Oid | int | Not Null | ObjectId of HStaffPatientAssoHistory rows generated by Architecture. |
Staff_oid | int | Null | Associated Staff ObjectID. Must be in HStaff table. |
ExternalHCProfessional_oid | int | Null | Associated External Staff ObjectID. Must be in HExternalHCProfessional table. |
RelationType | tinyint | Not Null | Role of the staff associated with the patient or patient Visit. |
| | | Allowable values: |
| | | 0 - AttendingDoctor, 1 - PrimaryPhysician, 2 - ReferringDoctor, 3 - ConsultingDoctor, 4 - AdmittingDoctor, |
| | | 5 - OperatingDoctor, 6 - DischargingDoctor, 7 - ResponsibleDoctor, 8 - DeathDeclaredDoctor, 9 - OtherCareGiver, |
| | | 10 - AdditionalDoctor, 11 - DeathApprovedDoctor, 12 - CoveringDoctor. |
Patient_Oid | int | Not Null | ObjectID of the patient associated with the staff. |
PatientVisit_Oid | int | Null | ObjectID of the patient visit associated with the staff. |
AssociationStartDateTime | smalldatetime | Not Null | Date and time when patient/staff association begins. |
AssociationEndDateTime | smalldatetime | Null | Date and time when patient/staff association ends. |
LastCngDtime | datetime | Null | Last system UTC date /time when row was updated. |