...
Note that retrieving an unsubmitted application will be quite unsatisfying--the available fields are quite restricted.
Postlaunch
There are several different options for testing the data mapping and confirming that data is being imported correctly once the feeds have been turned on. The immediate check is the test file from the CAS; if that arrives in Slate, that is a good sign. It will not actually be imported, but will show an Error. Once real application files start flowing, it is good to check occasionally that everything is flowing as expected.
...
The options for exporting data from WebAdmit about In Progress Applicants is limited.
...
Pulling this list gets a list of everyone who is currently In Progress; this means that anyone who has submitted is not included. There is no control over what fields are exported, so for vet Vet at least this means there is a great deal of address information that has not been imported yet.
The number of individuals in the “In Progress” pile in WebAdmit fluctuates as individuals submit their applications, and as they change their mind about applying to Tufts and ‘undesignate’ the school. When students previously designated Tufts, the In Progress file was sent; there is no way to pull back that data, so over the course of the cycle there will be several hundred people who ‘disappear’ from WebAdmit, but exist as prospects in Slate.
(1) Confirm there is no one in WebAdmit who does not have a record in Slate
XLOOKUP syntax: =XLOOKUP(lookup,lookup_array,return_array,[not_found],[match_mode],[search_mode]) https://exceljet.net/functions/xlookup-function
(2) Spot check- data is matching appropriately. (~10 records).
Process (1) identified three students who were in Slate but did not have VMCAS Id’s. None are currently designated for Tufts, but figuring out the issue All three of them have Slate accounts that they matched with, and have open applications for the 2024 cycle.
...
Rose Tuft and Ashley Bloomfield are the other two students.
Open question: are there any other students with applications in 2024 that were not affected? Note that it wouldn't be VMCAS re-apps, since they already have their ID on the field.
There are 136 people who applied in 2024 in the 2025 DVM pool; of that group there are 19 who have never applied to a DVM program before, and 16 of them have their Person/CAS ID’s.
...