Oracle API
Hi,
Good Day.
I would like to request assistance to create and develop a custom package/ procedure to write a logic to return the required columns from base tables based on employee_id and email, and also call this package from a concurrent program and generate the XML output.
Please see the requirements below:
Request Parameters:
- Employee ID
- UP Email
Response Fields:
-Fullname (Lastname, Firstname, Middle Name/Initial)
-Employee ID
-UP Mail
-Campus
-College, Unit, Or Office
-Category (Faculty/REPS/Admin/UP Contractual/Non-UP Contractual) - For Faculty members, can we also determine whether they are full-time or part-time?
-Employment Status (Active/Inactive)