WORKDAY_ROLE_SECURITY Table - Data Element Index   Tables and Data Elements   Human Capital Management Home   Data Warehouse Home

WORKDAY_ROLE_SECURITY Table

Explanation
The WORKDAY_ROLE_SECURITY table contains information about users of the Workday application.

Common Uses
Determining who has access to Workday and their security roles within the application.

Primary Key	Indexed Data Elements	Related Tables
	PENN_ID PRI_PENN_COST_CENTER PRI_PENN_SCH_CTR ROLE_ACADEMIC_UNIT_ID ROLE_SUPERVISORY_ORG_ID SECURITY_ROLE_DESC SECURITY_ROLE_ID WORKDAY_ID	EMPLOYEE_GENERAL (DWADMIN) HCM_ACADEMIC_UNIT (DWHCM) HCM_PARENT_ACADEMIC_UNIT (DWHCM) HCM_PARENT_SUPERVISORY_ORG (DWHCM) HCM_PERSON (DWHCM) HCM_SUPERVISORY_ORG (DWHCM) USER_ACCESS_LIST (DWHCM)

Cautions

• WORKDAY_ROLES_SECURITY is secured by center, and is available only to Access Administrators, for the center(s) in their area of responsibility. Access Administrators will be able to view records in this table for any individuals whose primary position school/center is in their area of responsibility.

• In Workday, users are granted access to specific Supervisory Organizations and/or Academic Units. To determine the 4-digit ORG_CODEs to which these assignments correspond, join to the reference tables for academic units or supervisory organizations noted above. Some of these units or organizations may be parents of others, resulting in the user having access to the parent and all its children.

• The WORKDAY_ROLES_SECURITY table is stored in the DWHCM schema in the Data Warehouse.

Source

Workday, in use at Penn since July 2019.

WORKDAY_ROLE_SECURITY Table - Data Element Index   Tables and Data Elements   Human Capital Management Home   Data Warehouse Home