HR Datamart PS Role Lookup API

This REST API will pull data from the HR Datamart EDADBA.HR_MANAGEMENT_TBL table.

Located in LastPass vault

A user may have multiple roles. Aggregate the roles into one record.

SELECT LISTAGG(rolename,',') as role
FROM EDADBA.HR_MANAGEMENT_TBL 
WHERE emplid='23689961'
GROUP BY emplid

Parameter:

Return: the single record for the given UH Number; pull the Kuali User ID for each row

Database Column	Label in JSON

Cherwell ticket requesting access to the datamart table

ES Web Services