SIS Reports Change Log

Owned by Ben Salazar
Last updated: Apr 17, 2024
1 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
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”