dbo.CV3DosingOption 
Default Table Name  CV3DosingOption 
Definition  Stores the dosing option defined by the user. 

dbo.CV3DosingOption 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. 
Name    varchar(30)  NO  Unique name of dosing option 
ControlType    int  NO  An enumerated type with the following list of possible values: 0 = [Dosage Low],1 = [Calculated Dose],2 = [Frequency], 
DisplayName    varchar(30)  NO  Display name for dosing option, which allows duplication 
IsCurrent    bit  NO  Indicates whether this row stores the current version of grid information 
BaseOptionGUID    HVCIDdt  NO  Stores the GUID of the first version of the dosing option 
ScheduleType    int  NO  An enumerated type with the following list of possible values: 0 = [Sequential],1 = [Concurrent], 
GridHeaderText    varchar(60)  YES  Allow the header text to be specified 
CanAddRemoveRows    bit  NO  Indicates whether rows can be added or removed from the grid 
LinkForDiscCancel    bit  NO  Indicates whether orders are linked for discontinue/cancel. Always TRUE for sequential schedule type. 
LinkForSuspend    bit  NO  Indicates whether orders are linked for suspend and unsuspended. Not applicable to sequential schedule type. 
CanBeSuspended    bit  NO  Indicates whether the order can be suspended. This overrides the setting in CV3OrderCatalogMasterItem 
CanBeModified    bit  NO  Indicates whether the order can be modified. Always NO for the sequential schedule type. 
SummaryLineSeparator    varchar(50)  YES  The initial text that is shown in the summary line 
ComponentLineEnd    varchar(50)  YES  This text is appended to the end of each summary line component. Substitution parameters are and where x is the sequence number and y is that total number of component items. 
IsRegularSummaryLineSuppressed    bit  NO  If TRUE, the summary line of the master order only includes information from the component. Otherwise, the component summary line is appended to the end of the regular summary line. Default is false. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3DosingOption Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3DosingOptionPK  PrimaryKey  GUID