...

Requested Features

Current Cycle

Release 2023.1.0 [

...

March 2023]

Features to Complete

• 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
    • The most recent term should include actuals to the current date, and projected fill from that point forward based on current fill and past patterns
  • Filtering
    • Allow filtering on program and term name
    • Allow filtering date range
    • Allow switching view between daily, weekly and monthly
• Data Extracts
  • Add a new hidden report page that allows for switching between tables that can be exported in full
    • UI to switch between between data to be extracted
    • Button to export (if possible); otherwise include export instructions on the page
  • Tables to extract
    • Full data behind the new Enrollment Trends report

...