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. 

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

OrderGUID 
Definition  A foreign key to the GUID column in the CV3Order table. 

OrderTaskGUID 
Definition  A foreign key to the GUID column in the CV3OrderTask table. 

CatalogItemTaskGUID 
Definition  A foreign key to the GUID column in the CV3CatalogItemTask table. 

TaskName 
Definition  The name of the task. This is copied from the catalog. 

ScheduledDtm 
Definition  Visit TimeZone - The scheduled date and time of this occurrence. 

EarliestScheduledDtm 
Definition  Visit TimeZone - The earliest scheduled date and time for this occurrence. 

LatestScheduledDtm 
Definition  Visit TimeZone - The latest scheduled date and time for this occurrence. 

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

PerformedProviderGUID 
Definition  The link to the Care Provider who performs this task. 

EnteredDtm 
Definition  Visit TimeZone - The date and time of the last performance information. 

PerformedFromDtm 
Definition  Visit TimeZone - The performed date and time. 

PerformedToDtm 
Definition  Visit TimeZone - The date and time the task was performed up until. This is used by continuous tasks. 

TaskStatusCode 
Definition  A foreign key to the Code column in the CV3TaskStatus table. 

SignificantDtm 
Definition  Visit TimeZone - Either the scheduled date and time or the performed date and time, whichever is most recent. 

SignificantTime 
Definition  Either the scheduled time or the performed time, whichever is most recent. 

UpdateTaskWhenPerformed 
Definition  Indicates whether the task needs to be updated when this occurrence is performed. 

IsSuspended 
Definition  Indicates whether this task occurrence is suspended. 

RequireReschedule 
Definition  Indicates whether this task occurrence needs rescheduling. 

OverdueMinute 
Definition  The number of minutes after the scheduled date and time that will flag this occurrence as overdue. 

OverdueMustReschedMinute 
Definition  The number of minutes after the scheduled date and time that will flag the rest of the occurrences to be rescheduled. 

IsTrackVariance 
Definition  Indicates whether variance tracking is required if this task is marked as not done. 

AdminID 
Definition  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 
Definition  The type of documents to be used to mark the task as done. 

TaskFormGUID 
Definition  A foreign key to the GUID column in the CV3OrderEntryForm table. 

PatientCareDocumentGUID 
Definition  A foreign key to the GUID column in the CV3PatientCareDocument table. 

TaskFormVersionGUID 
Definition  The link to the form version used to document this task. Join to GUID; form must be of type Task. 

ClientDocumentGUID 
Definition  Link to document - CV3ClientDocument 

SummaryLine 
Definition  The summary line for the task. This is based on the task entry form. 

ShowDose 
Definition  Indicates whether to display the dose in the worklist. 

ToBeSigned 
Definition  Indicates whether or not the task occurrence needs to be signed. 

TaskReason 
Definition  The reason for the task. 

TaskComment 
Definition  A comment about the task. 

TaskDose 
Definition  The dosage. 

TaskUom 
Definition  The unit of measure associated with the dosage. 

TaskRouteCode 
Definition  A foreign key to the Code column in the CV3OrderRoute table. 

TaskRouteModifierCode 
Definition  A foreign key to the Code column in the CV3OrderRouteModifier table. 

TaskFormCode 
Definition  A foreign key to the Code column in the CV3MedicationForm table. 

BodySite 
Definition  A foreign key to the Code column in the CV3BodySite table. 

AmountWasted 
Definition  The amount of drug wasted, if any. 

Diluent 
Definition  A foreign key to the Code column in the CV3Diluent table. 

TaskDuration 
Definition  The duration of the task. 

CoSignProviderGUID 
Definition  The link to the Care Provider who co-signed this task in minutes. 

CDSOccurrenceType 
Definition  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 
Definition  Indicates if this task was auto-completed as a result of the order completing. 

IncludedForStopDateCalc 
Definition  1 - this occurrence will be included in stop date calculation.0 - this occurrence will not be included in stop date calculation. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

TaskOrderSummaryLine 
Definition  The Task name + summary line concatenated together up to 2000 chars 

OrderedDoseOverride 
Definition  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 
Definition  New occurrences will store a GenerateGroupID in this column to track which occurrences were generated together. 

HasGeneratedFollowupTask 
Definition  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 
Definition  Volume to be infused 

TaskPumpVolumeUOM 
Definition  Volume to be infused UOM 

TaskPumpDoseRate 
Definition  Infusion rate / dose 

TaskPumpDoseRateUOM 
Definition  Infusion rate / dose UOM 

TaskPumpDurationMinutes 
Definition  Infusion duration,in minutes 

TaskPumpDrugID 
Definition  Drug ID for pump drug library match 

TaskPumpChannelID 
Definition  Scanned pump channel ID 

IsPumpProgrammingSkipped 
Definition  Pump is programmed or not 

SkipPumpProgrammingReason 
Definition  Reason to skip pump programming 

TaskPumpDrugAmount 
Definition  Drug amount (strength) 

TaskPumpDrugAmountUOM 
Definition  Drug amount (strength) UOM 

PatientItemScanStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Matched],2 = [Skipped], 

PatientItemScanSkippedReason 
Definition  The reason that the scan was skipped. This is only applicable if Scan Status Type = 3 

PatientIDBarcode 
Definition  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 
Definition  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 
Definition  Unique GUID used to support merge replication. 

TaskPumpVolumeToBeInfused 
Definition  Pump Volume to be infused 

TaskPumpDuration 
Definition  Pump duration 

TaskPumpDurationUOM 
Definition  Pump duration units 

TaskPumpFlowRate 
Definition  Pump flow rate 

TaskPumpFlowRateUOM 
Definition  Pump flow rate UOM 

TaskPumpVolumeToBeInfusedUOM 
Definition  Pump Volume to be infused UOM 

IsTaskPumpBagChange 
Definition  Indicates if bag changed on the infusion pump 

IsTaskPumpRateChange 
Definition  Indicates if rate change is sent to the infusion pump