You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
Table |
cm_demographics |
Description |
Demographics for statistics |
Column |
Format |
Description |
Definition |
Comments |
id |
integer, primary key |
Row identifier |
autoincrement |
|
co_person_id |
integer, foreign key |
CO Person ID |
cm_co_people:id |
|
gender |
varchar(2) |
self-asserted gender |
|
|
citizenship |
varchar(2) |
self-asserted citizenship |
|
|
ethnicity |
varchar(2) |
self-asserted ethnicity, may have multiple values selected |
- 1: Hispanic or Latino - a person of Mexican, Puerto Rican, Cuban, South or Central American, or other Spanish culture or origin, regardless of race.
- 2: Not Hispanic or Latino
|
|
race |
varchar(5) |
self-asserted race, may have multiple values selected |
- 1: Asian - a person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.
- 2: American Indian or Alaskan Native - a person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment.
- 4: Black or African American - a person having origins in any of the black racial groups of Africa.
- 8: Native Hawaiian or Pacific Islander - a person having origins in any of the original peoples of Hawaii, Guan, Samoa, or other Pacific Islands
- 16: White - a person having origins in any of the original peoples of Europe, the Middle East, or North Africa.
|
|
disability |
varchar(4) |
self-asserted disability, may have multiple values selected |
- 1: Hearing Impaired
- 2: Visual Impaired
- 4: Mobility/Orthopedic Impairment
- 8: Other Impairment
|
|