All of the SJT (Security Join Tables) jobs that that joins security information from other tables in the database into a temporary table on the application server for use in business rules.
SJT_OPR_CLS: Contains the User IDs with their data permission lists.
SJT_CLASS_ALL: Contains the data permission information for all the data permission lists that are given data access on the ‘Security by Dept Tree’ page or ‘Security by Permission List’ page.
TRANS_SJT_REFRESH: This deals specifically with security that is setup on the transaction tables and if a security object changes that modifies access to transaction data that is needed to run this process.
SJT Tables:
Transaction security tables
| Record | Description |
|---|---|
| SJT_PERSON | Contains transaction data for the people (employees, contingent workers, Person of Interest). It has row level security attributes (SetID, DeptID etc) for all the employees. |
| SJT_PERSON_USF | Stores person related transaction data for USF installations. |
| SJT_DEPT | Stores department related transaction data. |
| HRS_SJT_JO | Stores job opening related transaction data. |
User security tables
| Record | Description |
|---|---|
| SJT_CLASS_ALL | The row security access assigned to a permission list (role based or row security). It contains all the data permission information for all the permission lists that are given data access on the Security by Dept Tree page or Security by Permission List page. |
| SJT_OPR_CLS | Stores which user profiles are assigned which permission lists. Contains the user IDs of people with data permission and the permission lists with data permission that are assigned to them. |
SJT refresh processes have to be run regularly to keep security data (in user and transaction SJTs) up to date so that the system enforces data permission using the most current information.