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:
- Institutional Data Resource Management Policy
- Information Security
- Family Education Rights and Privacy Act (FERPA)
Learn more about BusinessObjects:
- Join the U-M BusinessObjects Users Forum to collaborate, learn, and share information with others.
- Refer to BusinessObjects User Resources in My LINC.