Versions Compared

Version Old Version 54 New Version 55
Changes made by

Bryon Vaughn

Bryon Vaughn

Saved on

Key

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

...

Release 2023.1.2 [May 2023]

Features to Complete

  • Enrollment Trends
    • BUG: Spring forecast charts are off, likely caused by the offset date method to keep numbers from spanning over two years.
    • BUG: Forecasted data does not include cases where there was not actual enrollment in the program in the previous term/year (SPCOMO in 2022, for example)
      • Should I just load in the target as placeholder history in these cases?
    • Include headcount, average credits, and tuition as alternate data points
    • Filtering
      • Allow switching view between daily, weekly and monthly
      CONSIDER: Show all years in the trend charts for actuals, with the projection pattern for the single year
  • Data Extracts
    • Include other tables in the extract page
      • UI to switch between between data to be extracted
      • Engage EBIS to see if we can enable PBI Automate to save files to Google Drive

...

Features Ready for Release

  • None

Previous Cycles

Release 2023.1.1 [April 2023]

  • Enrollment Trends
    • Move pages out of bookmarks and add to the main navigation panel
    • The most recent year should include actuals through the current date, and projected fill from that point forward starting with the current fill position with the target fill rate pattern
      • Use the point in time actual count and divide that by the fill rate on the same day from one year ago to get the estimated final landing position
      • Forecast actuals from there through the end of the year using the target forecast fill rates
    • Separate page to show all years in the trend chart for actuals, with the projection pattern for the current year (Trends All Years)

Release 2023.1.0 [March 2023]

  • Enrollment Trends
    • a2_trcl_trends.sql procedure
      • Pull all of the TRCL history for the past four years
      • Include the following data points
        • Transaction Date: Date of TRCL transaction
        • Program Code: Billing Program Code
        • Term Identifier: Term of the transaction
        • Term Name: The user friendly name of the terms to view (Summer, Spring, Fall)
        • Daily Credits: Net credits added/dropped per day
        • Final Total Credits: Final credits at the end of the enrollment period for the term
        • Percentage of Final: The percentage of the final credits as of the transaction date
        • Running Credits: Total number of credits for the enrollment period as of the transaction date
        • Target Credits: The latest defined credit target for the program by term
    • Add a new page showing the enrollment trends for a specific term name (Spring, Summer, Fall) from the latest available term to the past four years
      • Include actuals from all terms with active enrollment
      • Compare the trend for each year against the projected trend based on the previous year fill pattern
    • Filtering
      • Allow filtering on program and term name
      • Allow filtering date range
  • Data Extracts
    • Add a new hidden report page that allows for exporting full data rather than a subset from the visualization pages
      • Add bookmark to allow access
    • Tables to extract
      • Full data behind the new Enrollment Trends report

Release 2022.1.2 [December 2022]

...