Technical Details

Current Release Version: 2023.1.1

Release Date: 02 Feb 2023

Report Location: PowerBI / Apps / SPS Global

Security Roles: All SPS

Requested Features

Current Cycle 

Release 2023.1.2 [March 2023]

Features to Complete

• None

Features to Consider

• None

Features Ready for Release

• The SPCSEO and SPCSEC programs should only be showing up in the Sponsored Pre-College (Non-Credit) category.  Currently, they are in that category and Sponsored Visiting

Previous Cycles

Release 2023.1.1 [February 2023]

• Rename "Pre-College Immersion - Non-Degree" to "Pre-College (non-Credit) - Non-Degree"
• Create "Pre-College (Credit) - Non-Degree".  It should be above the Pre-College (Non-Credit) section and move:
  Visiting -- College Edge (SPNDGH) under that category.
• Create "Sponsored Pre-College (Non-Credit) - Non-Degree", place it in the rightmost column and move: 
  Visiting -- Columbia Secondary School - SPCSEC
  Visiting -- Columbia Secondary School -- Online (SPCSEO)
  Visiting -- Youth in STEM (SHYIS)

Release 2023.1.0 [January 2023]

• Adjust to fit the contents without scrolling in the 'Sponsored Visiting - Non-Degree Operated by SPS view on Active by Type page

Release 2022.1.0 [February 2022]

• Resize the Visiting Non-Degree visual to keep it from scrolling and close the gap between Pre-College and Auditor visuals
• Added blue border to content area to line up with in-page slicer design standard
• Added count to the section title for all but Non-Degree visuals
• Added measure and filter to isolate fully online programs
• Moved Sponsored By and Operated By slicers to the filter bar

Release 2021.1.0 [December 2021]

• Initial production release
• Cosmetic updates to bring the format inline with the new PBI design brief
• Updated link to point to the new Confluence location
• Renamed report and updated the tab titles to fit within the nav menu guidelines

Release 2021.0.2 [November 2021]

• Change the Program Description label on each tile to Program Description - Program Code.
  • In the ‘Official SPS Programs by Degree’ view Add a visual for the MPS programs just below the MS programs, and rename the following visual headings as:
    • Master of Science
    • Master of Professional Studies
    • High School Immersion - Non-Degree
    • American Language - Non-Degree
    • Auditor - Non-Degree
    • Sponsored Auditor - Non-Degree*
    • Visiting - Non-Degree
    • Sponsored Visiting - Non-Degree *
    • Remove the degree code column from each panel on the official Active SPS Academic Programs view
• Add 3 columns to the "All Active SPS Academic Programs" view after the degree code column.
  • Column 1 - "Sponsored Program"
  • Column 2 - "Operated by"
  • Sponsored Program is HEGIS Program Code = "N" then return "Yes" else "No"
  • Operated by is "Secondary_HEGIS_General_Code" = "P" the return "Office of the Provost" else "School of Professional Studies"
  • Column 3 - "Planned Program Inactivation end of" Where "Secondary_HEGIS_General_Code" <> "P". Return the value in the field (i.e Fa24 or Sp22).
  • The "Sponsored Auditor - Non-Degree*" label should be "Sponsored Auditor - Non-Degree Operated by SPS*" here: 
  • High School Immersion - Non-Degree" label should be "Pre-College Immersion - Non-Degree"

Release 2021.0.1 [August 2021]

• Initial beta release
• Create a view all_active_sps_academic_programs
• Create two views (1) All Active SPS Academic Programs (2) Official SPS Programs by Degree