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 |
|
bigint |
NO |
Auto generated unique primary key value. |
EventID |
|
int |
NO |
A foreign key to the EventID column in the SXAHMEvent table. |
ClientGUID |
|
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 |
|
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 |
|
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 |
|
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. |