Friday, February 4, 2011

2/3/2011 ASU EPM 9.0.79 Release Notes

New or Changed Tables and Views

Operational Warehouse Staging (OWS) Tables/Views
  • Campus Solutions
MDW Warehouse Tables/Views
  • Campus Solutions
    • Changed minority status logic in PS_ASU_D_PERSON_VW

      The minority status calculation for an indivudial is now changed based on the following federal guideline changes:

      1. Identify Nonresident Alien (X) students using the logic currently in place.
      2. Additionally, now people with visa_code='AR1' will be considered as citizens and given the minority code of 'X'
      3. Students who identify as Hispanic, even if they also select additional ethnic codes, should be coded as Hispanic/Latino (H).
      4. Non-Hispanic students who have more than one first character ethnic code, not including Unspecified (U), should be coded as Two or More Races (T). This is a new code.
      5. All other students should be assigned to the single ethnic code they selected
      6. Else to Unspecified (U) if they selected none.