Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Bound Default | Description |
---|
 (5) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | | Key to the dbo.Immunization table. |
(2)![Foreign Keys FK_Immunization_ItemID_Item_Immunization_ID: [dbo].[Item_Immunization].ItemID Foreign Keys FK_Immunization_ItemID_Item_Immunization_ID: [dbo].[Item_Immunization].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | | Item. Link to Item_Immunization.ID. |
 | NoteActivityID | numeric(16,0) | 9 | NOT NULL | | | Audit Note. Link to Act_Hdr_Note.ID. |
| MedispanDE | [dbo].[dict_id] | 5 | NOT NULL | | DictDefault | This is no longer used. It once referenced dbo.medispan_de.id. It just defaults to 0 now. |
| Unused_Med_Pointer | numeric(8,0) | 5 | NOT NULL | (0) | | This is no longer used. It just defaults to 0 now. |
 ![Foreign Keys FK_Immunization_BodySiteDE_Body_Site_DE_ID: [dbo].[Body_Site_DE].BodySiteDE Foreign Keys FK_Immunization_BodySiteDE_Body_Site_DE_ID: [dbo].[Body_Site_DE].BodySiteDE](../../../../Images/fk.png) | BodySiteDE | [dbo].[dict_id] | 5 | NOT NULL | | | Body Site. Link to Body_Site_DE.ID. |
 | Lot_ID | varchar(20) | 20 | NOT NULL | | | The lot # for the vaccine |
| BodySiteDET | varchar(255) | 255 | NOT NULL | (' ') | | Body Site. Link to dbo.Body_Site_de.Entryname |
 | RouteOfAdminDE | [dbo].[dict_id] | 5 | NOT NULL | | | Route of administration. Link to dbo.Route_of_Admin_de.id |
 | AgeIntervalDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | | Age Interval. Link to db.Age_Interval_de.id |
(3)![Check Constraints CK_Immunization_Disposition_Disposition : ([Disposition]='Rpt' OR [Disposition]='Rx' OR [Disposition]='None' OR [Disposition]='DocA' OR [Disposition]='ReqA') Check Constraints CK_Immunization_Disposition_Disposition : ([Disposition]='Rpt' OR [Disposition]='Rx' OR [Disposition]='None' OR [Disposition]='DocA' OR [Disposition]='ReqA')](../../../../Images/c-constraint.png) | Disposition | char(4) | 4 | NOT NULL | | | None/DocA/ReqA (none, documented administration, requested administration) |
(3) | AdministeredFuzzySortAs | datetime | 8 | NULL allowed | | | Date immunization was administered |
 | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | | Provider the immunization is for. Link to Idx_user.id |
| AdministeredFuzzyWhen | varchar(50) | 50 | NOT NULL | (' ') | | Administered date. Fuzzy date |
| AdministeredFuzzySpecificity | char(1) | 1 | NOT NULL | | | Administered date specificity (F - Fuzzy, D - Day, M - Month, Y - Year) |
 ![Check Constraints CK_Immunization_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E') Check Constraints CK_Immunization_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | | Create type. This will be A for Administration |
(2) | WhoAdministeredID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who administered the Immunization. Link to idx_user.id |
 | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | | User who recorded the Immunization being administered. Link to idx_user.id |
(5) | RecordedDTTM | datetime | 8 | NOT NULL | | | date immunization was added to the system. We do a getdate() call. |
(4)![Foreign Keys FK_Immunization_Order_Status_DE: [dbo].[Order_Status_DE].ImmunizationStatusDE Foreign Keys FK_Immunization_Order_Status_DE: [dbo].[Order_Status_DE].ImmunizationStatusDE](../../../../Images/fk.png) | ImmunizationStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Status. Link to Order_Status_DE.ID. |
(3) | Series | varchar(20) | 20 | NOT NULL | | | The series of the vaccine |
(2) | RequestedByID | [dbo].[uniqueid] | 9 | NOT NULL | | | Who requested the administration. Link to Idx_user.id |
| DateToAdminister | datetime | 8 | NULL allowed | | | Date Administration is to be done. |
(3) | NDC | char(12) | 12 | NOT NULL | (' ') | | 10 digit national drug code |
 | Dose | varchar(10) | 10 | NOT NULL | (' ') | | The dose given, IE 2ML |
 ![Foreign Keys FK_Immunization_VaccineManufacturerDE_Vaccine_Manufacturer_DE_ID: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDE Foreign Keys FK_Immunization_VaccineManufacturerDE_Vaccine_Manufacturer_DE_ID: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDE](../../../../Images/fk.png) | VaccineManufacturerDE | numeric(8,0) | 5 | NOT NULL | (0) | | Manufacturer. Link to Vaccine_Manufacturer_DE.ID |
(4)![Foreign Keys FK_Immunization_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDE Foreign Keys FK_Immunization_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDE](../../../../Images/fk.png) | MedDictDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | | Vaccine. Link to Medication_DE.ID |
 | LastVISGiven | [dbo].[BOOL] | 1 | NULL allowed | ('N') | | VIS is Vaccine Information Sheet. It displays info about the immunization and warnings for the patient. Has the user received a VIS for this immunization before? |
 | LastGivenDate | datetime | 8 | NOT NULL | ('1900-01-01') | | If they did receive a VIS before what was the date. |
 ![Check Constraints CK_Immunization_ConstentObtained_Yes_Or_No : ([ConstentObtained]='N' OR [ConstentObtained]='Y') Check Constraints CK_Immunization_ConstentObtained_Yes_Or_No : ([ConstentObtained]='N' OR [ConstentObtained]='Y')](../../../../Images/c-constraint.png) | ConstentObtained | [dbo].[BOOL] | 1 | NOT NULL | ('N') | | Did the user give Consent for this administration. This is a checkbox on the Record Administration tab in touchWorks. |
 | LastObtained | datetime | 8 | NOT NULL | ('1900-01-01') | | Last time Consent was obtained. So if you check the box in the application it would be the current date. |
(4) | VisDTTM | datetime | 8 | NULL allowed | ('1900-01-01') | | Date on the VIS handed out |
(2) | ToBeDoneDTTM | datetime | 8 | NULL allowed | | | The date the administration should be done. |
 | VIS1Name | varchar(255) | 255 | NULL allowed | | | Vaccine Informatuion Sheet 1 Name. Unused. |
(2) | VIS1PublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 1 Publication Date. Unused. |
 | VIS1LastPublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 1 Last Publication Date. Unused. |
 | VIS2Name | varchar(255) | 255 | NULL allowed | | | Vaccine Informatuion Sheet 2 Name. Unused. |
 ![Check Constraints CK_Immunization_VIS2Provided_Yes_Or_No : ([VIS2Provided]='N' OR [VIS2Provided]='Y') Check Constraints CK_Immunization_VIS2Provided_Yes_Or_No : ([VIS2Provided]='N' OR [VIS2Provided]='Y')](../../../../Images/c-constraint.png) | VIS2Provided | [dbo].[BOOL] | 1 | NULL allowed | | | Vaccine Informatuion Sheet 2 Provided (Y/N). Unused. |
(2) | VIS2PublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 2 Publication Date. Unused. |
 | VIS2LastGivenDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 3 Last Provided Date. Unused. |
 | VIS2LastPublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 2 Last Publication Date. Unused. |
 | VIS3Name | varchar(255) | 255 | NULL allowed | | | Vaccine Informatuion Sheet 2 Name. Unused. |
 ![Check Constraints CK_Immunization_VIS3Provided_Yes_Or_No : ([VIS3Provided]='N' OR [VIS3Provided]='Y') Check Constraints CK_Immunization_VIS3Provided_Yes_Or_No : ([VIS3Provided]='N' OR [VIS3Provided]='Y')](../../../../Images/c-constraint.png) | VIS3Provided | [dbo].[BOOL] | 1 | NULL allowed | | | Vaccine Informatuion Sheet 3 Provided (Y/N). Unused. |
(2) | VIS3PublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 3 Publication Date. Unused. |
 | VIS3LastGivenDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 3 Last Provided Date. Unused. |
 | VIS3LastPublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 3 Last Publication Date. Unused. |
 | VIS4Name | varchar(255) | 255 | NULL allowed | | | Vaccine Informatuion Sheet 4 Name. Unused. |
 ![Check Constraints CK_Immunization_VIS4Provided_Yes_Or_No : ([VIS4Provided]='N' OR [VIS4Provided]='Y') Check Constraints CK_Immunization_VIS4Provided_Yes_Or_No : ([VIS4Provided]='N' OR [VIS4Provided]='Y')](../../../../Images/c-constraint.png) | VIS4Provided | [dbo].[BOOL] | 1 | NULL allowed | | | Vaccine Informatuion Sheet 4 Provided (Y/N). Unused. |
(2) | VIS4PublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 3 Publication Date. Unused. |
 | VIS4LastGivenDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 4 Last Provided Date. Unused. |
 | VIS4LastPublicationDate | datetime | 8 | NULL allowed | | | Vaccine Informatuion Sheet 4 Last Publication Date. Unused. |
 | ProblemLinkList | varchar(500) | 500 | NOT NULL | ('') | | A piped list of problem ids that relate to the patient. They will link to dbo.Problem_header.id |
 | ALLSCRIP_SIG_CD | char(15) | 15 | NOT NULL | ('') | | If using one of our delivered sigs this will link to dbo.Allscrip_SIG.allscript_sig_cd |
 ![Check Constraints CK_Immunization_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Immunization_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | | Unverified? Y/N |
 | VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | | ID of user/team who owns a task. Link to idx_user.id |
 | VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | | Type of owner. Would be U/T for user or team |
 | PerformingComments | varchar(255) | 255 | NOT NULL | ('') | | A free text field for the provider to add a comment for the person performing the administration. |
| AuthorizingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | | Provider that authorized the immunization. Link to dbo.Provider.ID |
 | ExpirationDT | datetime | 8 | NULL allowed | | | Date the immunization expires |
![Check Constraints CK_Immunization_PARChecked_Yes_Or_No : ([PARChecked]='N' OR [PARChecked]='Y') Check Constraints CK_Immunization_PARChecked_Yes_Or_No : ([PARChecked]='N' OR [PARChecked]='Y')](../../../../Images/c-constraint.png) | PARChecked | [dbo].[BOOL] | 1 | NOT NULL | ('N') | | Y/N Were prior adverse reactions checked when this was given? This just means did a DUR check happen. |
| FreeTextPrescriber | varchar(150) | 150 | NOT NULL | ('') | | text field to add prescriber name |
| VisuallyVerifiedByID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | | provider who verified admin. Link to Provider.ID |
| InventoryID | varchar(64) | 64 | NULL allowed | | | Inventory ID for Flexscan interface |
| Barcode | varchar(64) | 64 | NULL allowed | | | Barcode of inventory item for Flexscan interface |