edge_budgets


Description

Budgets for periods of client care

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. Australia/Brisbane.

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

Relationships