...
Maddy would like to see the DVM prerequisite data in the new format used in the Slate hosted applications.
Research:
Prerequisite update and transition to entities
Should just be a matter of copying courses portal and changing the queries to look for the entity fields. Even if pre-req data is required for reading, we can just do a single download of pre-req data in October, [until we find the work around for the lack of unique identifiers on the data that would allow for matching].
Research:
Prerequisite update and transition to entities
In VMCAS, there are canned (uneditable) report for Prerequisites, and for Coursework - coursework report is ALL courses; we need the Prerequisite report. There is no custom way to get this data out--the report is it.
| Expand | ||
|---|---|---|
| ||
|
In TUSMGP
...
|
In 2023 when the entity was created, the Criterion name was set as a free text field. This had to be inactivated, and a new Criterion Name field linked to the same course_type prompt added.
The problem of bringing pre-req data over on a ongoing basis and not having it just create new rows was addressed by Helen in TUP Prerequisite Course Data missing; to align with that, I inactivated the old Designation field and added a new one that is unique for merging (-u suffix in name).
Outcome:
https://help.liaisonedu.com/Integration/WebAdMIT
Prerequisites for SFTP Delivery has been created in the Report manager in WebAdmit; I uploaded that .csv file to the WebAdMIT API - VMCAS Prerequisite Courses as a starting point for mapping.