...

An Excel doc outlining the Slate queries and their fields can be found here: https://tufts.app.box.com/s/cbmhofh5q5jw7cjbrijyityi44kq47zq

Design

Components

Bold views are final views
Italic views are cached

• Box

  • https://tufts.box.com/s/cbmhofh5q5jw7cjbrijyityi44kq47zq

• Denodo VDP

  • student_lifecycle

    • 01-base_layer

      • 01-connections

        • slate

          • ds_slate_tuf_application

          • ds_slate_tuf_person

          • ds_slate_tuh_application

          • ds_slate_tuh_person

          • ds_slate_tup_application

          • ds_slate_tup_person

          • ds_slate_tuv_application

          • ds_slate_tuv_person

          • ds_box_slate_race_release_dates

      • 02-base_views

        • slate

          • bv_slate_tuf_application

          • bv_slate_tuf_person

          • bv_slate_tuh_application

          • bv_slate_tuh_person

          • bv_slate_tup_application

          • bv_slate_tup_person

          • bv_slate_tuv_application

          • bv_slate_tuv_person

          • bv_box_slate_race_release_dates

    • 02-transformation

      • slate

        • agg_slate_person_max_race_release_date

        • p_slate_person

        • p_slate_application

    • 03-integration

      • slate

        • u_slate_person

        • u_slate_application

    • 04-interface_fulfillment

      • slate

        • slate_person

        • slate_application

• Denodo Scheduler

  • slate-union-views-cache

Masking of Race Data for Current Cycle

Deans should not be able to see race data for a current or future application cycle in order to prevent intervention in applications based on raced. To prevent this, a race release date is associated with each application based on the school and application term. These dates are currently defined in the race-release-dates sheet in the Box spreadsheet linked above. The max race release date is calculated for each person based on their applications and if this date is in the future, their race data values are set to null.