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 
To match CV3Order and CV3AlternateOrder 

Status 
Definition 
To match CV3Order and CV3AlternateOrder 

ToBeVerified 
Definition 
To match CV3Order and CV3AlternateOrder 

ToBeSigned 
Definition 
To match CV3Order and CV3AlternateOrder 

EnterRole 
Definition 
To match CV3Order and CV3AlternateOrder 

UserGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

ClientVisitGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

ClientGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

ChartGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

Name 
Definition 
To match CV3Order and CV3AlternateOrder 

Modifier 
Definition 
To match CV3Order and CV3AlternateOrder 

RequestedDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

RequestedDate 
Definition 
To match CV3Order and CV3AlternateOrder 

RequestedTime 
Definition 
To match CV3Order and CV3AlternateOrder 

StopDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

StopDate 
Definition 
To match CV3Order and CV3AlternateOrder 

StopTime 
Definition 
To match CV3Order and CV3AlternateOrder 

Duration 
Definition 
To match CV3Order and CV3AlternateOrder 

IsDurationChangeable 
Definition 
To match CV3Order and CV3AlternateOrder 

PerformedDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

SignificantDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

SignificantTime 
Definition 
To match CV3Order and CV3AlternateOrder 

ScheduledDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

AncillaryReferenceCode 
Definition 
To match CV3Order and CV3AlternateOrder 

SummaryLine 
Definition 
To match CV3Order and CV3AlternateOrder 

IDCode 
Definition 
To match CV3Order and CV3AlternateOrder 

TypeCode 
Definition 
To match CV3Order and CV3AlternateOrder 

ApplicSource 
Definition 
To match CV3Order and CV3AlternateOrder 

IsForDischarge 
Definition 
To match CV3Order and CV3AlternateOrder 

HasBeenModified 
Definition 
To match CV3Order and CV3AlternateOrder 

IsConditional 
Definition 
To match CV3Order and CV3AlternateOrder 

ConditionsText 
Definition 
To match CV3Order and CV3AlternateOrder 

IsHeld 
Definition 
To match CV3Order and CV3AlternateOrder 

HoldReasonText 
Definition 
To match CV3Order and CV3AlternateOrder 

IsAutoActivatable 
Definition 
To match CV3Order and CV3AlternateOrder 

ActivateDateReference 
Definition 
To match CV3Order and CV3AlternateOrder 

ActivateDaysBefore 
Definition 
To match CV3Order and CV3AlternateOrder 

ActivateHoursBefore 
Definition 
To match CV3Order and CV3AlternateOrder 

ActivateStatus 
Definition 
To match CV3Order and CV3AlternateOrder 

MinimumStatusForActivation 
Definition 
To match CV3Order and CV3AlternateOrder 

IsAutoCompletable 
Definition 
To match CV3Order and CV3AlternateOrder 

CompleteDateReference 
Definition 
To match CV3Order and CV3AlternateOrder 

CompleteDaysAfter 
Definition 
To match CV3Order and CV3AlternateOrder 

CompleteHoursAfter 
Definition 
To match CV3Order and CV3AlternateOrder 

CompleteStatus 
Definition 
To match CV3Order and CV3AlternateOrder 

MinimumStatusForCompletion 
Definition 
To match CV3Order and CV3AlternateOrder 

IsCompleteTemplate 
Definition 
To match CV3Order and CV3AlternateOrder 

TranspMethodCode 
Definition 
To match CV3Order and CV3AlternateOrder 

FrequencyCode 
Definition 
To match CV3Order and CV3AlternateOrder 

SourceCode 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderPriorityCode 
Definition 
To match CV3Order and CV3AlternateOrder 

SystemOrderPriorityCode 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderStatusCode 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderStatusLevelNum 
Definition 
To match CV3Order and CV3AlternateOrder 

IsPRN 
Definition 
To match CV3Order and CV3AlternateOrder 

IsSuspended 
Definition 
To match CV3Order and CV3AlternateOrder 

IsPartOfSet 
Definition 
To match CV3Order and CV3AlternateOrder 

SequenceNum 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSetName 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSetHeading 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSetGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

CareProviderGUID 
Definition  To match CV3Order and CV3AlternateOrder 

OrderEntryFormGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderCatalogMasterItemGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

IsIncluded 
Definition 
To match CV3Order and CV3AlternateOrder 

PathwayColumnHeaderGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

PathwayRowHeaderGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSetType 
Definition 
To match CV3Order and CV3AlternateOrder 

IsTrackVariance 
Definition 
To match CV3Order and CV3AlternateOrder 

IsGenericSet 
Definition 
To match CV3Order and CV3AlternateOrder 

SubSequenceNum 
Definition 
To match CV3Order and CV3AlternateOrder 

ModifyUserGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

ArrivalDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

ModifiedDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

ReqCodedTime 
Definition 
To match CV3Order and CV3AlternateOrder 

ReqTimeValue 
Definition 
To match CV3Order and CV3AlternateOrder 

ReqTimeUom 
Definition 
To match CV3Order and CV3AlternateOrder 

ReqTimeEventModifier 
Definition 
To match CV3Order and CV3AlternateOrder 

ReqTimeEventCode 
Definition 
To match CV3Order and CV3AlternateOrder 

VarianceType 
Definition 
To match CV3Order and CV3AlternateOrder 

RepeatOrder 
Definition 
To match CV3Order and CV3AlternateOrder 

IsAutoGenerated 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderTemplateGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

IsApplyProtection 
Definition 
To match CV3Order and CV3AlternateOrder 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsOrderSet 
Definition 
To match CV3Order and CV3AlternateOrder 

IsAddedGenericSet 
Definition 
To match CV3Order and CV3AlternateOrder 

OtherSessionType 
Definition 
To match CV3Order and CV3AlternateOrder 

IsRequired 
Definition 
To match CV3Order and CV3AlternateOrder 

CanBeModified 
Definition 
To match CV3Order and CV3AlternateOrder 

DiscCancelGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

SuspendGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

VerifyGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

ReleaseGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

ActivateGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSubsetName 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSubsetGUID 
Definition 
To match CV3Order and CV3AlternateOrder 

OrderSubsetType 
Definition 
To match CV3Order and CV3AlternateOrder 

WorklistRefItemGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

TaskRescheduleGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

TaskGroupNum 
Definition 
To match CV3Order and CV3AlternateOrder 

ReviewDtm 
Definition 
To match CV3Order and CV3AlternateOrder 

ComplexOrderType 
Definition 
To match CV3Order and CV3AlternateOrder 

IsLinkedForDiscCancel 
Definition 
To match CV3Order and CV3AlternateOrder 

IsLinkedForSuspend 
Definition 
To match CV3Order and CV3AlternateOrder 

CanBeSuspended 
Definition 
To match CV3Order and CV3AlternateOrder 

AlternateOrderType 
Definition 
To match CV3Order and CV3AlternateOrder 

InitialSessionTypeCode 
Definition 
To match CV3Order and CV3AlternateOrder 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.