Database view containing employee status in Employee Master

Need database view and column that contains the status of an employee in Employee Master program

• SSRS Reports

• Crystal Reports

• Enterprise ERP(Munis)

Need status to fetch active employees through a custom report

This field can be seen in EERP in Employee Master program under the section Employee Identification.

This status is available through TRS view pr_employee_master under column e_activity_status.