Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBCodedText This table holds text type columns' values for an Emergency Department visit (e.g. comment, disposition).
Column Name Column Datatype Column Null Option Column Comment
TBCodedTextOidINTNOT 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 which column holds the text.
TBCodedOidINTNULL This is the selected Data Dictionary Item identifier from the HDataDictionaryItem table.
TBCodedTextVARCHAR(200)NOT NULL This is the selected Data Dictionary Item text as defined in the HDataDictionaryItem table.
TBDispositionMappingSystemDispositionVARCHAR(16)NULL This indicates if this is a disposition and what is the mapped value.
TBCodedTextStartDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when this value started.
TBCodedTextStartedByOidINTNOT NULL This indicates the user who set the value.
TBCodedTextEndedDTimeMinsSMALLDATETIMENULL This indicates the date/time when this value ended.
TBCodedTextEndedByOidINTNULL This indicates the user who ended the value.
TBCodedTextStartedByVARCHAR(100)NOT NULL This is the Login ID of the user who started the assignment.
TBCodedTextEndedByVARCHAR(100)NULL This is the Login ID of the user who ended the assignment.
TBCodedTextIsEndedSMALLINTNOT NULL This indicates if the value is no longer active. 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