Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
SIG_LATIN_EXCEPTIONS Latin Directions Exceptions
Column Name Column Datatype Column Null Option Column Comment
LATIN_CODEvarchar(15)not null Latin Code(SIG)
EXCEPTION_TYPEvarchar(5)not null Exception Type(LOC = Location(Nurse Station or Clinic), RTDID = Routed Med Id)
EXCEPTION_CODEvarchar(13)not null Exception Code. If Exception Type equals 'LOC', then this will be either a Nurse Station or Clinic Code. If Exception Type equals 'RTDID', then this will be a Routed Med Code.
EXCEPTION_CODE_DESCvarchar(64)null Exception Code Description
GEN_FREQ_IND_IN_MINUTESvarchar(5)null General Frequency indicator in minutes
FIRST_OCC_WITHINvarchar(4)null First Occurrence Within. Number of minutes from the time the order is entered that the first occurrence should occur. This number may not exceed 1440(the number of minutes in 24 hours).
EARLY_ADMIN_WARNINGvarchar(4)null Early Admin Warning. Number of minutes in the Past/Future you can chart an occurrence, after which a warning message will appear.
EARLY_ADMIN_ERRORvarchar(4)null Early Admin Error. Number of minutes in the Past/Future you can chart an occurrence, after which an error message will appear.
LATE_ADMIN_WARNINGvarchar(4)null Late Admin Warning. Number of minutes in the Past/Future you can chart an occurrence, after which a warning message will appear.
LATE_ADMIN_ERRORvarchar(4)null Late Admin Error. Number of minutes in the Past/Future you can chart an occurrence, after which an error message will appear.
TIMESvarchar(254)null TOAS(Time of Administrations) - Comma separated list

Return to Table-Index

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