SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

GUID 
Definition  A foreign key to the GUID column in the CV3Order table. 

DosageLow 
Definition  The low range of the dosage. 

DosageHigh 
Definition  The high range of the dosage. 

Uom 
Definition  A foreign key to the Code column in the CV3UnitOfMeasure table. 

FormCode 
Definition  A foreign key to the Code column in the CV3MedicationForm table. 

AllowSubstitutes 
Definition  Indicates if substations are allowed. 1 = True; 0 = False 

NumRefills 
Definition  The number of refills allowed. 

OrderRouteCode 
Definition  A foreign key to the Code column in the CV3OrderRoute table. 

OrderRouteModifierCode 
Definition  A foreign key to the Code column in the CV3OrderRouteModifier table. 

IsTemplate 
Definition  Indicates if this is associated with a template order. 1 = True; 0 = False. Will always be true if ClientGUID is 0 

AdminInstructions 
Definition  The medication administration instructions. 

ClientGUID 
Definition  The link to the Client. May be 0 if order is a template 

RateAmount 
Definition  The amount of IV rate 

RateUom 
Definition  The UOM of IV rate 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

OrderedAs 
Definition  The brand name for an order 

OrderedAsType 
Definition  An enumerated type with the following list of possible values: 0 = [Blank],1 = [Brand Name],2 = [Non Brand Name],3 = [Default Brand Name], 

OrderedAsDisplay 
Definition  The formatted brand name text 

IsDAW 
Definition  Indicates if the Dispensed as Written (DAW) information is present or not 

DAWRequestedName 
Definition  Stores the the DAW requested name 

DAWReason 
Definition  Stores the Reason for the DAW 

DispensedAs 
Definition  Stores the Dispense As Order information 

RxStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [Rx No Verify Required],1 = [Rx Unverified],2 = [Rx Verified], 

RxVerifyBehaviorType 
Definition  An enumerated type with the following list of possible values: 0 = [No Verify Required],1 = [On Worklist After Verify],2 = [On Worklist Before Verify], 

IsPatientsOwnMed 
Definition  Patient's own medication. Not dispensed from Pharmacy 

IsSelfAdministered 
Definition  whether patient self medicates 

RxVerifyPolicyGUID 
Definition  The pharmacy verification policy used by the catalog item 

MedAdminWarningPolicyGUID 
Definition  The medication administration warning policy used by the catalog item 

DrugAmount 
Definition  Drug amount 

DrugAmountUOM 
Definition  Drug amount unit of measure 

DrugConcentration 
Definition  Drug concentration 

DrugConcentrationUOM 
Definition  Drug concentration unit of measure 

BaseConcentration 
Definition  Base Concentration 

BaseConcentrationUOM 
Definition  Unit of measure 

LenOfTimeCurrentRate 
Definition  Calculated Length of time at the current rate. Formatted as hh:mm 

TitrationDoseMin 
Definition  Minimum titration dosage 

TitrationDoseMax 
Definition  Maximum titration dosage 

AdministrationDevice 
Definition  Administration device, ie. pump 

DropRate 
Definition  Number of drops per minute 

IVRateCalculationText 
Definition  Description of iv rate calculation 

DoseCap 
Definition  Dosage amount that the ordered dose should be capped at. 

MaximumDose 
Definition  Indicates the maximum dose that can be ordered for this drug. 

AdditionalVerificationByGUID 
Definition  Contains the guid of the provider required to verify. 

IsKVO 
Definition  Used for alert filtering purposes 

SMMNonFormularyReason 
Definition  Stores non-formulary reason 

SMMDispenseInfo 
Definition  Pharmacy Dispensing Information 

IVLineTypeName 
Definition  Type of line IV is being infused into (eg central, venous). Dictionary based.The value from SXAMMLineType dictionary table. 

LenOfTimeCurrentRateUOM 
Definition  The units of measure for the length of time the IV will run based on the current rate. Also known as Hang time units of measure 

