S_WI_STU_IMM_X (ver 16.10.1)
This table is an extension of the [Students] table. This table provides Immunization-specific fields for Wisconsin.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 16.10.1 | Number(10,0) | Primary Key. |
Imm_exclude | 16.10.1 | Number(1,0) | Exclude Student from Immunization Reporting. |
Imm_2dose_hepb | 16.10.1 | Number(1,0) | Student is receiving the 2 dose series for Hepatitis B. |
Imm_Waiver | 16.10.1 | Varchar2(18) | Waiver for all immunizations. |
Imm_dtp_waiver | 16.10.1 | Varchar2(18) | Waiver type for Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_hepb_waiver | 16.10.1 | Varchar2(18) | Waiver type for Hepatitis B. |
Imm_mmr_waiver | 16.10.1 | Varchar2(18) | Waiver type for Measles, Mumps Rubella (MMR). |
Imm_polio_waiver | 16.10.1 | Varchar2(18) | Waiver type for Polio (IPV, OPV). |
Imm_TdapTd_waiver | 16.10.1 | Varchar2(18) | Waiver type for Tdap/Td Adolescent Booster.. |
Imm_var_waiver | 16.10.1 | Varchar2(18) | Waiver type for Varicella (Chicken Pox) Vaccine |
Imm_Notes | 16.10.1 | Varchar2(600) | Notes. |
Imm_Status | 16.10.1 | Varchar2(200) | Compliance Status. |
Imm_dtp1 | 16.10.1 | Date | Date of first Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp2 | 16.10.1 | Date | Date of second Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp3 | 16.10.1 | Date | Date of third Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp4 | 16.10.1 | Date | Date of fourth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp5 | 16.10.1 | Date | Date of fifth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp6 | 16.10.1 | Date | Date of sixth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_dtp7 | 16.10.1 | Date | Date of seventh Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td). |
Imm_hepb1 | 16.10.1 | Date | Date of first Hepatitis B. |
Imm_hepb2 | 16.10.1 | Date | Date of second Hepatitis B. |
Imm_hepb3 | 16.10.1 | Date | Date of third Hepatitis B. |
Imm_mmr1 | 16.10.1 | Date | Date of first Measles, Mumps Rubella (MMR). |
Imm_mmr2 | 16.10.1 | Date | Date of second Measles, Mumps Rubella (MMR). |
Imm_mmr3 | 16.10.1 | Date | Date of third Measles, Mumps Rubella (MMR). |
Imm_polio1 | 16.10.1 | Date | Date of first Polio (IPV, OPV). |
Imm_polio2 | 16.10.1 | Date | Date of second Polio (IPV, OPV). |
Imm_polio3 | 16.10.1 | Date | Date of third Polio (IPV, OPV). |
Imm_polio4 | 16.10.1 | Date | Date of fourth Polio (IPV, OPV). |
Imm_polio5 | 16.10.1 | Date | Date of fifth Polio (IPV, OPV). |
Imm_polio6 | 16.10.1 | Date | Date of sixth Polio (IPV, OPV). |
Imm_td | 16.10.1 | Date | Date of Adolescent Booster - Td. |
Imm_tdap | 16.10.1 | Date | Date of Adolescent Booster - Tdap. |
Imm_var1 | 16.10.1 | Date | Date of first Varicella (Chicken Pox) Vaccine. |
Imm_var2 | 16.10.1 | Date | Date of second Varicella (Chicken Pox) Vaccine. |
Imm_VarDisease | 16.10.1 | Date | Date of Chicken Pox Disease. |
Imm_LastDateModified | 17.6.1 | Date | Date Immunization was last modified. |
COVID_Vaccine_1_CVX_Code | 21.11.1.0 | Varchar2(4) | Type of first COVID Immunization. |
COVID_Vaccine_1_Date | 21.11.1.0 | Date | Date of first COVID. |
COVID_Vaccine_2_CVX_Code | 21.11.1.0 | Varchar2(4) | Type of second COVID Immunization. |
COVID_Vaccine_2_Date | 21.11.1.0 | Date | Date of second COVID. |
COVID_Vaccine_3_CVX_Code | 21.11.1.0 | Varchar2(4) | Type of third COVID Immunization. |
COVID_Vaccine_3_Date | 21.11.1.0 | Date | Date of third COVID. |
COVID_Vaccine_4_CVX_Code | 21.11.1.0 | Varchar2(4) | Type of fourth COVID Immunization. |
COVID_Vaccine_4_Date | 21.11.1.0 | Date | Date of fourth COVID. |
MenACWY_Vaccine_1_Date | 24.7.2.0 | Date | MenACWY vaccine seventh grad |
MenACWY_Vaccine_2_Date | 24.7.2.0 | Date | MenACWY booster (2nd dose in series) |
MenACWY_Waiver | 24.7.2.0 | Varchar2(18) | MenACWY Waiver Type |
Approved_Sharing_Records | 17.8.0 | Varchar2(1) | Parent/Guardian Approves Sharing of Student's Records. |
Signature_On_File | 17.8.0 | Number(1,0) | Parent/Guardian Signature On File. |
Date_ParentGuard_Response | 17.8.0 | Date | Date of Parent/Guardian Response. |