ESP_DEMOGRAPHIC Table

Owned by Melanie Davies (Unlicensed)
Last updated: Jun 16, 2021 by Adam Paczuski (Unlicensed)
1 min read

This table contains the most recent patient demographic information.

Column

Data Type

Description

centerid

character
varying(128)

Center identifier.

patid

character
varying(128)

Arbitrary person-level identifier. Used to link across tables.

birth_date

integer

Date of birth, formatted as a SAS Date (number of days since Jan 1, 1960).

sex

character(1)

Values returned:

M=Male F=Female U=Unknown.

hispanic

character(1)

A person of Hispanic race.
Values returned:

Y=Yes, N=No, U=Unknown.

race

integer

Values returned:
0=Unknown
1=American Indian or Alaska Native
2=Asian
3=Black or African American
4=Native Hawaiian or Other Pacific Islander
5=White

race_ethnicityintegerValues returned:
0=Unknown
1=Native American
2=Asian
3=Black
5=White
6=Hispanic

zip5

character
varying(5)

5 character zip code for patient’s primary address.

smokingcharacter varying(20)

Values returned: Current, Former, Never, Not Available, Passive

  • PATID is used as a primary key constraint
  • There are nine B-tree indexes on the table, one for each field.
  • CENTERID, RACE, RACE_ETHNICITY and SEX are constrained by foreign key constraints against their respective UVT tables described below.