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 22633 full 21.4s 2026-09-22 06:00:00.053307+00:00 2026-09-22 06:00:21.492923+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL stg_actual_inv_table_2024_pl success 22633 full 21.0s 2026-09-22 06:00:00.038142+00:00 2026-09-22 06:00:21.055463+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL_MMI stg_actual_inv_table_2024_pl_mmi success 3558 full 4.3s 2026-09-22 06:00:00.062149+00:00 2026-09-22 06:00:04.332473+00:00 23:00 PT
ACTUAL_INV_TABLE_2024_PL_SA06 stg_actual_inv_table_2024_pl_sa06 success 77589 full 69.6s 2026-09-22 06:00:00.036632+00:00 2026-09-22 06:01:09.630177+00:00 23:00 PT
ACTUAL_SO_TABLE_2024 stg_actual_so_table_2024 success 77433 full 91.8s 2026-09-22 05:30:00.030493+00:00 2026-09-22 05:31:31.870840+00:00 22:30, 08:00, 14:00 PT
COMPANIES stg_companies success 57015 full 59.9s 2026-09-22 01:00:00.031148+00:00 2026-09-22 01:00:59.983853+00:00 18:00 PT
GL_SUMMARY stg_gl_summary success 20020 full 199.0s 2026-09-22 09:00:00.026224+00:00 2026-09-22 09:03:19.035503+00:00 02:00, 09:00, 14:00 PT
GL_SUMMARY_2023 stg_gl_summary_2023 success 2860 full 21.3s 2026-09-22 01:00:00.034260+00:00 2026-09-22 01:00:21.373179+00:00 18:00 PT
INV_REVIEWED stg_inv_reviewed success 2 full 1.0s 2026-09-22 14:00:00.022953+00:00 2026-09-22 14:00:01.048612+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 84888 full 83.8s 2026-09-22 01:30:00.018130+00:00 2026-09-22 01:31:23.834304+00:00 18:30 PT
MTD_BUDGET_TABLE stg_mtd_budget_table success 1 full 0.8s 2026-09-22 07:15:00.018642+00:00 2026-09-22 07:15:00.877566+00:00 00:15 PT
OPEN_SO_PLANNING stg_open_so_planning success 5459 full 9.4s 2026-09-22 14:00:00.023318+00:00 2026-09-22 14:00:09.484626+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-09-22 06:00:00.085606+00:00 2026-09-22 06:00:00.809339+00:00 23:00 PT
PURCHASE_SALES_SOD stg_purchase_sales_sod success 78511 full 68.6s 2026-09-22 14:00:00.021263+00:00 2026-09-22 14:01:08.686380+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 44508 full 51.4s 2026-09-22 01:00:00.035376+00:00 2026-09-22 01:00:51.421068+00:00 18:00 PT
SALESPERSON stg_salesperson success 336 full 1.3s 2026-09-22 01:00:00.037096+00:00 2026-09-22 01:00:01.330729+00:00 18:00 PT
SO_DETAILS_BACKLOG stg_so_details_backlog success 5482 full 6.8s 2026-09-22 05:30:00.029463+00:00 2026-09-22 05:30:06.945204+00:00 22:30, 08:00, 14:00 PT
SO_DETAILS_BACKLOG_SUMMARY stg_so_details_backlog_summary success 5980 full 7.5s 2026-09-22 05:30:00.031268+00:00 2026-09-22 05:30:07.538839+00:00 22:30, 08:00, 14:00 PT
SO_DETAIL_BASE stg_so_detail_base success 77464 full 84.1s 2026-09-22 05:30:00.031497+00:00 2026-09-22 05:31:24.153266+00:00 22:30, 08:00, 14:00 PT