FDC Database Tables to Screens Mapping
Table Name | Navigation / Page |
Orgs | Client name and OrgId |
People | Administration / Users |
UserRole | Administration / Roles |
BatteryOilProductions | Data Input / Facility / Fluids tab |
BatteryTankGauges | Data Input / Facility / Fluids tab |
BatteryGasProductions | Data Input / Facility / Facility tab |
BatteryWaterProductions | Data Input / Facility / Fluids tab |
WellProperties | Data Input / Facility / Operations tab |
BatteryMeterReadings | Data Input / Facility / Fluids tab |
WellProductions | Data Input / Facility / Allocations tab |
TankEvents | Data Input / Facility / Events tab |
Wells | Assets / Wells |
WellLifeCycleTracking | Assets / Wells / Lifecycle History |
Batteries | Assets / Facilities |
BatteryMeters | Assets / Meters |
FlowTests | Data Input / Well Tests |
Tanks | Assets / Tanks |
TankServicing | Assets / Tanks / Tank Servicing Records |
Functions | Relates to Adding, Showing, Removing modules or screens for client |
FunctionOrgs | Ties in with the Functions table |
Reports | Shows what reports are displayed for client |
ReportPropertyConfigs | Ties in with the Reports table and can change/update configs such as displaying columns or changing names (labels) of columns |
**Some clients have this updated in the Admin Portal Website (See FDC Platforms_Environments_Providers_Extra Details spreadsheet | |
**Well Work screens are easier to correlate to the tables in the DB | |