dbo.CV3OrderTaskOccurrence 
Default Table Name  CV3OrderTaskOccurrence 
Definition  The performance details of a task. Contains details of who performed the task and when. 

dbo.CV3OrderTaskOccurrence Columns 
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(PK)    HVCIDdt  NO  Unique primary key value. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
OrderGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Order table. 
OrderTaskGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderTask table. 
CatalogItemTaskGUID(FK)    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(FK)    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(FK)    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(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderEntryForm table. 
PatientCareDocumentGUID(FK)    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(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderRoute table. 
TaskRouteModifierCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3OrderRouteModifier table. 
TaskFormCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3MedicationForm table. 
BodySite(FK)    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(FK)    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 

dbo.CV3OrderTaskOccurrence Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3OrderTaskOccurrencePK  PrimaryKey  GUID