Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

Source Database Information

Located in LastPass vault

  • folder: Shared-ES Software Engineering Databases

  • name: ES WS HRDW 9.2

  • db user: uhapp_micro

  • table: edadba.HR_MANAGEMENT_TBL

API Methods

Retrieve PS Role Records for an employee

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:

  • UH Number

Return: the single record for the given UH Number

PS Role Record Object

Database Column

Label in JSON

employee_alt_id

uh_number

References

Cherwell ticket requesting access to the datamart table

  • No labels