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 item. 

Description 
Definition  The description. 

EffectiveDate 
Definition  Enterprise TimeZone - The date that the item becomes effective. 

ExpiryDate 
Definition  Enterprise TimeZone - The date that the item expires, if any. 

AncillaryName 
Definition  Not used. See CV3AncillaryName. 

AncillaryCodingStd 
Definition  Not used. See CV3AncillaryName. 

IsCompletable 
Definition  Indicates if orders for this item can be set to a status of Completed. 

IsRepeatable 
Definition  Indicates if orders for this item can be repeated. 

Cost 
Definition  The cost of ordering this item. 

CostUnitOfMeasure 
Definition  The unit of measure associated to the cost (for example, dollars, cents). 

Duration 
Definition  The standard duration for orders of this item. 

IsDurationChangeable 
Definition  Indicates if the duration can be changed on the order. 

PrintClass 
Definition  Not used. 

SpecimenType 
Definition  The usual specimen type associated with this order. 

IsAutoActivatable 
Definition  Indicates if this item can be automatically activated. 

ActivateStatus 
Definition  The status code that the order is set to once it is activated. 

MinimumStatusForActivation 
Definition  The minimum status that the order must achieve before it is activated. 

ActivateDateReference 
Definition  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 
Definition  The number of days before the reference date that the order should be activated. 

ActivateHoursBefore 
Definition  The number of hours before the reference date that the order should be activated. 

IsAutoCompletable 
Definition  Indicates if this item can be automatically completed. 

CompleteStatus 
Definition  The status code that the order is set to once it is completed. 

MinimumStatusForCompletion 
Definition  The minimum status that the order must achieve before it is completed. 

CompleteDateReference 
Definition  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 
Definition  The number of days after the reference date that the order should be completed. 

CompleteHoursAfter 
Definition  The number of hours after the reference date that the order should be completed. 

ItemInfoID 
Definition  The link to the help file. 

CodedTimeGroupCode 
Definition  The link to a coded time group. This identifies which coded times are valid for the item. 

VerificationPolicyCode 
Definition  A foreign key to the Code column in the CV3VerificationPolicy table. 

OrgUnitGUID 
Definition  Link to the organization unit which owns the item (CV3OrganizationalUnit) 

TransmitPolicyGUID 
Definition  The link to the transmit policy. 

EntryFormGUID 
Definition  The link to the entry form used when ordering this item. 

OrderReviewCategoryGUID 
Definition  Link to the order review category (CV3OrderReviewCategory) 

IsIVAdditive 
Definition  Indicates that this item can be added to an IV order. 

CanBeSuspended 
Definition  Indicates if an order for this item can be suspended. 

AutoCompleteType 
Definition  Indicates if the auto completion rules apply to standard orders, discharge orders, or both. 

IsOngoingOrder 
Definition  Indicates if orders of this item are ongoing orders. 

DuplicatePolicyGUID 
Definition  The link to the duplicate policy which defines which items are considered duplicates. 

PatientCareDocumentGUID 
Definition  NOT USED 

TaskEffectiveDate 
Definition  Enterprise TimeZone - The effective date of the associated task, if applicable. 

TaskExpirationDate 
Definition  Enterprise TimeZone - The expiration date of the associated task, if applicable. 

CodedFreqGroupGUID 
Definition  A foreign key to the GUID column in the CV3CodedFrequencyGroup table. 

MaxRepeatsAllowed 
Definition  The maximum number of repeats allowed. 

OverrideMaxRepeats 
Definition  Indicates if the maximum number of repeats can be overridden when this item is ordered. 

AdvanceDaysRepeat 
Definition  The number of days before the requested date/time or schedule date/time that repeat orders should be generated. 

MinAdvanceOrdersRepeat 
Definition  The minimum number of repeat orders that should be generated in advance. 

IsPrimaryHidden 
Definition  Indicates whether ordering the “generic” version of the item is allowed. 

IsBaseSolution 
Definition  Values of 1 or 0. Indicates the item can be Base Solution or not. 

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

CanBeConditional 
Definition  This column will hold information whether the order item can be conditional or not. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsDurationExtendable 
Definition  Indicates whether the stop date can be extended using the Extend Stop Date feature. 

AllowAutomaticStopOrder 
Definition  Indicates whether the stop date can be extended by Automatic Stop Order. 

RelevantInfoPolicyGUID 
Definition  Link to a relevant information policy (CV3RelevantInfoPolicy) 

DoseBasisGroupGUID 
Definition  Link tot a dose basis group (CV3DoseBasisGroup) 

IsLMRPQueryItem 
Definition  Is item used in medical necessity checking 

OrderAvailPolicyGUID 
Definition  The availability policy used by the catalog item 

RxVerifyPolicyGUID 
Definition  The pharmacy verification policy used by the catalog item. This column has been renamed from PharmacyVerifyPolicyGUID 

MedAdminWarningPolicyGUID 
Definition  The policy used to define when medication administration warnings are displayed. 

IsLargeVolumeParenteral 
Definition  Indicates if the item is a continuous IV that may contain additives 

ReviewInterval 
Definition  The time frame after which the order has to be reviewed. Used to set the Review Date for an order. 

ReviewIntervalType 
Definition  An enumerated type with the following list of possible values: 0 = [Days],1 = [Hours], 

RelativeReviewInDays 
Definition  The number of days prior to the stop date that the order must be reviewed. 

IsReviewDateChangeable 
Definition  Can the review date be changed? 

AutoExtendStopDateType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [By Standard Policy],2 = [By ASO], 

IsInformational 
Definition  Indicates that this order item is a ‘Profile order’ (for information only). 

DosingOptionGroupGUID 
Definition  Stores the GUID of the Dose Option Group assigned to this order catalog master item. Links to CV3DosingOptionGroup.GUID. 

PRNReasonDictionaryType 
Definition  An enumerated type with the following list of possible values: 0 = [Free format text],1 = [Restricted Dictionary],2 = [Suggested Dictionary], 

PRNReasonDictionaryName 
Definition  Name of the PRNReason dictionary.The value for this column will come from CV3UserDictionary.Code. 

StopAfterTimesDisplayType 
Definition  An enumerated type with the following list of possible values: 0 = [Times],1 = [Doses],2 = [Units], 

TherapeuticCategory 
Definition  The therapeutic category of a drug. It links to the Category Name in the Multum DB – DrugCategory table 

TherapeuticCategoryID 
Definition  Id of therapeutic category assigned to multum drug id. 

TransferAutoStatusOrderPolicyGUID 
Definition  GUID of the Auto Status order transfer policy 

DischargeAutoStatusOrderPolicyGUID 
Definition  GUID of the Auto Status order discharge policy 

IsUnmappedPrescriptionItem 
Definition  TRUE if this is the non-formulary catalog item. 

AlternateMappingName 
Definition  Alternate Drug Mapping Name
 

RxOrderReviewPolicyID 
Definition  ID of SXAMMRxOrderReviewPolicy table which is only available when SMM is installed. A value of 0 indicates no policy 

RxDispensingPolicyID 
Definition  Reference (foreign key) to SXAMMDispensingPolicy table 

DrcGrouperID 
Definition  Stores the ID of the Dose Range Check Group Name associated with the catalog item 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CanUseACRRadiology 
Definition  Flag for location to Use ACR Radiology 

CostDisplayPolicyGUID 
Definition  Policy GUID 

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