Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| description | varchar |
|
|
An optional description of the action taken. @example: ‘Reviewed care plan’ |
| duration | interval |
|
|
The duration in minutes. @example: ‘15’ |
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| membership_id | int8 |
|
|
The id of the membership associated with the time tracking log. @example ‘1’ |
| created_by_id | int8 |
|
|
The foreign key to the profile which created the record. @example 1 |
| source_type | varchar |
|
|
The type of the optional underlying source. @example: Ticket |
| source_id | int8 |
|
|
The id of the optional underlying source. @example: Ticket |
| product_id | int8 |
|
|
The foreign key to the product for the record. @example 1 |
| invoiced_at | timestamp |
|
|
The time this time tracking log was invoiced at. @example 2025-07-01T00:00:00Z |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| took_place_on | date |
|
|
The date on which the tracked time took place. @example: 2025-08-06 |
| sah_funding_source | varchar |
|
|
The Support at Home funding source for care management. @example ‘RC’ |
| external_system_id | varchar |
|
|
An optional id to cross reference with another system. @example ABC-123 |
| person_involved_id | int8 |
|
|
The id of the person to whom this time tracking relates. Will generally be the member, but may be authorised representative, billing recipient, etc. @example 1 |
| invoiced_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 0cd93af235c6fbee59099bc931a554d6 | Performance | Asc | created_by_id |
| 502eae1ce702862f07ec86f0eada0a7b | Performance | Asc | product_id |
| 7b394eebb94664a9432760de207e8916 | Performance | Asc | external_system_id |
| 82e0de328ca734ca222d6a64ea967fe0 | Performance | Asc | source_id |
| 8d365387458037d14aad7ddeb411f94e | Performance | Asc | person_involved_id |
| bb0704c742256ee799dd9d6f4fc1c9b0 | Performance | Asc | company_id |
| f0cf387b421d3ae233d3a6c0d895ded2 | Performance | Asc | membership_id |