dbo.SXAHMScheduledEventOccurrence 
Default Table Name  SXAHMScheduledEventOccurrence 
Definition  This Health Management patient data table stores the completed and scheduled occurrences of immunization and wellness events that are listed on a patient's health Management schedule. 

dbo.SXAHMScheduledEventOccurrence Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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. 
TouchedWhenUTC    datetimeoffset(3)  NO  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    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. 
CreatedWhenUTC    datetimeoffset(3)  NO  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    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ScheduledEventOccurrenceID(PK)    bigint  NO  Auto generated unique primary key value. 
EventID(FK)    int  NO  A foreign key to the EventID column in the SXAHMEvent table. 
ClientGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Client table. 
EventType    int  NO  Specifies the event type of the parent event. We store it here so that we can quickly decide which icons need to display. 
CDSUniqueGUID    HVCIDdt  NO  A GUID used exclusively by the CDS system to uniquely identify occurrences. 
EventDefinitionID    bigint  YES  A foreign key to the EventDefinitionID column in the SXAHMEventDefinition table. 
IsRescheduled    bit  NO  This flags tracks whether or not this occurrence was ever rescheduled by the user. 
VaccineAdminDataID    bigint  YES  A foreign key to the VaccineAdminDataID column in the SXAHMVaccineAdminData table. 
OccurrenceStatusType    int  NO  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    int  YES  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 
ActionMonth    int  YES  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 
ActionDay    int  YES  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 
ActionTime    time(7)  YES  Works with the other action date/time columns to specify when the last action was taken on this occurrence. 
SiteGivenCode    varchar(30)  YES  Stores the location on the body where the administration was performed. Stores the code from the site dictionary. 
RouteCode    varchar(30)  YES  Specifies the route that the medication or immunization was given. Stores the code from the route dictionary. 
ActionProviderName    varchar(100)  YES  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(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
ScheduledDateStart    date  YES  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    date  YES  Specifies the latest date of a date range, during which this occurrence is scheduled to be due for completion. 
DoseAmount    numeric(14, 4)  YES  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    varchar(2000)  YES  Stores any additional comments that the care provider wishes to enter for this occurrence. 
DoseUOM    varchar(30)  YES  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(FK)    varchar(100)  YES  A foreign key to the Code column in the SXAHMHistoricalInformationSource table. 
IsPartialDose    bit  NO  This flag tracks that the dosage given was not the entire recommended dosage. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
ClientEventDefinitionID(FK)    bigint  YES  A foreign key to the ClientEventDefinitionID column in the SXAHMClientEventDefinition table. 
ParentOccurrenceID    bigint  YES  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    varchar(5)  YES  The application source for the occurrence status. Only valued through HL7. 
CommunityRecordID    varchar(255)  YES  Uniquely identify immunization record in community data provider(dbMotion) 
CommunityDataProvider    varchar(50)  YES  Community data provider Name like dbMotion, DocX, etc… 
CommunityRecordLastModifiedUTC    datetimeoffset(3)  YES  Enterprise TimeZone - Date and time the community record was last updated 
CommunityRecordLastModifiedBy    varchar(80)  YES  Name of the person who last modified the community record 
CommunitySource    varchar(100)  YES  The name of the facility/unit in the institute (commonly hospital) to which the immunization was reported. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
CommunitySourceDocumentGUID    HVCIDdt  YES  GUID of linked source document. New column added for MU3 document generation support. 

dbo.SXAHMScheduledEventOccurrence Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAHMScheduledEventOccurrencePK  PrimaryKey  ScheduledEventOccurrenceID