How ifeanyiayadiuno/etl_load works
This is a PyQt desktop system for reservoir-production operations. Operators maintain well identity and metadata, retrieve daily Prodview data, apply monthly allocation passes, run optional imports, then export reports or push production to Whitson+. The graph preserves those documented branches and the sampled production rebuild’s downstream synchronization steps. Several GUI, export, allocation, and integration implementations were not sampled; their documented capabilities are shown, but uncertain internal wiring is omitted.
Main entry points: pce_rebuild_pipeline.py Rebuild follow-up · prodview_update_gui.py Prodview update · well_master_gui.py Well Master UI · production_update.py Production rebuild
Components 25
Well Master
- Well Master UI
well_master_gui.py - Well Master data
well_master_db.py
Production ETL
- Prodview update
prodview_update_gui.py - Production rebuild
production_update.py - Rebuild follow-up
pce_rebuild_pipeline.py - Type-curve sync
sync_typecurves_to_production.py - Forecast rebuild
pce_frcst_prd_rebuild.py
Allocation
- ValNav allocation
ngl_monthly_update.py - NGL allocation load
ngl_allocation_load.py - Public Sales ratios
sales_allocation_updates.py
Imports
- Survey import UI
survey_import_dialog.py - Survey import
survey_import.py - Type-curve import UI
type_curves_import_dialog.py - Type-curve import
type_curves_import.py - Forecast import UI
monthly_forecasts_import_dialog.py - Forecast import
monthly_forecasts_import.py
Reporting and delivery
- Exports UI
exports_dialog.py - Gathered reports
exports_gathered_monthly.py - Whitson mass upload
whitson_mass_upload_dialog.py - Production push
whitson_production_push.py
Other components
- Operator
- Snowflake
- SQL Server
- Whitson+
- Operator workbooks
Connections 41
- Operator → Well Master UI: maintains wells
- Well Master UI → Well Master data: loads and saves
- Well Master UI → Snowflake: previews and imports
- Well Master data → SQL Server: reads and writes
- Operator → Prodview update: starts update
- Prodview update → Snowflake: queries daily data
- Prodview update → SQL Server: loads CDA
- Prodview update → Production rebuild: runs rebuild
- Production rebuild → SQL Server: rebuilds production
- Production rebuild → Rebuild follow-up: runs follow-up
- Rebuild follow-up → Type-curve sync: materializes curves
- Type-curve sync → SQL Server: syncs production
- Rebuild follow-up → SQL Server: syncs well data and ratios
- Rebuild follow-up → Forecast rebuild: rebuilds forecast table
- Forecast rebuild → SQL Server: updates forecast data
- Operator → ValNav allocation: runs monthly pass
- Operator → Public Sales ratios: runs sales pass
- ValNav allocation → SQL Server: updates allocations
- Public Sales ratios → SQL Server: updates allocations
- Operator → NGL allocation load: runs NGL update
- NGL allocation load → SQL Server: loads allocation data
- Operator → Survey import UI: starts import
- Survey import UI → Survey import: configures import
- Survey import UI → Operator workbooks: selects survey file
- Survey import → SQL Server: writes surveys
- Operator → Type-curve import UI: starts import
- Type-curve import UI → Type-curve import: configures import
- Type-curve import UI → Operator workbooks: selects curve file
- Type-curve import → SQL Server: writes type curves
- Type-curve import → Rebuild follow-up: runs follow-up
- Operator → Forecast import UI: starts import
- Forecast import UI → Forecast import: configures import
- Forecast import UI → Operator workbooks: selects forecast file
- Forecast import → SQL Server: loads forecasts
- Operator → Exports UI: requests reports
- Exports UI → Gathered reports: gathers monthly data
- Gathered reports → SQL Server: reads production
- Operator → Whitson mass upload: starts upload
- Whitson mass upload → Production push: prepares upload
- Production push → SQL Server: reads production
- Production push → Whitson+: pushes production