End User Requested SIS/SAP Report Changes

Requested Date	Report Folder	Report Name	Requested Changes	Date Changes Made
9/20/2024	Academic Student	UGS: Midterm Grade Advising Report UGS: Currently Registered by College	Add college code DP to list of college codes, as well as remove college codes that are not active and do not have any students sitting in them. College codes to be removed: ST, FM, AR, OO, JP, SP, AM, SM
9/9/2024	Academic Student	College: Application Detail Report COPH: Application Detail Report	Decommission COPH: Application Detail Report and add fields to College: Application Detail Report. Fields to be added: APP FEE AFEE_DATE TRANSF_GPA_2 PCOL_BACHR_GPA PCOL_MASTR_GPA GRE VERBAL PERCENT GRE QUANT PERCENT GRE ANALYT WRIT PERCENT DOB HS_CODE HS_DESC
8/16/2024	Academic Student	Campus: TutorTrac Download	Add DOB to the report because of the decommissioning of USFSP: TutorTrac Download.	9/9/2024
8/16/2024	Academic Student	USFSP: TutorTrac Download	Remove the report from the SIS reports inventory because the Campus: TutorTrac Download report contains the same columns as the USFSP: TutorTrac Download report in addition to the following fields: Start Term Grad Term OLGA Concentration Degree Credit Hours	9/9/2024
6/3/2024	Academic Student	College: Graduation Applicants by Grad Term	Remove logic that constrains the report to only Degree Status codes of ('AW','AP', 'SO'), allowing the report to show all applicants regardless of Degree Status code Add a parameter for Degree Status code	6/20/2024
3/22/2024	Academic Student	College: Application Detail Report	Add Student Level parameter('UG','GR,'ND','PR')	4/17/2024
12/13/2023	Academic Student	ROTC: Active and Enrolled Students by Term including Majors and Courses	Add " Instructor Name" Add " Instructor Email" Add " Graduation Date" Add " Graduation Status" Add " Graduation Level" Report Name Change " ROTC Active and Enrolled Students By Term Including Majors, Course and Instructor Information"	1/10/2024
11/15/2023	Academic Student	Class Rolls Master Report	Add “Admit Term” and “Admit Type”	12/06/2023
11/7/2023	Academic Student	Class Rolls Master Report	Add “USF GPA” and “Overall GPA”	12/06/2023
10/26/2023	Academic Student	Graduation: Graduating Students by Grad Term, College, and Degree Status	Add a student attribute column to the report	12/05/2023

SIS/SAP Report Updates (Technical Changes)

Date Changes Made	Report Folder	Report Name	Changes Made
4/1/2024	Academic Courses	College: Course Restrictions by Term, College and Department	Added logic to handle student attribute restrictions
3/4/2024	Academic Student	College: Students with Registration Permits by Term, Advisor User ID, College, Campus and Level	Added a Listagg funtion to "USER_DESC"
1/23/2024	Academic Student	FSI/SSS or NBS Retention/Attrition Report By Term and Attribute	Added a parameter for Admit Term Add a filter on Admit Term
11/20/2023	Academic Courses	Graduation: Graduating Students by Grad Term, College, and Degree Status	Added “COLL_DESC”, ” SECTION_TYPE_DESC”, “SPECIAL_APPROVAL_DESC”, “COURSE_SECTION_CONTRACT_DESC” Column name changes: “COLL” → “COLL_CODE” “DEPT” → “DEPT_CODE” “CAMPUS” → “CAMPUS_CODE” “INSTRUCTION_CODE” → “INSTRUCTIONAL_METHOD_CODE” “INSTRUCTION_DESC” → “INSTRUCTIONAL_METHOD_DESC” “TYPE” → “SECTION_TYPE_CODE” “SAPR” → “SPECIAL_APPROVAL_CODE” “CRSE_TEXT” → “COURSE_COMMENTS” “COURSE_STATUS” → “COURSE_STATUS_CODE” “OPEN/CLOSED” → “COURSE_STATUS_DESC_2” “SCCD_CODE” → “COURSE_SECTION_CONTRACT_CODE” “XL” → “CROSS_LISTED_COURSE” Column moved “CRSE_LEVL” “CRSE_SECT” “COURSE_STATUS” “COURSE_STATUS_DESC” “COURSE_STATUS_DESC_2”