Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
MrcMedicationOid | BIGINT | NOT NULL | Medication identification id, references to mrcMedication Table |
DiagnosisCode | VARCHAR(20) | NOT NULL | ICD(International Classification of Diseases) Code |
DiagnosisDescription | VARCHAR(255) | NOT NULL | ICD(International Classification of Diseases) Description |
DiagnosisRelease | VARCHAR(64) | NOT NULL | ICD(International Classification of Diseases) Release 10(Revision Number) |
DiagnosisType | VARCHAR(16) | NOT NULL | Diagnosis Type(Provider or Pharmacy) |
IsPrimaryDiagnosis | BIT | NOT NULL | Indicates Primary or Secondary diagnosis(1-Primary, 0-Secondary) |
LastCngDTime | datetime | NULL | Last change date time for Diagnosis. This is valued using getutcdate() and not the local time. |