dbo.SXAHMVaccineMedicationPackaging 
Default Table Name  SXAHMVaccineMedicationPackaging 
Definition  This Health Management configuration table defines the various ways a Vaccine of a specific Brand is packaged. Each row has a unique product or drug code, such as an NDC, which uniquely identifies a specific packaging that was licensed by a vaccine manufacturer. Each Brand of a vaccine product may have many different packagings. 

dbo.SXAHMVaccineMedicationPackaging 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. 
VaccineMedicationPackagingID(PK)    int  NO  Auto generated unique primary key value. 
VaccineMedicationItemID(FK)    int  NO  A foreign key to the VaccineMedicationItemID column in the SXAHMVaccineMedicationItem table. 
Name    varchar(100)  NO  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(FK)    varchar(100)  YES  A foreign key to the Code column in the SXAHMPackagingType table. 
ProductCode    varchar(30)  NO  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    varchar(30)  YES  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    numeric(14, 4)  YES  Specifies the size of a single dose, as the vaccine is packaged. This value is associated the the DosageUOM. 
RouteCode    varchar(30)  YES  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    varchar(30)  YES  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    int  YES  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    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXAHMVaccineMedicationPackaging Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAHMVaccineMedicationPackagingPK  PrimaryKey  VaccineMedicationPackagingID