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. |
| interim | bool |
|
|
The flag to indicate interim budget status. @example false |
| 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) |
|---|---|---|---|
| edge_budgets_pkey | Primary key | Asc | id |
| edge_budgets_approved_by_actor_id_idx | Performance | Asc | approved_by_actor_id |
| edge_budgets_company_id_idx | Performance | Asc | company_id |
| edge_budgets_created_by_actor_id_idx | Performance | Asc | created_by_actor_id |
| edge_budgets_custom_funding_scheme_type_id_idx | Performance | Asc | custom_funding_scheme_type_id |
| edge_budgets_finance_sah_funding_source_id_idx | Performance | Asc | finance_sah_funding_source_id |
| edge_budgets_membership_id_idx | Performance | Asc | membership_id |
| edge_budgets_updated_by_actor_id_idx | Performance | Asc | updated_by_actor_id |