Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| client_name | varchar |
|
|
The client name @example ‘Mary Beth’ |
| description | varchar |
|
|
An optional internal description @example ‘Proposed changes’ |
| 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) |
|---|---|---|---|
| 0ed810a663c09509805802f23dbca616 | Performance | Asc | company_id |
| 36bb19f92c115d5b3f65762b9675a53d | Performance | Asc | updated_by_actor_id |
| 3e968259eb8fd5b9b38e99680bc48d5b | Performance | Asc | finance_sah_funding_source_id |
| 4ad6a489b0a272398dbeafc79f3bc87c | Performance | Asc | approved_by_actor_id |
| 644767ab856bdfa36bb58f01f4da82a4 | Performance | Asc | custom_funding_scheme_type_id |
| 7234c41c7ae7082c2de4babb82b1da7c | Performance | Asc | membership_id |
| d846b1f3a19a48a42178270c05091395 | Performance | Asc | created_by_actor_id |