SIS Reports Change Log

Owned by Braden Seidl
Last updated: Sept 20, 2024 by Braden Seidl
2 min read
Overview

Beginning November 2023, this page is utilized for displaying SIS/SAP report changes. If you have any questions related to information on this page, please reach out to sisreports@usf.edu.

Any changes to existing SIS/SAP reports or for new data requests, please submit a data request form using the following url: http://usfweb.usf.edu/ODS/Forms/RequestForm.aspx.


End User Requested SIS/SAP Report Changes
Requested DateReport FolderReport Name Requested ChangesDate Changes Made
9/20/2024Academic StudentUGS: 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/2024Academic 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/2024Academic StudentCampus: TutorTrac DownloadAdd DOB to the report because of the decommissioning of USFSP: TutorTrac Download. 9/9/2024
8/16/2024Academic StudentUSFSP: TutorTrac DownloadRemove 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 StudentCollege: 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/2024Academic StudentCollege: Application Detail ReportAdd Student Level parameter('UG','GR,'ND','PR')4/17/2024
12/13/2023 Academic StudentROTC: 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/2023Academic StudentClass Rolls Master ReportAdd “Admit Term” and “Admit Type”12/06/2023
11/7/2023Academic StudentClass Rolls Master ReportAdd “USF GPA” and “Overall GPA”12/06/2023
10/26/2023Academic StudentGraduation: Graduating Students by Grad Term, College, and Degree StatusAdd a student attribute column to the report12/05/2023



SIS/SAP Report Updates (Technical Changes)
Date Changes MadeReport FolderReport Name Changes Made
4/1/2024Academic CoursesCollege: Course Restrictions by Term, College and Department
  • Added logic to handle student attribute restrictions
3/4/2024Academic StudentCollege: Students with Registration Permits by Term, Advisor User ID, College, Campus and Level
  • Added a Listagg funtion to "USER_DESC"
1/23/2024Academic StudentFSI/SSS or NBS Retention/Attrition Report By Term and Attribute
  • Added a parameter for Admit Term
  • Add a filter on Admit Term
11/20/2023Academic CoursesGraduation: 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:
    1. “COLL” → “COLL_CODE”
    2. “DEPT” → “DEPT_CODE”
    3. “CAMPUS” → “CAMPUS_CODE”
    4. “INSTRUCTION_CODE” → “INSTRUCTIONAL_METHOD_CODE”
    5. “INSTRUCTION_DESC” → “INSTRUCTIONAL_METHOD_DESC”
    6. “TYPE” → “SECTION_TYPE_CODE”
    7. “SAPR” → “SPECIAL_APPROVAL_CODE”
    8. “CRSE_TEXT” → “COURSE_COMMENTS”
    9. “COURSE_STATUS” → “COURSE_STATUS_CODE”
    10. “OPEN/CLOSED” → “COURSE_STATUS_DESC_2”
    11. “SCCD_CODE” → “COURSE_SECTION_CONTRACT_CODE”
    12. “XL” → “CROSS_LISTED_COURSE”
  • Column moved
    1. “CRSE_LEVL”
    2. “CRSE_SECT”
    3. “COURSE_STATUS”
    4. “COURSE_STATUS_DESC”
    5. “COURSE_STATUS_DESC_2”