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. 

VaccineMedicationPackagingID 
Definition  Auto generated unique primary key value. 

VaccineMedicationItemID 
Definition  A foreign key to the VaccineMedicationItemID column in the SXAHMVaccineMedicationItem table. 

Name 
Definition  Uniquely identifies this medication packaging (for this vaccine). Contains a combination of medication, dose, and packaging information that summarizes the available information such that the care provider can select the row that corresponds to the actual stock that they are using for an immunization. 

PackagingTypeCode 
Definition  A foreign key to the Code column in the SXAHMPackagingType table. 

ProductCode 
Definition  An alphanumeric code that uniquely identifies this version of a product. This value is unique for each packaging of a product. There are several different codes that might be used in this field: NDC(US), DIN (Canada), etc... 

SingleDosageUOM 
Definition  The Unit of Measure code of the a single dose is stored as a code that will be looked up in the CV3UnitOfMeasure table. For example: MCG/mL 

SingleDosageValue 
Definition  Specifies the size of a single dose, as the vaccine is packaged. This value is associated the the DosageUOM. 

RouteCode 
Definition  The Route of a Vaccine is determined by the manufacturer when they package a product. For example, a vaccine in a needle is typically IM, and a nasal spray would be Intra-nasal. The nature of the packaging determines the route. 

FormCode 
Definition  The packaging of the Vaccine determines its Dosage Form, which refers to the form in which the medication comes. For example: Suspension. This column stores a Code CV3MedicationForm table. 

CPTCode 
Definition  The CPT code set accurately describes medical, surgical, and diagnostic services and is designed to communicate uniform information about medical services and procedures among physicians, coders, patients, accreditation organizations, and payers for administrative, financial, and analytical purposes. CPT stands for Current Procedural Terminology, and is from the American Medical Association. The code is number that is closely coupled with the drug code and packaging, since this affects the route and form, which in turn affect the procedure to administer the vaccine. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.