dbo.CV3OrderCatalogSet 
Default Table Name  CV3OrderCatalogSet 
Definition  A collection of order catalog items which can be ordered together. Sets may be personal (that is, owned by a particular care provider). 

dbo.CV3OrderCatalogSet 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 set. 
Description    varchar(40)  YES  The description. 
EffectiveDate    datetime  YES  Enterprise TimeZone - The effective date of the catalog set. 
ExpiryDate    datetime  YES  Enterprise TimeZone - The expiry date of the catalog set. 
ItemInfoID    int  NO  The link to the Help file. 
OwnerGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrganizationalUnit table. 
IsPersonal    bit  NO  Indicates that this is a personal set. 1 = True; 0 = False 
Type    int  NO  An enumerated type with the following list of possible values: 0 = [OrderSet],1 = [ClinicalPathway],2 = [GenericSet],3 = [PersonalOrderSet],4 = [LinkedSet], 
CatalogSetGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderCatalogSet table. 
VersionNum    int  NO  The version number. Only applicable to pathways 
PathwayID    varchar(30)  YES  An alpha-numeric code for the path. 
ELOS    varchar(30)  YES  The estimated length of stay. This is only applicable to clinical paths. 
Uom    varchar(30)  YES  The unit of measure for the estimated length of stay. 
IsCurrent    bit  NO  Indicates if this is the current version of the pathway. 1 = True; 0 = False 
ReviewDtm    datetime  YES  The date that a clinical path should be reviewed. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
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], 
OrderEntryFormGUID    HVCIDdt  YES  Identifies the form to be used with the set. The form must be of the type "Multi-Order" 
RelevantInfoPolicyGUID    HVCIDdt  YES  The relevant info policy applicable to the set 
OrderAvailPolicyGUID    HVCIDdt  YES  The availability policy used by the catalog item 
VerificationPolicyCode    varchar(30)  YES  Identifies the verification policy. 
IsDupCheckingSuppressed    bit  YES  Indicates if duplicate checking is suppress within the order set 
AllowReinstateHoursNum    int  YES  Indicates if reinstate hours is allow within the order set
 
DuplicatePolicyGUID    HVCIDdt  YES  The duplicate policy used by this set. This is used to check for other duplicate sets. 
IsFormDisplayedOnVerify    bit  YES  Is the form displayed upon verification 
GenericType    tinyint  YES  The content type of Generic Set, will only be defined if the CV3OrderCatalogSet.Type is 2. Valid values are NULL (not a generic set), 1 (contains prefilled order items), 2 (contains a order browse item), 3 (contains the entire order catalog browse). 
CanDirectDeleteItem    bit  NO  Indicates whether the Order items can be deleted directly from the Order Entry Worksheet dialog. This flag will be populated from the Config Tools in Order Set Maintenance dialog with "Allow order items to be deleted directly from order entry worksheet: checkbox: 0 - order item can not be deleted directly from Order Entry Worksheet dialog; 1 - order can be deleted directly from Order Entry Worksheet dialog 
CanDirectEditItem    bit  NO  Indicates whether the Order items can be modified directly from the Order Entry Worksheet dialog. This flag will be populated from the Config Tools in Order Set Maintenance dialog with "Allow order items to be edited directly from order entry worksheet: checkbox: 0 - order item can not be modified directly from Order Entry Worksheet dialog; 1 - order can be modified directly from Order Entry Worksheet dialog 
SetExternalIDCode    varchar(60)  YES  Represents the external ID of the order set. 
TransferAutoStatusOrderPolicyGUID    HVCIDdt  YES  GUID of the Auto Status order transfer policy 
DischargeAutoStatusOrderPolicyGUID    HVCIDdt  YES  GUID of the Auto Status order discharge policy 
DisplayModifierType    tinyint  YES  An enumerated type with the following list of possible values: 0 = [Never],1 = [Always],2 = [Always(Order Entry)],3 = [When Unselected], 
ModifiedUserGUID    HVCIDdt  YES  Stores the last clinically significant modification user GUID 
ModifiedUserNameAndOccupation    varchar(255)  YES  Stores the last clinically significant modification user name and occupation in the format of ' ()'. This field is used for historical purposes. 
ModifiedDtm    datetime  YES  Enterprise TimeZone - Stores the last clinically significant modification date/time 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CanUseDeselectAndResetSelection    bit  NO  Allow use of 'Deselect All' and 'Reset Selections' actions 
CanUseQuickSelectTemplate    bit  NO  Allow use of QuickSelect Templates 
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.CV3OrderCatalogSet Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderCatalogSetPK  PrimaryKey  GUID