All Tables
141 tables · 22'445'990 total rows · 22'445'990 materialized
| Table ↑ | Layer | Rows | Columns |
|---|---|---|---|
| bitbundle_memberships | smebits | 37 | 6 |
| bitbundle_registry | smebits | 11 | 18 |
| debug_missing_billing | other | 0 | 8 |
| debug_movement_balance | other | 849'254 | 8 |
| entity_registry | registry | 29 | 30 |
| entity_relationships | registry | 12 | 10 |
| gold_abt_departments | gold | 11 | 5 |
| gold_abt_kst_mapping | gold | 11 | 9 |
| gold_article_catalogues | gold | 72'572 | 13 |
| gold_article_price_palette | gold | 193'524 | 9 |
| gold_article_price_spread | gold | 48'381 | 14 |
| gold_billing_events | gold | 2'742'204 | 14 |
| gold_billing_prices | gold | 241'905 | 5 |
| gold_case_financials | gold | 80'119 | 14 |
| gold_case_material_usage | gold | 2'742'204 | 9 |
| gold_cases | gold | 65'163 | 14 |
| gold_catalogue_population | gold | 22 | 5 |
| gold_catalogue_registry | gold | 2 | 4 |
| gold_catalogue_types | gold | 5 | 5 |
| gold_cost_centers | gold | 498 | 6 |
| gold_drg_lookup | gold | 733 | 3 |
| gold_io_article_reconciliation | gold | 198'730 | 12 |
| gold_io_by_department | gold | 16 | 16 |
| gold_io_coefficient | gold | 1'001'413 | 11 |
| gold_io_coefficient_by_cc | gold | 1'712'621 | 15 |
| gold_io_coefficient_trend | gold | 319'248 | 16 |
| gold_io_coefficient_ward | gold | 0 | 17 |
| gold_io_coefficient_weekly | gold | 1'708'624 | 11 |
| gold_io_coefficient_weekly_trend | gold | 357'517 | 16 |
| gold_io_metering | gold | 609'035 | 56 |
| gold_material_activity | gold | 198'735 | 17 |
| gold_material_classifications | gold | 57 | 8 |
| gold_material_consumption | gold | 0 | 19 |
| gold_material_health | gold | 42'848 | 23 |
| gold_material_movements | gold | 884'420 | 14 |
| gold_material_sourcing | gold | 0 | 16 |
| gold_materials | gold | 48'381 | 31 |
| gold_movement_chain_mapping | gold | 497 | 2 |
| gold_net_exposure | gold | 29'276 | 16 |
| gold_packaging_types | gold | 15 | 6 |
| gold_price_comparison | gold | 48'381 | 14 |
| gold_price_palette | gold | 435'429 | 9 |
| gold_price_series | gold | 2'737'337 | 9 |
| gold_procedures | gold | 0 | 7 |
| gold_quality_metrics | gold | 9 | 6 |
| gold_reconciliation_summary | gold | 3 | 7 |
| gold_service_mandates | gold | 232 | 6 |
| gold_suppliers | gold | 11'427 | 5 |
| gold_supply_chains | gold | 2 | 15 |
| gold_supply_orgs | gold | 3 | 5 |
| gold_taxonomy_cardinality | gold | 1 | 11 |
| gold_taxonomy_closure | gold | 97 | 4 |
| gold_taxonomy_member_mappings | gold | 72'262 | 5 |
| gold_taxonomy_nodes | gold | 41 | 10 |
| lineage_pipeline_metrics | registry | 10 | 8 |
| lineage_registry | registry | 11 | 25 |
| lineage_validation_counts | registry | 2 | 3 |
| lineage_validation_rules | registry | 38 | 6 |
| notebook_registry | notebooks | 6 | 25 |
| pipeline_graph | registry | 2 | 7 |
| report_data | reports | 5 | 4 |
| report_data__report_catalogue_population | reports | 1 | 4 |
| report_data__report_data_quality | reports | 1 | 4 |
| report_data__report_entity_health | reports | 1 | 4 |
| report_data__report_executive_summary | reports | 1 | 4 |
| report_data__report_financial_risk | reports | 1 | 4 |
| report_registry | reports | 5 | 15 |
| signal_findings | other | 2'496'211 | 12 |
| signal_findings__perspective_billing_quality | probes | 0 | 12 |
| signal_findings__perspective_case_financial_integrity | probes | 383 | 12 |
| signal_findings__perspective_catalog_health | probes | 0 | 12 |
| signal_findings__perspective_catalog_inventory | probes | 0 | 12 |
| signal_findings__perspective_material_compliance | probes | 0 | 12 |
| signal_findings__perspective_material_health | probes | 42'848 | 12 |
| signal_findings__perspective_material_overall | probes | 42'848 | 12 |
| signal_findings__signal_active_date_expired | probes | 0 | 11 |
| signal_findings__signal_active_materials | probes | 0 | 11 |
| signal_findings__signal_active_single_source | probes | 0 | 11 |
| signal_findings__signal_backfilled_material_billing | probes | 0 | 11 |
| signal_findings__signal_barcode_duplicate | probes | 0 | 11 |
| signal_findings__signal_billing_amount_outlier | probes | 945 | 10 |
| signal_findings__signal_billing_before_usage | probes | 0 | 11 |
| signal_findings__signal_billing_below_internal_price | probes | 1'125'293 | 11 |
| signal_findings__signal_catalogue_completeness | probes | 0 | 11 |
| signal_findings__signal_catalogue_count_reconciliation | probes | 5 | 11 |
| signal_findings__signal_controlled_substance_traceability | probes | 0 | 11 |
| signal_findings__signal_conversion_factor_anomaly | probes | 0 | 11 |
| signal_findings__signal_cost_center_billing_mismatch | probes | 383 | 11 |
| signal_findings__signal_cross_site_price_consistency | probes | 0 | 11 |
| signal_findings__signal_drg_cost_outlier | probes | 3'337 | 11 |
| signal_findings__signal_duplicate_billing | probes | 10'255 | 11 |
| signal_findings__signal_four_signals_convergence | probes | 11'926 | 10 |
| signal_findings__signal_inactive_date_valid | probes | 0 | 11 |
| signal_findings__signal_inactive_materials | probes | 0 | 11 |
| signal_findings__signal_invoice_integrity | probes | 0 | 11 |
| signal_findings__signal_io_coefficient | probes | 23'832 | 11 |
| signal_findings__signal_io_coefficient_trend | probes | 4'032 | 11 |
| signal_findings__signal_io_coefficient_weekly | probes | 23'832 | 11 |
| signal_findings__signal_io_coefficient_weekly_trend | probes | 1'502 | 11 |
| signal_findings__signal_migel_reimbursement_gap | probes | 0 | 11 |
| signal_findings__signal_missing_mandatory_implants | probes | 0 | 11 |
| signal_findings__signal_missing_standard_price | probes | 0 | 11 |
| signal_findings__signal_multi_source_materials | probes | 0 | 11 |
| signal_findings__signal_negative_margin | probes | 1'156'409 | 11 |
| signal_findings__signal_orphan_billing | probes | 0 | 11 |
| signal_findings__signal_price_spread_inconsistency | probes | 0 | 10 |
| signal_findings__signal_procedure_without_usage | probes | 0 | 11 |
| signal_findings__signal_revenue_leakage | probes | 0 | 11 |
| signal_findings__signal_shelf_life_risk | probes | 0 | 11 |
| signal_findings__signal_single_source_dependency | probes | 0 | 11 |
| signal_findings__signal_stale_article | probes | 0 | 11 |
| signal_findings__signal_stale_material | probes | 0 | 11 |
| signal_findings__signal_veska_med_mat_classification | probes | 48'381 | 11 |
| signal_registry | probes | 45 | 20 |
| smebit_registry | smebits | 39 | 32 |
| smebit_verdicts | smebits | 1 | 6 |
| smebit_verdicts__smebit_orphan_material_investigation | smebits | 1 | 6 |
| smebit_verdicts__smebit_zeta_material_638876a_wrong_description | smebits | 1 | 6 |
| smebit_verdicts__smebit_zeta_piota_duplicate_supplier | smebits | 1 | 6 |
| thesis_registry | hypotheses | 10 | 25 |
| thesis_verdicts | other | 10 | 13 |
| thesis_verdicts__thesis_catalog_maintenance_gap | other | 1 | 13 |
| thesis_verdicts__thesis_controlled_substance_gap | other | 1 | 13 |
| thesis_verdicts__thesis_duplicate_billing | other | 1 | 13 |
| thesis_verdicts__thesis_io_imbalance | other | 1 | 13 |
| thesis_verdicts__thesis_overpriced_generics | other | 1 | 13 |
| thesis_verdicts__thesis_phantom_cases | other | 1 | 13 |
| thesis_verdicts__thesis_revenue_leakage_unbilled | other | 1 | 13 |
| thesis_verdicts__thesis_shelf_life_waste | other | 1 | 13 |
| thesis_verdicts__thesis_stale_catalogue | other | 1 | 13 |
| thesis_verdicts__thesis_supplier_concentration_risk | other | 1 | 13 |
| verdict_findings | other | 2 | 9 |
| verdict_findings__verdict_billing_workflow_gap | other | 0 | 9 |
| verdict_findings__verdict_catalogue_maintenance_lag | other | 0 | 9 |
| verdict_findings__verdict_duplicate_interface_error | other | 0 | 9 |
| verdict_findings__verdict_inventory_process_gap | other | 1 | 9 |
| verdict_findings__verdict_no_dual_sourcing_policy | other | 0 | 9 |
| verdict_findings__verdict_orphan_case_data_entry | other | 0 | 9 |
| verdict_findings__verdict_procurement_pricing_mismatch | other | 1 | 9 |
| verdict_findings__verdict_status_flag_date_drift | other | 0 | 9 |
| verdict_registry | diagnoses | 8 | 17 |