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. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. 

CreatedWhenUTC 
Definition  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. 

ScheduledEventOccurrenceID 
Definition  Auto generated unique primary key value. 

EventID 
Definition  A foreign key to the EventID column in the SXAHMEvent table. 

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

EventType 
Definition  Specifies the event type of the parent event. We store it here so that we can quickly decide which icons need to display. 

CDSUniqueGUID 
Definition  A GUID used exclusively by the CDS system to uniquely identify occurrences. 

EventDefinitionID 
Definition  A foreign key to the EventDefinitionID column in the SXAHMEventDefinition table. 

IsRescheduled 
Definition  This flags tracks whether or not this occurrence was ever rescheduled by the user. 

VaccineAdminDataID 
Definition  A foreign key to the VaccineAdminDataID column in the SXAHMVaccineAdminData table. 

OccurrenceStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [Pending],1 = [Completed],2 = [Not Completed],3 = [Deleted],4 = [Invalid],5 = [Unreconciled Completed],6 = [Unreconciled Not Completed],7 = [Rejected Completed],8 = [Rejected Not Completed],9 = [Cancel Pending],10 = [Cancel Processed], 

ActionYear 
Definition  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 

ActionMonth 
Definition  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 

ActionDay 
Definition  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 

ActionTime 
Definition  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 

SiteGivenCode 
Definition  Stores the location on the body where the administration was performed. Stores the code from the site dictionary. 

RouteCode 
Definition  Specifies the route that the medication or immunization was given. Stores the code from the route dictionary. 

ActionProviderName 
Definition  PHI: If the provider that performed the action is not in the system, then a free text provider name will be entered, since we still need to track this information. This is mostly for historical entries. 

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

ScheduledDateStart 
Definition  Specifies the date that this occurrence is scheduled to be due for completion. If the scheduled date is a range, then this value will specify the earliest date at which this occurrence is due. 

ScheduledDateEnd 
Definition  Specifies the latest date of a date range, during which this occurrence is scheduled to be due for completion. 

DoseAmount 
Definition  If a dosage of a medication is associated with this event's scheduled occurrences, this field tracks the dosage of the administered drug or vaccine. It is important to note that for vaccines, the dosage is related to the linked VaccineAdminData, which could be a combo vaccine; in which case the dose is not a dose of this antigen, but of the parent combo vaccine. Stored as a varchar since decimals can be entered, and decimal types do not handle blank values well. 

Comment 
Definition  Stores any additional comments that the care provider wishes to enter for this occurrence. 

DoseUOM 
Definition  If a dosage of a medication is associated with this event's scheduled occurrences, this field tracks the dosage of the administered drug or vaccine. This field stores 

HistoricalInformationSourceCode 
Definition  A foreign key to the Code column in the SXAHMHistoricalInformationSource table. 

IsPartialDose 
Definition  This flag tracks that the dosage given was not the entire recommended dosage. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

ClientEventDefinitionID 
Definition  A foreign key to the ClientEventDefinitionID column in the SXAHMClientEventDefinition table. 

ParentOccurrenceID 
Definition  Specifies the scheduling priority of the event definitions linked to this schedule, relative to event definitions for the same events, linked to other schedules. Links to the Code of the SXAHMSchedulingPriority dictionary. 

ApplicationSource 
Definition  The application source for the occurrence status. Only valued through HL7. 

CommunityRecordID 
Definition  Uniquely identify immunization record in community data provider(dbMotion) 

CommunityDataProvider 
Definition  Community data provider Name like dbMotion, DocX, etc… 

CommunityRecordLastModifiedUTC 
Definition  Enterprise TimeZone - Date and time the community record was last updated 

CommunityRecordLastModifiedBy 
Definition  Name of the person who last modified the community record 

CommunitySource 
Definition  The name of the facility/unit in the institute (commonly hospital) to which the immunization was reported. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

CommunitySourceDocumentGUID 
Definition  GUID of linked source document. New column added for MU3 document generation support.