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

Name 
Definition  The name of the order item. 

EnterRole 
Definition  A foreign key to the Code column in the CV3OrderRoleType table. 

UserGUID 
Definition  A foreign key to the GUID column in the CV3User table. 

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

ClientVisitGUID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

ChartGUID 
Definition  A foreign key to the GUID column in the CV3Chart table. 

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 and time to stop the order. 

StopDate 
Definition  The date 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  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 Time, Scheduled Time, or Performed Time. 

ScheduledDtm 
Definition  The date and time the order is scheduled. 

AncillaryReferenceCode 
Definition  The accession number from 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. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 

IsForDischarge 
Definition  Indicates if this is a discharge order. 

HasBeenModified 
Definition  Indicates if order has been modified. 

IsConditional 
Definition  Indicates if this is a conditional order. 

ConditionsText 
Definition  The conditions for the order. 

IsHeld 
Definition  Indicates whether or not the order is a hold order. 

HoldReasonText 
Definition  The reason for the hold order. 

IsAutoActivatable 
Definition  Indicates if the order activates automatically. 

ActivateDateReference 
Definition  A foreign key to the Code column in the CV3DateReference table. 

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

FrequencyCode 
Definition  A foreign key to the Code column in the CV3Frequency table. 

SourceCode 
Definition  A foreign key to the Code column in the CV3Source table. 

OrderPriorityCode 
Definition  A foreign key to the Code column in the CV3OrderPriority table. 

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

OrderEntryFormGUID 
Definition  A foreign key to the GUID column in the CV3OrderEntryForm table. 

OrderCatalogMasterItemGUID 
Definition  A foreign key to the GUID column in the CV3OrderCatalogMasterItem table. 

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

PathwayColumnHeaderGUID 
Definition  A foreign key to the GUID column in the CV3ClinicalPathwayHeader table. 

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  PHI: The date and time the order arrived in the Master Active database. 

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

ReqCodedTime 
Definition  A foreign key to the Name column in the CV3CodedTime table. 

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

ReqTimeUom 
Definition  A foreign key to the Code column in the CV3UnitOfMeasure table. 

ReqTimeEventModifier 
Definition  An enumerated type with the following list of possible values: 1 = [Before],2 = [After], 

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

VarianceType 
Definition  Not used. 

RepeatOrder 
Definition  The order type. 

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

OrderTemplateGUID 
Definition  A foreign key to the GUID column in the CV3Order table. 

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  An enumerated type with the following list of possible values: 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  Stores the calculated upcoming review date 

ComplexOrderType 
Definition  An enumerated type with the following list of possible values: 0 = [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 Master],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  An enumerated type with the following list of possible values: 0 = [Not Applicable],1 = [Historical Order],2 = [Outpatient Order], 

InitialSessionTypeCode 
Definition  Replaces the column SessionTypeCode 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.