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. 

ImmunizationReconciliationID 
Definition  Auto generated unique primary key value. 

ImmunizationQueryID 
Definition  A foreign key to the ImmunizationQueryID column in the SXAIMMImmunizationQuery table. 

ApplicSource 
Definition  Link to SXAIMMImmunizationQuery table 

ActionCode 
Definition  Soure application for row data. Action code: Add (A), Update (U) or Delete (D). 

ProductCVXCode 
Definition  Vaccine CVX Code 

ProductName 
Definition  Vaccine name 

ManufacturerMVXCode 
Definition  Manufacturer MVX code 

ManufacturerName 
Definition  Manufacturer Name 

RouteID 
Definition  Link to SXAIMMVaccineRoute table 

RouteName 
Definition  Route id+text if not found in SXAIMMVaccineRoute table 

SiteGivenID 
Definition  Link to SXAIMMVaccineSiteGiven table 

SiteGivenName 
Definition  Site Id + text if not found in SXAIMMVaccineSiteGiven table 

DoseUnitID 
Definition  Link to SXAIMMVaccineDoseUnit table 

DoseUnit 
Definition  Dose + unit if not found in SXAIMMVaccineDoseUnit table 

DoseNumber 
Definition  Dose number 

LotNumber 
Definition  Lot numbers of the vaccine administered 

VaccineLotExpirationDtm 
Definition  Vaccine lot expiration date 

VISDate 
Definition  Vaccine Information Statement published date 

VISSignedDate 
Definition  Vaccine Information Statement presented date 

Comment 
Definition  Vaccine administration notes 

GivenDate 
Definition  Administered date 

GivenTime 
Definition  Administered time 

AdministeredByGUID 
Definition  Link to CV3CareProvider table 

AdministeredBy 
Definition  Care provider name if not found in CV3CareProvider table 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

StatusType 
Definition  An enumerated type with the following list of possible values: 0 = [Administered],1 = [Not administered],2 = [Refused], 

DoseAmount 
Definition  Immunization dose amount 

DoseUOM 
Definition  Immunization dose unit of measure 

VaccineLotExpirationDates 
Definition  Lot expiration date/times of the vaccine administered 

ActionYear 
Definition  The year that the immunization was given. Required to support partial dates. 

ActionMonth 
Definition  The month that the immunization was given. Required to support partial dates. 

ActionDay 
Definition  The day that the immunization was given. Required to support partial dates. 

HistoricalInformationSourceCode 
Definition  Historical Information Source (eg: Parent Recall, Written record, etc.) 

RefusalReasonCode 
Definition  Immunization refusal reason code 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.