S_SC_STU_MED_IMM_X (ver 17.3.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| DPT | 17.3.0 | Varchar2(13) | Status of DPT. |
| DTP1 | 17.3.0 | Date | Date for DPT dose 1. |
| DTP2 | 17.3.0 | Date | Date for DPT dose 2. |
| DTP3 | 17.3.0 | Date | Date for DPT dose 3. |
| DTP4 | 17.3.0 | Date | Date for DPT dose 4. |
| DTP5 | 17.3.0 | Date | Date for DPT dose 5. |
| DTTD1 | 17.3.0 | Date | Date for Td Tetanus Diphtheria dose 1. |
| DTTD2 | 17.3.0 | Date | Date for Td Tetanus Diphtheria dose 2. |
| DTTD3 | 17.3.0 | Date | Date for Td Tetanus Diphtheria dose 3. |
| DTTD4 | 17.3.0 | Date | Date for Td Tetanus Diphtheria dose 4. |
| DTTD5 | 17.3.0 | Date | Date for Td Tetanus Diphtheria dose 5. |
| EYE_DATA | 17.3.0 | Varchar2(72) | Information about the student's eye exam. |
| HEARING_DATA | 17.3.0 | Varchar2(72) | Information about the student's hearing exam. |
| HEIGHT_DATA | 17.3.0 | Varchar2(72) | The student's height. |
| HEPATITIS_A | 17.3.0 | Varchar2(8) | Status of Hepatitis A. |
| HEPATITIS_P | 17.3.0 | Varchar2(8) | Hepatitis B PED Status. |
| HEPBADULT1 | 17.3.0 | Date | Hepatitis B Adult dose 1. |
| HEPBADULT2 | 17.3.0 | Date | Hepatitis B Adult dose 2. |
| HEPBPED1 | 17.3.0 | Date | Hepatitis B PED dose 1. |
| HEPBPED2 | 17.3.0 | Date | Hepatitis B PED dose 2. |
| HEPBPED3 | 17.3.0 | Date | Hepatitis B PED dose 3. |
| HEPBPED4 | 17.3.0 | Date | Hepatitis B PED dose 4. |
| HEPBPED5 | 17.3.0 | Date | Hepatitis B PED dose 5. |
| HIB | 17.3.0 | Varchar2(13) | Status of HIB. |
| HIB1 | 17.3.0 | Date | HIB dose 1. |
| HIB2 | 17.3.0 | Date | HIB dose 2. |
| HIB3 | 17.3.0 | Date | HIB dose 3. |
| HIB4 | 17.3.0 | Date | HIB dose 4. |
| HXVAR1 | 17.3.0 | Date | Varicella dose 1. |
| HXVAR2 | 17.3.0 | Date | Varicella dose 2. |
| IMMUNE_STATUS | 17.3.0 | Varchar2(13) | Student's overall I'mmunization status. |
| IPV | 17.3.0 | Varchar2(13) | Status of IPV. |
| IPV1 | 17.3.0 | Date | IPV dose 1. |
| IPV2 | 17.3.0 | Date | IPV dose 2. |
| IPV3 | 17.3.0 | Date | IPV dose 3. |
| IPV4 | 17.3.0 | Date | IPV dose 4. |
| IPV5 | 17.3.0 | Date | IPV dose 5. |
| MEASLES1 | 17.3.0 | Date | Measles only dose 1. |
| MEASLES2 | 17.3.0 | Date | Measles only dose 2. |
| MED_OTHER1 | 17.3.0 | Varchar2(10) | Medical Date for other dose 1.. |
| MED_OTHER2 | 17.3.0 | Varchar2(10) | Medical Date for other dose 2 |
| MED_OTHER3 | 17.3.0 | Varchar2(10) | Medical Date for other dose 3. |
| MED_OTHER4 | 17.3.0 | Varchar2(10) | Medical Date for other dose 4. |
| MED_OTHER5 | 17.3.0 | Varchar2(10) | Medical Date for other dose 5. |
| MMR | 17.3.0 | Varchar2(13) | Status of MMR. |
| MMR1 | 17.3.0 | Date | MMR dose 1. |
| MMR2 | 17.3.0 | Date | MMR dose 2. |
| MMR3 | 17.3.0 | Date | MMR dose 3. |
| MUMPS1 | 17.3.0 | Date | Mumps only dose 1. |
| MUMPS2 | 17.3.0 | Date | Mumps only dose 2. |
| MUMPS_STATUS | 17.3.0 | Varchar2(13) | Status of mumps. |
| OPV | 17.3.0 | Varchar2(13) | Status of OPV. |
| OPV1 | 17.3.0 | Date | OPV dose 1. |
| OPV2 | 17.3.0 | Date | OPV dose 2. |
| OPV3 | 17.3.0 | Date | OPV dose 3. |
| OPV4 | 17.3.0 | Date | OPV dose 4. |
| OPV5 | 17.3.0 | Date | OPV dose 5. |
| PNEUMO1 | 17.3.0 | Date | Pneumococcal dose 1. |
| PNEUMO2 | 17.3.0 | Date | Pneumococcal dose 2. |
| PNEUMO3 | 17.3.0 | Date | Pneumococcal dose 3.. |
| PNEUMO4 | 17.3.0 | Date | Pneumococcal dose 4. |
| PNEUMO5 | 17.3.0 | Date | Pneumococcal dose 5 |
| PNEUMO6 | 17.3.0 | Date | Pneumococcal dose 6. |
| RV | 17.3.0 | Varchar2(13) | Measles only status. |
| STUDENTSDCID | 17.3.0 | Number(10,0) | Primary key. |
| TD | 17.3.0 | Varchar2(13) | Status of Td Tetanus Diphtheria. |
| VAR1 | 17.3.0 | Date | Date of first varicella dose. |
| VAR2 | 17.3.0 | Date | Date of second varicella dose. |
| VARICELLA | 17.3.0 | Varchar2(8) | Status of varicella disease. |
| VARICELLA_HX | 17.3.0 | Varchar2(8) | Status of varicella doses. |
| WEIGHT_DATA | 17.3.0 | Varchar2(72) | The student's weight. |