> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# StatusValue table

> Values for statuses

## StatusValue Table (199)

Values for statuses

## Fields

| Name                      | Description                                                                                                                            | Type                            | Nullable |
| ------------------------- | -------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------- | :------: |
| StatusValue\_id           | Primary key                                                                                                                            | PK                              |    No    |
| StatusDef\_id             | Link to statusdefinition                                                                                                               | FK [StatusDef](./statusdef.mdx) |    No    |
| contact\_id               | Link to contact, 0 if this status is not for contacts                                                                                  | FK [contact](./contact.mdx)     |    No    |
| person\_id                | Link to person, 0 if this status is not for person (always 0 in 6.0)                                                                   | FK [person](./person.mdx)       |    No    |
| project\_id               | Link to project, 0 if this status is not for project                                                                                   | FK [project](./project.mdx)     |    No    |
| extra1\_id                | Spare ID for future links                                                                                                              | Id                              |    No    |
| extra2\_id                | Spare ID for future links                                                                                                              | Id                              |    No    |
| isSignalled               | 1 = this status is 'true', and the GUI should display it                                                                               | Bool                            |    No    |
| needsUpdate               | 1 = the value is dirty and needs updating; set when the target (contact, project) is changed (or its activities and sales are changed) | Bool                            |    No    |
| registered                | Registered when                                                                                                                        | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                                                                                                                     | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                                                                                                                      | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                                   | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record                                                                                                  | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/3ZhivzBeXAvFeVZx/media/loc/en/database/tables/StatusValue.png?fit=max&auto=format&n=3ZhivzBeXAvFeVZx&q=85&s=be977e8cd62175c867efd31dd84e0173" alt="StatusValue table relationship diagram" width="693" height="661" data-path="media/loc/en/database/tables/StatusValue.png" />

## Indexes

| Fields                                  | Types        | Description |
| --------------------------------------- | ------------ | ----------- |
| StatusDef\_id                           | FK           | Index       |
| contact\_id                             | FK           | Index       |
| person\_id                              | FK           | Index       |
| project\_id                             | FK           | Index       |
| extra1\_id                              | Id           | Index       |
| extra2\_id                              | Id           | Index       |
| isSignalled                             | Bool         | Index       |
| contact\_id, isSignalled, StatusDef\_id | FK, Bool, FK | Index       |
| person\_id, isSignalled, StatusDef\_id  | FK, Bool, FK | Index       |
| project\_id, isSignalled, StatusDef\_id | FK, Bool, FK | Index       |
| extra1\_id, isSignalled, StatusDef\_id  | Id, Bool, FK | Index       |
| extra2\_id, isSignalled, StatusDef\_id  | Id, Bool, FK | Index       |

## Relationships

| Table                    | Description                                                                         |
| ------------------------ | ----------------------------------------------------------------------------------- |
| [associate](./associate) | Employees, resources and other users - except for External persons                  |
| [contact](./contact)     | Companies and Organizations.                                                        |
| [person](./person)       | Persons                                                                             |
| [project](./project)     | Projects                                                                            |
| [StatusDef](./statusdef) | Status definitions. Name and description are in LocaleText for internationalization |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [StatusDef table](/en/database/tables/statusdef.md)
- [Save Status Monitor](/en/api/reference/restful/agent/saint_agent/save-status-monitor.md)
- [Get Status Monitor](/en/api/reference/restful/agent/saint_agent/get-status-monitor.md)
- [Create Default Status Monitor](/en/api/reference/restful/agent/saint_agent/create-default-status-monitor.md)
- [SAINT in Settings and maintenance](/en/saint/admin/index.md)
- [Get Status Monitors](/en/api/reference/restful/agent/saint_agent/get-status-monitors.md)