DOCS_RCVD_PAT_ETHNICITY
Description:
This table holds information about patient ethnicity for received documents.

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 (.1 item) 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 PAT_ETHNICITY_C_NAME VARCHAR No
Holds discrete patient ethnicity information included in the received document. Uses CDC ethnicity codes. NOTE: Not all DXR use cases discretely parse this item.
May contain organization-specific values: Yes
Category Entries:
Not a valid ethnicity
Andalusian
Argentinean
Asturian
Belearic Islander
Bolivian
Canal Zone
Canarian
Castillian
Catalonian
Central American
Central American Indian
Chicano
Chilean
Colombian
Costa Rican
Criollo
Cuban
Dominican
Ecuadorian
Gallego
Guatemalan
Hispanic or Latino
Honduran
La Raza
Latin American
Mexican
Mexican American
Mexican American Indian
Mexicano
Nicaraguan
Not Hispanic or Latino
Panamanian
Paraguayan
Peruvian
Puerto Rican
Salvadoran
South American
South American Indian
Spaniard
Spanish Basque
Uruguayan
Valencian
Venezuelan