Versions Compared

Version Old Version 29 New Version 30
Changes made by

Braden Seidl

Braden Seidl

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



Panel
titleColorwhite
titleBGColor#006747
titleOverview

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.





Panel
titleColorwhite
titleBGColor#006747
titleEnd User Requested SIS/SAP Report Changes


Requested DateReport FolderReport Name Requested ChangesDate Changes Made
8/16/2024Academic StudentUSFSP: Campus TutorTrac DownloadRemove the report from the SIS reports inventory because the Campus: TutorTrac Download report contains the same columns as the USFSP: Campus TutorTrac Download report in addition to the following fields:
  • Start Term
  • Grad Term
  • OLGA
  • Concentration
  • Degree
  • Credit Hours

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





Panel
titleColorwhite
titleBGColor#006747
titleSIS/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”