Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
SITE Site Table
Column Name Column Datatype Column Null Option Column Comment
SITEvarchar(2)not null Hospital Site
TIDvarchar(3)null Terminal ID
NAMEvarchar(30)null Site Name
ADDRESSvarchar(64)null Address
CITYvarchar(32)null City
STATEvarchar(2)null State
ZIPvarchar(12)null Zip Code
PHONEvarchar(24)null Phone
ENHANCED_RX_CHARGINGvarchar(3)null Enhanced RX Charging(YES or NO)
SERVICE_PROVIDER_IDvarchar(32)null Service Provider Id
MAC_RECOVERY_FROM_DATTIMvarchar(18)null Med Administration Check Recovery From Date/Time(MM/DD/YYYY HH:MM or MM/DD/YYYY HH:MMxx)
MAC_RECOVERY_THROUGH_DATTIMvarchar(18)null Med Administration Check Recovery Through Date/Time(MM/DD/YYYY HH:MM or MM/DD/YYYY HH:MMxx)
CCOW_SUFFIXvarchar(10)null CCOW(Clinical Context Object Workgroup) Suffix
MS4_SITE_IDvarchar(12)null MS4 Site Id
CHARGE_RECORD_TYPEvarchar(8)null Charge Record Type(HL7 or 48/49)
FACILITY_URLvarchar(128)null Facility URL
FIN_HIS_FOR_JCODE_WASTEvarchar(12)null Financial Hospital Information System for JCode Waste(MS4, SOARIAN, or INVISION)
VXU_OBJ_IDENTIFIERvarchar(32)null VXU(Vaccination Record Update) Object Identifier
VXU_MEANINGFUL_USE_STAGEvarchar(2)null VXU(Vaccination Record Update) Meaningful Use Stage
LTC_PROCESSINGvarchar(3)null Long Term Care Processing?(YES or NO)
CLIN_SYS_ORG_CODEvarchar(10)null Clinical System Organization Code. This value is only used by the 'Pharmacy to Cerner DSS(Data Wharehouse) Extract' processing.
IMMUNIZ_QUERIESvarchar(7)null Immunization Queries(AIS or IIS)
NHSN_FACILITY_OIDvarchar(60)null NHSN_FACILITY_OID(National Healthcare Safety Network)
NHSN_FACILITY_IDvarchar(60)null NHSN_FACILITY_ID(National Healthcare Safety Network)

Return to Table-Index

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