Versions Compared

Version Old Version 9 New Version 10
Changes made by

Helen Williams

Helen Williams

Saved on

Key

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

Sprint date

Application/Person v1 (Beth)

Engagement v1 (Helen)

Application Schools v2 (Beth)

Programs v1

General

Completed

  • Slate queries finalized and connected to Denodo for Vet, GSBS, and Nutrition.

by Thanksgiving

  • Cross-check queries set up in each instance

  • Query data sent out for validation against previous external reporting (Brian Cody, Sara Abbott, IR)

  • Basic Person and Application Feeds set up in 4 instances/5 schools (Vet, Fletcher, TUSMGP, GSBS/NUTR)

NUTR

  • Meet with UCM to clarify data structure

  • start Slate queries finalized and connected to Denodo for TUSMGP and Fletcher.

  • Query/data structure draft created for Nutrition.

  • Start technical conversation series with Matt

  • Finalize next data priorities

by Christmas

connect Denodo feeds to Tableau for our testing

  • Query/data structure draft

  • Business process guide for Slate users providing engagement data through Denodo finalized.

January 2-18, 2025

January 21- February 7

February 10 - March 1

March 4 - March 21

...

  1. Person

    1. Simple bio/demo data

  2. Application

    1. Simple program/app data

    2. Funnel Dates

      1. Complete Date

      2. Interview Date

    3. Invite to Interview Flag

    4. Fee waived

    5. HRSA/Socioeconomic Indicators

    6. Application review indicators

      1. GPA

    7. Decline for institution

  3. Schools

  4. Engagements

    1. Lead Form submissions

    2. UCM/Hubspot Origin Sources

    3. First Source

    4. Flags

      1. Submitted a form

      2. Registered for an event

      3. Contacted the school

  5. Program Dataset (Meta data about programs)

    1. Cycle dates

      1. Application Open

      2. Application Deadline

      3. Decision dates

      4. Semester Start date (race release)

    2. Program length

    3. Program launch date/term

    4. Program close date

    5. Program Application Review stuff

      1. Do they require interviews?

      2. Rolling admission?

      3. Number of required recommendations

      4. Required test scores?

      5. Definition of complete application

      6. Requirements for complete post-submission? What is collected after you submit?

    6. Fee waiver process?

    7. Application fee amount?

    8. Location

    9. Format/Modality

    10. Degree or non-degree

    11. SIS codes

    12. PF codes

    13. Tuition

    14. Scholarship?

    15. Program Staff (use for content blocks?)(use the existing user table?)

      1. Admissions Director

      2. Manager, etc.

      3. Admissions Counselor/staff

    16. Program selectivity rating

Instances

  1. Vet

  2. Nutrition

  3. GSBS

  4. TUSMGP

  5. Fletcher

...