Skip to main content
Skip table of contents

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_exclude16.10.1Number(1,0)Exclude Student from Immunization Reporting.
Imm_2dose_hepb16.10.1Number(1,0)Student is receiving the 2 dose series for Hepatitis B.
Imm_Waiver16.10.1Varchar2(18)Waiver for all immunizations.
Imm_dtp_waiver16.10.1Varchar2(18)Waiver type for Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_hepb_waiver16.10.1Varchar2(18)Waiver type for Hepatitis B.
Imm_mmr_waiver16.10.1Varchar2(18)Waiver type for Measles, Mumps Rubella (MMR).
Imm_polio_waiver16.10.1Varchar2(18)Waiver type for Polio (IPV, OPV).
Imm_TdapTd_waiver16.10.1Varchar2(18)Waiver type for Tdap/Td Adolescent Booster..
Imm_var_waiver16.10.1Varchar2(18)Waiver type for Varicella (Chicken Pox) Vaccine
Imm_Notes16.10.1Varchar2(600)Notes.
Imm_Status16.10.1Varchar2(200)Compliance Status.
Imm_dtp116.10.1DateDate of first Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp216.10.1DateDate of second Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp316.10.1DateDate of third Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp416.10.1DateDate of fourth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp516.10.1DateDate of fifth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp616.10.1DateDate of sixth Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_dtp716.10.1DateDate of seventh Diptheria, Tetanus, Pertussis (DTaP, DTP, DT, Td).
Imm_hepb116.10.1DateDate of first Hepatitis B.
Imm_hepb216.10.1DateDate of second Hepatitis B.
Imm_hepb316.10.1DateDate of third Hepatitis B.
Imm_mmr116.10.1DateDate of first Measles, Mumps Rubella (MMR).
Imm_mmr216.10.1DateDate of second Measles, Mumps Rubella (MMR).
Imm_mmr316.10.1DateDate of third Measles, Mumps Rubella (MMR).
Imm_polio116.10.1DateDate of first Polio (IPV, OPV).
Imm_polio216.10.1DateDate of second Polio (IPV, OPV).
Imm_polio316.10.1DateDate of third Polio (IPV, OPV).
Imm_polio416.10.1DateDate of fourth Polio (IPV, OPV).
Imm_polio516.10.1DateDate of fifth Polio (IPV, OPV).
Imm_polio616.10.1DateDate of sixth Polio (IPV, OPV).
Imm_td16.10.1DateDate of Adolescent Booster - Td.
Imm_tdap16.10.1DateDate of Adolescent Booster - Tdap.
Imm_var116.10.1DateDate of first Varicella (Chicken Pox) Vaccine.
Imm_var216.10.1DateDate of second Varicella (Chicken Pox) Vaccine.
Imm_VarDisease16.10.1DateDate of Chicken Pox Disease.
Imm_LastDateModified17.6.1DateDate Immunization was last modified.
COVID_Vaccine_1_CVX_Code21.11.1.0Varchar2(4)Type of first COVID Immunization.
COVID_Vaccine_1_Date21.11.1.0DateDate of first COVID.
COVID_Vaccine_2_CVX_Code21.11.1.0Varchar2(4)Type of second COVID Immunization.
COVID_Vaccine_2_Date21.11.1.0DateDate of second COVID.
COVID_Vaccine_3_CVX_Code21.11.1.0Varchar2(4)Type of third COVID Immunization.
COVID_Vaccine_3_Date21.11.1.0DateDate of third COVID.
COVID_Vaccine_4_CVX_Code21.11.1.0Varchar2(4)Type of fourth COVID Immunization.
COVID_Vaccine_4_Date21.11.1.0DateDate of fourth COVID.
Approved_Sharing_Records17.8.0Varchar2(1)Parent/Guardian Approves Sharing of Student's Records.
Signature_On_File17.8.0Number(1,0)Parent/Guardian Signature On File.
Date_ParentGuard_Response17.8.0DateDate of Parent/Guardian Response.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.