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  A foreign key to the GUID column in the CV3Order table. 

IsIncluded 
Definition  Indicates whether this order is included in the order set, if applicable. 1 = True; 0 = False 

OrderCatalogSetGUID 
Definition  A foreign key to the GUID column in the CV3OrderCatalogSet table. 

MaxActivations 
Definition  The maximum number of activations of this order. This is applicable to repeat orders. 

RemainActivations 
Definition  The number of activations remaining. This is applicable to repeat orders. 

PRNReasonText 
Definition  The reason for delivering PRN medications. 

SpecialInstructions 
Definition  Any special instructions associated with the order. 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

TemplateGUID 
Definition  The link to the order template. 

FreqFromTime 
Definition  The starting time for the coded frequency. 

FreqToTime 
Definition  The ending time for the coded frequency. 

FreqUom 
Definition  The unit of measure for the frequency from and to times. 

FreqEventModifier 
Definition  The modifier of the time. 1 = Before; 2 = After 

FreqEventCode 
Definition  A foreign key to the Code column in the CV3ScheduleEvent table. 

FreqSummaryLine 
Definition  The summary line for the display. 

UseWakingHourOnly 
Definition  Indicates that the frequency code applies to waking hours only for task generation. 

GenTaskScheduleSource 
Definition  Indicates the source where the task schedule will be generated from. 

RepeatFrequency 
Definition  The frequency of the repetition (for example, every N hours). 

RepeatUom 
Definition  The unit of measure for the repetition (for example, hour, day, etc.). 

MaxRepeats 
Definition  The maximum number of repeat orders that can be created. 

LastRequestedDtm 
Definition  The requested date and time from the last repeat order that was created. 

RepeatStartDtm 
Definition  The starting time for the repeat orders. 

RepeatStopDtm 
Definition  The ending time for the repeat orders. 

VerificationPolicyCode 
Definition  The code of the Verification Policy used by the order. 

OriginOrderTemplateGUID 
Definition  The link to the order template that was used in creating the order. 

StopAfterValue 
Definition  Stores the value of the stop after 

StopAfterOption 
Definition  Stores the Stop After option0 = None1 = Days2 = Hours3 = Minutes4 = Times 

CalcStopDateMode 
Definition  Stores value that indicates whether the stop date can be calculated by the task processing.0 = CanCalcByTask, order generates task and stop date can be calculated by task.1 = CannotCalcByTask, stop date cannot be calculated by task.2 = Backedated, order generates task but is backdated further than the period defined in the 'Backdate Task Generation' entry, do not calculated the stop date by task. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

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

ReviewIntervalType 
Definition  Indicates the unit of measure for the review interval. 0 – Hours 1 – Days 

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  Indicates how the stop date will be extended when the order is marked as reviewed. Enumerated options are None (0), “ByStandardPolicy” (1), “ByASO” (2) 

ReviewTime 
Definition  Specifies that the next review time will be T + n hours 

ReviewDate 
Definition  Specifies that the next review date will be T + n days 

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

DosingOptionGUID 
Definition  For complex dosing master orders, stores the GUID of the dosing option that the user selected for this order. This links to CV3DosingOptionGUID 

HasAttachedSchedule 
Definition  Specify an order has attached schedule information. Either be a freq or a daily freq with adjusted admin times 

HasDataNotOnForm 
Definition  Indicates whether there ate extra data items that are stored with a value, but are not linked to the order form. This is data that was not populated from the Order Entry form, but from another source: Medication Management. 0 or Null – no extra data;1 – Extra data stored in the order 

DirectDeleteItemType 
Definition  Indicates whether the specific order item can be directly deleted from the Order Entry Worksheet dialog. This type will be populated from Config Tools in Order Set Item Attributes dialog with "Allow delete from worksheet" column containing combo box with the following values - 0-Not Allowed;1-Allowed;2-Default;3-FromSet 

DirectEditItemType 
Definition  Indicates whether the specific order item can be directly modified from the Order Entry Worksheet dialog. This type will be populated from Config Tools in Order Set Item Attributes dialog with "Allow edit from worksheet" column containing combo box with the following values - 0-Not Allowed;1-Allowed;2-Default;3-FromSet 

SuspendOptionType 
Definition  An enumerated type with the following list of possible values: 0 = [Now],1 = [Actual Suspend Date/Time],2 = [After next dose or occurrence], 

SuspendDtm 
Definition  Order suspend datetime 

UnsuspendOptionType 
Definition  An enumerated type with the following list of possible values: 0 = [Unsuspend Now],1 = [User unsuspends],2 = [Suspend Duration],3 = [Actual Resume Date/Time], 

SuspendForValue 
Definition  The value portion of the suspended for duration 

SuspendForOptionType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Days],2 = [Hours],3 = [Minutes],4 = [Times], 

UnsuspendDtm 
Definition  Order resume datetime 

SuspendUserGUID 
Definition  User who enters the suspend and/or unsuspend instructions 

