ColumnName |
Domain |
Datatype |
NULL |
Definition |
SiteID |
|
smallint |
YES |
Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
RepFlags |
|
tinyint |
YES |
Indicates the action in a distributed database environment. 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) |
YES |
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 |
YES |
The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
|
varchar(50) |
YES |
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 |
YES |
The date and time that the row was created and will be based on the Enterprise time zone. |
Active |
|
bit |
NO |
Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. |
GUID |
|
HVCIDdt |
NO |
Unique primary key value. |
ClientGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Client table. |
OrderGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Order table. |
OrderTaskGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3OrderTask table. |
CatalogItemTaskGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3CatalogItemTask table. |
TaskName |
|
varchar(255) |
YES |
The name of the task. This is copied from the catalog. |
ScheduledDtm |
|
datetime |
YES |
Visit TimeZone - The scheduled date and time of this occurrence. |
EarliestScheduledDtm |
|
datetime |
YES |
Visit TimeZone - The earliest scheduled date and time for this occurrence. |
LatestScheduledDtm |
|
datetime |
YES |
Visit TimeZone - The latest scheduled date and time for this occurrence. |
EnteredProviderGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3CareProvider table. |
PerformedProviderGUID |
|
HVCIDdt |
YES |
The link to the Care Provider who performs this task. |
EnteredDtm |
|
datetime |
YES |
Visit TimeZone - The date and time of the last performance information. |
PerformedFromDtm |
|
datetime |
YES |
Visit TimeZone - The performed date and time. |
PerformedToDtm |
|
datetime |
YES |
Visit TimeZone - The date and time the task was performed up until. This is used by continuous tasks. |
TaskStatusCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3TaskStatus table. |
SignificantDtm |
|
datetime |
YES |
Visit TimeZone - Either the scheduled date and time or the performed date and time, whichever is most recent. |
SignificantTime |
|
varchar(30) |
YES |
Either the scheduled time or the performed time, whichever is most recent. |
UpdateTaskWhenPerformed |
|
tinyint |
YES |
Indicates whether the task needs to be updated when this occurrence is performed. |
IsSuspended |
|
tinyint |
YES |
Indicates whether this task occurrence is suspended. |
RequireReschedule |
|
tinyint |
YES |
Indicates whether this task occurrence needs rescheduling. |
OverdueMinute |
|
int |
NO |
The number of minutes after the scheduled date and time that will flag this occurrence as overdue. |
OverdueMustReschedMinute |
|
int |
NO |
The number of minutes after the scheduled date and time that will flag the rest of the occurrences to be rescheduled. |
IsTrackVariance |
|
tinyint |
YES |
Indicates whether variance tracking is required if this task is marked as not done. |
AdminID |
|
int |
NO |
The administration ID. It starts with 1 the first time that medication is administered, and increments by one with each additional administration of medication. |
TaskDocType |
|
int |
NO |
The type of documents to be used to mark the task as done. |
TaskFormGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3OrderEntryForm table. |
PatientCareDocumentGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3PatientCareDocument table. |
TaskFormVersionGUID |
|
HVCIDdt |
YES |
The link to the form version used to document this task. Join to GUID; form must be of type Task. |
ClientDocumentGUID |
|
HVCIDdt |
YES |
Link to document - CV3ClientDocument |
SummaryLine |
|
varchar(2000) |
YES |
The summary line for the task. This is based on the task entry form. |
ShowDose |
|
tinyint |
YES |
Indicates whether to display the dose in the worklist. |
ToBeSigned |
|
tinyint |
YES |
Indicates whether or not the task occurrence needs to be signed. |
TaskReason |
|
varchar(255) |
YES |
The reason for the task. |
TaskComment |
|
varchar(255) |
YES |
A comment about the task. |
TaskDose |
|
varchar(10) |
YES |
The dosage. |
TaskUom |
|
varchar(30) |
YES |
The unit of measure associated with the dosage. |
TaskRouteCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3OrderRoute table. |
TaskRouteModifierCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3OrderRouteModifier table. |
TaskFormCode |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3MedicationForm table. |
BodySite |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3BodySite table. |
AmountWasted |
|
varchar(50) |
YES |
The amount of drug wasted, if any. |
Diluent |
|
varchar(30) |
YES |
A foreign key to the Code column in the CV3Diluent table. |
TaskDuration |
|
int |
NO |
The duration of the task. |
CoSignProviderGUID |
|
HVCIDdt |
YES |
The link to the Care Provider who co-signed this task in minutes. |
CDSOccurrenceType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [No value set],10 = [Task 1 Set 1 First Occur],11 = [Task 1 Set 1 Subsequent Occur],12 = [Task 1 Subsequent Set First Occur],13 = [Task 1 Subsequent Set Subsequent Occur],20 = [Task 1 for Based On Perform Date],30 = [Task 1 for First Given First Occur],31 = [Task 1 for First Given Subseq Occur],40 = [Task 1 for Manual First Occur],110 = [Task 2 Set 1 First Occur],111 = [Task 2 Set 1 Subsequent Occur],112 = [Task 2 Subsequent Set First Occur],113 = [Task 2 Subsequent Set Subsequent Occur],120 = [Task 2 for Based On Perform Date],130 = [Task 2 for First Given First Occur],131 = [Task 2 for First Given Subseq Occur],140 = [Task 2 for Manual First Occur],141 = [Task 2 for Manul Subseq Occur], |
IsAutoCompleted |
|
tinyint |
YES |
Indicates if this task was auto-completed as a result of the order completing. |
IncludedForStopDateCalc |
|
tinyint |
YES |
1 - this occurrence will be included in stop date calculation.0 - this occurrence will not be included in stop date calculation. |
MSrepl_tran_version |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
TaskOrderSummaryLine |
|
varchar(2000) |
YES |
The Task name + summary line concatenated together up to 2000 chars |
OrderedDoseOverride |
|
tinyint |
YES |
indicate if a partial or overdose was given for this task. NULL or 0 indicates that the dose was not overridden, 1 represents a partial dose was given and 2 represents a higher dose was given. |
GenerateGroupID |
|
int |
YES |
New occurrences will store a GenerateGroupID in this column to track which occurrences were generated together. |
HasGeneratedFollowupTask |
|
bit |
YES |
A boolean set to true the first time we generate a follow-up task on the primary occurrence. Only internal primary tasks should ever have this set to true. At the occurrence level, this is set true the first time THIS occurrence generates a follow-up task. Reset to False if the primary is reset to pending/Not done and the follow-up task is deleted. |
TaskPumpVolume |
|
varchar(10) |
YES |
Volume to be infused |
TaskPumpVolumeUOM |
|
varchar(30) |
YES |
Volume to be infused UOM |
TaskPumpDoseRate |
|
varchar(10) |
YES |
Infusion rate / dose |
TaskPumpDoseRateUOM |
|
varchar(30) |
YES |
Infusion rate / dose UOM |
TaskPumpDurationMinutes |
|
smallint |
YES |
Infusion duration,in minutes |
TaskPumpDrugID |
|
varchar(30) |
YES |
Drug ID for pump drug library match |
TaskPumpChannelID |
|
varchar(50) |
YES |
Scanned pump channel ID |
IsPumpProgrammingSkipped |
|
bit |
YES |
Pump is programmed or not |
SkipPumpProgrammingReason |
|
varchar(2000) |
YES |
Reason to skip pump programming |
TaskPumpDrugAmount |
|
varchar(10) |
YES |
Drug amount (strength) |
TaskPumpDrugAmountUOM |
|
varchar(30) |
YES |
Drug amount (strength) UOM |
PatientItemScanStatusType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [None],1 = [Matched],2 = [Skipped], |
PatientItemScanSkippedReason |
|
varchar(255) |
YES |
The reason that the scan was skipped. This is only applicable if Scan Status Type = 3 |
PatientIDBarcode |
|
varchar(40) |
YES |
The barcode that identifies the patient. This may have been scanned or entered manually. It may or may not include a prefix and/or suffix |
TaskItemBarcode |
|
varchar(40) |
YES |
The barcode that identifies the item being administered. This may have been scanned or entered manually. It may or may not include a prefix and/or suffix. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
TaskPumpVolumeToBeInfused |
|
varchar(10) |
YES |
Pump Volume to be infused |
TaskPumpDuration |
|
varchar(30) |
YES |
Pump duration |
TaskPumpDurationUOM |
|
varchar(30) |
YES |
Pump duration units |
TaskPumpFlowRate |
|
varchar(10) |
YES |
Pump flow rate |
TaskPumpFlowRateUOM |
|
varchar(30) |
YES |
Pump flow rate UOM |
TaskPumpVolumeToBeInfusedUOM |
|
varchar(30) |
YES |
Pump Volume to be infused UOM |
IsTaskPumpBagChange |
|
bit |
NO |
Indicates if bag changed on the infusion pump |
IsTaskPumpRateChange |
|
bit |
NO |
Indicates if rate change is sent to the infusion pump |