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. 

Entered 
Definition  Visit TimeZone - The date and time the row was entered 

Status 
Definition  The status of the order 

ToBeVerified 
Definition  Indicates if this order is to be verified 

ToBeSigned 
Definition  Indicates if this order is to be signed 

EnterRole 
Definition  The role of the person who entered the order (CV3OrderRoleType) 

UserGUID 
Definition  A link to the user 

ClientVisitGUID 
Definition  A link to the Client Visit 

ClientGUID 
Definition  A link to the Client 

ChartGUID 
Definition  Link to the CV3Chart table 

Name 
Definition  The name of the order form 

Modifier 
Definition  The modifier of the order item. This is copied from the order Catalog Item 

RequestedDtm 
Definition  Visit TimeZone - The date and time for which the order is requested 

RequestedDate 
Definition  The date for which the order is requested 

RequestedTime 
Definition  The time for which the order is requested 

StopDtm 
Definition  Visit TimeZone - The date to stop the order 

StopDate 
Definition  The date and time to stop the order 

StopTime 
Definition  The time to stop the order 

Duration 
Definition  The duration of the order 

IsDurationChangeable 
Definition  Indicates if the duration of the order can be changed 

PerformedDtm 
Definition  Visit TimeZone - The date and time the order was performed 

SignificantDtm 
Definition  Visit TimeZone - The most recent Requested, Scheduled or Performed dtm 

SignificantTime 
Definition  The most recent Requested, Scheduled or Performed dtm 

ScheduledDtm 
Definition  Visit TimeZone - The date and time the order is scheduled 

AncillaryReferenceCode 
Definition  The accession number from the lab 

SummaryLine 
Definition  The system generated summary line of the order 

IDCode 
Definition  The system generated unique identifier for the order 

TypeCode 
Definition  The order type (Diagnostic, Medication or Other) 

ApplicSource 
Definition  Identifies which Eclipsys application was used to enter the information: CV-Sunrise Clinical Manager; ADT-ADT Interface or LAB-LAB Interface 

IsForDischarge 
Definition  Indicates if this is a discharge order 

HasBeenModified 
Definition  Indicates if the order has been modified 

IsConditional 
Definition  Indicates if this is a conditional order 

ConditionsText 
Definition  The conditions of the order 

IsHeld 
Definition  indicates whether or not the order is a held order 

HoldReasonText 
Definition  The reason for the hold order 

IsAutoActivatable 
Definition  Indicates if the order activates automatically 

ActivateDateReference 
Definition  The reference date used to determine when the order should be activated. This is a true date but a reference data such as ordered fate and time 

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 

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 

IsAutoCompletable 
Definition  Indicates if the order completes automatically 

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. 

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.  

IsCompleteTemplate 
Definition  If this is an order template, this flag indicates if the template is complete and no additional data is required upon order entry. 

TranspMethodCode 
Definition  The method of transport (CV3TransportMethod) 

FrequencyCode 
Definition  The frequency for this order e.g. q4h (CV3Frequency) 

SourceCode 
Definition  The source of the order (CV3Source) 

OrderPriorityCode 
Definition  Order Priority Code (CV3OrderPriority)  

SystemOrderPriorityCode 
Definition  The internal order priority. 

OrderStatusCode 
Definition  The order status. 

OrderStatusLevelNum 
Definition  A level number assigned to the status. The higher the number, the further along the order is in its life cycle. 

IsPRN 
Definition  Indicates if this is a PRN order. 

IsSuspended 
Definition  Indicates if this order is suspended. 

IsPartOfSet 
Definition  Indicates if this order is part of a set. 

SequenceNum 
Definition  The sequence number within a set, if applicable. 

OrderSetName 
Definition  The name of the order set, if applicable. 

OrderSetHeading 
Definition  The heading of the order within the order set, if applicable. 

OrderSetGUID 
Definition  The link to the ParentGUID on CV3OrderItemXref. 

CareProviderGUID 
Definition  Link to the Care Provider (CV3CareProvider) 

OrderEntryFormGUID 
Definition  The link to the form used to enter the order (CV3OrderEntryForm) 

OrderCatalogMasterItemGUID 
Definition  The link to the order catalog master item (CV3OrderCatalogMasterItem) 

IsIncluded 
Definition  Indicates whether this order is included in the order set, if applicable.  

