Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
SIG_LATIN Latin Directions (SIG)
Column Name Column Datatype Column Null Option Column Comment
LATIN_CODEvarchar(15)not null Latin Code(SIG)
GEN_FREQ_INDvarchar(5)null General Frequency Indicator
MAX_NUM_TOAS_PER_DAYvarchar(2)null Max Number of TOAS(Times of Administrations) Per Day
DESCRIPTIONvarchar(30)null Latin Code Description
DAYSvarchar(17)null Days(ALL, UNSPECIFIED, or 2 digit comma separated days of week(MO,TU,WE,TH,FR,SA,SU))
SCHEDULED_PRNvarchar(9)null Scheduled or PRN(SCH or PRN)
DAYS_ACTIVEvarchar(2)null Number of Days Active
TAKEHOME_DIRECT1varchar(30)null Takehome Directions 1
TAKEHOME_DIRECT2varchar(30)null Takehome Directions 2
TAKEHOME_DIRECT3varchar(30)null Takehome Directions 3
TYPE_SIGvarchar(11)null SIG Type
INTERVALvarchar(6)null Interval. Value will be either Hours or Minutes, depending on the value of the INTERVAL_UNIT
ADMIN_INTERVALvarchar(4)null Admin Interval. Number of minutes between doses you can administer a medication. This number may not exceed 1440(the number of minutes in 1 day)
INHOUSE_DIRECT1varchar(30)null Inhouse Directions 1
INHOUSE_DIRECT2varchar(30)null Inhouse Directions 2
INHOUSE_DIRECT3varchar(30)null Inhouse Directions 3
INHOUSE_DIRECT4varchar(30)null Inhouse Directions 4
INHOUSE_DIRECT5varchar(30)null Inhouse Directions 5
INHOUSE_DIRECT6varchar(30)null Inhouse Directions 6
TIMESvarchar(512)null Times of Admin(TOAS)(HH:MM,HH:MM,HH:MM,...)
INTERVAL_UNITvarchar(4)null Interval Unit(Minutes = Mins, Hours = Hrs)
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.
CPOE_MAX_NUM_DOSESvarchar(2)null CPOE(Computerized Physician Order Entry) Max Number of Doses

Return to Table-Index

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