ESP_DISEASE Table

This table contains one record per combination of patient and detected disease along with the detection criteria, review workflow status, reviewer notes and derived variables for 5 year, 10 year and Mini-Sentinel age groups. This table is generated via execution of the various ESP disease detection algorithms.

Column	Data Type	Description
centerid	character varying(128)	Center identifier.
patid	character varying(128)	Arbitrary person-level identifier. Used to link across tables.
condition	character varying(100)	Condition that triggered the disease detection.
date	integer	Date on which the disease was detectable, formatted as a SAS Date (number of days since Jan 1, 1960).
age_at_detected_year	integer	Patient age as of January 1 of the year of the disease was detected.
age_group_5yr	character varying(5)	Patient age group (specified in 5 year intervals) as of Jan 1 of the year of the encounter.
age_group_10yr	character varying(5)	Patient age group (specified in 10 year intervals) as of Jan 1 of the year of the encounter.
age_group_ms	character varying(5)	Patient age group (using Mini-Sentinel age groups) as of Jan 1 of the year of the encounter.
criteria	character varying(255)	Detection criteria.
status	character varying(32)	Review workflow status. One of: AR – Awaiting review UR – Under review RM – Reviewed by MD FP – False positive Q – Confirmed case S – Transmitted to health department
notes	text	Review notes.

PATID, CONDITION, DATE comprise the primary key constraint
There are ten B-tree indexes on the table, one for each field except NOTES.
CONDITION, CRITERIA and STATUS are constrained by foreign key constraints against their respective UVT tables described below.
PATID is constrained by foreign key constraint against ESP_DEMOGRAPHIC.PATID.