Data Model
Containing all documentation on the tables and fields that make up the Insights API data model.
By Prosper and 1 other2 authors23 articles
Insights API DatamodelThis documentation covers all tables available through the Simplicate SQL API, which is accessible via a PostgreSQL protocol compatible interface.
Custom Fields TablesThese tables show Simplicate custom field values per entity type. They share the same structure but link to different parent entities and store organization-specific information.
Table api_administrationsCompany entities/business units
Table api_employeesThe _api_employees table exposes employee information including names, types, and status.
Table api_teamsThe _api_teams table exposes team entities configured in Simplicate.
Table api_teams_to_employees_bridgeThe api_teams_to_employees_bridge table is a bridge table that links employees to their teams. An employee can belong to multiple teams, and a team can have multiple employees.
Table api_relations
Table api_projectsThe _api_projects table exposes project entities from Simplicate
Table api_project_servicesThe api_project_services table exposes project service entities, which represent the individual services configured within a project.
Table api_project_assignmentsThe _api_project_assignments table exposes project assignment entities, which represent the assignment of employees to specific project services and item types.
Table api_invoicelinesThe api_invoicelines table exposes individual invoice line items, including pricing and links to projects, services, and revenue groups.
Table api_invoicesThe api_invoices table exposes invoice header information from Simplicate's invoicing module.
Table api_salesThe _api_sales table exposes sales/opportunity entities from Simplicate
Table api_workflowsThe api_workflows table exposes workflow entities, which represent tasks and their progress through defined workflow steps.
Table api_item_typesThe api_item_types table exposes item type entities, which represent different types of hours or costs that can be registered in Simplicate.
Table api_time_registrationsThe api_time_registrations table exposes individual time registration entries, including hours, values, and related metadata.
Table api_revenuegroupsThe api_revenuegroups table exposes revenue group entities, which are used to categorize revenue for reporting purposes.
Table api_employee_timesheetThe api_employee_timesheet table exposes aggregated timesheet data per employee per day, including productivity metrics, hours breakdown, and targets.
Table api_project_assignments_factsThe api_project_assignments_facts table exposes time-series data about project assignments, including assigned and registered hours and values per date/month.
Table api_project_service_costsThe api_project_service_costs table exposes cost registrations on project services, including purchase and selling values.
Table api_project_service_date_factsThe api_project_service_date_facts table exposes time-series financial data for project services, including registered values, invoice values, and costs per date.
Table api_project_service_cost_budgetsThe api_project_service_cost_budgets table exposes cost budget information configured for project services, broken down by item type.
Table api_project_service_hour_budgetsThe api_project_service_hour_budgets table exposes hour budget information configured for project services, broken down by item type.