Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HCareTeamAssignmentHistory Contains patient/staff assignment history information.
Column Name Column Datatype Column Null Option Column Comment
CareTeamAssignHistory_OIDintNOT NULL Unique ObjectID assigned to the row entry.
Patient_oidintNOT NULL Patient ObjectId. Must exist in HPatient table.
Staff_oidintNOT NULL Staff member Objectid. Must exist in HStaff table.
AssignmentStartDTimeDATETIMENOT NULL Staff assignment start date and time.
AssignmentEndDTimeDATETIMENOT NULL Staff assignment End date and time.
LastCngDtimeDATETIMENULL System UTC date /time when row was updated.

Return to Table-Index

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