dbo.SXACMPCompletionObject 
Default Table Name  SXACMPCompletionObject 
Definition  This table holds all signature and completion requests 

dbo.SXACMPCompletionObject Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  NO  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    datetime  NO  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  NO  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    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
CompletionObjectID(PK)    bigint  NO  Auto generated unique primary key value. 
ObjectGUID    HVCIDdt  YES  The link to the order, task, or document that is must be completed. For non-electronic documents, it will be null. 
ObjectTypeID(FK)    int  NO  A foreign key to the ObjectTypeID column in the SXAObjectType table. 
ObjectSource    varchar(25)  NO  An indicator of where the object originated. Valid values ('SCM','RM'). 
CompletionStep    varchar(25)  NO  The step that needs to be performed on the item. Valid values (Sign, Transcribe, Dictate). 
CompletionStatus    char(10)  NO  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    datetime  YES  The date and time the step was completed for the object. 
CompletionUserGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3User table. 
CareProviderGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3CareProvider table. 
CareProviderGUIDType    varchar(25)  NO  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(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
StatusHistoryGUID    HVCIDdt  YES  (Formerly OrderStatusHistoryGUID) 
DueWhenDtm    datetime  YES  The date and time that the step for this object must be completed. (For future use to determine overdue.) 
ClientGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Client table. 
ChartGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Chart table. 
FacilityGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Location table. 
ClientVisitGUID    HVCIDdt  NO  A link to the CV3ClientVisitTable 
Reason    varchar(255)  YES  The last reason the user reassigned or refused to complete this step. 
CompletionOrder    smallint  NO  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    smallint  NO  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    bit  NO  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    bit  NO  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    datetime  YES  A date used to identify the document which is incomplete. (Only needed for documents which require dates such as op reports) 
IsAged    bit  NO  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    smallint  NO  The age of the deficiency in days. For Q3 release, all rows will have a value of 0. 
AgingMessage    varchar(40)  YES  Text of why this deficiency was not aged by deficiency aging. (For Q3 all rows will have a null value.) 
AgeStartDate    datetime  YES  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    datetime  YES  The date when the nightly aging program last aged the deficiency. (For Q3 all rows will have a null value.) 
AgingStatus    bit  NO  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    datetime  YES  The date and time that a signature block was added to an image document. (For Q3 all rows will have a null value.) 
DeficiencyLetterType    char(10)  YES  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    uniqueidentifier  NO  Optimistic lock identifier. 
OriginalCompletionActivity    varchar(40)  YES  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    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXACMPCompletionObject Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACMPCompletionObjectPK  PrimaryKey  CompletionObjectID