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 item. |
Description |
|
varchar(40) |
YES |
The description. |
EffectiveDate |
|
datetime |
YES |
Enterprise TimeZone - The date that the item becomes effective. |
ExpiryDate |
|
datetime |
YES |
Enterprise TimeZone - The date that the item expires, if any. |
AncillaryName |
|
varchar(125) |
YES |
Not used. See CV3AncillaryName. |
AncillaryCodingStd |
|
varchar(60) |
YES |
Not used. See CV3AncillaryName. |
IsCompletable |
|
bit |
NO |
Indicates if orders for this item can be set to a status of Completed. |
IsRepeatable |
|
bit |
NO |
Indicates if orders for this item can be repeated. |
Cost |
|
varchar(10) |
YES |
The cost of ordering this item. |
CostUnitOfMeasure |
|
varchar(20) |
YES |
The unit of measure associated to the cost (for example, dollars, cents). |
Duration |
|
int |
NO |
The standard duration for orders of this item. |
IsDurationChangeable |
|
bit |
NO |
Indicates if the duration can be changed on the order. |
PrintClass |
|
varchar(30) |
YES |
Not used. |
SpecimenType |
|
varchar(40) |
YES |
The usual specimen type associated with this order. |
IsAutoActivatable |
|
bit |
NO |
Indicates if this item can be automatically activated. |
ActivateStatus |
|
varchar(40) |
YES |
The status code that the order is set to once it is activated. |
MinimumStatusForActivation |
|
varchar(40) |
YES |
The minimum status that the order must achieve before it is activated. |
ActivateDateReference |
|
varchar(40) |
YES |
The reference date used to determine when the order should be activated. This is not a true date, but a reference date such as date of surgery. |
ActivateDaysBefore |
|
int |
NO |
The number of days before the reference date that the order should be activated. |
ActivateHoursBefore |
|
int |
NO |
The number of hours before the reference date that the order should be activated. |
IsAutoCompletable |
|
bit |
NO |
Indicates if this item can be automatically completed. |
CompleteStatus |
|
varchar(40) |
YES |
The status code that the order is set to once it is completed. |
MinimumStatusForCompletion |
|
varchar(40) |
YES |
The minimum status that the order must achieve before it is completed. |
CompleteDateReference |
|
varchar(40) |
YES |
The reference date used to determine when the order should be completed. This is not a true date, but a reference date such as date of surgery. |
CompleteDaysAfter |
|
int |
NO |
The number of days after the reference date that the order should be completed. |
CompleteHoursAfter |
|
int |
NO |
The number of hours after the reference date that the order should be completed. |
ItemInfoID |
|
int |
NO |
The link to the help file. |
CodedTimeGroupCode |
|
varchar(40) |
YES |
The link to a coded time group. This identifies which coded times are valid for the item. |
VerificationPolicyCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3VerificationPolicy table. |
OrgUnitGUID |
|
HVCIDdt |
YES |
Link to the organization unit which owns the item (CV3OrganizationalUnit) |
TransmitPolicyGUID |
|
HVCIDdt |
YES |
The link to the transmit policy. |
EntryFormGUID |
|
HVCIDdt |
YES |
The link to the entry form used when ordering this item. |
OrderReviewCategoryGUID |
|
HVCIDdt |
YES |
Link to the order review category (CV3OrderReviewCategory) |
IsIVAdditive |
|
bit |
NO |
Indicates that this item can be added to an IV order. |
CanBeSuspended |
|
bit |
NO |
Indicates if an order for this item can be suspended. |
AutoCompleteType |
|
int |
NO |
Indicates if the auto completion rules apply to standard orders, discharge orders, or both. |
IsOngoingOrder |
|
bit |
NO |
Indicates if orders of this item are ongoing orders. |
DuplicatePolicyGUID |
|
HVCIDdt |
YES |
The link to the duplicate policy which defines which items are considered duplicates. |
PatientCareDocumentGUID |
|
HVCIDdt |
YES |
NOT USED |
TaskEffectiveDate |
|
datetime |
YES |
Enterprise TimeZone - The effective date of the associated task, if applicable. |
TaskExpirationDate |
|
datetime |
YES |
Enterprise TimeZone - The expiration date of the associated task, if applicable. |
CodedFreqGroupGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3CodedFrequencyGroup table. |
MaxRepeatsAllowed |
|
int |
YES |
The maximum number of repeats allowed. |
OverrideMaxRepeats |
|
tinyint |
YES |
Indicates if the maximum number of repeats can be overridden when this item is ordered. |
AdvanceDaysRepeat |
|
int |
YES |
The number of days before the requested date/time or schedule date/time that repeat orders should be generated. |
MinAdvanceOrdersRepeat |
|
int |
YES |
The minimum number of repeat orders that should be generated in advance. |
IsPrimaryHidden |
|
tinyint |
YES |
Indicates whether ordering the “generic” version of the item is allowed. |
IsBaseSolution |
|
tinyint |
YES |
Values of 1 or 0. Indicates the item can be Base Solution or not. |
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], |
CanBeConditional |
|
bit |
NO |
This column will hold information whether the order item can be conditional or not. |
MSrepl_tran_version |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
IsDurationExtendable |
|
bit |
NO |
Indicates whether the stop date can be extended using the Extend Stop Date feature. |
AllowAutomaticStopOrder |
|
bit |
NO |
Indicates whether the stop date can be extended by Automatic Stop Order. |
RelevantInfoPolicyGUID |
|
HVCIDdt |
YES |
Link to a relevant information policy (CV3RelevantInfoPolicy) |
DoseBasisGroupGUID |
|
HVCIDdt |
YES |
Link tot a dose basis group (CV3DoseBasisGroup) |
IsLMRPQueryItem |
|
bit |
NO |
Is item used in medical necessity checking |
OrderAvailPolicyGUID |
|
HVCIDdt |
YES |
The availability policy used by the catalog item |
RxVerifyPolicyGUID |
|
HVCIDdt |
YES |
The pharmacy verification policy used by the catalog item. This column has been renamed from PharmacyVerifyPolicyGUID |
MedAdminWarningPolicyGUID |
|
HVCIDdt |
YES |
The policy used to define when medication administration warnings are displayed. |
IsLargeVolumeParenteral |
|
bit |
NO |
Indicates if the item is a continuous IV that may contain additives |
ReviewInterval |
|
int |
NO |
The time frame after which the order has to be reviewed. Used to set the Review Date for an order. |
ReviewIntervalType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Days],1 = [Hours], |
RelativeReviewInDays |
|
int |
NO |
The number of days prior to the stop date that the order must be reviewed. |
IsReviewDateChangeable |
|
bit |
NO |
Can the review date be changed? |
AutoExtendStopDateType |
|
int |
NO |
An enumerated type with the following list of possible values: 0 = [None],1 = [By Standard Policy],2 = [By ASO], |
IsInformational |
|
bit |
NO |
Indicates that this order item is a ‘Profile order’ (for information only). |
DosingOptionGroupGUID |
|
HVCIDdt |
YES |
Stores the GUID of the Dose Option Group assigned to this order catalog master item. Links to CV3DosingOptionGroup.GUID. |
PRNReasonDictionaryType |
|
int |
NO |
An enumerated type with the following list of possible values: 0 = [Free format text],1 = [Restricted Dictionary],2 = [Suggested Dictionary], |
PRNReasonDictionaryName |
|
varchar(30) |
YES |
Name of the PRNReason dictionary.The value for this column will come from CV3UserDictionary.Code. |
StopAfterTimesDisplayType |
|
int |
NO |
An enumerated type with the following list of possible values: 0 = [Times],1 = [Doses],2 = [Units], |
TherapeuticCategory |
|
varchar(255) |
YES |
The therapeutic category of a drug. It links to the Category Name in the Multum DB – DrugCategory table |
TherapeuticCategoryID |
|
int |
YES |
Id of therapeutic category assigned to multum drug id. |
TransferAutoStatusOrderPolicyGUID |
|
HVCIDdt |
YES |
GUID of the Auto Status order transfer policy |
DischargeAutoStatusOrderPolicyGUID |
|
HVCIDdt |
YES |
GUID of the Auto Status order discharge policy |
IsUnmappedPrescriptionItem |
|
bit |
NO |
TRUE if this is the non-formulary catalog item. |
AlternateMappingName |
|
varchar(255) |
YES |
Alternate Drug Mapping Name
|
RxOrderReviewPolicyID |
|
int |
NO |
ID of SXAMMRxOrderReviewPolicy table which is only available when SMM is installed. A value of 0 indicates no policy |
RxDispensingPolicyID |
|
int |
YES |
Reference (foreign key) to SXAMMDispensingPolicy table |
DrcGrouperID |
|
int |
YES |
Stores the ID of the Dose Range Check Group Name associated with the catalog item |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
CanUseACRRadiology |
|
bit |
NO |
Flag for location to Use ACR Radiology |
CostDisplayPolicyGUID |
|
HVCIDdt |
YES |
Policy GUID |
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], |