Tables


Analysis of schema "lookout_analytics_edge"

Raw tables and views from the Lookout application database.

Generated on Thu Dec 04 06:26 UTC 2025

Tables

Table / View Columns Type Comments
edge_finance_sah_client_contributions 13 Table

A current and historical list of Support at Home programme client contributions rates per membership
edge_services_third_party_provider_rates 9 Table
edge_automatic_must_do_templates 12 Table
edge_communities_memberships 4 Table
edge_events 13 Table
edge_helper_verification_renewals 13 Table
edge_match_requests 20 Table
edge_helper_leave_period_actions 13 Table
edge_purchase_order_lines_services 9 Table
edge_recurrences 11 Table

A set of data to support recurrences for shifts and breaks.
edge_shifts 18 Table
edge_roster_items 17 Table
edge_services_australia_identifiers 9 Table
edge_supplier_generated_invoices 14 Table
edge_ticket_tags 11 Table
edge_focal_assessments_norton_scales 12 Table
edge_payroll_award_agreements_higher_duties_services 9 Table
edge_finance_hcp_rates 6 Table
edge_focal_assessments_braden_scales 13 Table
edge_helper_leave_reasons 10 Table
edge_finance_sah_commonwealth_unspent_funds 12 Table

A list of Support at Home programme commonwealth unspent funds per membership
edge_ticket_categories 10 Table
edge_profiles 11 Table
edge_payroll_award_agreements_higher_duties 10 Table
edge_archive_reasons 13 Table
edge_visit_cancelation_reasons 18 Table
edge_custom_funding_scheme_types 10 Table

User generated funding scheme types.
edge_contract_prices 14 Table
edge_helpers 28 Table
edge_contracts 14 Table
edge_billing_runs 12 Table
edge_help_plans 10 Table
edge_finance_sah_subsidies 9 Table

A list of Support at Home subsidy amounts. This is a global table.
edge_communities 11 Table
edge_helper_tag_categories 11 Table
edge_discussions_discussions 13 Table
edge_finance_sah_payment_statement_item_budget_lines 11 Table

The budget usage(s) for each payment response items from Services Australia for SAH claims @visibility external
edge_payroll_award_rules 18 Table
edge_availability_schedules 15 Table
edge_focal_assessments_kesslers 17 Table
edge_finance_hcp_daily_rates 9 Table
edge_cohorts 10 Table
edge_products 50 Table
edge_funding_schemes 29 Table
edge_community_roles 9 Table
edge_services 16 Table
edge_focal_assessments_mini_nutritionals 14 Table
edge_staffers 12 Table

Contains information about staff members within the company, including their roles, bio, access info, etc.
edge_attendees 13 Table
edge_budget_service_plan_services 4 Table
edge_visits 48 Table
edge_payroll_award_streams 9 Table
edge_staffer_roles 11 Table

A collection of permissions that are granted to each staffer associated with the role. These are also known as Access Roles.
edge_helper_verification_files 10 Table
edge_contract_client_transport_prices 14 Table
edge_budgets 22 Table
edge_invoice_lines 19 Table
edge_payroll_award_agreements 10 Table
edge_payroll_award_versions 12 Table
edge_finance_sah_statement_periods 12 Table

Represents a period for which statements are released for Support at Home clients
edge_cohort_participations 13 Table
edge_finance_membership_hcp_rates 15 Table
edge_opportunities 17 Table
edge_finance_accounts 11 Table
edge_automatic_must_dos 14 Table
edge_bulk_actions 11 Table
edge_focal_assessments_caregiver_strain_indices 20 Table
edge_finance_sah_entitlements 13 Table

The components that make up a budget received from Services Australia
edge_users 19 Table
edge_focal_assessments_pascds 28 Table
edge_availability_schedules_rules 12 Table
edge_provider_travel_rates 29 Table
edge_finance_sah_claims 18 Table

Represents a Support at Home claim within Lookout
edge_payroll_award_agreements_higher_duties_custom_schemes 9 Table
edge_dva_referral_plans 17 Table
edge_finance_sah_classifications 15 Table

A current and historical list of Support at Home programme classifications per membership
edge_invoices 33 Table
edge_client_transport_rates 26 Table
edge_invoice_lines_services 9 Table
edge_focal_assessments_frats 24 Table
edge_helper_verifications 11 Table
edge_third_party_provider_rates 17 Table
edge_budget_expenses 15 Table
edge_payroll_award_rules_inputs 14 Table
edge_focal_assessments_frop_coms 33 Table
edge_payroll_award_classifications 14 Table
edge_budget_incomes 15 Table
edge_finance_hcp_claims 16 Table
edge_finance_sah_supplements 11 Table

A current and historical list of Support at Home programme supplements per membership
edge_tickets 22 Table
edge_visit_logs 9 Table
edge_agreement_templates 12 Table
edge_membership_plans 24 Table
edge_finance_transactions 20 Table
edge_help_plan_entries 11 Table
edge_purchase_orders 10 Table
edge_payroll_awards 10 Table
edge_purchase_order_lines 31 Table
edge_focal_assessments_abbey_pain_scales 14 Table
edge_billable_price_metadata 9 Table
edge_discussions_messages 12 Table
edge_agreement_templates_ticket_categories 4 Table
edge_custom_attributes 17 Table
edge_budget_service_plans 58 Table
edge_focal_assessments 18 Table
edge_verifications 11 Table
edge_time_tracking_logs 19 Table
edge_contract_provider_travel_prices 14 Table
edge_shift_breaks 17 Table
edge_budget_tracking_expenses 18 Table
edge_comments 10 Table
edge_surveys 16 Table
edge_helper_prices 14 Table
edge_helper_agreements 12 Table
edge_observations 21 Table
edge_budget_signing_requests 14 Table
edge_focal_assessments_cams 11 Table
edge_custom_attribute_values 11 Table
edge_custom_attribute_options 10 Table
edge_finance_sah_funding_sources 18 Table

This represents a budget from Services Australia.
edge_memberships 40 Table
edge_finance_sah_payment_statement_items 17 Table

The payment response items from Services Australia for SAH claims
edge_ticket_templates 14 Table
edge_communities_helpers 10 Table