Ethnicity_Lookup table

Owned by Jordan Lamb
Last updated: Mar 01, 2022
1 min read

key summary type created updated due assignee reporter priority status resolution
Refresh

Possible Ethnicity values and their descriptions. Currently only used in StudentPuente Data Warehouse tale. Records hand-copied from Oracle. Does not need to be updated unless the Oracle STVETCT table is updated.

Updated: no

Oracle Field/Calc

DW Field

Description or Sample

STVETCT.STVETCT_Code

Ethnicity_Code

  1. Black Non-Hispanic

  1. Am. Indian or Alaskan Native

  1. Asian or Pacific Islander

  1. Hispanic

  1. White Non-Hispanic

  1. Other

STVETCT.STVETCT_Desc

Ethnicity

(see Ethnicity_Code)

Â