Overview
For users of the decommissioned legacy Student Data Warehouse (SDW), the following guide was developed to assist with transitioning their reporting to IDR. It provides suggested reports or packages in IDR that are the equivalent to what was found in the SDW.
Information
Use the tables below or download the attached PDF file.
Which Enterprise Report or Data Package do I use?
|
|
Enterprise
Report
|
Suggested
Package
|
Query
Subject
|
Notes
|
|
Student
|
Student Data
|
Student Detail
|
Student
|
Student info, majors, minors, email, advisor
|
|
GPA / Hours
|
Student Data
|
Student Detail
|
Student
|
|
|
Address
|
Student Data
|
Student Detail
|
Person Address UO
|
MA and PR addresses
|
|
Majors / Minors
|
Student Data
|
Student Detail
|
Student
|
--
|
|
Awarded Degrees
|
Awarded Degrees
Latin Honors
|
Student Detail
|
Degrees UO
|
--
|
|
Registration
|
Class Roster
Grade Distribution
Students not Registered
Unofficial Transcripts
|
Student Detail
|
Student Course
|
--
|
|
Class Schedule
|
Course Summary
Course Enrollment Statistics
Class Schedules
|
Schedule Offering
|
Schedule Offering
|
--
|
Student
[Student Detail].[Student] query subject has one row per student per term with active student records.
|
|
Business Name
|
Package
|
Query Subject
|
Notes
|
|
ID
|
ID
|
Student Detail
|
Student
|
95#
|
|
Name
|
Name
|
Student Detail
|
Student
|
Last, First MI
|
|
Preferred First Name and separate name fields
|
Name
|
Student Detail
|
Person Detail
|
--
|
|
Academic Period
|
Term
|
Student Detail
|
Student
|
201801
Fall 2018
|
|
Confidentiality Indicator
|
Confidentiality Indicator
|
Student Detail
|
Person Detail
|
FERPA Indicator
(Must include on all reports with ID / Name.)
|
|
Registered Ind
|
Registered
|
Student Detail
|
Student
|
Y
|
|
Student Level
|
Level
|
Student Detail
|
Student
|
GR
UG
LAW
|
|
All Packed Majors
|
All Majors
|
Student Detail
|
Student
|
MATH|BADM
|
|
Packed Majors 1-4
|
Major
|
Student Detail
|
Student
|
MATH
BADM
|
|
All Packed Major Colls
|
College
|
Student Detail
|
Student
|
AS|BA
|
|
All Packed Major Depts
|
Department
|
Student Detail
|
Student
|
MATH|BA
|
|
All Packed Minors
|
All Minors
|
Student Detail
|
Student
|
CIS|HC
|
|
Packed Minor 1-4
|
Minor
|
Student Detail
|
Student
|
CIS
HC
|
|
All Packed Minor Colls
|
Minor College
|
Student Detail
|
Student
|
AS|HC
|
|
All Packed Minor Depts
|
Minor Department
|
Student Detail
|
Student
|
CIS|HC
|
|
Academic Period Admitted
|
Admit Term
|
Student Detail
|
Student
|
201501
|
|
Current Time Status
(Enrollment Status in SDW)
|
Time Status
|
Student Detail
|
Student
|
FT = Full time
HT = Half time
LT = Less than half time
|
|
Student Classification BOAP
(beginning of academic period)
|
Class Standing
|
Student Detail
|
Student
|
Sophomore
Graduate
|
|
Primary Advisor
|
Advisor
|
Student Detail
|
Student
|
Department or
advisor name
|
|
Cohort
|
Cohort
|
Student Detail
|
Student
|
FTFT201701
INTL_INSUR
|
|
Student Concentrations
|
Concentrations
|
Student Detail
|
Student
|
MO1|FINC
|
|
Student Endorsements
|
Endorsements
|
Student Detail
|
Student
|
EI07|EI19
|
|
Student Specializations
|
Specializations
|
Student Detail
|
Student
|
SBP|INEN|FISA
|
|
Student Attributes
|
Attributes
|
Student Detail
|
Student
|
EFL|PW|SOU
English First Language| Pathway|SOU Enrollment Partnership
|
|
UO Email Address
|
Email
|
Student Detail
|
Person Detail
|
UO policy to only use UO email after admitted.
|
|
Address
|
Address
|
Student Detail
|
Person Address UO
|
MA and PR addresses
|
|
Residency Ind
|
Residency
|
Student Detail
|
Student
|
R = Resident
N = Non-Resident
|
|
Honors College Flag
|
Honors College
|
Student Detail
|
Student
|
Y
|
|
International Student Flag
|
International
|
Student Detail
|
Student
|
Y
|
|
Bend Only Flag
|
Bend Only
|
Student Detail
|
Student
|
Y
|
|
Orientation Session
|
Orientation
|
Student Detail
|
Student
|
IntroDUCKtion
|
|
Professional Objective
|
Professional Objective
|
Student Detail
|
Student
|
Pre-Med
Pre-Law
|
|
Student Rate
|
Rate
|
Student Detail
|
Student
|
GTF
|
|
Student Type
|
Type
|
Student Detail
|
Student
|
1-11 Transfer
PostBac
Doctoral
|
|
Education Level
|
Education Level
|
Student Detail
|
Student
|
HS/GED
Some College
Associates
Bachelors
Masters
|
|
Student Status
|
Student Status
|
Student Detail
|
Student
|
Active
Inactive
(Use Registered Ind ='Y' instead.)
|
|
Federal Ethnicity Code
|
Ethnicity
|
Student Detail
|
Person Detail Extended
|
Contact registrar's office for ethnicity data if you get an error.
|
|
Block Code
|
Block
|
Student Detail
|
Student
|
IntroDUCKtion
|
|
Learn Com
|
Learning Community
|
Student Detail
|
Student
|
FIG
TRIG
Pathway
(Flag, CRN, Title)
|
|
Dean's List
|
Dean's List
|
Student Detail
|
Student
|
DL
Dean's List
|
|
Term GPA
|
Term GPA
|
Student Detail
|
Student
|
3.65
|
|
Cum GPA as of today
|
UO Cumulative GPA
|
Student Detail
|
Student
|
3.75
(Always as of today no matter which term used.)
|
|
Total Credits
|
Term Hours
|
Student Detail
|
Student
|
12
|
|
UO Earned Hours
|
UO Earned Hours
|
Student Detail
|
Student
|
45
|
|
Transfer Hours
|
Transfer Hours
|
Student Detail
|
Student
|
10
|
|
Overall Earned Hours
|
Overall Earned Hours
|
Student Detail
|
Student
|
55
|
Awarded Degrees
|
|
Business Name
|
Package
|
Query Subject
|
Notes
|
|
Student Name
|
Name
|
Student Detail
|
Person Detail
|
Pre-joined to Degree UO
|
|
Confidentiality Indicator
|
Confidentiality
|
Student Detail
|
Person Detail
|
FERPA indicator
|
|
Degree Term
|
Term
|
Student Detail
|
Degree UO
|
Term degree awarded
|
|
Degree Code
|
Degree
|
Student Detail
|
Degree UO
|
BS|BA|MS|
PHD|JD
|
|
Degree Level
|
Degree Level
|
Student Detail
|
Degree UO
|
GR|UG|
LAW
|
|
Degree Date
|
Award Date
|
Student Detail
|
Degree UO
|
--
|
|
All Degree Majors
|
All Degrees
|
Student Detail
|
Degree UO
|
|SPAN|PSY|
|
|
Degree Major 1-4
|
Degree
|
Student Detail
|
Degree UO
|
SPAN
PSY
|
|
All Degree Major Colleges
|
College
|
Student Detail
|
Degree UO
|
|AS|AS|
|
|
All Degree Minors
|
All Minors
|
Student Detail
|
Degree UO
|
|FDST|MENA|
|
|
Degree Minor 1-4
|
Minor
|
Student Detail
|
Degree UO
|
FDST
MENA
|
|
All Degree Minor Colleges
|
Minor College
|
Student Detail
|
Degree UO
|
|AS|AS|
|
|
Degree Inst Honor
|
Institutional Honors
|
Student Detail
|
Degree UO
|
Honors College|
Magna Cum Laude
|
|
Degree Dept Honor
|
Departmental Honors
|
Student Detail
|
Degree UO
|
1st Major|2nd Major
|
|
Latin Honor
|
Latin Honors
|
Student Detail
|
Degree UO
|
(no Honors College, use Degree Inst Honor instead)
Cum Laude|
Summa Cum Laude
|
|
Honors College Flag
|
Honors College
|
Student Detail
|
Degree UO
|
--
|
|
Degree Status
|
Status
|
Student Detail
|
Degree UO
|
AW = Awarded AP = Applied
|
|
Appl Date
|
Degree Application Date
|
Student Detail
|
Degree UO
|
--
|
|
Inst Transfer Flag
|
UO or Transfer
|
Student Detail
|
Degree UO
|
I = UO (institutional)
T = Other institution (transfer)
|
|
Postbac Flag
|
Postbac
|
Student Detail
|
Degree UO
|
--
|
|
INTL Flag
|
International Student Flag
|
Student Detail
|
Degree UO
|
--
|
Student Course
If data from [Student] is used, join on academic period: [Student Detail].[Student Course].[ACADEMIC_PERIOD]=[Student Detail].[Student].[ACADEMIC_PERIOD].
|
|
Business Name
|
Package
|
Query Subject
|
Notes
|
|
Academic Period
|
Term
|
Student Detail
|
Student Course
|
201801
|
|
Course Registered Ind
|
Registered
|
Student Detail
|
Student Course
|
Y
|
|
ID
|
ID
|
Student Detail
|
Student Course
|
95#
|
|
Name
|
Name
|
Student Detail
|
Student Course
|
Last, First MI
|
|
Preferred First Name and separate name fields
|
Name
|
Student Detail
|
Person Detail
|
--
|
|
Confidentiality Indicator
|
Confidentiality Indicator
|
Student Detail
|
Person Detail
|
FERPA Indicator
(Must include on all reports with ID / Name.)
|
|
Transfer Course Indicator
|
|
Student Detail
|
Student Course
|
N = UO Courses only
|
|
Course Reference Number
|
CRN
|
Student Detail
|
Student Course
|
36744
|
|
Course Identification
|
Class
|
Student Detail
|
Student Course
|
MATH231
|
|
Subject
|
Subject
|
Student Detail
|
Student Course
|
MATH
|
|
Course Number
|
Number
|
Student Detail
|
Student Course
|
231
|
|
Special Approval
|
Special Approval
|
Student Detail
|
Student Course
|
I = Instructor Approval
|
|
Course Credits
|
Hours
|
Student Detail
|
Student Course
|
4
|
|
Course Title Short
|
Title
|
Student Detail
|
Student Course
|
Algebra
|
|
Final Grade
|
Grade
|
Student Detail
|
Student Course
|
A
|
|
Instructor
|
Instructor
|
Student Detail
|
Student Course
|
Instructor name
|
|
Grade Type
|
Grade Mode
|
Student Detail
|
Student Course
|
G = Graded
P = Pass/No Pass
|
|
Registration Status
|
Registration Status
|
Student Detail
|
Student Course
|
RE = Registered
DC = Drop
WN = W/D no ref
|
|
Course Level
|
Level
|
Student Detail
|
Student Course
|
GR
UG
|
|
Course Fees
|
Course Fees
|
Student Detail
|
Schedule Offering
|
--
|
|
College
|
College
|
Student Detail
|
Student Course
|
AS
|
|
Department
|
Department
|
Student Detail
|
Student Course
|
MATH
|
|
Course Title Short
|
Title
|
Student Detail
|
Student Course
|
Algebra
|
|
Final Grade
|
Grade
|
Student Detail
|
Student Course
|
A
|
|
Transfer Course Indicator
|
|
Student Detail
|
Student Course
|
N = UO Courses only
|
|
Campus
|
Campus
|
Student Detail
|
Student Course
|
I = UO main campus
V = On-line
|
|
Course Attributes
|
Course Attributes
|
Student Detail
|
Student Course Attributes
|
3|GHNS
Science Group >3|Global Hlth: Natural Science
|