ItemExternalIDCode 
Definition  Represents the external ID of the orders within the set 

DisplayModifierType 
Definition  An enumerated type with the following list of possible values: 0 = [Never],1 = [Always],2 = [Always(Order Entry)],3 = [When Unselected],4 = [Default],5 = [From Set], 

TransferToLocnGUID 
Definition  The location that the user is being transferred to. The GUID is taken from the CV3Location table. Default value is NULL. 

HistoricalOrderInfoSourceCode 
Definition  The information source of the order being reconciled. Values are either taken from the Code column in CCV3OrderReconcileInfoSource or are entered as free-text by the user. Default value is NULL. 

IsNoActionOnTransfer 
Definition  If this flag is true, the order will not be canceled on patient discharge. 

IsNoActionOnDischarge 
Definition  Valid values are

Not applicable = 0
Times = 1
Doses = 2
Units = 3
 

IsReconcileContinueOnTransfer 
Definition  The flag will be set to true if the user selected Continue action during transfer reconciliation. If the flag is true, order status will not change on Transfer (auto-dc/cancel or auto-suspend). 

CopyToCareProviderGUIDs 
Definition  Records the CareProviderGUID(s) for CopyTo field. Can contain up to 5 GUIDs 

BlindCopyToCareProviderGUIDs 
Definition  Records the CareProviderGUID(s) for BlindCopyTo field. Can contain up to 5 GUIDs 

IsScript 
Definition 
Whether or not this order has a script 

EntrySourceType 
Definition  An enumerated type with the following list of possible values: 0 = [Not Applicable],1 = [Admission],2 = [Admission From Transfer],3 = [Transfer],4 = [Discharge],5 = [Outpatient Medication Profile], 

FollowUpComment 
Definition 
Follow Up Comment 

BodySite 
Definition 
Body Site 

FinancialClass 
Definition 
Financial Class 

ConvertedToOutpatientOrderGUID 
Definition  This column will store the converted outpatient order's GUID. This is used in import tool 

RxSequenceNum 
Definition  This column is used to store the sequence number of the prescription. 

ScriptNumber 
Definition  This column is used to store the batch or script number of the prescription (group). 

IsToBeSent 
Definition  This column stores the flag (0 or 1), refers the prescription needs to be transmitted or not. 

FutureStartDateReasonType 
Definition  Store the type of reason why the start date of this order is future date. Actual reason will be stored in CV3EnumReference table 

IsUsingForm 
Definition  If it is true, order form will be used to create, edit or view the outpatient order, otherwise inline panel will be used. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsWithheld 
Definition  If it is true, the outpatient order is withheld, otherwise, it's normal order 

LastPrintedOrdStatusHistGUID 
Definition  This column holds the GUID (from CV3OrderStatusHistory table) of the latest row that has been passed to report print module.
Mainly applicable for OP Orders Reprint Module. 

IsNotSupplied 
Definition  If it is true, the outpatient order medication is not supplied from hospital, otherwise, it's supplied from hospital. 

InfoSource 
Definition  Sources of information for a home medication 

DSN 
Definition  The DSN generated by Order Appropriateness Tracking (OAT) system for this order. 

Score 
Definition  The Score evaluated by Order Appropriateness Tracking (OAT) system for this order based on the indication and scenario selected 

OriginalOrderName 
Definition  The origial order name submitted to Order Appropriateness Tracking (OAT) system for checking. 

OriginalOrderModifier 
Definition  The origial order modifier of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. 

OriginalOrderModifierVersion 
Definition  The origial order modifier version of the prefilled item submitted to Order Appropriateness Tracking (OAT) system for checking. 

OATReason 
Definition  The reason to override the decision recommended by Order Appropriateness Tracking (OAT) system. 

Cost 
Definition  The cost of this procedure assigned by Order Appropriateness Tracking (OAT) system. 

RRL 
Definition  The Relative Radiation Level (RRL) of this procedure assigned by Order Appropriateness Tracking (OAT) system. 

CDSMechanism 
Definition  The clinical decision system mechanism to determine the Order Appropriateness for this order. It might also be inbound from HL7. 

AUCSourceType 
Definition  An enumerated type with the following list of possible values: 0 = [Electronic],1 = [Manual],2 = [HL7], 

IsBypassAUCChecking 
Definition  Is Bypass AUC Checking 

BypassAUCCheckingReason 
Definition  Bypass AUC Checking Reason 

RecommendationText 
Definition  Store the recommendation text for appropriate use criteria of the order 

BypassAUCCheckingReasonModifierCode 
Definition  Store the modifier code for the reason to bypass AUC checking 

CDSMechanismGCode 
Definition  Store the G code for the CDSMechanism 

AdherenceScore 
Definition  Store the Adherence Score for AUC checking 

AdherenceScoreModifierCode 
Definition  Store the Modifier Code for the Adherence Score 

CanOverrideMaxRepeats 
Definition  Identifies whether the maximum repeat occurrences configured in the catalog master item can be overridden on order creation.