Development (AP)

Technical Details

Current Release Version: 2023.1.2

Release Date:

Report Location: PowerBI / Apps / SPS Global

Security Roles: All SPS

Requested Features

Current Cycle 

Release 2023.1.3 [May 2023]

Features to Complete

  • None

Features to Consider

  • None

Features Ready for Release

Previous Cycles

Release 2023.1.2 [March 2023]

  • 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

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