dbo.CV3MedicationExtension 
Default Table Name  CV3MedicationExtension 
Definition  Change table identities for BIGINT enhancement 

dbo.CV3MedicationExtension Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  YES  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    datetime  YES  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  YES  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    datetime  YES  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Order table. 
DosageLow    varchar(10)  YES  The low range of the dosage. 
DosageHigh    varchar(10)  YES  The high range of the dosage. 
Uom(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3UnitOfMeasure table. 
FormCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3MedicationForm table. 
AllowSubstitutes    bit  NO  Indicates if substations are allowed. 1 = True; 0 = False 
NumRefills    int  YES  The number of refills allowed. 
OrderRouteCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderRoute table. 
OrderRouteModifierCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderRouteModifier table. 
IsTemplate    bit  NO  Indicates if this is associated with a template order. 1 = True; 0 = False. Will always be true if ClientGUID is 0 
AdminInstructions    varchar(2000)  YES  The medication administration instructions. 
ClientGUID    HVCIDdt  YES  The link to the Client. May be 0 if order is a template 
RateAmount    varchar(10)  YES  The amount of IV rate 
RateUom    varchar(30)  YES  The UOM of IV rate 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
OrderedAs    varchar(125)  YES  The brand name for an order 
OrderedAsType    int  YES  An enumerated type with the following list of possible values: 0 = [Blank],1 = [Brand Name],2 = [Non Brand Name],3 = [Default Brand Name], 
OrderedAsDisplay    varchar(255)  YES  The formatted brand name text 
IsDAW    bit  YES  Indicates if the Dispensed as Written (DAW) information is present or not 
DAWRequestedName    varchar(125)  YES  Stores the the DAW requested name 
DAWReason    varchar(255)  YES  Stores the Reason for the DAW 
DispensedAs    varchar(125)  YES  Stores the Dispense As Order information 
RxStatusType    int  YES  An enumerated type with the following list of possible values: 0 = [Rx No Verify Required],1 = [Rx Unverified],2 = [Rx Verified], 
RxVerifyBehaviorType    int  YES  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    bit  YES  Patient's own medication. Not dispensed from Pharmacy 
IsSelfAdministered    bit  YES  whether patient self medicates 
RxVerifyPolicyGUID    HVCIDdt  YES  The pharmacy verification policy used by the catalog item 
MedAdminWarningPolicyGUID    HVCIDdt  YES  The medication administration warning policy used by the catalog item 
DrugAmount    varchar(10)  YES  Drug amount 
DrugAmountUOM    varchar(30)  YES  Drug amount unit of measure 
DrugConcentration    varchar(10)  YES  Drug concentration 
DrugConcentrationUOM    varchar(30)  YES  Drug concentration unit of measure 
BaseConcentration    varchar(10)  YES  Base Concentration 
BaseConcentrationUOM    varchar(30)  YES  Unit of measure 
LenOfTimeCurrentRate    varchar(30)  YES  Calculated Length of time at the current rate. Formatted as hh:mm 
TitrationDoseMin    varchar(10)  YES  Minimum titration dosage 
TitrationDoseMax    varchar(10)  YES  Maximum titration dosage 
AdministrationDevice    varchar(30)  YES  Administration device, ie. pump 
DropRate    int  YES  Number of drops per minute 
IVRateCalculationText    varchar(2000)  YES  Description of iv rate calculation 
DoseCap    varchar(10)  YES  Dosage amount that the ordered dose should be capped at. 
MaximumDose    varchar(10)  YES  Indicates the maximum dose that can be ordered for this drug. 
AdditionalVerificationByGUID    HVCIDdt  YES  Contains the guid of the provider required to verify. 
IsKVO    bit  YES  Used for alert filtering purposes 
SMMNonFormularyReason    varchar(255)  YES  Stores non-formulary reason 
SMMDispenseInfo    varchar(2000)  YES  Pharmacy Dispensing Information 
IVLineTypeName    varchar(100)  YES  Type of line IV is being infused into (eg central, venous). Dictionary based.The value from SXAMMLineType dictionary table. 
LenOfTimeCurrentRateUOM    varchar(30)  YES  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    varchar(10)  YES  This is available for medication (IV) orders. It holds the actual volume of solution after the pharmacy has added all the components. 
TotalIVVolumeUOM    varchar(30)  YES  Units of measure for Total IV Volume above. The value will come from Cv3UnitOfMeasure dictionary. 
LastDoseTakenCodedTime    varchar(30)  YES  The time that the last dose was taken. The user can select a value from the suggested dictionary or enter free text. 
TherapeuticCategory    varchar(255)  YES  The therapeutic category of a drug. It links to the Category Name in the Multum DB – DrugCategory table 
LastDoseTakenDate    varchar(1000)  YES  The date that the last dose was taken 
PrescriptionID    bigint  YES  rescriptionID from the prescription if the order was created by translating a prescription. 
PrescriptionGenericItemID    bigint  YES  GenericItemID from the Prescription if the order was created by translating a prescription 
IsDisallowRenewRx    bit  YES  This field can be set by called MLM to disallow renewal of the prescription. 
MultumDrugName    varchar(255)  YES  To store the drug name from the prescription during the "Copy from Prescription" functionality 
IsExcludedFromRxDispensePolicy    bit  YES  Indicates that this record is not included in the pharmacy dispense policy 
RxDurationAmountText    varchar(10)  YES  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    bit  YES  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    varchar(1000)  YES  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    varchar(1000)  YES  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    varchar(1000)  YES  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    varchar(10)  YES  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    datetime  YES 
Last dose taken date time 
RxDurationUnit    varchar(80)  YES 
Duration unit for rx 
RxQuantityUnit    varchar(80)  YES 
Quantity unit for rx 
IsAutoCompletableInContinuousState    bit  YES  Indicator whether service need to auto complete this continuous medication 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsClinicallyChecked    bit  YES  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    bit  YES  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    varchar(2000)  YES  Selected values are concatenated in a comma or semi-colon separated list. 
PatientOwnSupplyQuantity    varchar(10)  YES  Quantity of patient own supply medication. 
PatientOwnSupplyDose    varchar(10)  YES  Dosage of patient own supply medication. 
PatientOwnSupplyUom    varchar(30)  YES  Unit of measure of patient own supply medication. 
PatientOwnSupplyFormCode    varchar(30)  YES  Medication form code of patient own supply. 
MedicationOrigin    varchar(30)  YES  Medication origin. 
DispenseSource    varchar(30)  YES  Dispensing source. 
DispenseAmount    varchar(10)  YES  Dispense amount. 
DispenseAmountUnit    varchar(30)  YES  Dispense amount unit. 
GeneralPractitionerInstrOptionType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [Stop after],2 = [Review after],3 = [Continue], 
GeneralPractitionerInstrUnitType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [Hours],2 = [Days],3 = [Weeks],4 = [Months], 
GeneralPractitionerInstrValue    int  YES  General Practitioner instructions value. 
GeneralPractitionerComments    varchar(2000)  YES  General Practitioner comments. 
IsPendingReview    bit  NO  If it is true, the continuous outpatient order medication is pending review. 
IsConfirmed    bit  NO  To mark the outpatient order as confirmed. 0 is unconfirmed (default value), 1 is confirmed. 
IsSurgeryPreOp    bit  NO  Specifies whether it's Surgery Pre-Operation Medication Order. 

dbo.CV3MedicationExtension Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3MedicationExtensionPK  PrimaryKey  GUID