SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  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 
Definition  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 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  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 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

GUID 
Definition  Unique primary key value. 

Name 
Definition  The primary name of the catalog set. 

Description 
Definition  The description. 

EffectiveDate 
Definition  Enterprise TimeZone - The effective date of the catalog set. 

ExpiryDate 
Definition  Enterprise TimeZone - The expiry date of the catalog set. 

ItemInfoID 
Definition  The link to the Help file. 

OwnerGUID 
Definition  A foreign key to the GUID column in the CV3OrganizationalUnit table. 

IsPersonal 
Definition  Indicates that this is a personal set. 1 = True; 0 = False 

Type 
Definition  An enumerated type with the following list of possible values: 0 = [OrderSet],1 = [ClinicalPathway],2 = [GenericSet],3 = [PersonalOrderSet],4 = [LinkedSet], 

CatalogSetGUID 
Definition  A foreign key to the GUID column in the CV3OrderCatalogSet table. 

VersionNum 
Definition  The version number. Only applicable to pathways 

PathwayID 
Definition  An alpha-numeric code for the path. 

ELOS 
Definition  The estimated length of stay. This is only applicable to clinical paths. 

Uom 
Definition  The unit of measure for the estimated length of stay. 

IsCurrent 
Definition  Indicates if this is the current version of the pathway. 1 = True; 0 = False 

ReviewDtm 
Definition  The date that a clinical path should be reviewed. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

WarnMsgDisplayType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Display in Browse],2 = [Display on Demand],3 = [Require Acknowledgement], 

OrderEntryFormGUID 
Definition  Identifies the form to be used with the set. The form must be of the type "Multi-Order" 

RelevantInfoPolicyGUID 
Definition  The relevant info policy applicable to the set 

OrderAvailPolicyGUID 
Definition  The availability policy used by the catalog item 

VerificationPolicyCode 
Definition  Identifies the verification policy. 

IsDupCheckingSuppressed 
Definition  Indicates if duplicate checking is suppress within the order set 

AllowReinstateHoursNum 
Definition  Indicates if reinstate hours is allow within the order set
 

DuplicatePolicyGUID 
Definition  The duplicate policy used by this set. This is used to check for other duplicate sets. 

IsFormDisplayedOnVerify 
Definition  Is the form displayed upon verification 

GenericType 
Definition  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 
Definition  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 
Definition  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 
Definition  Represents the external ID of the order set. 

TransferAutoStatusOrderPolicyGUID 
Definition  GUID of the Auto Status order transfer policy 

DischargeAutoStatusOrderPolicyGUID 
Definition  GUID of the Auto Status order discharge policy 

DisplayModifierType 
Definition  An enumerated type with the following list of possible values: 0 = [Never],1 = [Always],2 = [Always(Order Entry)],3 = [When Unselected], 

ModifiedUserGUID 
Definition  Stores the last clinically significant modification user GUID 

ModifiedUserNameAndOccupation 
Definition  Stores the last clinically significant modification user name and occupation in the format of ' ()'. This field is used for historical purposes. 

ModifiedDtm 
Definition  Enterprise TimeZone - Stores the last clinically significant modification date/time 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CanUseDeselectAndResetSelection 
Definition  Allow use of 'Deselect All' and 'Reset Selections' actions 

CanUseQuickSelectTemplate 
Definition  Allow use of QuickSelect Templates 

AgeRangeFrom 
Definition  User need to mention descriptive usage of this column. 

AgeRangeTo 
Definition  User need to mention descriptive usage of this column. 

AgeRangeUnitType 
Definition  An enumerated type with the following list of possible values: 0 = [Years],1 = [Months],2 = [Weeks],3 = [Days],