dbo.CV3OrderCatalogMasterItem 
Default Table Name  CV3OrderCatalogMasterItem 
Definition  Acts as a template for an order catalog item. Note that the order catalog master item contains the policy information about the item; the order catalog item contains display name information and the order keeps the details.
 

dbo.CV3OrderCatalogMasterItem 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(125)  YES  The primary name of the catalog item. 
Description    varchar(40)  YES  The description. 
EffectiveDate    datetime  YES  Enterprise TimeZone - The date that the item becomes effective. 
ExpiryDate    datetime  YES  Enterprise TimeZone - The date that the item expires, if any. 
AncillaryName    varchar(125)  YES  Not used. See CV3AncillaryName. 
AncillaryCodingStd    varchar(60)  YES  Not used. See CV3AncillaryName. 
IsCompletable    bit  NO  Indicates if orders for this item can be set to a status of Completed. 
IsRepeatable    bit  NO  Indicates if orders for this item can be repeated. 
Cost    varchar(10)  YES  The cost of ordering this item. 
CostUnitOfMeasure    varchar(20)  YES  The unit of measure associated to the cost (for example, dollars, cents). 
Duration    int  NO  The standard duration for orders of this item. 
IsDurationChangeable    bit  NO  Indicates if the duration can be changed on the order. 
PrintClass    varchar(30)  YES  Not used. 
SpecimenType    varchar(40)  YES  The usual specimen type associated with this order. 
IsAutoActivatable    bit  NO  Indicates if this item can be automatically activated. 
ActivateStatus    varchar(40)  YES  The status code that the order is set to once it is activated. 
MinimumStatusForActivation    varchar(40)  YES  The minimum status that the order must achieve before it is activated. 
ActivateDateReference    varchar(40)  YES  The reference date used to determine when the order should be activated. This is not a true date, but a reference date such as date of surgery. 
ActivateDaysBefore    int  NO  The number of days before the reference date that the order should be activated. 
ActivateHoursBefore    int  NO  The number of hours before the reference date that the order should be activated. 
IsAutoCompletable    bit  NO  Indicates if this item can be automatically completed. 
CompleteStatus    varchar(40)  YES  The status code that the order is set to once it is completed. 
MinimumStatusForCompletion    varchar(40)  YES  The minimum status that the order must achieve before it is completed. 
CompleteDateReference    varchar(40)  YES  The reference date used to determine when the order should be completed. This is not a true date, but a reference date such as date of surgery. 
CompleteDaysAfter    int  NO  The number of days after the reference date that the order should be completed. 
CompleteHoursAfter    int  NO  The number of hours after the reference date that the order should be completed. 
ItemInfoID    int  NO  The link to the help file. 
CodedTimeGroupCode    varchar(40)  YES  The link to a coded time group. This identifies which coded times are valid for the item. 
VerificationPolicyCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3VerificationPolicy table. 
OrgUnitGUID    HVCIDdt  YES  Link to the organization unit which owns the item (CV3OrganizationalUnit) 
TransmitPolicyGUID    HVCIDdt  YES  The link to the transmit policy. 
EntryFormGUID    HVCIDdt  YES  The link to the entry form used when ordering this item. 
OrderReviewCategoryGUID    HVCIDdt  YES  Link to the order review category (CV3OrderReviewCategory) 
IsIVAdditive    bit  NO  Indicates that this item can be added to an IV order. 
CanBeSuspended    bit  NO  Indicates if an order for this item can be suspended. 
AutoCompleteType    int  NO  Indicates if the auto completion rules apply to standard orders, discharge orders, or both. 
IsOngoingOrder    bit  NO  Indicates if orders of this item are ongoing orders. 
DuplicatePolicyGUID    HVCIDdt  YES  The link to the duplicate policy which defines which items are considered duplicates. 
PatientCareDocumentGUID    HVCIDdt  YES  NOT USED 
TaskEffectiveDate    datetime  YES  Enterprise TimeZone - The effective date of the associated task, if applicable. 
TaskExpirationDate    datetime  YES  Enterprise TimeZone - The expiration date of the associated task, if applicable. 
CodedFreqGroupGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CodedFrequencyGroup table. 
MaxRepeatsAllowed    int  YES  The maximum number of repeats allowed. 
OverrideMaxRepeats    tinyint  YES  Indicates if the maximum number of repeats can be overridden when this item is ordered. 
AdvanceDaysRepeat    int  YES  The number of days before the requested date/time or schedule date/time that repeat orders should be generated. 
MinAdvanceOrdersRepeat    int  YES  The minimum number of repeat orders that should be generated in advance. 
IsPrimaryHidden    tinyint  YES  Indicates whether ordering the “generic” version of the item is allowed. 
IsBaseSolution    tinyint  YES  Values of 1 or 0. Indicates the item can be Base Solution or not. 
WarnMsgDisplayType    int  NO  An enumerated type with the following list of possible values: 0 = [None],1 = [Display in Browse],2 = [Display on Demand],3 = [Require Acknowledgement], 
CanBeConditional    bit  NO  This column will hold information whether the order item can be conditional or not. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
IsDurationExtendable    bit  NO  Indicates whether the stop date can be extended using the Extend Stop Date feature. 
AllowAutomaticStopOrder    bit  NO  Indicates whether the stop date can be extended by Automatic Stop Order. 
RelevantInfoPolicyGUID    HVCIDdt  YES  Link to a relevant information policy (CV3RelevantInfoPolicy) 
DoseBasisGroupGUID    HVCIDdt  YES  Link tot a dose basis group (CV3DoseBasisGroup) 
IsLMRPQueryItem    bit  NO  Is item used in medical necessity checking 
OrderAvailPolicyGUID    HVCIDdt  YES  The availability policy used by the catalog item 
RxVerifyPolicyGUID    HVCIDdt  YES  The pharmacy verification policy used by the catalog item. This column has been renamed from PharmacyVerifyPolicyGUID 
MedAdminWarningPolicyGUID    HVCIDdt  YES  The policy used to define when medication administration warnings are displayed. 
IsLargeVolumeParenteral    bit  NO  Indicates if the item is a continuous IV that may contain additives 
ReviewInterval    int  NO  The time frame after which the order has to be reviewed. Used to set the Review Date for an order. 
ReviewIntervalType    int  YES  An enumerated type with the following list of possible values: 0 = [Days],1 = [Hours], 
RelativeReviewInDays    int  NO  The number of days prior to the stop date that the order must be reviewed. 
IsReviewDateChangeable    bit  NO  Can the review date be changed? 
AutoExtendStopDateType    int  NO  An enumerated type with the following list of possible values: 0 = [None],1 = [By Standard Policy],2 = [By ASO], 
IsInformational    bit  NO  Indicates that this order item is a ‘Profile order’ (for information only). 
DosingOptionGroupGUID    HVCIDdt  YES  Stores the GUID of the Dose Option Group assigned to this order catalog master item. Links to CV3DosingOptionGroup.GUID. 
PRNReasonDictionaryType    int  NO  An enumerated type with the following list of possible values: 0 = [Free format text],1 = [Restricted Dictionary],2 = [Suggested Dictionary], 
PRNReasonDictionaryName    varchar(30)  YES  Name of the PRNReason dictionary.The value for this column will come from CV3UserDictionary.Code. 
StopAfterTimesDisplayType    int  NO  An enumerated type with the following list of possible values: 0 = [Times],1 = [Doses],2 = [Units], 
TherapeuticCategory    varchar(255)  YES  The therapeutic category of a drug. It links to the Category Name in the Multum DB – DrugCategory table 
TherapeuticCategoryID    int  YES  Id of therapeutic category assigned to multum drug id. 
TransferAutoStatusOrderPolicyGUID    HVCIDdt  YES  GUID of the Auto Status order transfer policy 
DischargeAutoStatusOrderPolicyGUID    HVCIDdt  YES  GUID of the Auto Status order discharge policy 
IsUnmappedPrescriptionItem    bit  NO  TRUE if this is the non-formulary catalog item. 
AlternateMappingName    varchar(255)  YES  Alternate Drug Mapping Name
 
RxOrderReviewPolicyID    int  NO  ID of SXAMMRxOrderReviewPolicy table which is only available when SMM is installed. A value of 0 indicates no policy 
RxDispensingPolicyID    int  YES  Reference (foreign key) to SXAMMDispensingPolicy table 
DrcGrouperID    int  YES  Stores the ID of the Dose Range Check Group Name associated with the catalog item 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CanUseACRRadiology    bit  NO  Flag for location to Use ACR Radiology 
CostDisplayPolicyGUID    HVCIDdt  YES  Policy GUID 
AgeRangeFrom    int  YES  User need to mention descriptive usage of this column. 
AgeRangeTo    int  YES  User need to mention descriptive usage of this column. 
AgeRangeUnitType    int  YES  An enumerated type with the following list of possible values: 0 = [Years],1 = [Months],2 = [Weeks],3 = [Days], 

dbo.CV3OrderCatalogMasterItem Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderCatalogMasterItemPK  PrimaryKey  GUID