Every now and then we need to check the status of accounts in Activity Insight, we download the list of active users that are staff and faculty. We have the ability to cross check most faculty from a report pulled from Workday, but we are finding that we have to cross check faculty and staff at http://www.work.psu.edu/ldap/ because the faculty may not be appearing in our list. Sometimes the number of faculty/staff we need to double check can be 200 or more and as you can imagine that would take us a lot of time.

What I would like to do is to upload a csv file that contains First Name, Last Name, and PSU Access ID to the FAMS Tool, and it check "ldap" and then update the file we uploaded with the following fields:
EduPerson Primary Affiliation
Title
Business Area
Department
Campus

I will then use these results to disable or enable faculty accounts.
Eventually, I would like to build off of this process so it automatically disables the accounts where the LDAP information comes back with EduPerson Primary Affiliation with "Member" or comes back with the user cannot be found.

Just from first pass:

• Connect to central ldap (maybe make that a class like employee dir)
• Make integration for checking user status
• Make csv importer and exporter (again should be in its own job)
• maybe (big on this) also do auto delete on AI side (maybe have an opt in for this)

After talking to Nicole:

Have the integration take a CSV (which will follow what the example will be), pull relevant info from central LDAP (as defined in this issue), THEN also have the option of disabling (not deleting) faculty if eduPersonPrimaryAffiliation is "member". If this functionality is requested (maybe some sort of button or switch in the front end, sent as a boolean flag), the CSV will also indicate which faculty account has been disabled (a new column, something like now_disabled).

Here is the file we would submit via the tool. We want to make sure if LDAP returns Member they then get disabled in Activity Insight, but if they can't be found in LDAP the response back can be user not found.

LDAP_Check.csv

Include whether or not an user is already disabled. Get this info even when not disabling.