Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBTriageLevel This table holds the patient visit's triage levels.
Column Name Column Datatype Column Null Option Column Comment
TBTriageLevelOidINTNOT 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.
TBTriageLevelSMALLINTNOT NULL This is the triage level as defined in the HDataDictionaryItem table.
TBTriageLevelStartDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when the triage value started.
TBTriageLevelStartedByOidINTNOT NULL This indicates the user who valued the triage value.
TBTriageLevelEndedDTimeMinsSMALLDATETIMENULL This indicates the end date/time of this triage value.
TBTriageLevelEndedByOidINTNULL This indicates the user who ended this triage value.
TBTriageLevelStartedByVARCHAR(100)NOT NULL This indicates the login ID of the user who started the triage value.
TBTriageLevelEndedByVARCHAR(100)NULL This indicates the login ID of the user who ended the triage value.
TBTriageLevelIsEndedSMALLINTNOT NULL This indicates if the triage value ended. 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