Source of Government Ethnicity column

Overview

Various tables have a field title Government Ethnicity.  When analytics became more centralized and focused, there was a need to present data more in a consistent way which lead to definitions such as these.

This is the process that was adopted to calculate the government ethnicity field.  It is implemented by a Banner function called FZ_GOVT_ETHNICITY.

Conventions: 

  • Banner column names are in parentheses.
  • When the word "returned" is used, that means processing stops and the specified value will be put in the table.
  • Items in quotation marks are literal values and those word(s) will be returned.

Steps:

  1. From SPAPERS, read these fields:
    1. New Ethnicity code (Hispanic or Latino or Not Hispanic or Latino).  If it is empty, assume they are Not Hispanic or Latino.  (spbpers_ethn_cde)
    2. Citizenship code (spbpers_citz_code)
    3. Ethnicity and Race confirmed (spbpers_confirmed_re_cde)
    4. The rows in the Race Details area at the bottom of SPAPERS.
  2. Then there are a series of checks.
    1. If the citizenship code is 5 - Student Visa-Has or Needs Visa, exit and return "Foreign National" .
    2. If the New Ethnicity code is "Hispanic or Latino", exit and return "Hispanic" .
    3. If there is more than one row in the Race Details area, exit and return "2 or more Ethnicities".
    4. If there are no races listed and the Ethnicity and Race confirmed flag is Y, then exit and return "Unknown"
    5. Finally, exit and return the only race code for the person, either "Asian", "Black", "Am. Indian", "Pacific Islander", or "White" will be returned.