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 |
|
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 |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3User table. |
CareProviderGUID |
|
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 |
|
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 |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3Client table. |
ChartGUID |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3Chart table. |
FacilityGUID |
|
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. |