Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HStaffPatientAssoHistory Contains patient and staff association history information.
Column Name Column Datatype Column Null Option Column Comment
CreatedUserIdintNot Null UserId of the user who created the row.
StaffAssociation_OidintNot Null ObjectId of HStaffPatientAssoHistory rows generated by Architecture.
Staff_oidintNull Associated Staff ObjectID. Must be in HStaff table.
ExternalHCProfessional_oidintNull Associated External Staff ObjectID. Must be in HExternalHCProfessional table.
RelationTypetinyintNot 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_OidintNot Null ObjectID of the patient associated with the staff.
PatientVisit_OidintNull ObjectID of the patient visit associated with the staff.
AssociationStartDateTimesmalldatetimeNot Null Date and time when patient/staff association begins.
AssociationEndDateTimesmalldatetimeNull Date and time when patient/staff association ends.
LastCngDtimedatetimeNull Last system UTC date /time when row was updated.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates