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.

If this is a Adjunct Faculty, there might not be a CX user in /etc/passwd for the instructor, thus, make sure to create the record in the userid_table as below:

uid: <Max uid from table + 1>

id_no:  <ParkId>

user_name: <ParkId>

active_date: <current date>

Run the following query to get max id and then increment it:  select max(uid) from userid_table

or simply query ">>" on uid field through senter2 userid_table in CX.

In the above screenshot, then the new record would use 11295 as the new uid.


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 some 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.