Course History institutions (CHI) - Add a method to "move" CHI referenced records to new CHI number
Course History institutions (CHI) is a "mess" in our installation, as historically users entered data with misspellings or not checking to see if it was already there. It's tedious and "dangerous" to consolidate and realign these CHI records and the referenced records. Please provide a way to combine and/or move referenced records to a new CHI number?
kday
shared this idea
-
Eliud Garnica
commented
Please review the suggestion in this ticket as a potential solution to this issue:
Add a status field to CHI table (Course History):
https://ideas.aeries.com/forums/925735-aeries-ideas/suggestions/43360392-add-a-status-field-to-chi-table-course-history
.
Adding a Status field with values such as Active and Inactive to the CHI table would help prevent the reuse of invalid entries. Additionally, providing a way to combine or move reference records would greatly facilitate the cleanup of this table. The status field is used in many tables: CRS, TCH, STF.tg, etc.
