URG C Calculation Incorrect

Slate Instance

TUH

Requestor/Reporter

Sara Abbott/Laura Felch

Date

Apr 29, 2024

Status

COMPLETE

Bug Description

students who only have one NIH criteria for URG C-ness are being marked as URG C

Issue Description

Too man URG C’s!

image-20240429-160759.png
These students do not qualify because they only have the single socio-economic disadvantage flag

Troubleshooting/Research

The rule that calculates the summary field value is incorrect:

image-20240429-161029.png

The URG C flag itself is set only upon submission, BUT the hierarchical fields that determine the value in the NIH URG field run constantly, so an update to the URG C field will cascade.

There were 69 applications ONLY ‘Homeless’ or ‘Pell’, and the related person was flagged as URG C’s (out of 339 URG C apps total). 47 of those were marked as from URG C’s in the NIH field, but it is only 31 people, total; other people were A’s or B’s, so that will not change. Of that group, there are only 7 Admits, IE’s, or blanks; 2 of those are MBR’s, 3 were PhD’s, and two are PREP--one who does not have a decision yet. https://tufts.box.com/s/n8ihjfuql68ep5akkbbugxz5e0l8cnvo

Resolution Steps

(1) Update the rule
(2) Review students who applied for 2024; identify the wrongfully C’s, and batch update that field
(3) check after the rules run to confirm UR status has been updated
(4) report back out to Sara & Laura