Overview
SS&E Enterprise supports various data feeds. Each data feed, while focused on specific types of information, supports various actions (Insert, Update, or Delete). While all data feeds support Insert and Update, only a subset support deletion. Below find a description of the action type, as well as which data feeds support these actions.
Action Type
Insert : This process identifies new records in the SIS and imports them into SS&E as new records.
Update: This process identifies previously imported records whose data has changed in the SIS and updates them in SS&E. This requires that the record still be in the data feed with its new values.
Delete: This process:
- Retrieves all of the known SIS Ids for the data stream imported from the SIS on the All Ids data stream
- Compares them to the source system ids stored in SS&E
- Then, removes records from the SS&E UI that no longer exist in the SIS.
- Usage of this feature requires that the All Ids method be implemented for the data stream.
- Click here to learn more about SIS Data Deletion Integration via All Ids. This article also explains how to manually delete data that integrates data deletion from the UI.
- By design, SIS Data Deletion Integration via All Ids does NOT remove data from a past term.
- On most Data Feeds that do not integrate data deletion with the SIS (Delete = No) there is no way to remove the imported data from the UI after it has imported into SS&E.
-
- There are a few Data Feeds that do not integrate data deletion with the SIS however there is another method in place that can delete imported data from SS&E.
- Only data feeds that show Delete = No* (have an asterisk) can use a different data deletion method to remove data from the UI, as explained below.
-
- Data deleted by All Ids displays as "Purged By Institution".
| Feed | Insert | Update | Delete |
|
Academic Calendar |
Yes | Yes | No |
| Academic Level | Yes | Yes | No |
| Address Type | Yes | Yes | No |
| Building | Yes | Yes | No |
| Course | Yes | Yes | No |
| Course Equivalency | Yes | Yes | No |
| Course Offering | Yes | Yes | No |
| Course Section | Yes | Yes | Yes** |
| Course Section Schedule Element | Yes | Yes | Yes |
| Degree | Yes | Yes | No |
| Degree Program | Yes | Yes | No |
| Department | Yes | Yes | No |
| High School | Yes | Yes | No |
| Hold | Yes | Yes | No |
| Location | Yes | Yes | Yes |
| Major | Yes | Yes | No |
| Note | Yes | Yes | No |
| Note Type | Yes | Yes | No* |
| Person | Yes | Yes | No |
| Person Academic Plan | Yes | Yes | Yes |
| Person Academic Plan Course | Yes | Yes | Yes |
| Person Address | Yes | Yes | No* |
| Person Application | Yes | Yes | No |
| Person Application Location | Yes | Yes | Yes |
| Person Degree Program | Yes | Yes | No |
| Person FAFSA | Yes | Yes | No |
| Person Financial Aid | Yes | Yes | No |
| Person Financial Aid Award | Yes | Yes | No |
| Person High School | Yes | Yes | Yes* |
| Person Hold | Yes | Yes | Yes* |
| Person Location | Yes | Yes | No |
| Person Phone | Yes | Yes | Yes |
| Person Student Type | Yes | Yes | No* |
| Person Tag | Yes | Yes | No* |
| Phone Type | Yes | Yes | No |
| Prerequisite Course | Yes | Yes | No |
| Prerequisite Group | Yes | Yes | No |
| Prerequisite Permission | Yes | Yes | No |
| Prerequisite Test | Yes | Yes | No |
| Program | Yes | Yes | No |
| Student Type | Yes | Yes | No |
| Subscription | Yes | Yes | No |
| Tag | Yes | Yes | No |
| Test | Yes | Yes | No |
| Test Score | Yes | Yes | Yes |
| Test Type | Yes | Yes | No |
| Transcript | Yes | Yes | No |
| Transcript Course | Yes | Yes | Yes** |
| Transcript Course Attendance | Yes | Yes | No |
| Transcript Course Status History | Yes | Yes | No |
| Transcript Degree | Yes | Yes | Yes |
SIS Import Data Deletion via A Different Method
The following data feeds do NOT support data deletion integration via All Ids, however, based on the SIS Import data definitions, may remove data from the UI (Student Profile) by a different method:
*Note Type "Active = No" removes inactive note type names from displaying in the Note Type dropdown selections when adding a new note or editing an existing note in SS&E. For more information about Note Types Administration, click here.
*Person Address "active=false" removes the person address from displaying in SS&E.
*Person High School "end date" determines when the High School is no longer "attended" by the student. The end date will display on the Student Profile - High Schools section. In addition, the High School start date and end date can both be used to target certain students using Student Filters, along with many other Student High School Filter selection criteria seen here.
- Person High School records imported from the SIS can be removed from the UI via Person High School All Ids.
- Person High School records manually assigned via an Individual Prospect or a Prospect CSV Import cannot be removed via All Ids data deletion integration.
- An automated tag applied when "the student has a specific student type and is attending selected high schools" will be removed from the UI after the person high school record end date "ends", eg. the end date is now in the past, and falls before today's date.
NOTE: If the Person High School record is deleted (either manually or via All Ids) this will not remove the above tag assigned when "the student has a specific student type and is attending selected high schools".
- If an automated tag needs to be removed, the person high school record must first import with an end date in the past - since this is what will remove the tag by the system/a daily job. AFTER the tag is removed, the person high school record can be deleted if it should no longer display on the UI.
*Person Hold In addition to supporting data deletion integration via All Ids, the imported "endDate" determines the end date of a hold on a student record. When null/there is no end date then this means that the hold is "active". A person hold is removed from the UI when the person hold record "ends".
*Person Student Type "end date" removes the Student Type from displaying on the UI. This also removes any automated tag applied to the student with a condition where the student has a specific student type. These tag(s) will be removed from the UI when the person student type record "ends".
*Person Tag "active=false" sets the expiration date that removes the tag from the UI.
Exceptions
There are exceptions to how deletion works for some feeds. See SIS Data Deletion Integration Configuration and Troubleshooting for more detail.
**Course Section All Ids will only check against source system ids associated with course section records in a current or future term.
**Transcript Course All Ids will only check against source system ids associated with transcript course records in a current or future term.