Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The company that the record belongs to. @example 1 |
| membership_id | int8 |
|
|
The membership the record belongs to. @example 1 |
| budget_id | varchar |
|
|
The external_id for the budget in Services Australia. @example ‘9000007955’ |
| budget_type | varchar |
|
|
The name of the budget from Services Australia. @example ‘Home support ongoing’ |
| budget_type_code | varchar |
|
|
The budget type code from Services Australia. @example ‘ON’ |
| start_date | date |
|
|
The start date of the budget allocation. @example ‘2024-07-01’ |
| end_date | date |
|
|
The end date of the budget allocation. @example ‘2025-06-30’ |
| status | varchar |
|
|
The status of the budget from Services Australia. @example ‘Open’ |
| opening_balance_cents | int4 |
|
|
The total budget amount for time range in cents. @example 5000000 |
| opening_balance_currency | varchar |
|
|
The currency code for the total budget amount. @example ‘AUD’ |
| available_balance_cents | int4 |
|
|
The available budget amount left for the time range in cents. @example 4500000 |
| available_balance_currency | varchar |
|
|
The currency code for the available budget amount. @example ‘AUD’ |
| created_at | timestamp |
|
|
|
| updated_at | 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) |
|---|---|---|---|
| bab0deef08997f06c9c997c29d4f8edb | Performance | Asc | company_id |
| c877fc6660c6e708f037efc43a0a3939 | Performance | Asc | membership_id |
| fff8e8d86d3f6b9024e63c79394aaf21 | Performance | Asc | budget_id |