HR Datamart UH Officer Lookup API
- Cameron Ahana
This REST API will pull the first UH Officer in an employee’s supervisor hierarchy. An officer is identified by their job code.
Source Database Information
Located in LastPass vault
folder: Shared-ES Software Engineering Databases
name: ES WS HRDW 9.2
db user: uhapp_micro
table:
API Methods
Retrieve UH Officer record for an employee
Parameter:
UH Number
Given the employee’s UH Number, walk up their supervisor hierarchy in the HR Datamart until it hits the first job code in the list below. For the President (Job Code S100 or UH Number 10101943) and the Director of Internal Audit (Job Code S135 or UH Number 20037229), the UH Officer will be the BOR secretary Yvonne Lau (Job Code S195 or UH Number 11059964). I’d recommend keying against the job code because if people rotate in/out of those job codes, the code doesn’t need to change.
Return: the single record for the given UH Number; pull the Kuali User ID for the UH Number of the UH Officer
Job Code for UH Officers
Job Code | UH Officer |
|---|---|
S100 | System = direct report to President = President = David Lassner |
S106 | System OVPAS = VP Academic Strategy = Debora Halbert |
S165 | System OVPA = VP Administration = Jan Gouveia |
S167 | System OVPBF = VP Budget and Finance = Kalbert Young |
C100 | System CC = VP Community Colleges = Erika Lacro |
S124 | System OVPIT = VP Information Technology = Garret Yoshimi |
S115 | System OVPLA = VP Legal Affairs / University General Counsel = Carrie Okinaga |
S109 | System OVPRI = VP Research and Innovation = Vassilis Syrmos |
M110 | UHM = UHM Provost = Michael Bruno |
GE102 | UHH = UHH Chancellor = Bonnie Irwin |
GE102 | UHWO = UHWO Chancellor = Maenette Benham |
GE102 | Hawaii CC = CC Chancellor = Susan Kazama |
GE102 | Honolulu CC = CC Chancellor = Karen Lee |
GE102 | Kapiolani CC = CC Chancellor = Misaki Takabayashi |
GE102 | Kauai CC = CC Chancellor = Margaret Sanchez |
GE102 | Leeward CC = CC Chancellor = Carlos Penaloza |
GE102 | Maui College = CC Chancellor = Lui Hokoana |
GE102 | Windward CC = CC Chancellor = Ardis Eschenberg |
References