If a faculty member is not able to log in, or they do not have the faculty tab. The following items need to be checked.
1.) That they are assigned to faculty in the role_rec
- This tells CX that a person should be in MyPark and check the end date
2.) That they have a record in the userid_table for their account
- It will reject a person and not give a person a faculty role because faculty need to enter grades/attendance and for an audit trail there needs to be a record with the userid_table granting that rights.
3.) There may be a jenzcst_rec record that would negate the person being in the role_rec
4.) If the above conditions are all OK and the JenzUpload is still not capturing the user to display the Faculty tab, then check and remove (in case it exists) the respective record in the mirror table for roles (jenzcst_rec), so that its deletion will allow jenzupload to add back the Faculty role in JICS/MyPark.
SELECT * FROM jenzcst_rec
WHERE host_id = ##PARK_ID##
AND status_code = 'FAC'
According to Jenzabar, such a scenario can occur when a person was previously assigned a Faculty role and perhaps come clean-up script comes along and removes it from the system but leaves the mirror table record intact. The mirror table basically tells jenzupload that the Faculty role was present when in actuality it was not, thus ignoring its addition. Deleting mirror table records will often tell jenzuplaod to re-sync things if it believes stuff is missing.