dbo.CV3OrderVariableComponent 
Default Table Name  CV3OrderVariableComponent 
Definition  When a master order is created, the dosing or frequency information is stored in this table. One child order will be created per row. 

dbo.CV3OrderVariableComponent 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)    HVCIDdt  NO  Unique primary key value. 
OrderGUID    HVCIDdt  NO  Primary key 
IsTemplate    bit  NO  Indicate whether the order is an order template. 
ComplexOrderType    int  NO  Indicates the order type for the child order 2 – Sequential Complex Dose Child Order;4 – Concurrent Complex Dose Child Order;6 – Multiple Frequencies Child Order 
SequenceNumber    int  NO  Indicate the sequence that the orders will be created. 
DosageLow    varchar(10)  YES  Store the dosage low 
DosageHigh    varchar(10)  YES  Store the dosage high 
Uom    varchar(30)  YES  Store the uom. 
OrderRouteCode    varchar(30)  YES  Store the order route code 
OrderRouteModifierCode    varchar(30)  YES  Store the order route modifier code 
FrequencyCode    varchar(30)  YES  Store the frequency code 
FreqFromTime    int  YES  Store the frequency from time value if frequency is selected. 
FreqToTime    int  YES  Store the frequency to time value if frequency is selected. 
FreqUom    varchar(30)  YES  Store the frequency uom if frequency is selected. 
FreqEventModifierType    int  YES  Store the event modifier for event based frequency code 
FreqEventCode    varchar(30)  YES  Store the event code for event based frequency code 
StopAfterValue    int  NO  Store the duration value 
StopAfterOptionType    int  NO  Store the duration uom 1 – Days;2 – Hours; 3 – Minutes; 4 – Times 
RequestedDate    varchar(20)  YES  Store the requested date of the child order 
RequestedTime    varchar(30)  YES  Store the requested time for time critical child order 
ReqCodedTime    varchar(30)  YES  Store the coded requested time for time critical order 
ReqTimeValue    int  YES  Store the time value for requested time of event based type 
ReqTimeUom    varchar(30)  YES  Store the uom of the time value for requested time of event based type. 
ReqTimeEventModifierType    int  YES  Store the event modifier for requested time of event based type 
ReqTimeEventCode    varchar(30)  YES  Store the event time code for requested time of event based type 
StopDate    varchar(20)  YES  Store the stop date of the child order 
StopTime    varchar(30)  YES  Store the stop time of the child order 
EstimatedStopDtm    datetime  YES  Estimate stop date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. 
CalcDoseMethod    tinyint  YES  Indicate the method used for calculated dose 0 – Per dose; 1 – Daily Dose 
CalcRequestedDose    varchar(30)  YES  Store the requested calculated dose 
CalcUOMPer    varchar(30)  YES  Store the uom per requested dose. 
CalcActualDose    varchar(30)  YES  Store the actual dose used for the calculated dose 
CalcOverrideReason    varchar(255)  YES  Store the override dose reason 
CalcTotalDailyDose    varchar(30)  YES  Store the total daily dose 
CalcInfo    varchar(2000)  YES  Store the calculated dose information 
IsPRN    bit  NO  Indicate whether the order instance should be a PRN order 
PRNReasonText    varchar(255)  YES  For PRN order instance, store the PRN reason. 
ChildOrderGUID    HVCIDdt  YES  Store the Order GUID for child order created from this component. 
EstimatedRequestedDtm    datetime  YES  Estimate requested date/time of the child order. This should be calculated and updated when the estimated stop date/time is calculated for the master order. This field is mainly used by CDS. 
DataItemCode1    varchar(40)  YES  Stores the first data item code returned from call MLM 
DataItemValue1    varchar(800)  YES  Stores the value returned for DataItemCode1 from call MLM 
DataItemCode2    varchar(40)  YES  Stores the second data item code returned from call MLM 
DataItemValue2    varchar(800)  YES  Stores the value returned for DataItemCode2 from call MLM 
DataItemCode3    varchar(40)  YES  Stores the third data item code returned from call MLM 
DataItemValue3    varchar(800)  YES  Stores the value returned for DataItemCode3 from call MLM 
DataItemCode4    varchar(40)  YES  Stores the fourth data item code returned from call MLM 
DataItemValue4    varchar(800)  YES  Stores the value returned for DataItemCode4 from call MLM 
DataItemCode5    varchar(40)  YES  Stores the fifth data item code returned from call MLM 
DataItemValue5    varchar(800)  YES  Stores the value returned for DataItemCode5 from call MLM 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3OrderVariableComponent Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderVariableComponentPK  PrimaryKey  GUID