/
SIS Reports Change Log

SIS Reports Change Log


 

 

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 Date

Report Folder

Report Name 

Requested Changes

Date Changes Made

2/21/2025

Academic Student

Academic Courses

Admissions General

BISK General

Spreadsheet (122 Reports): https://usf.box.com/s/ytxf919d3lrjptyf9rjivpv2zuudztu1

Due to changes in the underlying data, many reports containing email, address, and phone number columns have encountered errors when run for certain terms. These reports are currently being reviewed and proactively updated to ensure proper functionality.

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

10/4/2024

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 

Changes canceled.

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:

    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”

 

 

 

Related content

Student Success Research & Analytics (SSRA)
Student Success Research & Analytics (SSRA)
Read with this
SSRA Year to Year Admissions Report
SSRA Year to Year Admissions Report
More like this
ODS Notifications
Read with this
USF ODS SSRA - News & Updates
USF ODS SSRA - News & Updates
More like this
ODS Knowledge Base
ODS Knowledge Base
Read with this
Student Financial Aid for public institutions reporting on a fall cohort
Student Financial Aid for public institutions reporting on a fall cohort
More like this