Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

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
6/3/2024Academic 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 


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”

  • No labels