api_employees

Description

The api_employees table exposes employee information including their identifiers, names, types, and status.

Fields

Field Name	Type	Description
employee_id	Integer	Unique identifier for the employee
supervisor_employee_id	Integer	Unique identifier of the employee's supervisor
employee	String	Full name of the employee
employee_initials	String	Employee initials
employee_type	String	Type or category of employee (e.g., permanent, contractor, intern)
employee_status	String	Current status of the employee (e.g., active, inactive, terminated)

Related Tables

• api_teams_to_employees_bridge - Team memberships via employee_id
• api_time_registrations - Time registrations via employee_id
• api_employee_timesheet - Timesheet data via employee_id
• api_project_assignments - Project assignments via employee_id
• api_employee_custom_fields - Custom fields via employee_id