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. |