Skip to main content
Switch to text-only version
Get accessibility information and assistance


Data Warehouse

Data Warehouse Production Report Catalog - Overview


Academic Affairs


Report Name Description Run Time
Class Roster by CRN Displays course subject code, course number, course name, course credit hours, all of the students taking the selected class, their student email, confidentiality code, major, program, and class standing. Takes an input of term code and CRN. Screenshot < 10 seconds
Course Enrollments by Term by Dept with Gender and Ethnicity Displays course subject code, CRN, course name, instructor name, term code, part of term code, course credit hours, maximum class size, all of the students taking the class, their class standing, V-Number, gender, and ethnicity. Takes an input of term code and department. Input Output < 15 seconds
Enrollment by Course - Student Credit Hours Displays division, department, subject code, course number, on or off campus status, instruction mode, term code and term description, CRN, course title, instructor, course credit hours, classroom capacity, maximum class size, the number of students taking the class seperated out by class standing, and the total number of student credit hours. Takes an input of term code, department, and subject code. < 20 seconds
Faculty by Arrangements Displays faculty names, schedule code description, schedule code, course subject code, course number, course title, division code, division, course CRN, term code, top student in the class, the student's V-Number, and the course credit hours. Does not take any inputs. < 10 seconds
Faculty Load by Term - Cross List Displays term code, CRN, course subject code, course number, course title, CIP, credits, RSCH, NRSCH, number enrolled, maximum class size, course type, campus, instructor ID, instructor name, and instructor title. Takes an input of term code. < 10 seconds
Faculty Load by Term - No Cross List Displays term code, CRN, couse subject code, course number, course title, CIP, credits, RSCH, NRSCH, number enrolled, maximum class size, course type, campus, instructor ID, instructor name, and instructor title. Takes an input of term code. < 20 seconds
Grade Summary by Dept by CRN by Term Displays department, course subject code, course number, course title, CRN, instructor name, and number of students that recieved each grade letter in the course. Takes an input of term code and department. < 10 seconds
Graduate Student Enrollment by Term Displays term code, student last and first name, V-Number, citizenship code description, admit type, degree description, major description, minor description, program 1 and 2 description, GPA, and current credit hours. Takes an input of term code. < 10 seconds
International Students with Less than Minimum Credit Hours for a Term Displays student level, sutdent name, V-Number, class standing, and credit hours. Takes an input of term code. < 10 seconds
Student Schedule by Term Displays term code, student name and V-Number, and student course load by the inputted term. Course load is displayed by course subject code, course number, CRN, course title, credit hours, building, room number, schedule type, days of the week, begin time, end time, and instructor name. Takes an input of term code and student V-Number. < 10 seconds


Accounts Recievable


Report Name Description Run Time
Amount by Detail Category and Term with Drill Through (Detail) (Aggregated Amt) The underlying support report for the "Amount by Detail Category and Term with Drill Through (Summary)." Displays term code, detail category code, detail category code description (links back to the main summary report), detail code, detail code description, V-Number, and amount. Takes an input of term code range and detail category code description. < 20 seconds
Amount by Detail Category and Term with Drill Through (Summary) The main drill through report. Links to "Amount by Detail Category and Term with Drill Through (Detail) (Aggregated Amt)." Displays detail category code, detail category code description, detail code, detail code description, term code, term code description, and total. Takes an input of term code range and detail category code description. < 10 seconds


Admissions


Report Name Description Run Time
Admitted Students by Term Displays student V-Number, name, admitted term, decision date, admit type code, and major description. Takes and input of term code. < 15 seconds


Athletics


Report Name Description Run Time
Athletics Fund Activity Report Displays fiscal year, fund code description, organization code description, account type level 1 description, account type level 2 description, account code description, and totals broken down by fiscal periods. Takes and input of fiscal year, fund code description, and organization code description. Not Available


College of Education


Report Name Description Run Time
Student Count by Term, College, Major, Program, and Minor Displays college, term description, major description, program description, minor description, and the number of students within each of the previous categories. Takes an input of term code/term description and colleges. < 10 seconds


College of Liberal Arts


Report Name Description Run Time
Student Count by Term, College, Major, Program, and Minor Displays college, term description, major description, program description, minor description, and the number of students within each of the previous categories. Takes an input of term code/term description and colleges. < 10 seconds

Finance


Report Name Description Run Time
Assessments (YTD Actual Revenue or Expense) Displays inputted information, fund code, organization code, fund code description, and the YTD actual sum. Takes an input of fiscal year and any combination of fund type level 1 range, fund type level 2 range, fund range, account type level 1 range, and account type level 2 range. < 20 seconds
Assessments (YTD Budget Revenue or Expense) Displays inputted information, fund code, organization code, fund code description, and the accounted budget total. Takes an input of fiscal year and any combination of fund type level 1 range, fund type level 2 range, fund range, account type level 1 range, and account type level 2 range. < 20 seconds
Budget Status Report Displays inputted information, fund type level 2, account type level 2, accounted budget, actuals, encumberances, and available balance. Takes an input of fiscal year, fiscal period, and any combination of fund, fund level, organization, organization level, program, and program level. < 30 seconds
Chancellor's Office Assessments Displays fiscal year, fund code, organization code, fund code description, YTD budgeted expense, percent of total, and assessment. Takes an input of fiscal year and the chancellor's office assessment amount. Not Available
Fiscal Period Activity by Fund by Org by Program Displays inputted information, account type level 1, account type level 2, account code description, and account total actuals broken down by fiscal period. Takes an input of fiscal year, beginning and ending fiscal period, fund code, organization code, and program code. < 20 seconds
Monthly Crosstab Report Displays inputted information, account code, account code description, and actuals broken down by fiscal period. Broken down into the five sections of income, salaries/wages, OPE, general expenses, and transfers.Takes an input of fiscal year, beginning and ending period, fund code, organization code, and program code. < 20 seconds
PowerCube Demo Displays organization code level 1, organzation level 1 description, account type level 1, account type level 1 description and account total actuals broken down by fiscal year and fiscal period. Does not take any inputs. < 5 seconds


Graduate Office


Report Name Description Run Time
Graduate Assitant Waivers Displays graduate assistant names, V-Number, rate code, rate description, program 1 code, program 1 description, term code, tuition/waiver, charge/payment, detail code, and detail code description. Takes an input of academic year. < 10 seconds
Graduate Program Applications by Term Displays term code, admit type, major, application decision, and the number of students in each of the previous categories. Takes an input of academic year. < 10 seconds
Graduate Student Race/Ethnicity/Gender by Term by Major Displays term code, program 1 code, program 2 code, major, Hispanic/non-Hispanic indicator, race/ethnicity, sex, first time graudate student indicator, and the number of students in each of the previous categories. Takes an input of academic year. < 10 seconds


Human Resources


Report Name Description Run Time
Employee Count by Employee Class - Based on POSN ECLS Displays ECLS, ECLS description, and the number of employees in each of the previous categories as a pie chart. Does not take any inputs. < 5 seconds
Contact

University Computing Services 503-838-8154 | or e-mail: webmaster@wou.edu

MissionWestern Oregon University | 345 N. Monmouth Ave. | Monmouth OR 97361 | 503-838-8000(V/TTY) | Admissions 1-877-877-1593 | webmaster@wou.edu Text only
shocker-127 Remote IP: 54.91.120.148 ((none!))