New fields added to Student data sets

10/21/2020

New fields were recently added to the Student Records, Recruiting and Admissions, and Third Week Count Student data sets in the U-M Data Warehouse to improve university reporting on student data. The new information includes military details, self-reported test sources, tuition details, and first generation undergraduate student indicator.

Additional detail on the new tables can be found in the data dictionary. The new Student data set fields include the following:

Recruiting and Admission Data Set and SA02 Business Object Universe

What Changed

Entity Name

Table Name

Attribute Name

Column Name

New Column

Person Address

PERSON_ADDRESS

Person Address Maximum Effective Date

PERSON_ADDRESS_MAX_EFFDT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Employee Identification Code

EMPLID

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Test Identification Code

TEST_ID

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Test Component Code

TEST_COMPONENT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Test Date

TEST_DT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Data Source Code

DATA_SOURCE

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Test Component Short Description

TEST_COMPONENT_DESCRSHORT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Data Source Short Description

DATA_SOURCE_DESCRSHORT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Score

SCORE

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Score Letter Code

SCORE_LETTER

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

External Academic Level Code

EXT_ACAD_LEVEL

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

External Academic Level Short Description

EXT_ACAD_LEVEL_DESCRSHORT

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Date Loaded

DATE_LOADED

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Student Test Comprehensive Percentile

STDNT_TEST_COMP_PERCENTILE

New Table

Student Test Components All

STDNT_TEST_COMP_ALL

Test Administration Code

TEST_ADMIN

Student Records Data Set and SA03 Business Object Universe

 

What Changed

Entity Name

Table Name

Attribute Name

Column Name

New Column

Person Addresses

PERSON_ADDRESSES

Person Address Maximum Effective Date

PERSON_ADDRESS_MAX_EFFDT

New Column

Personal Data

PERSONAL_DATA

First Generation Undergraduate Student Indicator

FIRST_GEN_UG_STDNT_IND

New Column

Personal Data

PERSONAL_DATA

Estimated Gross Family Income Description

EST_GROSS_FAM_INC_DES

New Column

Personal Data

PERSONAL_DATA

National Collegiate Athletic Association Any Institution First Full Time Enrolled Term Code

NCAA_ANY_INST_FRST_FT_TERM_CD

New Column

Personal Data

PERSONAL_DATA

National Collegiate Athletic Association Any Institution First Full Time Enrolled Term Description

NCAA_ANY_INST_FRST_FT_TERM_DES

New Column

Personal Data

PERSONAL_DATA

First Time Entry Type Code

FIRST_TIME_ENTRY_TYPE_CD

New Column

Personal Data

PERSONAL_DATA

Military Veteran Indicator

MLTRY_VTRN_IND

New Column

Personal Data

PERSONAL_DATA

Military Active Duty Indicator

MLTRY_ACTV_DUTY_IND

New Column

Personal Data

PERSONAL_DATA

National Guard Reserve Indicator

NATL_GUARD_RSRV_IND

New Column

Personal Data

PERSONAL_DATA

Military Service Indicator

MLTRY_SRVC_IND

New Column

Personal Data

PERSONAL_DATA

Military Dependent Indicator

MLTRY_DEP_IND

New Column

Personal Data

PERSONAL_DATA

Military Connected Indicator

MLTRY_CNNCTD_IND

New Column

Personal Data

PERSONAL_DATA

Air Force Indicator

AIR_FORCE_IND

New Column

Personal Data

PERSONAL_DATA

Army Indicator

ARMY_IND

New Column

Personal Data

PERSONAL_DATA

Coast Guard Indicator

CSTGRD_IND

New Column

Personal Data

PERSONAL_DATA

Marines Indicator

MARINES_IND

New Column

Personal Data

PERSONAL_DATA

Navy Indicator

NAVY_IND

New Column

Student Career Term

STDNT_CAR_TERM

Tuition Division Code

TUITION_DIV_CD

New Column

Student Career Term

STDNT_CAR_TERM

Tuition Division Description

TUITION_DIV_DESCR

New Column

Student Enrollment

STDNT_ENRL

Student Enrollment Add Date

STDNT_ENRL_ADD_DT

New Column

Student Enrollment

STDNT_ENRL

Student Enrollment Drop Date

STDNT_ENRL_DROP_DT

New Column

Student Enrollment

STDNT_ENRL

Grading Basis Status Date

GRADING_BASIS_STATUS_DT

New Column

Student Enrollment

STDNT_ENRL

Course Grade Input Date

CRSE_GRADE_INPUT_DT

New Table

United States Military Detail

US_MLTRY_DTL

Employee Identification Code

EMPLID

New Table

United States Military Detail

