Information regarding the evaluation of a child's immunization status for a given series.
| Col # |
Column Name |
Data Type |
Not Null? |
Comments |
| 1 |
SERIES_EVAL_ID |
NUMBER |
Y |
|
| 2 |
CHILD_ID |
NUMBER |
Y |
The unique identifier representing a child in the MCIR system. |
| 3 |
SERIES_ID |
NUMBER |
Y |
|
| 4 |
SERIES_CD |
VARCHAR2(4 BYTE) |
Y |
The code representing the series of vaccines necessary for protection from a single disease. |
| 5 |
PROTOCOL_ID |
NUMBER(2) |
Y |
The unique identifier representing the protocol or optimal schedule for administering immunization services. |
| 6 |
EVAL_RESULT_ID |
NUMBER(2) |
|
|
| 7 |
SER_EVAL_DT |
CHAR(8 BYTE) |
|
The date representing the day in which a vaccination series assessment is performed for a child. |
| 8 |
SER_EREC_SHOT_DT |
CHAR(8 BYTE) |
|
The date representing the earliest day when a dose in a vaccine series sequence would be listed as required. |
| 9 |
SER_RREC_SHOT_DT |
CHAR(8 BYTE) |
|
The date representing the earliest date when a dose in a vaccine series sequence would be listed as routinely recommended. |
| 10 |
SER_OVER_SHOT_DT |
CHAR(8 BYTE) |
|
The date representing the earliest day when a dose in a vaccine series sequence would be listed as overdue. |
| 11 |
SER_NEXT_SHOT_ORD |
NUMBER |
|
The non-monetary numeric unit representing the next sequence number or order of a vaccination in the current vaccine series dose schedule. |
| 12 |
EVAL_NEXT_DT |
CHAR(8 BYTE) |
|
The date representing the day in which a series evaluation must be repeated. |
| 13 |
VACC_SCHED_ID |
NUMBER |
|
The unique identifier representing a vaccine schedule. |
| 14 |
SER_EVAL_RESULT_CD |
VARCHAR2(4 BYTE) |
|
|
| 15 |
RECALL_DATE |
DATE |
|
contains the date calculation of the greatest value of the overdue date and (routinely recommended date + 30 days). Records where this date is less than today's date qualitfy to be recalled. |