Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
MrcMedInfoClassification This table stores medication classification information from xml(Extensible Markup Language ), each sentence within the pxml(Persisted Extensible Markup Language ) corresponds to one row here.
Column Name Column Datatype Column Null Option Column Comment
MrcMedInfoClassificationOidbigintNOT NULL Medication classification id(Primary key)
MrcMedicationOidbigintNOT NULL Foreign Key(FK) to MrcMedication table
SpecifiedOrdersmallintNOT NULL Indicating classification Ordinal
Sourcevarchar(10)NOT NULL Classification source(Allowable values: FDB, AHFS, ATC)
DrugClassificationIdvarchar(12)NOT NULL The drug classification id as defined by the source vocabulary(FDB and AHFS have different schemes)
DrugClassificationDescvarchar(300)NOT NULL The drug classification description
LastCngDTimedatetimeNULL Last change date time(UTC date time) for prescription.

Return to Table-Index

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