Both the Session and Candidate tables have Date_registered and Date_active column which always have the same value.
Date_active was meant to be used when someone is set to Active, whereas Date_registered should just be the day that it was created. That is currently not the case.
Discussion required: Should we remove Date_active, or update the code to set the column properly when set to Active?
RegisteredBy / UserID are also always the same in the candidate table
Both the Session and Candidate tables have Date_registered and Date_active column which always have the same value.
Date_active was meant to be used when someone is set to Active, whereas Date_registered should just be the day that it was created. That is currently not the case.
Discussion required: Should we remove Date_active, or update the code to set the column properly when set to Active?
RegisteredBy / UserID are also always the same in the candidate table