IMM_DUE

Description:

The IMM_DUE table contains information about when an immunization is due. The rows included in this table are items from DXR (Document) masterfile which include information on type of immunization, due date, earliest date and next dose number for the due immunization.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	The unique identifier for the document record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	IMM_DUE_TYPE_ID	NUMERIC	No
	The type ID of immunization that is due. This column is frequently used to link to the table CLARITY_IMMUNZATN.
6	IMM_DUE_TYPE_ID_NAME	VARCHAR	No
	The name of the immunization.
7	IMM_DUE_TYPE_FT	VARCHAR	No
	The free text description of the type of immunization that is due.
8	IMM_DUE_DUE_DATE	DATETIME	No
	The due date for immunization that is due.
9	IMM_DUE_EARLIEST_DT	DATETIME	No
	The earliest date of immunization that is due.
10	IMM_DUE_NEXT_DOSE	VARCHAR	No
	The next dose number of immunization that is due.
11	IMM_DUE_SCHED_ID_FT	VARCHAR	No
	Immunization schedule ID used for the recommended vaccination.
12	IMM_DUE_SCHED_NM_FT	VARCHAR	No
	Immunization schedule name used for the recommended vaccination.
13	IMM_DUE_SCHED_CD_FT	VARCHAR	No
	Immunization schedule coding system used for the recommended vaccination.