Known Issue - Delete Partial(Incomplete) records from the Online Enrollment Import list can produce an error

When a Partial(Incomplete) Online Enrollment record is deleted from the Import list, the Registration End Date (STU.RED) is not being updated, leaving a NULL value. When the Deleted filter is chosen an error is produced because there is no Registration End Date. We are aware of the issue and working on a fix. In the meantime the following SQL query can be run to update STU.RED which will clear the error. We recommend not deleting Partial(Incomplete) records until the issue is fixed. Deleting Pending Imports does not produce an error.


USE AeriesRegistration <--your Registration Database name goes here.

 --SELECT * FROM STU

UPDATE STU

SET RED = '2020-06-24 12:00:00.000' <--Enter the date of deletion

WHERE  (RES = 'D') AND (RED IS NULL)


You may follow this Idea here: https://ideas.aeries.com/forums/926386/suggestions/40800535

Login to post a comment