Financial Aid Loan Audit Report - Brief / IE_SIS_FA_LOAN_AUDIT_DASHBOARD_BRF / Yes / New version of the Loan Audit Dashboard with changes made to improve performance and simplify user input. This combines several financial aid audits for review by financial aid offices. /
- Remove 9 Un-used parameters
- Remove views invoking row level security (approved by Steve Martino)
- Views changed to tables as data source whenever possible
FLAG-EAS Roster Status by Instructor / IE_SIS_SR_FLAG_INSTR_RSTR_ACTVTY / No / This report can be used todetermine which instructors have reviewedor have not reviewed students as of a given date range. / Each of these FLAGS reports had several changes and are too numerous to list here. The most significant changes are listed below and may apply to one or more of the FLAGS reports.
Added multi-select functionality to additional parameters
Clarification - include / exclude functionality only affects Kokomo data
Add class start date and end date as parameters
Add parameter to include current classes only (uses session start & end dates)
Add additional drop-downs in IUIE parameters
Add academic level as a parameter
Add session to reports
Add student phone numbers to reports
Parameters in IUIE convert to upper case
Change term parameters to start with 4115
Removed duplicate rows which were being displayed in some cases
Block enrollment classes removed from all reports
Changed parameters to show code and description
Convert to campus specific action codes
Filter out saved but not submitted rosters from original reports
Remove enrollment status as a parameter - default to enrolled
Add leading zeros to student id in export files
Class based reports use course school and department, not student school
Set career parameter default to UGRD
Suppress IPFW and PUFWA from campus parameters
------
A Detailed List of Changes by Report Follows After This Table
------
FLAG-EAS Attendance List / IE_SIS_SR_FLAG_RSTR_ATTEND_LST / No / This report tracks attendance including: Not Attending, Never Attended, Irregular Attendance, etc.
FLAG-EAS Students Attending But Not Enrolled / IE_SIS_SR_FLAG_RSTR_NOT_ENRL / No / This report is used to identify students who are attending but not on roster; compares added student to other classes of this course to facilitate appropriate advising and enrollment.
FLAG-EAS Roster History / IE_SIS_SR_FLAG_SPF_RSTR_HIST / No / This report displays the historical class assessments of 1 or all students in a particular class
FLAG-EAS Student Oncourse Activity for a Selected Instructor / IE_SIS_SR_FLAG_RSTR_INSTR / No / Produce EAS data for students who are assigned to a particular instructor
FLAG-EAS Roster Report for Advisors / IE_SIS_SR_FLAG_RSTR_ADVSR / No / Produce EAS data for students who are assigned to a particular advisor
FLAG-EAS Student Detail / IE_SIS_SR_FLAG_STDNT_DET / No / Produce Student level detail data, linked to from other reports
FLAG-EAS Student Performance Roster Current Student Actions / IE_SIS_SR_FLAG_SPF_RSTR_CURR_STDNT_ACTNS / No / This report lists the Recommended Student Actions by student, by action as indicated by a class instructor from the Student Performance Roster.
FLAG-EAS Roster Report for Administrative Users / IE_SIS_SR_FLAG_RSTR_ADMIN / No / Report to display SPF roster results for a chosen school, dept, etc.
FLAG-EAS Campus Dashboard / IE_SIS_SR_FLAG_RSTR_CAMPUS_DSHBRD / No / Overview by campus of SP Roster results
FLAG-EAS Institution Dashboard / IE_SIS_SR_FLAG_RSTR_DSHBRD / No / Overview at the institution level of SP Roster results
FLAGS Roster Current Student Ratings / IE_SIS_SR_FLAG_SPF_RSTR_CURR_STDNT_RTNGS / No / This report lists the Student FLAGS Ratings by student as indicated by a class instructor from the Student Performance Roster.
Detailed Listing of FLAGS Changes & Fixes by Report
Report / Change or Fix
IE_SIS_SR_FLAG_INSTR_RSTR_ACTVTY / Add an option to exclude/include Purdue Courses (they have the 5 digit #’s) The default should be include.
add and option to included classes based on Course Attribute Value Code = 'GATEWAY'
add class start & end from & to date parameters
add date range start & end date parameters
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add school and department to export for roster status by instructor
add session to report
all parameters in sql should raise case
cascading parameters campus, class school, class department - use SR_ONC_SESN_ENRL_CSCD_V
cascading term inst grp org
chack all reports to see if correct career being used - student or class
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
Exclude block enrollment / “BE” courses – these should be excluded for all campuses.
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
show class start & end dates in the instructor roster activity report
suppress IPFW and PUFWA from campus list in parameter
add enrollment status to instructor status
add level as parameter - include drill-throughs
default include rosters for 'instructors with rosters'
ENRL_CNT is pulling enrollment capacity, not students enrolled
Linda checking: The excel download for the above report did not include both “Instructors With No Rosters” and “Instructors With Rosters” when “All Instructors” were chosen and were displaying on the BIRT report.
Modify Enrollment counts to not include waitlisted students.
School & Department should be Course School, Course Department - labels & params
IE_SIS_SR_FLAG_RSTR_ADMIN / add class school and class department parameters
add class start & end from & to date parameters
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add session to report
add student group parameter - multi select entry no drop down
add term and class enrolled status logic
cascading parameters campus, class school, class department - use SR_ONC_SESN_ENRL_CSCD_V
cascading term inst grp org
check all reports to see if correct career being used - student or class
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
Exclude block enrollment / “BE” courses – these should be excluded for all campuses.
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
remove enrollment status as parameter
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
Set the default for "Include Rosters With No Issues" to "Exclude Rosters With no Issues"
set up cascading parameters for admin_cascade
suppress IPFW and PUFWA from campus list in parameter
add level as parameter - include drill-throughs
right justify oncourse cls 'average
School & Department should be Course School, Course Department - labels & params
unbold # stdnts
IE_SIS_SR_FLAG_RSTR_ADVSR / add class start & end from & to date parameters
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add session to report
add student group parameter - multi select entry no drop down
add term and class enrolled status logic
all parameters in sql should raise case
check all reports to see if correct career being used - student or class
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check advisor logic to make sure it's using the advisor roles jim provided
check to make sure report is using dimensions, not hard coded
Exclude block enrollment / “BE” courses – these should be excluded for all campuses.
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
remove enrollment status as parameter
replace shepherr with dss_rds for ps_iu_aa_note_hdr
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
suppress IPFW and PUFWA from campus list in parameter
add level as parameter - include drill-throughs
All' if no advisor selected
exclude oncourse
getting duplicates (probably advisor)
Level' in detail section in wrong column
School & Department should be Course School, Course Department - labels & params
IE_SIS_SR_FLAG_RSTR_ATTEND_LST / Add class description to report
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
all parameters in sql should raise case
cascading term inst grp org
check all reports to see if correct career being used - student or class
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded - in IUIE
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
exclude attending as a parameter
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
Parse PRSN_PREF_FULL_NM into Last Name and First name
remove enrollment status as parameter
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
supress IPFW and PUFWA from campus list in parameter
add colors to attendance list
add level as parameter - include drill-throughs
entry by - change to user id
figure out why email won't show
School & Department should be Course School, Course Department - labels & params
IE_SIS_SR_FLAG_RSTR_CAMPUS_DSHBRD / add default filter for drop down for term parameter in iuie
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
Add the new student FLAGS values
Attendance, Trends, FLAGS, and Actions graphs need to be repositioned to the top of the report as it is on the FLAGS Institutional Dashboard.
Career Code - the ability to filter on UGRD population. This will flow through the entire report.
Change column of ‘Student Currently Rated’ to return the value of % total submitted students for that campus.
Change Dashboard count to be based on the students school and not the class school.
Change 'Students Currently Rated' columns to calculate '% of Total' and label as such.
Header counts do not match subreport counts
if actions are included, convert to campus specific campus dimension
Label needs to be updated: "Students with Progress Ratings" should be "Students with FLAGS"
make sure current = Y and submitted = 'Y' in all reports
Sort of first graph should be in Alpha order
IE_SIS_SR_FLAG_RSTR_DSHBRD / add drill-through to campus dashboard from tables
add drill-throughs to top 2 graphs to campus dashboard
add drop down for term parameter in iuie
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
Career Code - the ability to filter on UGRD population. This will flow through the entire report. Report currently pulling in all careers.
Change column of ‘Student Currently Rated’ to return the value of % total submitted students for that campus.
change help text ofr jim murray's email
change source for career parameter to be the view not hard coded - in IUIE
Change 'Students Currently Rated' columns to calculate '% of Total' and label as such.
Class Analysis: The column heading 'Issues - % of Enrolled' needs to be changed to "% of submitted classes"
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
mouse over tooltip on major graphs
Sort of first graph should be in Alpha order
Student Analysis and Class Analysis charts: Change % of enrollment to calculate % of submitted students and classes respectfully.
term is hard coded - turn into parameter
IE_SIS_SR_FLAG_RSTR_INSTR / add class school and class department parameters
add class start & end from & to date parameters
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add parameter to select specific course attribute (GATEWAY)
add session to report
add term and class enrolled status logic
cascading parameters campus, class school, class department - use SR_ONC_SESN_ENRL_CSCD_V
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
Drill down to Student Performance Roster History does not seem to be passing the parameters correctly
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
remove enrollment status as parameter
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
suppress IPFW and PUFWA from campus list in parameter
trend data not populating
add level as parameter - include drill-throughs
All' if no instructor selected
Att and Pro have same numbers
dup rows due to career - move career parameter
exclude oncourse option
getting duplicates (probably instructor)
IE_SIS_SR_FLAG_RSTR_NOT_ENRL / Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
cascading term inst grp org
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
Report downloads need to have leading zeros on the student ID column.
suppress IPFW and PUFWA from campus list in parameter
add level as parameter - include drill-throughs
check all reports to see if correct career being used - student or class
change source for career parameter to be the view not hard coded
move 'class enrolled in'
School & Department should be Course School, Course Department - labels & params
set career parameter default to UGRD
where program & plan used as parameters, select against primary and secondary programs & plans
IE_SIS_SR_FLAG_RSTR_STATS / add parameter driven help, question mark help and hover over help
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
all parameters in sql should raise case
check all reports to see if correct career being used - student or class
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
Exclude block enrollment / “BE” courses – these should be excluded for all campuses.
fix params to show cd & desc
indicate required parameters by adding '*'
make sure current = Y and submitted = 'Y' in all reports
set career parameter default to UGRD
Summary report of daily activity - daily tracking report - review with a group
suppress IPFW and PUFWA from campus list in parameter
We want only reviewed rosters and exclude rosters with no issues. General daily sums of entries and cumulative totals of all rosters submitted is good for now.In time we will also want to show, by campus, the number of each attendance, trend, progress, and action value.
where program & plan used as parameters, select against primary and secondary programs & plans
IE_SIS_SR_FLAG_SPF_RSTR_CURR_STDNT_ACTNS / Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
Add Student phone numbers. - Linda finding out which phone number
add term and class enrolled status logic
all parameters in sql should raise case
cascading term inst grp org
check all reports to see if correct career being used - student or class
change alpha parameters so they convert to upper case in the iuie
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
Duplicates in report. Relates to campus dashboard counts
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
remove enrollment status as parameter
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
Set the default for "Display Help Content" to "No"
suppress IPFW and PUFWA from campus list in parameter
add action as a parameter - multi - select
add colors to actions report
add level as parameter - include drill-throughs
change output so it is in more of a table form
remove 'iuie report generated…'
School & Department should be Course School, Course Department - labels & params
should be action centric, not student centric
IE_SIS_SR_FLAG_SPF_RSTR_CURR_STDNT_RTNGS / Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
Add student group
add term and class enrolled status logic
Add the ability to enter multiple student IDs
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
remove enrollment status as parameter
IE_SIS_SR_FLAG_SPF_RSTR_HIST / Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
check all reports to see if correct career being used - student or class
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
Phone number does not display on the reports
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
suppress IPFW and PUFWA from campus list in parameter
add level as parameter - include drill-throughs
All' if no student selected
better spacing in student header columns
change color of email linkl to white
change source for career parameter to be the view not hard coded
Colors consistent in history report
don't include deleted rows
remove 'iuie report generated…'
un bold email link
IE_SIS_SR_FLAG_STDNT_DET / add advisors to student detail - academic advisors only
Add parameter to choose to include / exclude classes which have not yet started based on the session begin & end datesdefault to do not include
add term and class enrolled status logic
change source for career parameter to be the view not hard coded
change to USSS in title, change to IU-FLAGS in title, change FLAGS description in footer
check to make sure report is using dimensions, not hard coded
fix params to show cd & desc
if actions are included, convert to campus specific campus dimension
make sure current = Y and submitted = 'Y' in all reports
Phone number does not display on the reports
suppress IPFW and PUFWA from campus list in parameter
check all reports to see if correct career being used - student or class
change radio buttons to check boxes
Exclude block enrollment / “BE” courses – these should be excluded for all campuses.
make highlight colors consistent with instr, advsr, admin
remove all iuie params - note in iuie - actually just require university ID
remove 'iuie report generated…'
Report downloads need to have leading zeros on the student ID column.
set career parameter default to UGRD
silver border right side of student name in header
The ‘no recommended action’ should be green
Page 1 of 13 August 1, 2012