CEO Dashboard - Oracle -> Postgres Sync Status

Auto-refreshes every 15s. This page reflects the Postgres staging tables Power BI reads from.

DatasetTarget tableStatusRowsRow limit DurationLast startLast endSchedule
ACTUAL_INV_TABLE_2024 stg_actual_inv_table_2024 success 28476 full 25.5s 2026-11-21 07:00:00.030928+00:00 2026-11-21 07:00:25.533458+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL stg_actual_inv_table_2024_pl success 28476 full 25.0s 2026-11-21 07:00:00.035960+00:00 2026-11-21 07:00:25.098523+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL_MMI stg_actual_inv_table_2024_pl_mmi success 3558 full 4.1s 2026-11-21 07:00:00.036965+00:00 2026-11-21 07:00:04.150324+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL_SA06 stg_actual_inv_table_2024_pl_sa06 success 83432 full 71.8s 2026-11-21 07:00:00.047493+00:00 2026-11-21 07:01:11.899694+00:00 23:00 PT
ACTUAL_SO_TABLE_2024 stg_actual_so_table_2024 success 83002 full 100.7s 2026-11-21 06:30:00.028444+00:00 2026-11-21 06:31:40.709751+00:00 22:30, 08:00, 14:00 PT
COMPANIES stg_companies success 57069 full 59.9s 2026-11-21 02:00:00.033008+00:00 2026-11-21 02:00:59.984938+00:00 18:00 PT
GL_SUMMARY stg_gl_summary success 20020 full 210.3s 2026-11-21 10:00:00.032849+00:00 2026-11-21 10:03:30.314531+00:00 02:00, 09:00, 14:00 PT
GL_SUMMARY_2023 stg_gl_summary_2023 success 2860 full 21.3s 2026-11-21 02:00:00.030822+00:00 2026-11-21 02:00:21.398470+00:00 18:00 PT
INV_REVIEWED stg_inv_reviewed success 0 full 0.8s 2026-11-21 12:00:00.028779+00:00 2026-11-21 12:00:00.834525+00:00 00:00, 01:00, 02:00, 03:00, 04:00, 05:00, 06:00, 07:00, 08:00, 09:00, 10:00, 11:00, 12:00, 13:00, 14:00, 15:00, 16:00, 17:00, 18:00, 19:00, 20:00, 21:00, 22:00, 23:00 PT
MMI_VENDOR_PERFORMANCE stg_mmi_vendor_performance success 89301 full 80.8s 2026-11-21 02:30:00.024108+00:00 2026-11-21 02:31:20.802851+00:00 18:30 PT
MTD_BUDGET_TABLE stg_mtd_budget_table success 1 full 0.8s 2026-11-21 08:15:00.025678+00:00 2026-11-21 08:15:00.842935+00:00 00:15 PT
OPEN_SO_PLANNING stg_open_so_planning success 5592 full 9.7s 2026-11-21 12:00:00.029883+00:00 2026-11-21 12:00:09.717008+00:00 00:00, 01:00, 02:00, 03:00, 04:00, 05:00, 06:00, 07:00, 08:00, 09:00, 10:00, 11:00, 12:00, 13:00, 14:00, 15:00, 16:00, 17:00, 18:00, 19:00, 20:00, 21:00, 22:00, 23:00 PT
PENTAGON_DATA_COMPANIES stg_pentagon_data_companies success 22430 full 0.7s 2026-11-21 07:00:00.050746+00:00 2026-11-21 07:00:00.816425+00:00 23:00 PT
PURCHASE_SALES_SOD stg_purchase_sales_sod success 82361 full 68.8s 2026-11-21 12:00:00.029701+00:00 2026-11-21 12:01:08.868088+00:00 00:00, 01:00, 02:00, 03:00, 04:00, 05:00, 06:00, 07:00, 08:00, 09:00, 10:00, 11:00, 12:00, 13:00, 14:00, 15:00, 16:00, 17:00, 18:00, 19:00, 20:00, 21:00, 22:00, 23:00 PT
ROLODEX stg_rolodex success 44693 full 53.8s 2026-11-21 02:00:00.050498+00:00 2026-11-21 02:00:53.958160+00:00 18:00 PT
SALESPERSON stg_salesperson success 340 full 1.2s 2026-11-21 02:00:00.037222+00:00 2026-11-21 02:00:01.234747+00:00 18:00 PT
SO_DETAILS_BACKLOG stg_so_details_backlog success 5630 full 6.7s 2026-11-21 06:30:00.028096+00:00 2026-11-21 06:30:06.836308+00:00 22:30, 08:00, 14:00 PT
SO_DETAILS_BACKLOG_SUMMARY stg_so_details_backlog_summary success 6126 full 7.5s 2026-11-21 06:30:00.027371+00:00 2026-11-21 06:30:07.584193+00:00 22:30, 08:00, 14:00 PT
SO_DETAIL_BASE stg_so_detail_base success 83033 full 93.6s 2026-11-21 06:30:00.026571+00:00 2026-11-21 06:31:33.682327+00:00 22:30, 08:00, 14:00 PT