Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HStaffAssociations Contains information about staff associated with the patient or the patient visit.
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HStaffAssociations Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the Patient
Descriptionvarchar(21)NULL Not used.
IsVersionedbitNOT NULL Indicates if the row has been modified
CreatedUserIdintNULL UserId of the user who created the row.
CreationTimesmalldatetimeNULL Date and time when the object is created.
IsExternalbitNULL When set to True, indicates that the staff is an external staff. An external staff does not belong to a healthcare unit, but is associated with the unit.
Allowable Values: 0 - False, 1 - True or NULL.
RelationTypetinyintNULL Role of the staff associated with the patient or the 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
StartDatesmalldatetimeNULL Date and Time when the association of the staff to the patient or the patient visit begins.
EndDatesmalldatetimeNULL Date and Time when the association of the staff to the patient or the patient visits ends.
StartTimesmalldatetimeNULL Not Used
EndTimesmalldatetimeNULL Not Used
IsOrderAssociatedbitNULL Indicates that association has come from orders or through the Visit screen. Allowable Values: 0 - False, 1 - True or Null
StaffAssocRefCounterintNULL Incremental counter for every association of a staff with a visit.
ExternalProfessional_oidintNULL ObjectId for External staff , same as objectid in HExternalHCProfessional table.
Patient_oidintNULL Object ID of the patient associated with the staff.
PatientVisit_oidintNULL ObjectID of the patient visit associated with the staff.
Staff_oidintNULL Associated Staff Object ID. Must be in HStaff table.
DeathInformation_oidintNULL Object Id for the deceased patient as in HDeathInformation table.
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