HR Datamart Employee Lookup API
- Cameron Ahana
This REST API will pull data from the HR Datamart psempl table.
Source Database Information
Located in LastPass vault
folder: Shared-ES Software Engineering Databases
name: ES WS HRDW 9.2
table: edadba.uhapp_micro_psempl
API Methods
Retrieve Employee Records
Parameter:
UH Number
Return: the employee record objects based on the given UH Number
Retrieve Employee Record
Parameter:
UH NumberPosition Number
Return: the employee record object based on the given UH Number and Position Number
Retrieve Primary Employee Record
Parameter:
UH Number
Return: the employee record object based on the given UH Number and job_indicator='P'
Employee Record Object
Database Column | Label in JSON |
|---|---|
employee_alt_id | uh_number |
name | name |
empl_record_no | record_number |
position_no | position_number |
job_title | job_title |
job_code | job_code |
eac | eac |
eac_division_desc | division |
eac_branch_desc | branch |
eac_section_desc | section |
campus_key | campus |
empl_status | status |
fte_person | fte |
fte_total | fte_total |
union_code | bargaining_unit |
functional_code | functional_code |
job_indicator | job_indicator |
sal_admin_plan | salary_admin_plan |
employee_type_code | employee_type_code |
deptId | deptId |
dept_descr | dept_descr |
ps_jobcode | ps_jobcode |
grade | grade |
Sample Query
SELECT *
FROM edadba.uhapp_micro_psempl
WHERE employee_alt_id=?
ORDER BY record_no;References
Cherwell ticket requesting to create a user with access to the HR Datamart table psempl, which is modeled after the leave_psempl table.
Cherwell ticket to synch database columns with leave_psempl.