All data/reference files: TUV VMCAS API 2024-2025 updates
Biodemo
complete 10/7/2024
Spot check Slate and VMCAS are in alignment: 5. Application Review - Biodemo.
Gender Marker and Identity must be updated from temporary app-scoped fields to permanent homes. Sex and Gender Updates
Upload source file, and run:
And then map to sex (which needs to be done until we have better fields in SIS):
Addresses and Contact Info
complete 10/4/2024
https://vet.admissions.tufts.edu/manage/query/query?id=80377095-a25b-4184-b1a9-0eb3e8649a05
Note that when the expiration date for an address is past, it will not be included in the ranking, and will not show on the student record.
Spot check that the missing address have dates
Spot check Slate and VMCAS are in alignment
Essays and Other Multi-line Text fields
complete 10/4/2024
Personal Statement suppInfo.essa.essa0.essayText
Three month gap explanation gapEducationOrWorkDescrip
Disciplinary Explanation persInfo.otheInfo.infr1.explanation
Performance Explanation persInfo.otheInfo.infr0.explanation
Candidacy Changes since previous application cand_change
Previous Professional Degree Enrollment (new!) previousEnrollmentDescrip
Tufts essay (or video) essay
Why Tufts? progMate.progSele0.custQues.quesBloc4.ques2282441.answerId
Additional Information otherRelevantInformation
I missed ‘Why Tufts’! The recovery: map and watch for next file to come in on the feed – Complete
Pull the field from WebAdmit (which has to be done anyway for all of the text fields to re-format for the line breaks '/n' issues)
WebAdmit Query: 75- Essays and Multiline Text Fields (which lines up with the Slate review query 75. App Review - Essays and Multiline text boxes
**removed all mapping to these fields prior to import, so nothing got written over in the last bit until data freeze.
[For 2026: set up WebAdmit SFTP for these text fields]
Experiences
Review previous year’s Export file in WebAdmit, and update as appropriate.
Download file from WebAdmit
In production, inactivate source format and update the “remap as of” date
Upload file into proper file format and related folder
Review the field mappings
Update the field fusion to add this cycle’s Program ID
Refresh and Update the prompt value mappings
Update the Round Static mapping
Refresh Test, do import, and review
Animal, Veterinary, Research {{YYYY}} VMCAS to Slate Animal Experiences
Volunteer, Non-Animal, Extracurricular {{YYYY}} VMCAS to Slate All
These generate ZIP files, which can be matched to the source formats
Experiences - Animal
Experiences - Employment
Experiences - Extracurricular
Experiences - Research
Experiences - Vet
Experiences - Volunteer
Awards, Honors, Scholarships should have come in on the feed, but I left out the dates; those have now been added to the feed and the incoming data has been reviewed.
License and Certifications (new for 2025!) was mapped, but does not have date. Also found type for group #83 was missing…and there were just 3. Added 11 more, so 14 in total are now available through the API (with dates!).
For both Awards/Honors/Scholarships to correct them I cleaned out the old data, and did the same download and upload process fine.
Licenses and Certifications are a bit trickier, since I can't see how to get the data out of WebAdmit. Asked the Slate CAS group, where I got nothing, and Liaison help desk has been less than helpful. I figured out I can build a flat csv report (where the exports show) for a single grouping (Licenses, or Certifications) save it, then change the type to .zip file and run the export without saving to get the one row per thing format the source formats use.
Note: In the past, these files have been cleaned before uploading; I just added filters in the portal to only show the item if it had a start date, and that seems to have weeded out the phantom rows.
Awards/Honors/Scholarships and Licenses/Certifications are all set in the source format going forward.
GPA Data
10/7/2024 complete
Although the data is not being immediately used, the Reader cutoff score does include the gpas. Grad schools will come over as 0.0 if there is no data, so those need to be adjusted to not blow up the formula.
https://vet.admissions.tufts.edu/manage/query/query?id=1e30e28d-9ec6-458f-a9da-e1d0a36db3f1 is the query to find everyone who has a gpa that is 0.0. There is a field in the query that is set to look for the non-blank records, and we could also restrict so it is just the graduate gpas, but there is no reason not to clean those records as well. [I feel like retention policies are a thing to look at the clean up these blank rows across all of the entities.]
There is no way to map a number field to a blank value, so the spreadsheet has to have the 0.0 values removed, then updated via the Replacing 0.0 in GPA entity rows with blanks source format. This matches the values on GPA GUIDS, VMCAS ID and Slate app ID’s. [That’s a bit wack, mixing the Slate app ID and the VMCAS person ID values, but it works.]
Add Comment