SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. 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. 

CompletionObjectID 
Definition  Auto generated unique primary key value. 

ObjectGUID 
Definition  The link to the order, task, or document that is must be completed. For non-electronic documents, it will be null. 

ObjectTypeID 
Definition  A foreign key to the ObjectTypeID column in the SXAObjectType table. 

ObjectSource 
Definition  An indicator of where the object originated. Valid values ('SCM','RM'). 

CompletionStep 
Definition  The step that needs to be performed on the item. Valid values (Sign, Transcribe, Dictate). 

CompletionStatus 
Definition  Current status of the completion step. Valid values: Active, Pending, Completed, Refused, NotSigned, Canceled, Rolled, Hold. Objects with a status of Active or Refused will show up in lists to be processed. Pending will not show up until a previous ob 

CompletionDtm 
Definition  The date and time the step was completed for the object. 

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

CareProviderGUID 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

CareProviderGUIDType 
Definition  This field defines the meaning of the CareProviderGUID, and this determines the table where the CareProviderGUID may be found. For Q3 release, all rows will have a value of "Provider". Valid values (Provider, Visit Role, Order Role, Provider Type) will 

CareProviderGUIDOriginal 
Definition  A foreign key to the GUID column in the CV3CareProvider table. 

StatusHistoryGUID 
Definition  (Formerly OrderStatusHistoryGUID) 

DueWhenDtm 
Definition  The date and time that the step for this object must be completed. (For future use to determine overdue.) 

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

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

FacilityGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

ClientVisitGUID 
Definition  A link to the CV3ClientVisitTable 

Reason 
Definition  The last reason the user reassigned or refused to complete this step. 

CompletionOrder 
Definition  The order in which the incompletions must be processed for this object. All incompletions for order 1 for an object at the same step must be processed before those for order 2, etc. If several active entries exist for the same order, they may be process 

MinimumForOrder 
Definition  The minimum number of incompletions which must be processed for this object with this completion order at this step. (For the Q3 release, all rows will have a value of 1.) 

CompletesOrder 
Definition  Indicates whether or not the completion of a completion object at this order will complete all completion objects for the same object at the same step with the same order. 0 = False, 1 = True. (For Q3 release, all rows have a value of = 0) 

RefusesOrder 
Definition  Indicates whether or not the refusal of a completion object at this order will refuse all completion objects for the same object at the same step with the same order. 0 = False, 1 = True. (For Q3 release, all rows have a value of = 0) 

ReportDate 
Definition  A date used to identify the document which is incomplete. (Only needed for documents which require dates such as op reports) 

IsAged 
Definition  An indicator whether or not this needs to be aged for deficiencies. 1=True, 0=False. For Q3 release, all rows will have a value = 0. 

AgeDays 
Definition  The age of the deficiency in days. For Q3 release, all rows will have a value of 0. 

AgingMessage 
Definition  Text of why this deficiency was not aged by deficiency aging. (For Q3 all rows will have a null value.) 

AgeStartDate 
Definition  The date when deficiency aging started. This date is set by nightly deficiency aging program. (For Q3 all rows will have a null value.) 

AgingDate 
Definition  The date when the nightly aging program last aged the deficiency. (For Q3 all rows will have a null value.) 

AgingStatus 
Definition  An indicator of whether the nightly aging program aged the deficiency the last time it ran. (Aging can be temporarily halted for many reasons.) 0 = False, 1 = True. (For Q3 all rows will have a value of 0.) 

SignatureBlockDtm 
Definition  The date and time that a signature block was added to an image document. (For Q3 all rows will have a null value.) 

DeficiencyLetterType 
Definition  The type of deficiency letter this deficiency would generate. This would only be set for completion objects that age nightly and which have DeficiencyLetterControl.IsLetterGenerated = 1. (For Q3 all rows will have a null value.) Valid values (New, Notify 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

OriginalCompletionActivity 
Definition  The original activity that is being signed for. Currently only a subset of CV3OrderStatusHistory.FunctionCodeNum reference. Possible values are New, Modified, Cancelled, Suspended, Unsuspended, Discontinued etc. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.