Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBAssignment This table holds which staff is assigned to each visit.
Column Name Column Datatype Column Null Option Column Comment
TBAssignmentOidINTNOT NULL This is the primary key.
TBVisitOidINTNOT NULL This is a foreign key to HTBVisit.
TBVisitStatusSMALLINTNOT NULL This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
TBColumnOidSMALLINTNOT NULL This is a foreign key to the HTBColumn table. It indicates to which column does this apply to(e.g. MD, RN, etc.)
TBAssignmentStaffOidINTNULL This indicates which Soarian Clinicals staff is assigned.
EDClinicianOidINTNULL This indicates which Emergency Department staff is assigned.
TBAssignmentIsPrimarySMALLINTNOT NULL This indicates if this staff is the primary care giver. Allowable Values: 0 - No, 1 - Yes.
TBAssignmentIsResponsibleSMALLINTNOT NULL This indicates if this staff is the responsible care giver. Allowable Values: 0 - No, 1 - Yes.
TBAssignmentStartDTimeMinsSMALLDATETIMENOT NULL This indicates the start date/time of this assignment.
TBAssignmentEndDTimeMinsSMALLDATETIMENULL This indicates the end date/time of this assignment.
TBAssignmentStartedByOidINTNOT NULL This is the user who started the assignment.
TBAssignmentEndedByOidINTNULL This is the user who ended the assignment.
TBAssignmentStartedByVARCHAR(100)NOT NULL This is the login ID of the user who started the assignment.
TBAssignmentEndedByVARCHAR(100)NULL This is the login ID of the user who ended the assignment.
TBAssignmentIsEndedSMALLINTNOT NULL This indicates if the assignment ended. Allowable Values: 0 - No, 1 - Yes.
TBAssignmentIsUpdatedSMALLINTNOT NULL This indicates if the entry has been changed historically. Allowable Values: 0 - No, 1 - Yes.
LastCngDtimeDATETIMENOT NULL This indicates the current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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