System owners may choose to make user-security related information available to school and center Access Administrators via the Warehouse (and the BusinessObjects User Access Reporting universe), for their use in monitoring and maintenance activities.
Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.
| COMP_APPLICATION_GROUP Table Elements |
DW_ROLES_DESC Table Elements |
| COMP_APPLICATION_USER Table Elements |
DW_ROLES_INDIRECT Table Elements |
| COMP_APPLICATION_USER_GROUP Table Elements |
USER_ACCESS_LIST Table Elements |
| DW_ROLES Table Elements |
WORKDAY_ROLE_SECURITY Table Elements |
The User Access Administration collection is available only to Access Administrators or their designated backups (for a list of current Access Administrators, click here). Access Administrators should use the appropriate form to request access to this data.