S_TX_STU_IMM_X (ver 16.12.1)
This table is an extension of the Students table, and is used to hold Immunization records for Texas students for the purposes of TREx.
Column Name | Version | Data Type | Description |
---|---|---|---|
DTAP_EXEMPT | 17.9.0 | VARCHAR2(1) | The exemption code for DTaP. |
DTAP_EXPIRATION | 17.9.0 | DATE | The date the exemption expires for DTaP. |
DTP_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for DTP. |
DTP_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for DTP. |
HEP_A_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Hepatitis A. |
HEP_A_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Hepatitis A. |
HEP_B_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Hepatitis B. |
HEP_B_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Hepatitis B. |
HIB_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for HIB. |
HIB_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for HIB. |
HPV_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for HPV. |
HPV_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for HPV. |
IMM_COMPLETE_712 | 16.12.1 | NUMBER(1,0) | Indicates the student is compliant for grades 7 -12. |
IMM_COMPLETE_712_DATE | 16.12.1 | DATE | Indicates the date the student achieved compliance for grades 7-12. |
IMM_COMPLETE_K6 | 16.12.1 | NUMBER(1,0) | Indicates the student is compliant for grades KG to 6. |
IMM_COMPLETE_K6_DATE | 16.12.1 | DATE | Indicates the date the student achieved compliance for grades KG to 6. |
IMM_DTAP_1_DATE | 17.9.0 | DATE | Date of the first immunization for DTaP. |
IMM_DTAP_2_DATE | 17.9.0 | DATE | Date of the second immunization for DTaP. |
IMM_DTAP_3_DATE | 17.9.0 | DATE | Date of the third immunization for DTaP. |
IMM_DTAP_4_DATE | 17.9.0 | DATE | Date of the fourth immunization for DTaP. |
IMM_DTAP_5_DATE | 17.9.0 | DATE | Date of the fifth immunization for DTaP. |
IMM_DTAP_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for DTaP. |
IMM_DTAP_7_DATE | 18.5.0 | DATE | Date of the seventh immunization for DTaP. |
IMM_DTAP_8_DATE | 18.5.0 | DATE | Date of the eighth immunization for DTaP. |
IMM_DTP_1_DATE | 16.12.1 | DATE | Date of the first immunization for DTP. |
IMM_DTP_2_DATE | 16.12.1 | DATE | Date of the second immunization for DTP. |
IMM_DTP_3_DATE | 16.12.1 | DATE | Date of the third immunization for DTP. |
IMM_DTP_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for DTP. |
IMM_DTP_5_DATE | 16.12.1 | DATE | Date of the fifth immunization for DTP. |
IMM_DTP_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for DTP. |
IMM_DTP_7_DATE | 18.5.0 | DATE | Date of the seventh immunization for DTP. |
IMM_DTP_8_DATE | 18.5.0 | DATE | Date of the eighth immunization for DTP. |
IMM_FLU_1_DATE | 17.9.0 | DATE | Date of the first immunization for Influenza. |
IMM_FLU_2_DATE | 17.9.0 | DATE | Date of the second immunization for Influenza. |
IMM_HEP_A_1_DATE | 16.12.1 | DATE | Date of the first immunization for Hepatitis A. |
IMM_HEP_A_2_DATE | 16.12.1 | DATE | Date of the second immunization for Hepatitis A. |
IMM_HEP_A_3_DATE | 18.5.0 | DATE | Date of the third immunization for Hepatitis A. |
IMM_HEP_A_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Hepatitis A. |
IMM_HEP_A_5_DATE | 18.5.0 | DATE | Date of the fifth immunization for Hepatitis A. |
IMM_HEP_B_1_DATE | 16.12.1 | DATE | Date of the first immunization for Hepatitis B |
IMM_HEP_B_2_DATE | 16.12.1 | DATE | Date of the second immunization for Hepatitis B. |
IMM_HEP_B_3_DATE | 16.12.1 | DATE | Date of the third immunization for Hepatitis B. |
IMM_HEP_B_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for Hepatitis B. |
IMM_HEP_B_5_DATE | 18.5.0 | DATE | Date of the fifth immunization for Hepatitis B. |
IMM_HEP_B_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for Hepatitis B. |
IMM_HIB_1_DATE | 16.12.1 | DATE | Date of the first immunization for HIB. |
IMM_HIB_2_DATE | 16.12.1 | DATE | Date of the second immunization for HIB. |
IMM_HIB_3_DATE | 16.12.1 | DATE | Date of the third immunization for HIB. |
IMM_HIB_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for HIB. |
IMM_HIB_5_DATE | 18.5.0 | DATE | Date of the fifth immunization for HIB. |
IMM_HIB_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for HIB. |
IMM_HPV_1_DATE | 16.12.1 | DATE | Date of the first immunization for HPV. |
IMM_HPV_2_DATE | 16.12.1 | DATE | Date of the second immunization for HPV. |
IMM_HPV_3_DATE | 16.12.1 | DATE | Date of the third immunization for HPV. |
IMM_HPV_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for HPV. |
IMM_MEASELS_1_DATE | 16.12.1 | DATE | Date of the first immunization for Measles. |
IMM_MEASELS_2_DATE | 16.12.1 | DATE | Date of the second immunization for Measles. |
IMM_MEASELS_3_DATE | 18.5.0 | DATE | Date of the third immunization for Measles. |
IMM_MEASELS_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Measles. |
IMM_MENINGOCOCCAL_1_DATE | 16.12.1 | DATE | Date of the first immunization for Meningococcal. |
IMM_MENINGOCOCCAL_2_DATE | 16.12.1 | DATE | Date of the second immunization for Meningococcal. |
IMM_MENINGOCOCCAL_3_DATE | 18.5.0 | DATE | Date of the third immunization for Meningococcal. |
IMM_MMR_1_DATE | 16.12.1 | DATE | Date of the first immunization for MMR. |
IMM_MMR_2_DATE | 16.12.1 | DATE | Date of the second immunization for MMR. |
IMM_MMR_3_DATE | 16.12.1 | DATE | Date of the third immunization for MMR. |
IMM_MMR_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for MMR. |
IMM_MUMPS_1_DATE | 18.3.0 | DATE | Date of the first immunization for Mumps. |
IMM_MUMPS_2_DATE | 18.3.0 | DATE | Date of the second immunization for Mumps. |
IMM_MUMPS_3_DATE | 18.5.0 | DATE | Date of the third immunization for Mumps. |
IMM_MUMPS_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Mumps. |
IMM_OTHER_1 | 16.12.1 | VARCHAR2(4000) | Type and Date of any other immunization to be tracked. |
IMM_OTHER_2 | 16.12.1 | VARCHAR2(4000) | Type and Date of any other immunization to be tracked. |
IMM_OTHER_3 | 16.12.1 | VARCHAR2(4000) | Type and Date of any other immunization to be tracked. |
IMM_OTHER_4 | 16.12.1 | VARCHAR2(4000) | Type and Date of any other immunization to be tracked. |
IMM_OTHER_5 | 16.12.1 | VARCHAR2(4000) | Type and Date of any other immunization to be tracked. |
IMM_PCV_1_DATE | 16.12.1 | DATE | Date of the first immunization for PCV. |
IMM_PCV_2_DATE | 16.12.1 | DATE | Date of the second immunization for PCV. |
IMM_PCV_3_DATE | 16.12.1 | DATE | Date of the third immunization for PCV. |
IMM_PCV_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for PCV. |
IMM_PCV_5_DATE | 18.5.0 | DATE | Date of the fifth immunization for PCV. |
IMM_PCV_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for PCV. |
IMM_PERTUSSIS_1_DATE | 18.3.0 | DATE | Date of the first immunization for Pertussis. |
IMM_PERTUSSIS_2_DATE | 18.3.0 | DATE | Date of the second immunization for Pertussis. |
IMM_POLIO_1_DATE | 16.12.1 | DATE | Date of the first immunization for Polio. |
IMM_POLIO_2_DATE | 16.12.1 | DATE | Date of the second immunization for Polio. |
IMM_POLIO_3_DATE | 16.12.1 | DATE | Date of the third immunization for Polio. |
IMM_POLIO_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for Polio. |
IMM_POLIO_5_DATE | 16.12.1 | DATE | Date of the fifth immunization for Polio. |
IMM_POLIO_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for Polio. |
IMM_POLIO_7_DATE | 18.5.0 | DATE | Date of the seventh immunization for Polio. |
IMM_POLIO_8_DATE | 18.5.0 | DATE | Date of the eighth immunization for Polio. |
IMM_POLIO_9_DATE | 18.5.0 | DATE | Date of the ninth immunization for Polio. |
IMM_POLIO_10_DATE | 18.5.0 | DATE | Date of the tenth immunization for Polio. |
IMM_PPV_1_DATE | 16.12.1 | DATE | Date of the first immunization for PPV. |
IMM_PPV_2_DATE | 16.12.1 | DATE | Date of the second immunization for PPV. |
IMM_PPV_3_DATE | 16.12.1 | DATE | Date of the third immunization for PPV. |
IMM_PPV_4_DATE | 16.12.1 | DATE | Date of the fourth immunization for PPV. |
IMM_RUBELLA_1_DATE | 18.3.0 | DATE | Date of the first immunization for Rubella. |
IMM_RUBELLA_2_DATE | 18.3.0 | DATE | Date of the second immunization for Rubella. |
IMM_RUBELLA_3_DATE | 18.5.0 | DATE | Date of the third immunization for Rubella. |
IMM_RUBELLA_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Rubella. |
IMM_RV_1_DATE | 17.9.0 | DATE | Date of the first immunization for Rotavirus. |
IMM_RV_2_DATE | 17.9.0 | DATE | Date of the second immunization for Rotavirus. |
IMM_RV_3_DATE | 17.9.0 | DATE | Date of the third immunization for Rotavirus. |
IMM_RV_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Rotavirus. |
IMM_TDAP_1_DATE | 16.12.1 | DATE | Date of the first immunization for Tdap. |
IMM_TDAP_2_DATE | 16.12.1 | DATE | Date of the second immunization for Tdap. |
IMM_TDAP_3_DATE | 16.12.1 | DATE | Date of the third immunization for Tdap. |
IMM_TDAP_4_DATE | 16.12.1 | TDAP. | Date of the fourth immunization for Tdap. |
IMM_TDAP_5_DATE | 16.12.1 | DATE | Date of the fifth immunization for Tdap. |
IMM_TDAP_6_DATE | 18.5.0 | DATE | Date of the sixth immunization for Tdap. |
IMM_TDAP_7_DATE | 18.5.0 | DATE | Date of the seventh immunization for Tdap. |
IMM_TDAP_8_DATE | 18.5.0 | DATE | Date of the eighth immunization for Tdap. |
IMM_TDDT_1_DATE | 18.3.0 | DATE | Date of the first immunization for Td/dt. |
IMM_TDDT_2_DATE | 18.3.0 | DATE | Date of the second immunization for Td/dt. |
IMM_TDDT_3_DATE | 18.3.0 | DATE | Date of the third immunization for Td/dt. |
IMM_TDDT_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Td/dt. |
IMM_TDDT_5_DATE | 18.5.0 | DATE | Date of the fifth immunization for Td/dt. |
IMM_VARICELLA_1_DATE | 16.12.1 | DATE | Date of the first immunization for Varicella. |
IMM_VARICELLA_2_DATE | 16.12.1 | DATE | Date of the second immunization for Varicella. |
IMM_VARICELLA_3_DATE | 18.5.0 | DATE | Date of the third immunization for Varicella. |
IMM_VARICELLA_4_DATE | 18.5.0 | DATE | Date of the fourth immunization for Varicella. |
MEASELS_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Measles. |
MEASELS_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Measles. |
MENINGOCOCCAL_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Meningococcal. |
MENINGOCOCCAL_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Meningococcal. |
MMR_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for MMR. |
MMR_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for MMR. |
MUMPS_EXEMPT | 18.3.0 | VARCHAR2(1) | The exemption code for Mumps. |
MUMPS_EXPIRATION | 18.3.0 | DATE | The date the exemption expires for Mumps. |
PCV_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for PCV. |
PCV_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for PCV. |
PERTUSSIS_EXEMPT | 18.3.0 | VARCHAR2(1) | The exemption code for Pertussis. |
PERTUSSIS_EXPIRATION | 18.3.0 | DATE | The date the exemption expires for Pertussis. |
POLIO_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Polio. |
POLIO_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Polio. |
PPV_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for PPV. |
PPV_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for PPV. |
RUBELLA_EXEMPT | 18.3.0 | VARCHAR2(1) | The exemption code for Rubella. |
RUBELLA_EXPIRATION | 18.3.0 | DATE | The date the exemption expires for Rubella. |
RV_EXEMPT | 17.9.0 | DATE | The date the exemption expires for Rotavirus. |
RV_EXPIRATION | 17.8.9 | VARCHAR2(1) | The exemption code for Rotavirus. |
STUDENTSDCID | 16.12.1 | NUMBER(10,0) | Foreign key. |
TB_1_DATE | 16.12.1 | DATE | The date of the first TB test. |
TB_1_RESULT | 16.12.1 | VARCHAR2(10) | The result of the first TB test. |
TB_2_DATE | 16.12.1 | DATE | The date of the second TB test. |
TB_2_RESULT | 16.12.1 | VARCHAR2(10) | The result of the second TB test. |
TDAP_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Tdap. |
TDAP_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Tdap. |
TDDT_EXEMPT | 18.3.0 | VARCHAR2(1) | The exemption code for Td/dt. |
TDDT_EXPIRATION | 18.3.0 | DATE | The date the exemption expires for Td/dt. |
VARICELLA_DATE_OF_DISEASE | 18.5.0 | DATE | The date the student had Varicella; used to document the reason why the student is exempt from the Varicella immunizations. As of May 2015, this field replaces the former text-based field, VARICELLA_HISTORY. Existing data is automatically migrated to the new field. |
VARICELLA_EXEMPT | 16.12.1 | VARCHAR2(1) | The exemption code for Varicella. |
VARICELLA_EXPIRATION | 16.12.1 | DATE | The date the exemption expires for Varicella. |
VARICELLA_HISTORY | 16.12.1 | VARCHAR2(10) | No longer used as of May 2018. Existing data is automatically migrated into a new date-based field, VARICELLA_DATE_OF_DISEASE. |