PathwayColumnHeaderGUID 
Definition  The link to clinical pathway header (CV3ClinicalPathwayHeader)  

PathwayRowHeaderGUID 
Definition  The link to the CV3ClinicalPathwayHeader. 

OrderSetType 
Definition  Stores the order catalog set type, if applicable.  

IsTrackVariance 
Definition  Not used. 

IsGenericSet 
Definition  Identifies the template representing a generic set in an order set or clinical path. 

SubSequenceNum 
Definition  The sequence number on an order inserted in a generic set. 

ModifyUserGUID 
Definition  Identifies the user who modified an order and caused a Pending Verify status change. 

ArrivalDtm 
Definition  Visit TimeZone - The date and time the order arrived in the Master Active database. 

ModifiedDtm 
Definition  Visit TimeZone - The date and time the order was last modified. 

ReqCodedTime 
Definition  The coded time for which the order was requested (CV3CodedTime)  

ReqTimeValue 
Definition  The time value of the event-based coded time. 

ReqTimeUom 
Definition  The unit of measure for the event-based coded time (CV3UnitOfMeasure)  

ReqTimeEventModifier 
Definition  when the requested time of an order is based on an event, this value indicates if it is before or after the event (1 = before; 2 = after) 

ReqTimeEventCode 
Definition  The modifier of the time. 

VarianceType 
Definition  Not used.  

RepeatOrder 
Definition  The order type. 

IsAutoGenerated 
Definition  Indicates if this order is generated by a background process. 

OrderTemplateGUID 
Definition  The GUID of the pre-filled order item that this order was created from, if applicable (CV3Order) 

IsApplyProtection 
Definition  Determines whether to protect fields during order entry on fields with Selected Item Only protection, if applicable. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsOrderSet 
Definition  Indicates whether the particular item is order set or not. 

IsAddedGenericSet 
Definition  This column will indicate whether the particular item is an added generic set or not. 

OtherSessionType 
Definition  Internal order session type enumerator (0 - Completed 

IsRequired 
Definition  Indicates if the order is required in this set. 

CanBeModified 
Definition  Indicates whether or not the order can be modified. This is applicable only to orders associated to a linked set. 

DiscCancelGroupNum 
Definition  Indicates if this order should be grouped with other orders for discontinue/cancel. The column CV3OrderSet.DiscCancelGroupByGUID will help identify which orders are part of the group.  

SuspendGroupNum 
Definition  Indicates if this order should be grouped for Suspend/Unsuspended behavior. 

VerifyGroupNum 
Definition  Indicates if this order should be grouped with other orders for verification. 

ReleaseGroupNum 
Definition  Indicates if this order should be grouped with other orders when released.  

ActivateGroupNum 
Definition  Indicates if this order should be grouped with other orders when activated. 

OrderSubsetName 
Definition  The name of the sub-set that the order belongs to. 

OrderSubsetGUID 
Definition  Link to CV3OrderSet.GUID This points to the sub-set that the order may belong to. (note: CV3OrderSet is a new table) 

OrderSubsetType 
Definition  Indicates the order sub-set type  

WorklistRefItemGroupNum 
Definition  Indicates if this order will be used in the task worklist as a reference item  

TaskRescheduleGroupNum 
Definition  Indicates if this order is grouped with other orders when tasks are rescheduled. If so, all tasks must be rescheduled at onces 

TaskGroupNum 
Definition  Indicates if this order will appear grouped with other orders on the task worklist  

ReviewDtm 
Definition  Visit TimeZone - Stores the calculated upcoming review date 

ComplexOrderType 
Definition  Define the type of order: 0 or NULL regular order ; 1 – Sequential Complex Dose Master; 2 – Sequential Complex Dose Child; 3 – Concurrent Complex Dose Master; 4 – Concurrent Complex Dose Child; 5 – Multiple Frequencies Mater; 6 – Multiple Frequencies Child 

IsLinkedForDiscCancel 
Definition  Indicates whether this order is linked in a group for dc/cancel  

IsLinkedForSuspend 
Definition  Indicates whether this order is linked in a group for suspend/unsuspended 

CanBeSuspended 
Definition  Indicates whether this order can be suspended. This overrides the setting of CV3OrderCatalogMasterItem  

AlternateOrderType 
Definition  Used to distinguish Historical Orders (0 = not applicable; 1 = Historical order) 

InitialSessionTypeCode 
Definition  The session type used during order entry 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.