Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| start_date | date |
|
|
The start date of the budgetted period @example ‘2025-01-01’ |
| end_date | date |
|
|
The end date of the budgetted period @example ‘2025-01-01’ |
| funding_scheme_type | varchar |
|
|
The funding scheme for the budget @example ‘hcp’, ‘ndis’, etc. |
| funding_scheme_classification | varchar |
|
|
The classification within the funding scheme @example ‘1’, ‘2’, etc. |
| approved_at | timestamp |
|
|
When the budget was approved @example ‘2025-01-01T00:00:00Z’ |
| company_id | int8 |
|
|
The foreign key to the company record. @example 1 |
| membership_id | int8 |
|
|
The foreign key to the membership record. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| created_by_actor_id | int8 |
|
|
The foreign key for the profile that created the budget. @example 1 |
| updated_by_actor_id | int8 |
|
|
The foreign key for the profile that last updated the budget. @example 1 |
| approved_by_actor_id | int8 |
|
|
The foreign key for the profile that approved the budget. @example 1 |
| funding_scheme_attributes | jsonb |
|
|
A snapshot of funding scheme attributes to support calculations @example {“independence_contribution_rate”: “0.05”} |
| archived_at | timestamp |
|
|
The tiem the budget was archived. @example ‘2025-01-01T00:00:00’ |
| custom_funding_scheme_type_id | int8 |
|
|
The custom funding scheme type id. @example 1. |
| finance_sah_funding_source_id | int8 |
|
|
The support at home funding source id (synced from Services Australia). @example 1. |
| approved_at_in_company_tz | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| archived_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| 0870a38cdf726125a3819ab5f6cb2b11 | Performance | Asc | updated_by_actor_id |
| 389a8f43189e0859d634041a519e9752 | Performance | Asc | approved_by_actor_id |
| 425e2c65896f5dacdcdec5e2304e8c3e | Performance | Asc | finance_sah_funding_source_id |
| 99b202981d429e2904cf0a186dae2a22 | Performance | Asc | custom_funding_scheme_type_id |
| b4ce47c7a73356d4009cb25e951e9f4f | Performance | Asc | company_id |
| c82bf23e5b02c1b9249843234b51497b | Performance | Asc | created_by_actor_id |
| e858279b36d2fb27242fae0443d31ca1 | Performance | Asc | membership_id |