# Goal & KPI Entities {#goal--kpi-entities}


Entities for goals, OKRs, KPIs, key results, and goal templates.


## Goal {#goal}


| Column               | Type    | Description                        |
| -------------------- | ------- | ---------------------------------- |
| `name`               | string  | Goal name                          |
| `description`        | string? | Description                        |
| `deadline`           | string  | Deadline period                    |
| `level`              | enum    | `ORGANIZATION`, `TEAM`, `EMPLOYEE` |
| `progress`           | number  | Progress percentage                |
| `ownerEmployeeId`    | UUID?   | FK to owning employee              |
| `ownerTeamId`        | UUID?   | FK to owning team                  |
| `leadId`             | UUID?   | FK to lead employee                |
| `alignedKeyResultId` | UUID?   | FK to aligned key result           |

**Relations:** `keyResults` (OneToMany KeyResult), `ownerEmployee` (ManyToOne Employee), `ownerTeam` (ManyToOne OrganizationTeam)


## KeyResult {#keyresult}


| Column         | Type    | Description                                          |
| -------------- | ------- | ---------------------------------------------------- |
| `name`         | string  | Key result name                                      |
| `description`  | string? | Description                                          |
| `type`         | enum    | `NUMERICAL`, `TRUE_FALSE`, `CURRENCY`, `TASK`        |
| `targetValue`  | number? | Target value                                         |
| `initialValue` | number? | Starting value                                       |
| `update`       | number? | Current value                                        |
| `progress`     | number  | Progress percentage                                  |
| `deadline`     | string  | Deadline period                                      |
| `softDeadline` | Date?   | Soft deadline                                        |
| `hardDeadline` | Date?   | Hard deadline                                        |
| `status`       | enum    | `ON_TRACK`, `NEEDS_ATTENTION`, `AT_RISK`, `NONE_SET` |
| `weight`       | enum?   | Importance weight                                    |
| `goalId`       | UUID    | FK to goal                                           |
| `ownerId`      | UUID?   | FK to employee owner                                 |
| `leadId`       | UUID?   | FK to lead employee                                  |
| `projectId`    | UUID?   | FK to project                                        |
| `taskId`       | UUID?   | FK to task                                           |


## GoalKPI {#goalkpi}


| Column         | Type    | Description                                   |
| -------------- | ------- | --------------------------------------------- |
| `name`         | string  | KPI name                                      |
| `description`  | string? | Description                                   |
| `type`         | enum    | `NUMERICAL`, `TRUE_FALSE`, `CURRENCY`, `TASK` |
| `unit`         | string? | Measurement unit                              |
| `operator`     | enum    | `>=`, `<=`, `=`                               |
| `currentValue` | number  | Current value                                 |
| `targetValue`  | number  | Target value                                  |
| `leadId`       | UUID?   | FK to lead employee                           |


## GoalTemplate / KeyResultTemplate / GoalKPITemplate {#goaltemplate--keyresulttemplate--goalkpitemplate}


Template versions of goals, key results, and KPIs for reuse.


## GoalTimeFrame {#goaltimeframe}


| Column      | Type   | Description       |
| ----------- | ------ | ----------------- |
| `name`      | string | Time frame name   |
| `status`    | enum   | Time frame status |
| `startDate` | Date   | Start date        |
| `endDate`   | Date   | End date          |


## GoalGeneralSetting {#goalgeneralsetting}


| Column                       | Type    | Description                 |
| ---------------------------- | ------- | --------------------------- |
| `maxObjectives`              | number  | Max objectives per employee |
| `maxKeyResults`              | number  | Max KRs per objective       |
| `employeeCanCreateObjective` | boolean | Self-service creation       |
| `canSeeAllObjectives`        | boolean | Visibility                  |


## Related Pages {#related-pages}


- [Goal Endpoints](https://sourcey-gauzy.pages.dev/api/goal-endpoints/index.md) — API reference
- [Goals & KPIs](https://sourcey-gauzy.pages.dev/features/goals-and-kpis/index.md) — feature guide
- [Goals & OKRs](https://sourcey-gauzy.pages.dev/features/goals-and-okrs/index.md) — OKR methodology