Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
MrcMedDiagnosis This table stores the primary or secondary diagnosis information for the patient medication.
Column Name Column Datatype Column Null Option Column Comment
MrcMedicationOidBIGINTNOT NULL Medication identification id, references to mrcMedication Table
DiagnosisCodeVARCHAR(20)NOT NULL ICD(International Classification of Diseases) Code
DiagnosisDescriptionVARCHAR(255)NOT NULL ICD(International Classification of Diseases) Description
DiagnosisReleaseVARCHAR(64)NOT NULL ICD(International Classification of Diseases) Release 10(Revision Number)
DiagnosisTypeVARCHAR(16)NOT NULL Diagnosis Type(Provider or Pharmacy)
IsPrimaryDiagnosisBITNOT NULL Indicates Primary or Secondary diagnosis(1-Primary, 0-Secondary)
LastCngDTimedatetimeNULL Last change date time for Diagnosis. This is valued using getutcdate() and not the local time.

Return to Table-Index

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