dbo.CV3OrderXRef 
Default Table Name  CV3OrderXRef 
Definition  Used to group orders together for the purposes of Order Sets, Order Pathways, Conditional Orders, and Repeat Orders. 

dbo.CV3OrderXRef 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. 
ParentGUID(PK)(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3OrderCatalogSet table. 
OrderGUID(PK)(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Order table. 
Type(PK)    int  NO  An enumerated type with the following list of possible values: 0 = [OrderSet],1 = [Conditional],2 = [Variance],3 = [Repeat],4 = [GenericOrderSet],5 = [LinkedHealthIssues], 
ClientGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Client table. 
VarianceType    int  YES  The variance recorded for this path, if any. 0 = None; 1 = Modify template; 2 = Deviation 
OrderTemplateID    int  YES  The unique identifier for order templates in order sets, generic sets, personal sets, and clinical paths. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
MultiOrderEntryFieldGUID    HVCIDdt  YES  Link to the Entry field table 
MultiFieldDataItemCode    varchar(40)  YES  The code from the data item from the order sets form which is being mapped 
MultiFieldOccNum    int  YES  Number of field occurrences 
RefSetBehaviorType    int  YES  An enumerated type with the following list of possible values: 0 = [Add All],1 = [Add Selected],2 = [Add None], 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3OrderXRef Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderXRefPK  PrimaryKey  OrderGUID, ParentGUID, Type