All Lookout Analytics and BYOBI schema changes will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning, adapted for use with schema versioning.
- Changes to
edge_availability_schedules. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_availability_schedules_rules. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_must_do_templates. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_event_times. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_membership_plan_services. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_profiles. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_time_tracking_logs. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_ticket_snoozes. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_vhc_service_plans. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_visit_helper_locations. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_purchase_orders. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_pricing_component_sets. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_payroll_shift_cost_lines. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_incompatibilities. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_care_plan_risks. Lookout Analytics documentation or BYOBI documentation.
- Updated documentation in
edge_helper_tag_categories. Lookout Analytics documentation or BYOBI documentation.
- Updated documentation in
edge_tags. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_memberships_tags. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_risk_categories. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_templates_risk_categories. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_templates. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_responses. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_response_interpretations. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_response_history_summaries. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_custom_forms_requests. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_action_text_rich_texts. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_notifications_devices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_notifications_notifications. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_notifications_settings. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_help_plans. Lookout Analytics documentation or BYOBI documentation:- Removed
template_librarycolumn.
- Removed
- Changes to
edge_help_plans. Lookout Analytics documentation or BYOBI documentation:- Added the
care_plan_template_idcolumn.
- Added the
- Added
edge_referral_invitations. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_incidents. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_question_option_exception_preferences. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_membership_leave_periods. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_care_plan_templates. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_request_responses. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_companies. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_company_hosts. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_leave_periods. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_requisites_verifications. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_ticket_todos. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_tags. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_third_party_services. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_verification_file_types. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_schedules. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_requests. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_suggested_visits. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_question_options. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_schedule_rules. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_suggested_visits_services. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_independent_contractor_invoices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_observation_metadata. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_observation_actions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_observation_categories. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_service_codes. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_membership_notes. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_referrals. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_must_dos. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_membership_agreements. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_survey_question_exception_preferences. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_survey_questions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_observation_actions_observations. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_requisites. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_should_knows. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_incident_categorisations. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_schedule_rules_services. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_services_visits. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_observation_categories_observations. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_memberships_requisites. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_memberships. Lookout Analytics documentation or BYOBI documentation.- Added the
archive_reasoncolumn. - Added the
sah_last_synced_atcolumn. - Added the
sah_care_recipient_datacolumn. - Added the
sah_last_synced_at_in_company_tzcolumn.
- Added the
- Changes to
edge_helpers. Lookout Analytics documentation or BYOBI documentation.- Added the
archive_reasoncolumn.
- Added the
- Changes to
edge_purchase_order_lines. Lookout Analytics documentation or BYOBI documentation.- Added the
external_idcolumn. - Added the
billable_price_centscolumn. - Added the
billable_price_currencycolumn. - Added the
billable_price_metadata_idcolumn. - Added the
margin_percentagecolumn. - Added the
statuscolumn. - Added the
canceled_atcolumn. - Added the
checkout_link_resent_atcolumn. - Added the
checkout_link_revoked_atcolumn. - Added the
checkout_link_sent_atcolumn. - Added the
delivered_atcolumn. - Added the
checkout_notecolumn (PII). - Added the
checkout_location_lonlatcolumn (PII). - Added the
checkout_location_accuracycolumn. - Added the
cancelation_reason_idcolumn. - Added the
cancelation_notecolumn (PII). - Added the
vendor_contact_idcolumn. - Added the
checked_in_atcolumn. - Added the
check_in_location_lonlatcolumn (PII). - Added the
check_in_location_accuracycolumn. - Added the
tracking_linkcolumn (PII). - Added the
skip_claimscolumn. - Added the
canceled_at_in_company_tzcolumn. - Added the
checkout_link_resent_at_in_company_tzcolumn. - Added the
checkout_link_revoked_at_in_company_tzcolumn. - Added the
checkout_link_sent_at_in_company_tzcolumn. - Added the
delivered_at_in_company_tzcolumn. - Added the
checked_in_at_in_company_tzcolumn.
- Added the
- Added
edge_profiles_tickets. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_members. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_staffers. Lookout Analytics documentation or BYOBI documentation.- Changed the
biocolumn to be PII. This will not impact BYOBI, but Lookout Analytics users will no longer see this column inedge_staffers. - Changed the
telephonecolumn to be PII. This will not impact BYOBI, but Lookout Analytics users will no longer see this column inedge_staffers. - Changed the
avatarcolumn to be PII. This will not impact BYOBI, but Lookout Analytics users will no longer see this column inedge_staffers.
- Changed the
- Added
edge_helpers_tags. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_incident_actions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_independent_contractor_invoice_lines. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_visit_logs. Lookout Analytics documentation or BYOBI documentation.- Added the
diffcolumn.
- Added the
- Added
edge_helpers_memberships. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_profiles. Lookout Analytics documentation or BYOBI documentation.- Added the
postal_street1column. - Added the
postal_street2column. - Added the
postal_localitycolumn. - Added the
postal_regioncolumn. - Added the
postal_postcodecolumn.
- Added the
- Added
edge_insights. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_budgets. Lookout Analytics documentation or BYOBI documentation.- Added the
interimcolumn.
- Added the
- Changes to
edge_finance_sah_payment_statement_items. Lookout Analytics documentation or BYOBI documentation.- Added the
reviewed_atcolumn. - Added the
original_invoice_amount_centscolumn. - Added the
original_invoice_amount_currencycolumn. - Added the
original_client_contribution_amount_centscolumn. - Added the
original_client_contribution_amount_currencycolumn. - Added the
original_payment_amount_centscolumn. - Added the
original_payment_amount_currencycolumn. - Added the
adjustment_invoice_line_idcolumn. - Added the
quantitycolumn. - Added the
unit_typecolumn. - Added the
delivery_datecolumn. - Added the
service_group_idcolumn. - Added the
service_group_textcolumn. - Added the
service_type_idcolumn. - Added the
service_type_textcolumn. - Added the
service_idcolumn. - Added the
service_textcolumn.
- Added the
- Changes to
edge_finance_sah_funding_sources. Lookout Analytics documentation or BYOBI documentation.- Added the
interimcolumn. - Added the
sah_updated_at_date_timecolumn.
- Added the
- Added
edge_ticket_tags_tickets. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_verification_renewals. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_funding_schemes. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_verifications. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_verification_files. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_tag_categories. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_prices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_leave_reasons. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_leave_period_actions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_helper_agreements. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_pascds. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_norton_scales. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_mini_nutritionals. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_kesslers. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_frop_coms. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_frats. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_caregiver_strain_indices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_cams. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_braden_scales. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments_abbey_pain_scales. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_focal_assessments. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_discussions_messages. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_discussions_discussions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_contracts. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_contract_provider_travel_prices. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_contract_prices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_contract_client_transport_prices. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_community_roles. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_communities_helpers. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_cohorts. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_cohort_participations. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_ticket_templates. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_custom_funding_scheme_types. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_ticket_categories. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_recurrences. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_provider_travel_rates. Lookout Analytics documentation or BYOBI documentation.
- Changes to
edge_payroll_awards. Lookout Analytics documentation or BYOBI documentation:- Removed
broken_shift_thresholdcolumn.
- Removed
- Added
edge_automatic_must_do_templates. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_visits. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_opportunities. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_supplements. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_statement_periods. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_payment_statement_items. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_payment_statement_item_budget_lines. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_commonwealth_unspent_funds. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_subsidies. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_classifications. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_claims. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_client_contributions. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_entitlements. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_sah_funding_sources. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_tracking_expenses. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_signing_requests. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_service_plan_services. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_incomes. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_expenses. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budgets. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_billable_price_metadata. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_automatic_must_dos. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_budget_service_plans. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_agreement_templates_ticket_categories. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_products. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_agreements. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_agreements_higher_duties. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_agreements_higher_duties_custom_schemes. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_agreements_higher_duties_services. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_classifications. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_rules. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_rules_inputs. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_streams. Lookout Analytics documentation or BYOBI documentation. - Added
edge_payroll_award_versions. Lookout Analytics documentation or BYOBI documentation. - Changes to
edge_time_tracking_logs. Lookout Analytics documentation or BYOBI documentation.- Added the
external_system_idcolumn. - Added the
person_involved_idcolumn. - Changed the
descriptioncolumn to be PII. This will not impact BYOBI, but Lookout Analytics users will no longer see this column inedge_time_tracking_logs.
- Added the
- Added
edge_shift_breaks. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_roster_items. Lookout Analytics documentation or BYOBI documentation.
- Changes to
dim_helpers. Lookout Analytics documentation or BYOBI documentation:- Fixed a bug with the
archive_reasoncolumn not containing the most recent values. - Added the
archive_reason_descriptioncolumn.
- Fixed a bug with the
- Changes to
dim_memberships. Lookout Analytics documentation or BYOBI documentation:- Fixed a bug with the
archive_reasoncolumn not containing the most recent values. - Added the
archive_reason_descriptioncolumn.
- Fixed a bug with the
- Changes to
edge_helpers. Lookout Analytics documentation or BYOBI documentation:- Dropped the
archive_reasoncolumn. - Added the
archive_reason_idcolumn. - Added the
vendor_contact_idcolumn.
- Dropped the
- Changes to
edge_memberships. Lookout Analytics documentation or BYOBI documentation:- Dropped the
archive_reasoncolumn. - Added the
archive_reason_idcolumn. - Added the
sah_membership_plan_idcolumn. - Added the
hcp_membership_plan_idcolumn. - Added the
services_australia_identifier_idcolumn.
- Dropped the
- Changes to
edge_payroll_awards. Lookout Analytics documentation or BYOBI documentation:- Added
apply_higher_duty_to_shift_afterandbroken_shift_thresholdcolumns.
- Added
- Added
edge_services_australia_identifiers. Lookout Analytics documentation or BYOBI documentation.
- Changes to
fct_visits. Lookout Analytics documentation or BYOBI documentation:- Fixed a bug with the canceled_reason column.
- Added the canceled_reason_description column.
- Added
edge_archive_reasons. Lookout Analytics documentation or BYOBI documentation. - Added
edge_visit_cancelation_reasons. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_membership_plans. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_invoice_lines_services. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_hcp_daily_rates. Lookout Analytics documentation or BYOBI documentation.
- Added
scheduled_exceptional_visits_after_sah_changeoverto dim_products. Lookout Analytics documentation or BYOBI documentation. - Added
has_assumed_delivery_after_sah_changeoverto fct_purchase_order_items. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_membership_hcp_rates. Lookout Analytics documentation or BYOBI documentation.
- Added
edge_finance_hcp_rates. Lookout Analytics documentation or BYOBI documentation.