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 |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3OrderCatalogSet table. |
OrderGUID |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3Order table. |
Type |
|
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 |
|
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. |