Created by Miki Yanagi, last modified on May 24, 2023

New logic has been applied to CSRPT on 5/24/2023.

Reason for the change: IPEDS Fall Enrollment Survey and NC-SARA require institutions to report students' location as of census day. A new address_type of LOCL (local) has been implemented in MaineStreet to capture more accurate data, however, the current logic in UM_STUD_EXTRACT does not include the address type.  IPEDS keyholder group has reviewed the logic and is proposing the change.

The definition for each address type is on the Student Addresses page.

Current logic:

Currently, the address data in UM_STUD_EXTRACT is based on PS_ADDRESSES table and PS_PERSONAL_DATA table. If the PS_ADDRESSES table has an active address, the address is used. Otherwise data from PS_PERSONAL_DATA is used. When there are multiple active addresses in the PS_ADDRESSES, the following hierarchy of the address type is used.

  1. HOME
  2. BILL
  3. MAIL 
  4. CHK
  5. BUSN
  6. CAMP

Proposed logic:

Local and residence hall address type are added to the top of current hierarchy.

  1. LOCL 
  2. RESH
  3. HOME
  4. BILL
  5. MAIL 
  6. CHK
  7. BUSN
  8. CAMP


List of fields:

The following fields in UM_STUD_EXTRACT, UM_STUD_CENSUS, and UM_STUD_EXT_ARC may be affected by this change.

  • ADDRESS1
  • ADDRESS2
  • ADDRESS3
  • ADDRESS4
  • CITY
  • COUNTRY
  • COUNTRY_DESCR1
  • COUNTY
  • POSTAL
  • STATE
  • STATE_DESCR1

In addition to the fields above, the following fields may be affected by the change in UM_STUD_EXT_VW and UM_STUD_CENS_VW.

  • UM_ANY_COUNTRY
  • UM_CALC_COUNTRY
  • UM_CALC_COUNTY
  • UM_CALC_STATE
  • UM_CANADA