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 |
|
|
|
| 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) |
|---|---|---|---|
| 597867330e910c767d91e89fd3758af3 | Performance | Asc | services_australia_identifier_id |
| a4c42de6a4c27746f10bd0266061140d | Performance | Asc | company_id |
| cf6297509f701f0a961ce1eb914cfcff | Performance | Asc | created_by_id |