Database view containing supervisor details of an employee

Client needs TRS view containing supervisor's id for a given employee

• SSRS reports

• Crystal reports

• Supervisor

• Payroll

• Human Resources

• TRS views

View database column option does not show view name

Employee's supervisor ID is available in TRS view pr_employee_master under column e_supervisor. Replace XXXX in the last line of the following query with an employee ID to view their supervisor ID.

SELECT

a_employee_number,

a_name_first,

a_name_last,

e_supervisor

FROM

pr_employee_master

WHERE a_employee_number = XXXX