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 |
|
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 |
|
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 |
|
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], |