Tables


Analysis of schema "lookout_analytics_edge"

Raw tables and views from the Lookout application database.

Generated on Thu Apr 16 07:16 UTC 2026

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_membership_notes 18 Table
edge_services_third_party_provider_rates 9 Table
edge_automatic_must_do_templates 12 Table
edge_finance_sah_service_codes 19 Table

Reference data for Support at Home service codes, derived from the Services Australia services list. Each row represents a unique billable combination of service, wraparound, item, and health professional type. @visibility external
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_survey_schedules 15 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_notifications_notifications 13 Table
edge_services_australia_identifiers 9 Table
edge_supplier_generated_invoices 14 Table
edge_services_visits 4 Table
edge_suggested_visits 29 Table
edge_ticket_tags 11 Table
edge_companies 9 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_company_hosts 10 Table
edge_ticket_categories 10 Table
edge_profiles 11 Table
edge_members 10 Table
edge_payroll_award_agreements_higher_duties 10 Table
edge_archive_reasons 13 Table
edge_incidents 14 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 27 Table
edge_survey_question_option_exception_preferences 5 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_survey_questions 20 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_observation_actions_observations 4 Table
edge_payroll_award_rules 18 Table
edge_availability_schedules 15 Table
edge_focal_assessments_kesslers 17 Table
edge_profiles_tickets 4 Table
edge_finance_hcp_daily_rates 9 Table
edge_requisites 10 Table
edge_cohorts 10 Table
edge_helpers_memberships 4 Table
edge_products 50 Table
edge_suggested_visits_services 4 Table
edge_funding_schemes 29 Table
edge_community_roles 9 Table
edge_services 16 Table
edge_focal_assessments_mini_nutritionals 14 Table
edge_staffers 9 Table
edge_insights 20 Table
edge_attendees 13 Table
edge_independent_contractor_invoices 15 Table

Invoices for independent contractor helpers.
edge_budget_service_plan_services 4 Table
edge_observation_categories 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_tags 9 Table
edge_helper_verification_files 10 Table
edge_contract_client_transport_prices 14 Table
edge_budgets 23 Table

Budgets for periods of client care
edge_invoice_lines 29 Table
edge_third_party_services 16 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_membership_leave_periods 14 Table
edge_finance_accounts 11 Table
edge_survey_request_responses 7 Table
edge_requisites_verifications 9 Table
edge_survey_question_options 7 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_notifications_devices 9 Table
edge_must_dos 14 Table
edge_users 19 Table
edge_focal_assessments_pascds 28 Table
edge_observation_actions 4 Table

A list of observation actions. This is a global table.
edge_observation_categories_observations 4 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_should_knows 11 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_verification_file_types 10 Table
edge_ticket_todos 11 Table
edge_membership_agreements 12 Table
edge_memberships_requisites 9 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_schedule_rules_services 4 Table
edge_helpers_services 4 Table
edge_incident_categorisations 19 Table
edge_incident_actions 28 Table
edge_survey_question_exception_preferences 5 Table
edge_purchase_orders 10 Table
edge_observation_metadata 7 Table
edge_payroll_awards 10 Table
edge_purchase_order_lines 54 Table
edge_focal_assessments_abbey_pain_scales 14 Table
edge_schedule_rules 25 Table
edge_billable_price_metadata 9 Table
edge_discussions_messages 12 Table
edge_care_plan_templates 12 Table
edge_independent_contractor_invoice_lines 23 Table

Invoice lines for independent contractor helpers.
edge_notifications_settings 13 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_leave_periods 13 Table
edge_referrals 16 Table
edge_referral_invitations 13 Table
edge_helper_prices 14 Table
edge_ticket_tags_tickets 4 Table
edge_helper_agreements 12 Table
edge_observations 21 Table
edge_survey_requests 18 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 20 Table

This represents a budget from Services Australia.
edge_memberships 43 Table
edge_finance_sah_payment_statement_items 35 Table

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