TotalIVVolume 
Definition  This is available for medication (IV) orders. It holds the actual volume of solution after the pharmacy has added all the components. 

TotalIVVolumeUOM 
Definition  Units of measure for Total IV Volume above. The value will come from Cv3UnitOfMeasure dictionary. 

LastDoseTakenCodedTime 
Definition  The time that the last dose was taken. The user can select a value from the suggested dictionary or enter free text. 

TherapeuticCategory 
Definition  The therapeutic category of a drug. It links to the Category Name in the Multum DB – DrugCategory table 

LastDoseTakenDate 
Definition  The date that the last dose was taken 

PrescriptionID 
Definition  rescriptionID from the prescription if the order was created by translating a prescription. 

PrescriptionGenericItemID 
Definition  GenericItemID from the Prescription if the order was created by translating a prescription 

IsDisallowRenewRx 
Definition  This field can be set by called MLM to disallow renewal of the prescription. 

MultumDrugName 
Definition  To store the drug name from the prescription during the "Copy from Prescription" functionality 

IsExcludedFromRxDispensePolicy 
Definition  Indicates that this record is not included in the pharmacy dispense policy 

RxDurationAmountText 
Definition  Stores the value from the new order form field RxDurationAmount. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication DurationAmount. 

RxIsContinuous 
Definition  Stores the value from the new order form field RxIsContinuous. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication IsContinuous. 

RxInstructions 
Definition  Stores the value from the new order form field RxInstructions. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication Instructions. 

RxComments 
Definition  Stores the value from the new order form field RxComment. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication Comments. 

RxMemo 
Definition  Stores the value from the new order form field RxMemo. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication Memo. 

RxQuantityAmountText 
Definition  Stores the value from the new order form field RxQuantityAmount. If the home medication (Hx or Rx) is created from the order, or if the order is created from a home medication (Rx or Hx) the value is copied from/to home medication QuantityAmount. 

LastDoseTakenDtm 
Definition 
Last dose taken date time 

RxDurationUnit 
Definition 
Duration unit for rx 

RxQuantityUnit 
Definition 
Quantity unit for rx 

IsAutoCompletableInContinuousState 
Definition  Indicator whether service need to auto complete this continuous medication 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsClinicallyChecked 
Definition  Indicator whether selected row is clinically checked. Null means user hasn't set the field yet, “1” means clinically checked, “0” means clinically check removed 

IsTransferMedication 
Definition  Indicator to distinguish between true home meds and meds prescribed as part of an admission to another organization from which the patient is transferred. 

ComplianceAid 
Definition  Selected values are concatenated in a comma or semi-colon separated list. 

PatientOwnSupplyQuantity 
Definition  Quantity of patient own supply medication. 

PatientOwnSupplyDose 
Definition  Dosage of patient own supply medication. 

PatientOwnSupplyUom 
Definition  Unit of measure of patient own supply medication. 

PatientOwnSupplyFormCode 
Definition  Medication form code of patient own supply. 

MedicationOrigin 
Definition  Medication origin. 

DispenseSource 
Definition  Dispensing source. 

DispenseAmount 
Definition  Dispense amount. 

DispenseAmountUnit 
Definition  Dispense amount unit. 

GeneralPractitionerInstrOptionType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Stop after],2 = [Review after],3 = [Continue], 

GeneralPractitionerInstrUnitType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Hours],2 = [Days],3 = [Weeks],4 = [Months], 

GeneralPractitionerInstrValue 
Definition  General Practitioner instructions value. 

GeneralPractitionerComments 
Definition  General Practitioner comments. 

IsPendingReview 
Definition  If it is true, the continuous outpatient order medication is pending review. 

IsConfirmed 
Definition  To mark the outpatient order as confirmed. 0 is unconfirmed (default value), 1 is confirmed. 

IsSurgeryPreOp 
Definition  Specifies whether it's Surgery Pre-Operation Medication Order.