HEA Compatibility - Program Enrollment table compliancy
- Johnathan Clark
-
Version 9.6.0.0
Foundry’s Program Enrollment table (foundry_programenrollment) has been replaced with Microsoft’s Program Enrollment table (mshied_programenrollment) to meet compatibility requirements with Microsoft's Higher Education Accelerator (HEA) v.5.
Foundry's update to Microsoft’s Higher Education Accelerator (HEA) v.5 for greymatter version 9.6 includes a new Program Enrollment Table from the HEA. This new table replaces all previous Foundry-built Program Enrollment columns except those for Contact and Program Plan, which remain available and hosted in the greymatter layer.
The table below compares the columns previously available in the foundry_programenrollment table for greymatter v.9.5 with HEA v.4 against the columns now available in the mshied_programenrollment table for greymatter v.9.6 with HEA v.5.
| greymatter v.9.5 Columns in foundry_programenrollment | greymatter v.9.6 Columns in mshied_programenrollment |
| foundry_contactid | foundry_contactid |
| foundry_contactidname | foundry_contactidname |
| foundry_contactidyominame | foundry_contactidyominame |
| - | mshied_EducationOrganizationId |
| - | mshied_EducationOrganizationIdName |
| - | mshied_EducationOrganizationIdYomiName |
| - | mshied_EndDate |
| - | mshied_ExitReason |
| - | mshied_exitreasonName |
| foundry_name | mshied_name |
| foundry_program | mshied_programid |
| foundry_programenrollmentid | mshied_programenrollmentid |
| foundry_programplan | foundry_programplan |
| foundry_programplanname | foundry_programplanname |
| foundry_startterm | foundry_startterm |
| foundry_starttermname | foundry_starttermname |
| foundry_student | mshied_studentid |
| foundry_studentname | mshied_studentidname |
| foundry_studentyominame | mshied_studentidyominame |