Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| status | varchar |
|
|
The status of the claim. @example preparing |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| name | varchar |
|
|
The user defined name for the claim. @example “July 2025”. |
| description | varchar |
|
|
Optional description with more details about the claim. @example “Our claim for July 2025”. |
| created_by_id | int8 |
|
|
The profile id of the creator of the claim. @example 1. |
| exported_at | timestamp |
|
|
The time the claim was exported from Lookout to be uploaded to Services Australia. @example 2025-07-01T00:00:00Z |
| imported_at | timestamp |
|
|
The time the claim was imported from Services Australia into Lookout. @example 2025-07-01T00:00:00Z |
| finalised_at | timestamp |
|
|
The time the claim was finalised. @example 2025-07-01T00:00:00Z |
| services_australia_identifier_id | int8 |
|
|
The Services Australia identifier (NAPS ID) for the claim. @example 1. |
| reviewed_at | timestamp |
|
|
The timestamp of when the claim was reviewed and marked as ready to finalise. @example 2025-01-01T00:00:00Z |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| exported_at_in_company_tz | timestamp |
|
|
|
| imported_at_in_company_tz | timestamp |
|
|
|
| finalised_at_in_company_tz | timestamp |
|
|
|
| reviewed_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 9bd43657a43514810a412b6917ca752a | Performance | Asc | services_australia_identifier_id |
| a515c66367f07f0db10ffd62331c0c95 | Performance | Asc | created_by_id |
| d5acca6b7732eb38e7520f34dbc79aea | Performance | Asc | company_id |