Skip to main content

Table api_projects

The _api_projects table exposes project entities from Simplicate

Prosper Rabo avatar
Written by Prosper Rabo
Updated this week

⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.

Fields

Field Name

Type

Description

project_id

Integer

Unique identifier for the project

relation_id

Integer

Identifier of the client relation

administration_id

Integer

Identifier of the administration

project_manager_id

Integer

Identifier of the project manager (employee)

project_number

String

Human-readable project number or code

project

String

Name or title of the project

project_status

String

Current status of the project (e.g., active, completed, on hold)

is_project_billable

String

Indicates whether the project is billable to the client (yes/no)

project_category

String

Category of project: direct (billable) or indirect (non-billable)

project_start_date

Date

Planned or actual start date of the project

project_end_date

Date

Planned or actual end date of the project

date_created

DateTime

Date when the project was created in the system

date_updated

DateTime

Date when the project was last updated

Deprecated Fields

⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.

Deprecated Field

Type

Recommended Alternative

key_project_id

Integer

Use project_id instead

key_administration_id

Integer

Use administration_id instead

key_project_manager_id

Integer

Use project_manager_id instead

project_name

String

Use project instead

is_billable

String

Use is_project_billable instead

start_date

Date

Use project_start_date instead

end_date

Date

Use project_end_date instead

Related Tables

  • _api_project_services - Project services via project_id

  • _api_project_assignments - Project assignments via project_id

  • _api_relations - Client details via relation_id

  • _api_employees - Project manager details via project_manager_id

  • _api_administrations - Administration details via administration_id

  • _api_project_custom_fields - Custom fields for projects via project_id

Did this answer your question?