US_MLTRY_DTL

Source System Code

SRC_SYS_CD

New Table

United States Military Detail

US_MLTRY_DTL

Source System Key

SRC_SYS_KEY

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Indicator

MLTRY_VTRN_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Air Force Indicator

MLTRY_VTRN_AIR_FORCE_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Army Indicator

MLTRY_VTRN_ARMY_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Coast Guard Indicator

MLTRY_VTRN_CSTGRD_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Marines Indicator

MLTRY_VTRN_MARINES_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Veteran Navy Indicator

MLTRY_VTRN_NAVY_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Indicator

MLTRY_ACTV_DUTY_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Air Force Indicator

MLTRY_ACTV_DUTY_AIR_FORCE_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Army Indicator

MLTRY_ACTV_DUTY_ARMY_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Coast Guard Indicator

MLTRY_ACTV_DUTY_CSTGRD_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Marines Indicator

MLTRY_ACTV_DUTY_MARINES_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Active Duty Navy Indicator

MLTRY_ACTV_DUTY_NAVY_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Indicator

NATL_GUARD_RSRV_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Air Force Indicator

NATL_GUARD_RSRV_AIR_FORCE_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Army Indicator

NATL_GUARD_RSRV_ARMY_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Coast Guard Indicator

NATL_GUARD_RSRV_CSTGRD_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Marines Indicator

NATL_GUARD_RSRV_MARINES_IND

New Table

United States Military Detail

US_MLTRY_DTL

National Guard Reserve Navy Indicator

NATL_GUARD_RSRV_NAVY_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Service Indicator

MLTRY_SRVC_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Dependent Indicator

MLTRY_DEP_IND

New Table

United States Military Detail

US_MLTRY_DTL

Military Connected Indicator

MLTRY_CNNCTD_IND

Third Week Data Set and SA05 BusinessObjects universe

 

What Changed

Entity Name

Table Name

Attribute Name

Column Name

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Military Veteran Indicator

MLTRY_VTRN_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Military Active Duty Indicator

MLTRY_ACTV_DUTY_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

National Guard Reserve Indicator

NATL_GUARD_RSRV_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Military Service Indicator

MLTRY_SRVC_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Military Dependent Indicator

MLTRY_DEP_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Military Connected Indicator

MLTRY_CNNCTD_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Air Force Indicator

AIR_FORCE_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Army Indicator

ARMY_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Coast Guard Indicator

CSTGRD_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Marines Indicator

MARINES_IND

New Column

Third Week Personal Data

THIRDWK_PERSONAL_DATA

Navy Indicator

NAVY_IND

New Column

Third Week Student Career Term

THIRDWK_STDNT_CAR_TERM

Tuition Division Code

TUITION_DIV_CD

New Column

Third Week Student Career Term

THIRDWK_STDNT_CAR_TERM

Tuition Division Description

TUITION_DIV_DESCR

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Employee Identification Code

EMPLID

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Reporting Term Code

RPTING_TERM

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Source System Code

SRC_SYS_CD

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Source System Key

SRC_SYS_KEY

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Indicator

MLTRY_VTRN_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Air Force Indicator

MLTRY_VTRN_AIR_FORCE_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Army Indicator

MLTRY_VTRN_ARMY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Coast Guard Indicator

MLTRY_VTRN_CSTGRD_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Marines Indicator

MLTRY_VTRN_MARINES_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Veteran Navy Indicator

MLTRY_VTRN_NAVY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Indicator

MLTRY_ACTV_DUTY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Air Force Indicator

MLTRY_ACTV_DUTY_AIR_FORCE_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Army Indicator

MLTRY_ACTV_DUTY_ARMY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Coast Guard Indicator

MLTRY_ACTV_DUTY_CSTGRD_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Marines Indicator

MLTRY_ACTV_DUTY_MARINES_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Active Duty Navy Indicator

MLTRY_ACTV_DUTY_NAVY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Indicator

NATL_GUARD_RSRV_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Air Force Indicator

NATL_GUARD_RSRV_AIR_FORCE_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Army Indicator

NATL_GUARD_RSRV_ARMY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Coast Guard Indicator

NATL_GUARD_RSRV_CSTGRD_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Marines Indicator

NATL_GUARD_RSRV_MARINES_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

National Guard Reserve Navy Indicator

NATL_GUARD_RSRV_NAVY_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Service Indicator

MLTRY_SRVC_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Dependent Indicator

MLTRY_DEP_IND

New Table

Third Week United States Military Detail

THIRDWK_US_MLTRY_DTL

Military Connected Indicator

MLTRY_CNNCTD_IND

For additional information on proper usage of university data:

Learn more about BusinessObjects: