Query to Display Missing data in a Table

[MAQAQM]

Dear Gurus,

I want to build a view and from it create a report with crystal reports, the query must be able to tell me how many days are missing data in the database!

can someone help me on this? a query which tells me the days where there is no data in the tables of the database

thanks
AQM

 

[Turkbear]

Hi,
Need to know the tables involved, what fields are in them and how they can be linked..
( also, what consitutes missing data?)


What version of Crystal?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

AQM,

You can help us to help you by posting some additional specifications such as:

1) Sample table name(s).
2) Column name of the DATE column you wish to use to check for omissions.
3) START_DATE and END_DATE (or period of time from today) that you wish to check for omissions.

If you post responses to those items, I'm certain that we can help you with specific sample code.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[SantaMufasa]

Were we separated at birth, Turkbear? If so, you must have been born just seconds before me, right?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

the table involved are so many tables, but I past them below. the Date column is Date_stamp from FV_DATES table and that's the only column i it. the rest if you need their column, please let me know. I want to check from selected options, or range of dates that the database will verify. e.g: from 09/09/06 to 24/09/06.



below are the list of tables
=================================
FM_SPECIFICATION
FV_BATT_GP_EXPECT_INJECT_VOLS
FV_BATTERY_APP_CALC
FV_BATTERY_APP0_VW
FV_BATTERY_NON_PROD
FV_BATTERY_PROD
FV_BATTERY_TOTAL_PROD1_CALC
FV_BATTERY_TOTAL_PROD1_CALC
FV_COMPANY
FV_COMPLETION_NON_PROD
FV_COMPONENT
FV_COMPONENT_CONTROL
FV_CONNECTION_METER
FV_CONNECTIONS
FV_COUNTER_METER_PROD
FV_DATA_POINTS
FV_DATES
FV_DOWN_TIME_CODE
FV_EQUIPMENT
FV_EQUIPMENT_NON_PROD
FV_EQUIPMENT_PROD
FV_ERROR
FV_EXTERNAL_FAC_NON_PROD
FV_FIELDVIEW_TABLE
FV_FLUID_ANALYSIS
FV_FLUID_ANALYSIS_COMP
FV_FLUID_SAMPLE
FV_FLUID_TYPE
FV_FS_FLUID_ANALYSIS
FV_FS_FLUID_ANALYSIS
FV_GAS_EXPANSION_DATA
FV_GAS_EXPANSION_DATA
FV_GAS_PLANT_APP_CALC
FV_GAS_PLANT_APP0_VW
FV_GAS_PLANT_CALC_INPUT_VW
FV_GAS_PLANT_GAS_PROD2_CALC
FV_GAS_PLANT_INJECTION_VW
FV_GAS_PLANT_INLET_FLD_PROD_VW
FV_GAS_PLANT_INPUT_VW
FV_GAS_PLANT_INPUT_VW
FV_GAS_PLANT_NON_PROD
FV_GAS_PLANT_PROD
FV_GAS_WELL_APP0_VW
FV_GAS_WELL_EXP_PROD_CALC
FV_GAS_WELL_EXP_PROD_VW
FV_GAS_WELL_LOST_PROD_CALC
FV_GAS_WELL_LOST_PROD_VW
FV_GAS_WELL_NON_PROD
FV_GAS_WELL_NON_PROD
FV_GAS_WELL_PROD
FV_GAS_WELL_TEST_VOL_VW
FV_GEOGRAPHIC_LOCATIONS
FV_GOR_CONSTS_NON_PROD_VW
FV_GP_EXPECT_INJECT_VOLS_VW
FV_GP_INJECTED_VOLUMES_VW
FV_GP_LIQ_METER_RECPT_CALC
FV_GP_LIQ_METER_RECPT_VW
FV_GROUP_SITE
FV_GROUPS
FV_INJ_FAC_NON_PROD
FV_INJ_FAC_PROD
FV_INJ_FACILITY_APP_CALC
FV_INJ_WELL_APP_CALC
FV_INJ_WELL_MTD_DAYS_ON_VW
FV_INJ_WELL_NON_PROD
FV_INJ_WELL_PROD
FV_INJ_WELL_PROD
FV_INJ_WELL_PROD
FV_INJ_WELL_PROD
FV_INJECTION_WELL_PROD_CALC
FV_INJECTION_WELL_PROD_VW
FV_INLET_FIELD_GAS_PROD_VW
FV_INLET_FIELD_GAS_PROD_VW
FV_INLET_FIELD_GAS_PROD_VW
FV_INLET_NON_PROD
FV_INLET_PROD
FV_INTERFACE_VAR_TYPES
FV_INTRA_DAY_METER_CALC
FV_INTRA_DAY_METER_CALC
FV_INTRA_DAY_TANK_CALC
FV_MATERIAL_COMPOSITION
FV_METER_CALC
FV_METER_FLAGS_R_CALC
FV_METER_NON_PROD
FV_METER_NON_PROD
FV_METER_NON_PROD
FV_MODEL_CONSTS_NON_PROD_VW
FV_MULTI_WELL_TEST
FV_MULTI_WELL_TEST_WELL_DATA
FV_NET_ROYALTY_INTEREST
FV_NON_OP_DATA
FV_NON_OP_DATA
FV_OIL_WELL_APP0_VW
FV_OIL_WELL_CALC
FV_OIL_WELL_INJECTED_VOLUMES
FV_OIL_WELL_NON_PROD
FV_OIL_WELL_PROD
FV_OIL_WELL_PROD
FV_OIL_WELL_PUMP_EFF_VW
FV_ORIFICE_METER_PROD
FV_PERF_VARIABLE_HEADER
FV_PERF_VARIABLE_PROD
FV_PLANT_INLETS_VW
FV_PROFILE
FV_PUMP_CALC
FV_PUMP_MODEL
FV_PUMP_NON_PROD
FV_PUMP_PROD
FV_REGULATORY_STATUS
FV_REGULATORY_STATUS
FV_REPORT
FV_RESIDUAL_METER
FV_SEQUENCE_STEP
FV_SH_CONSTS_NON_PROD_VW
FV_SITE
FV_SITE_ALLOCATION_CALC
FV_SITE_ALLOCATION_CALC
FV_SITE_APP_CALC
FV_SITE_APP0_VW
FV_SITE_CONNECT_VW
FV_SITE_DATE_VW
FV_SITE_FIELD_PRODUCTION_VW
FV_SITE_INVALID_CALC
FV_SITE_INVENTORY_CALC
FV_SITE_INVENTORY_VW
FV_SITE_METER1_R_VW
FV_SITE_METER2_R_CALC
FV_SITE_NON_PROD
FV_SITE_NON_PROD
FV_SITE_PROD
FV_SITE_PROD
FV_SITE_PROD
FV_SITE_PROD
FV_SITE_PROD
FV_SITE_PROD_REMARK
FV_SITE_PROD_REMARK
FV_SITE_PROD_REMARK
FV_SITE_STANDARD_BALANCE_CALC
FV_SITE_TRUCK_DISP_RECPT_CALC
FV_SITE_TYPES
FV_SITE_USER_OBJECT_ITEM_PROD
FV_SITE_USER_OBJECT_NPROD
FV_SITE_USER_OBJECT_PROD
FV_SOURCE_WELL_NON_PROD
FV_SOURCE_WELL_PROD
FV_STRAPPING_TABLE
FV_STRAPPING_TABLE_ENTRY
FV_SYNC_CHANGES
FV_TANK_CALC
FV_TANK_NON_PROD
FV_TANK_PROD
FV_TANK_TYPE
FV_TANK_VOLUME_ADJ_CODES
FV_TEST_COUNTER_METER_PROD
FV_TEST_SEQUENCE
FV_TEST_TANK_PROD
FV_TEST_VESSEL
FV_TEST_VESSEL_NON_PROD
FV_THC_CONSTS_NON_PROD_VW
FV_TRUCK_TICKET
FV_TRUCK_TICKET_CALC
FV_UI_ATTRIB
FV_UNIT_TYPES
FV_USER_DATA_POINTS
FV_USER_LISTS
FV_USER_OBJECTS]
FV_VALIDATION_CHANGE_LOG
FV_VARIABLE_TYPES
FV_VOLUME_CORRECTION_ENTRY
FV_VOLUME_CORRECTION_ENTRY
FV_WELL_APP_CALC
FV_WELL_TEST_DATA
FV_WELL_TOTAL_PROD_CALC
FV_WORKING_INTEREST
FV_YGF_CONSTS_NON_PROD_VW

 

[MAQAQM]

below are the table scripts:
================================
CREATE TABLE FM_SPECIFICATION (
KIND NUMBER NOT NULL,
START_DATE DATE,
END_DATE DATE,
NAME VARCHAR2 (150),
DEFINED_BY VARCHAR2 (20),
TYPE NUMBER ) ;

CREATE TABLE FV_BATCH_OBJECT_TYPES (
TYPE_ID NUMBER NOT NULL,
VERSION VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (96),
DESCRIPTION VARCHAR2 (762) ) ;


CREATE TABLE FV_BATCH_RECIPIENT_TYPES (
TYPE_ID NUMBER NOT NULL,
VERSION VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (96),
DESCRIPTION VARCHAR2 (762) ) ;

CREATE TABLE FV_BATTERY_APP_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
EXPECTED_OIL_PROD NUMBER,
EXPECTED_WATER_PROD NUMBER,
EXPECTED_GAS_PROD NUMBER,
EXPECTED_CO2_PROD NUMBER,
EXPECTED_SAND_PROD NUMBER,
TOTAL_OIL_PROD NUMBER,
TOTAL_WATER_PROD NUMBER,
TOTAL_GAS_PROD NUMBER,
TOTAL_CO2_PROD NUMBER,
TOTAL_SAND_PROD NUMBER,
METER_OIL_IN NUMBER,
METER_OIL_OUT NUMBER,
METER_PROD_WATER_IN NUMBER,
METER_PROD_WATER_OUT NUMBER,
METER_SRC_WATER_IN NUMBER,
METER_SRC_WATER_OUT NUMBER,
TRUCKED_OIL_RECPT NUMBER,
TRUCKED_OIL_SALES_DISP NUMBER,
TRUCKED_OIL_DISP NUMBER,
TRUCKED_PROD_WATER_RECPT NUMBER,
TRUCKED_PROD_WATER_DISP NUMBER,
TRUCKED_SRC_WATER_RECPT NUMBER,
TRUCKED_SRC_WATER_DISP NUMBER,
TRUCKED_SAND_DISP NUMBER,
TRUCKED_SAND_RECPT NUMBER,
CO2_PRODUCTION NUMBER,
FIELD_GAS_LIFT NUMBER,
REFERENCE_GAS_LIFT NUMBER,
EXPECTED_COND_PROD NUMBER,
TOTAL_OIL_VARIANCE FLOAT DEFAULT 0.0,
TOTAL_GAS_VARIANCE FLOAT DEFAULT 0.0,
TOTAL_WATER_VARIANCE FLOAT DEFAULT 0.0,
TOTAL_CO2_VARIANCE FLOAT DEFAULT 0.0,
TOTAL_COND_VARIANCE FLOAT DEFAULT 0.0,
TOTAL_OIL_PROD_60F FLOAT,
TOTAL_OIL_PROD_15C FLOAT ) ;

CREATE TABLE FV_BATTERY_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
BATTERY_TYPE FLOAT,
SOURCE_WATER_CALC FLOAT,
PROD_WATER_CALC FLOAT,
SALES_TARGET FLOAT,
WATER_TARGET FLOAT,
GAS_TARGET FLOAT,
OIL_PRICE FLOAT,
PROCESSING_FEE FLOAT,
DISPOSAL_FEE FLOAT,
CLEANING_FEE FLOAT,
BLEND_FACTOR FLOAT,
OIL_DENSITY FLOAT,
WATER_DENSITY FLOAT,
OIL_SHRINKAGE FLOAT,
WATER_SHRINKAGE FLOAT,
GAS_SHRINKAGE FLOAT,
ALLOCATION_STATUS FLOAT,
GAS_SHRINK_METHOD FLOAT,
END_DATE DATE,
TRUCKED_COND_AS NUMBER (5),
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_BATTERY_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS FLOAT,
OIL_RECOVERY FLOAT,
WATER_RECOVERY FLOAT,
SW_DISPOSITION FLOAT,
SW_RECEIPT FLOAT,
CARRIED_FORWARD NUMBER (5) ) ;

CREATE TABLE FV_BATT_GP_EXPECT_INJECT_VOLS (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
EXPECTED_INJECTED_CO2 FLOAT,
EXPECTED_INJECTED_GAS FLOAT,
EXPECTED_INJECTED_COND FLOAT,
EXPECTED_INJECTED_H2O FLOAT,
EXPECTED_INJECTED_OIL FLOAT ) ;


CREATE TABLE FV_COMPANY (
COMPANY_ID VARCHAR2 (23) NOT NULL,
PHONE_1 VARCHAR2 (150),
NAME VARCHAR2 (120),
SHORT_NAME VARCHAR2 (60),
DESCRIPTION VARCHAR2 (765),
CONTACT VARCHAR2 (60),
PHONE_2 VARCHAR2 (150),
FAX VARCHAR2 (60),
COMPANY_TYPE FLOAT,
DELETE_DATE DATE ) ;

CREATE TABLE FV_COMPONENT (
COMPONENT_ID VARCHAR2 (23) NOT NULL,
LOCATION_ID NUMBER (5),
PARENT_ID NUMBER (5),
LAST_APPLIED_ID NUMBER (10),
LAST_SENT_UP_ID NUMBER (10),
LAST_SENT_DOWN_ID NUMBER (10),
LAST_APPLIED_TIME DATE ) ;

CREATE TABLE FV_COMPONENT_CONTROL (
COMPONENT_CONTROL_ID VARCHAR2 (23) NOT NULL,
CONTROL_NAME VARCHAR2 (30) NOT NULL,
CONTROL_STRING VARCHAR2 (50),
LOCATION_ID NUMBER (5) NOT NULL,
APPLICATION_NAME VARCHAR2 (30) NOT NULL,
CONTROL_VALUE NUMBER (10) ) ;

CREATE TABLE FV_CONNECTIONS (
CONNECTION_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
PRIMARY_OIL NUMBER (10),
PRIMARY_GAS NUMBER (10),
PRIMARY_WATER NUMBER (10),
PRIMARY_COND NUMBER (10),
SRC_SITE_ID VARCHAR2 (23),
DEST_SITE_ID VARCHAR2 (23),
SRC_METER_ID VARCHAR2 (23),
DEST_METER_ID VARCHAR2 (23),
END_DATE DATE,
SRC_SITE_TYPE FLOAT,
DEST_SITE_TYPE FLOAT,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_CONNECTION_METER (
CONNECTION_METER_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
REAL_METER_ID VARCHAR2 (23) NOT NULL,
SITE_ID VARCHAR2 (23) NOT NULL,
END_DATE DATE ) ;



CREATE TABLE FV_DATA_POINTS (
DATA_POINT_ID NUMBER (22) NOT NULL,
NAME VARCHAR2 (60),
DESCRIPTION VARCHAR2 (120),
DATA_TYPE VARCHAR2 (60),
UNITS VARCHAR2 (60),
MIN_VALUE FLOAT,
MAX_VALUE FLOAT,
DISPLAY_FORMAT VARCHAR2 (30),
OBJECT_ID VARCHAR2 (23),
DELETE_DATE DATE,
DOMAIN VARCHAR2 (765) ) ;

CREATE TABLE FV_DATES (
DATE_STAMP DATE NOT NULL ) ;

CREATE TABLE FV_DERIVED_METER_ERROR (
METER_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE ) ;

CREATE TABLE FV_DERIVED_METER_INVALID_CALC (
METER_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL ) ;

CREATE TABLE FV_DERIVED_METER_PERSIST (
METER_NON_PROD_ID VARCHAR2 (23) NOT NULL,
DERIVED_METER_PERSIST LONG ) ;

CREATE TABLE FV_DERIVED_METER_PERSIST_SQL (
METER_NON_PROD_ID VARCHAR2 (23) NOT NULL,
DERIVED_METER_CALC_SQL LONG ) ;

CREATE TABLE FV_DERIVED_METER_RELATION (
METER_NON_PROD_ID VARCHAR2 (23) NOT NULL,
PARENT_SITE_ID VARCHAR2 (23) NOT NULL,
RELATED_ID VARCHAR2 (23) NOT NULL,
RELATED_TYPE NUMBER (10) NOT NULL,
RELATED_VAR_ID NUMBER (10) NOT NULL ) ;

CREATE TABLE FV_DOWN_TIME_CODE (
DOWN_TIME_ID VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (120),
CODE VARCHAR2 (15),
DELETE_DATE DATE ) ;

CREATE TABLE FV_DOWN_TIME_SCHEDULED_TYPE (
TYPE_ID NUMBER (10) NOT NULL,
VERSION VARCHAR2 (23) NOT NULL,
LONG_NAME VARCHAR2 (105),
SHORT_NAME VARCHAR2 (75),
CREATED_BY VARCHAR2 (90),
CREATED_DATE DATE,
LAST_CHANGED_BY VARCHAR2 (90),
LAST_CHANGED_DATE DATE ) ;

CREATE TABLE FV_ENUMERATION_CODES (
ENUMERATION_TYPE_ID NUMBER (5) NOT NULL,
ENUMERATION_CODE NUMBER (10) NOT NULL,
VERSION VARCHAR2 (23) NOT NULL,
LONG_NAME VARCHAR2 (105),
SHORT_NAME VARCHAR2 (75),
CREATED_BY VARCHAR2 (90),
CREATED_DATE DATE,
LAST_CHANGED_BY VARCHAR2 (90),
LAST_CHANGED_DATE DATE ) ;

CREATE TABLE FV_EQUIPMENT (
EQUIP_ID VARCHAR2 (23) NOT NULL,
SITE_ID VARCHAR2 (23),
START_DATE DATE,
END_DATE DATE,
NAME VARCHAR2 (120),
PA_CODE VARCHAR2 (72),
TYPE FLOAT,
DESCRIPTION VARCHAR2 (765),
SERIAL_NUMBER VARCHAR2 (60),
HIDDEN_STATE FLOAT,
TAG_ID VARCHAR2 (40),
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_EQUIPMENT_NON_PROD (
EQUIP_ID VARCHAR2 (23),
DATAPOINT_1 FLOAT,
DATAPOINT_2 FLOAT,
DATAPOINT_3 FLOAT,
DATAPOINT_4 FLOAT,
DATAPOINT_5 FLOAT,
DATAPOINT_6 FLOAT,
DATAPOINT_7 FLOAT,
DATAPOINT_8 FLOAT,
DATAPOINT_9 FLOAT,
DATAPOINT_10 FLOAT,
DATAPOINT_11 VARCHAR2 (768),
DATAPOINT_12 VARCHAR2 (768),
DATAPOINT_13 VARCHAR2 (768),
DATAPOINT_14 VARCHAR2 (768),
DATAPOINT_15 VARCHAR2 (768),
DATAPOINT_16 VARCHAR2 (768),
DATAPOINT_17 VARCHAR2 (768),
DATAPOINT_18 VARCHAR2 (768),
DATAPOINT_19 VARCHAR2 (768),
DATAPOINT_20 VARCHAR2 (768),
START_DATE DATE NOT NULL,
END_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_EQUIPMENT_PROD (
EQUIP_ID VARCHAR2 (23),
START_DATE DATE NOT NULL,
DATAPOINT_1 FLOAT,
DATAPOINT_2 FLOAT,
DATAPOINT_3 FLOAT,
DATAPOINT_4 FLOAT,
DATAPOINT_5 FLOAT,
DATAPOINT_6 FLOAT,
DATAPOINT_7 FLOAT,
DATAPOINT_8 FLOAT,
DATAPOINT_9 FLOAT,
DATAPOINT_10 FLOAT,
DATAPOINT_11 VARCHAR2 (768),
DATAPOINT_12 VARCHAR2 (768),
DATAPOINT_13 VARCHAR2 (768),
DATAPOINT_14 VARCHAR2 (768),
DATAPOINT_15 VARCHAR2 (768),
DATAPOINT_16 VARCHAR2 (768),
DATAPOINT_17 VARCHAR2 (768),
DATAPOINT_18 VARCHAR2 (768),
DATAPOINT_19 VARCHAR2 (768),
DATAPOINT_20 VARCHAR2 (768),
CARRIED_FORWARD NUMBER (1),
DATAPOINT_21 VARCHAR2 (768),
DATAPOINT_22 VARCHAR2 (768),
DATAPOINT_23 VARCHAR2 (768),
DATAPOINT_24 VARCHAR2 (768),
DATAPOINT_25 VARCHAR2 (768),
DATAPOINT_26 VARCHAR2 (768),
DATAPOINT_27 VARCHAR2 (768),
DATAPOINT_28 VARCHAR2 (768),
DATAPOINT_29 VARCHAR2 (768),
DATAPOINT_30 VARCHAR2 (768),
DATAPOINT_31 FLOAT,
DATAPOINT_32 FLOAT,
DATAPOINT_33 FLOAT,
DATAPOINT_34 FLOAT,
DATAPOINT_35 FLOAT,
DATAPOINT_36 FLOAT,
DATAPOINT_37 FLOAT,
DATAPOINT_38 FLOAT,
DATAPOINT_39 FLOAT,
DATAPOINT_40 FLOAT ) ;

CREATE TABLE FV_ERROR (
VERSION VARCHAR2 (23) NOT NULL,
ERROR_NUMBER NUMBER (10) NOT NULL,
ORACLE_ERROR NUMBER (10),
MESSAGE VARCHAR2 (765) ) ;

CREATE TABLE FV_EVENT (
EVENT_ID VARCHAR2 (23) NOT NULL,
ENTITY_ID VARCHAR2 (23) NOT NULL,
ENTITY_TYPE NUMBER (10),
START_TIME DATE NOT NULL,
END_TIME DATE NOT NULL,
DATE_STAMP DATE NOT NULL,
ORIGINAL_LANGUAGE_ID NUMBER (10) NOT NULL,
TITLE VARCHAR2 (768),
VALUE_1 FLOAT,
VALUE_1_CODE_ID VARCHAR2 (23),
VOLUME FLOAT,
VOLUME_UNIT VARCHAR2 (69),
CUSTOM_FIELD_1 VARCHAR2 (768),
CUSTOM_FIELD_2 VARCHAR2 (768),
CUSTOM_FIELD_3 VARCHAR2 (768),
CUSTOM_FIELD_4 VARCHAR2 (768),
CUSTOM_FIELD_5 VARCHAR2 (768),
CUSTOM_FIELD_6 VARCHAR2 (768),
CUSTOM_FIELD_7 VARCHAR2 (768),
CUSTOM_FIELD_8 VARCHAR2 (768),
CUSTOM_FIELD_9 VARCHAR2 (768),
CUSTOM_FIELD_10 VARCHAR2 (768),
CUSTOM_FIELD_11 VARCHAR2 (768),
CUSTOM_FIELD_12 VARCHAR2 (768),
CUSTOM_FIELD_13 VARCHAR2 (768),
CUSTOM_FIELD_14 VARCHAR2 (768),
CUSTOM_FIELD_15 VARCHAR2 (768),
CUSTOM_FIELD_16 VARCHAR2 (768),
CUSTOM_FIELD_17 VARCHAR2 (768),
CUSTOM_FIELD_18 VARCHAR2 (768),
CUSTOM_FIELD_19 VARCHAR2 (768),
CUSTOM_FIELD_20 VARCHAR2 (768),
CUSTOM_FIELD_21 VARCHAR2 (768),
CUSTOM_FIELD_22 VARCHAR2 (768),
CUSTOM_FIELD_23 VARCHAR2 (768),
CUSTOM_FIELD_24 VARCHAR2 (768),
CUSTOM_FIELD_25 VARCHAR2 (768),
CUSTOM_FIELD_26 VARCHAR2 (768),
CUSTOM_FIELD_27 VARCHAR2 (768),
CUSTOM_FIELD_28 VARCHAR2 (768),
CUSTOM_FIELD_29 VARCHAR2 (768),
CUSTOM_FIELD_30 VARCHAR2 (768),
CATEGORY_CODE_ID VARCHAR2 (23),
RELATED_ID VARCHAR2 (23) NOT NULL,
USER_ID VARCHAR2 (38),
APPLICATION_NAME VARCHAR2 (768),
INSERT_USER VARCHAR2 (114),
INSERT_TIME DATE,
UPDATE_USER VARCHAR2 (114),
UPDATE_TIME DATE ) ;

CREATE TABLE FV_EVENT_CODES (
CODE_ID VARCHAR2 (23) NOT NULL,
CODE_TYPE NUMBER (10) NOT NULL,
DELETE_DATE DATE,
NAME VARCHAR2 (120),
CODE VARCHAR2 (15),
DESCRIPTION VARCHAR2 (768) ) ;

CREATE TABLE FV_EVENT_COMMENT (
EVENT_ID VARCHAR2 (23) NOT NULL,
LANGUAGE_ID NUMBER (10) NOT NULL,
DESCRIPTION LONG ) ;

CREATE TABLE FV_EXTERNAL_FAC_NON_PROD (
SITE_ID VARCHAR2 (23),
START_DATE DATE,
FACILITY_TYPE_ID VARCHAR2 (23),
END_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_FACILITY (
FACILITY_ID VARCHAR2 (23) NOT NULL,
FACILITY_TYPE VARCHAR2 (60),
EQUIPMENT_ID VARCHAR2 (23),
SITE_ID VARCHAR2 (23),
START_TIME DATE,
END_TIME DATE,
NAME VARCHAR2 (120) ) ;

CREATE TABLE FV_FACILITY_CONNECTION (
FACILITY_CONNECTION_ID VARCHAR2 (23) NOT NULL,
TO_FACILITY VARCHAR2 (23),
FROM_FACILITY VARCHAR2 (23),
START_TIME DATE NOT NULL,
END_TIME DATE ) ;

CREATE TABLE FV_FACILITY_TYPE (
FACILITY_TYPE VARCHAR2 (60) NOT NULL ) ;

CREATE TABLE FV_FIELDVIEW_TABLE (
TABLE_NAME VARCHAR2 (30) NOT NULL,
ID_COLUMN_NAME VARCHAR2 (25),
CREATION_ORDER FLOAT NOT NULL,
GLOBAL FLOAT NOT NULL,
REPLICATE FLOAT NOT NULL,
HANDLE_DUPLICATES FLOAT NOT NULL,
DATE_KEY_COLUMN VARCHAR2 (25),
START_DATE_COLUMN VARCHAR2 (25),
END_DATE_COLUMN VARCHAR2 (25),
TRUNC_FLAG NUMBER (38) ) ;

CREATE TABLE FV_FILTER (
FILTER_ID VARCHAR2 (25) NOT NULL,
NAME VARCHAR2 (120) NOT NULL,
DESCRIPTION VARCHAR2 (765),
DATA LONG,
CREATED_BY VARCHAR2 (90),
CREATED_DATE DATE,
LAST_CHANGED_BY VARCHAR2 (90),
LAST_CHANGED_DATE DATE ) ;

CREATE TABLE FV_FLUID_ANALYSIS (
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL,
SAMPLE_POINT_ID VARCHAR2 (23) NOT NULL,
SAMPLE_POINT_TYPE NUMBER (10),
SAMPLE_ID VARCHAR2 (255),
START_DATE DATE NOT NULL,
LAB_DATE DATE,
END_DATE DATE,
EFFECT_CALCULATION NUMBER (1) NOT NULL,
FLUID_TYPE NUMBER (10),
DESCRIPTION VARCHAR2 (765),
HEAT_CONTENT FLOAT,
H2SPPM FLOAT,
DENSITY NUMBER (38,8),
SALINITY NUMBER (38,8),
BSW_CUT NUMBER (38,8),
DATAPOINT_1 NUMBER (38,8),
DATAPOINT_2 NUMBER (38,8),
DATAPOINT_3 NUMBER (38,8),
DATAPOINT_4 NUMBER (38,8),
DATAPOINT_5 NUMBER (38,8),
DATAPOINT_6 NUMBER (38,8),
DATAPOINT_7 NUMBER (38,8),
DATAPOINT_8 NUMBER (38,8),
DATAPOINT_9 NUMBER (38,8),
DATAPOINT_10 NUMBER (38,8),
DATAPOINT_11 NUMBER (38,8),
DATAPOINT_12 NUMBER (38,8),
DATAPOINT_13 NUMBER (38,8),
DATAPOINT_14 NUMBER (38,8),
DATAPOINT_15 NUMBER (38,8),
DATAPOINT_16 NUMBER (38,8),
DATAPOINT_17 NUMBER (38,8),
DATAPOINT_18 NUMBER (38,8),
DATAPOINT_19 NUMBER (38,8),
DATAPOINT_20 NUMBER (38,8),
DATAPOINT_21 NUMBER (38,8),
DATAPOINT_22 NUMBER (38,8),
DATAPOINT_23 NUMBER (38,8),
DATAPOINT_24 NUMBER (38,8),
DATAPOINT_25 NUMBER (38,8),
UPDATE_DATE DATE DEFAULT Sysdate NOT NULL,
DELETE_DATE DATE DEFAULT NULL ) ;

CREATE TABLE FV_FLUID_ANALYSIS_COMP (
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL,
FLUID_PHASE NUMBER (1) DEFAULT 2 NOT NULL,
N2 FLOAT,
CO2 FLOAT,
H2S FLOAT,
H2O FLOAT,
HE FLOAT,
C1 FLOAT,
C2 FLOAT,
C3 FLOAT,
IC4 FLOAT,
NC4 FLOAT,
IC5 FLOAT,
NC5 FLOAT,
C6 FLOAT,
C7 FLOAT,
C8 FLOAT,
C9 FLOAT,
C10 FLOAT,
O2 FLOAT,
CO FLOAT,
H2 FLOAT,
USER_COMPONENT_1 NUMBER (38,8),
USER_COMPONENT_2 NUMBER (38,8),
USER_COMPONENT_3 NUMBER (38,8),
USER_COMPONENT_4 NUMBER (38,8),
USER_COMPONENT_5 NUMBER (38,8),
USER_COMPONENT_6 NUMBER (38,8),
USER_COMPONENT_7 NUMBER (38,8),
USER_COMPONENT_8 NUMBER (38,8),
USER_COMPONENT_9 NUMBER (38,8),
USER_COMPONENT_10 NUMBER (38,8),
USER_COMPONENT_11 NUMBER (38,8),
USER_COMPONENT_12 NUMBER (38,8),
USER_COMPONENT_13 NUMBER (38,8),
USER_COMPONENT_14 NUMBER (38,8),
USER_COMPONENT_15 NUMBER (38,8),
USER_COMPONENT_16 NUMBER (38,8),
USER_COMPONENT_17 NUMBER (38,8),
USER_COMPONENT_18 NUMBER (38,8),
USER_COMPONENT_19 NUMBER (38,8),
USER_COMPONENT_20 NUMBER (38,8),
USER_COMPONENT_21 NUMBER (38,8),
USER_COMPONENT_22 NUMBER (38,8),
USER_COMPONENT_23 NUMBER (38,8),
USER_COMPONENT_24 NUMBER (38,8),
USER_COMPONENT_25 NUMBER (38,8) ) ;

CREATE TABLE FV_FLUID_ANALYSIS_REF_X (
REFERENCE_SITE_ID VARCHAR2 (23) NOT NULL,
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL ) ;

CREATE TABLE FV_FLUID_ANALYSIS_USAGE_X (
FLUID_ANALYSIS_USAGE_ID VARCHAR2 (23) NOT NULL,
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL,
USAGE_POINT_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE ) ;

CREATE TABLE FV_FLUID_SAMPLE (
FLUID_SAMPLE_ID VARCHAR2 (23) NOT NULL,
SAMPLE_CODE VARCHAR2 (255),
SAMPLE_DATE DATE NOT NULL,
FLUID_TYPE NUMBER (10),
SAMPLE_POINT_ID VARCHAR2 (23) NOT NULL,
SAMPLE_POINT_TYPE NUMBER (10),
VOLUME FLOAT,
SAMPLE_COLLECTOR VARCHAR2 (255),
SAMPLE_COMMENT VARCHAR2 (765),
DEFAULT_SAMPLE NUMBER (1) ) ;

CREATE TABLE FV_FLUID_SAMPLE_REF_X (
FLUID_SAMPLE_ID VARCHAR2 (23) NOT NULL,
REFERENCE_POINT_ID VARCHAR2 (23) NOT NULL ) ;

CREATE TABLE FV_FLUID_TYPE (
FLUID_TYPE NUMBER (10) NOT NULL,
FLUID_NAME VARCHAR2 (150) NOT NULL ) ;

CREATE TABLE FV_FS_FLUID_ANALYSIS (
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL,
FLUID_SAMPLE_ID VARCHAR2 (23) NOT NULL,
ANALYSIS_LAB_DATE DATE NOT NULL,
ANALYSIS_PRESSURE FLOAT,
ANALYSIS_TEMPERATURE FLOAT,
ACIDITY NUMBER (38,8),
API_GRAVITY NUMBER (38,8),
BSW_CUT NUMBER (38,8),
COND_HYDROCARBON_CONTENT NUMBER (38,8),
COND_WATER_CONTENT NUMBER (38,8),
COPPER_STRIP_CORROSION NUMBER (38,8),
CONDENSATE_DENSITY NUMBER (38,8),
CRUDE_OIL_TEMPERATURE NUMBER (38,8),
DISSOLVED_GAS_DENSITY NUMBER (38,8),
DISSOLVED_GAS_SG NUMBER (38,8),
DISSOLVED_GOR NUMBER (38,8),
DYNAMIC_VISCOSITY_T1 NUMBER (38,8),
DYNAMIC_VISCOSITY_T2 NUMBER (38,8),
EVAPORATION_TEST_95 NUMBER (38,8),
EXP_EMULSION_VISCOSITY NUMBER (38,8),
EMULSION_DENSITY NUMBER (38,8),
GAS_DENSITY_LINE_CONDITION NUMBER (38,8),
GAS_DENSITY_STD_CONDITION NUMBER (38,8),
GAS_VISCOSITY NUMBER (38,8),
GRANOLUMETRIC_FACTOR NUMBER (38,8) DEFAULT 0.0125,
HIGHER_GHV NUMBER (38,8),
HYDROCARBON_DEWPOINT NUMBER (38,8),
HYDROCARBON_DENSITY NUMBER (38,8),
LAB_TEMPERATURE NUMBER (38,8),
LOWER_GHV NUMBER (38,8),
MDEA_STANDARD NUMBER (38,8),
MOLECULAR_MASS NUMBER (38,8),
OIL_DENSITY_STD_CONDITION NUMBER (38,8),
OIL_DENSITY_LINE_CONDITION NUMBER (38,8),
OIL_DENSITY_AIR NUMBER (38,8),
OIL_DENSITY_VACCUM NUMBER (38,8),
OIL_RESIDUE NUMBER (38,8),
OIL_VISCOSITY NUMBER (38,8),
PARTICLE_DIAMETER NUMBER (38,8),
PLUGGING_INDEX_10 NUMBER (38,8),
PLUGGING_INDEX_20 NUMBER (38,8),
PPB_O2 NUMBER (38,8),
REAL_POUR_POINT NUMBER (38,8),
RESIDUE_AFTER_EVAPORATION NUMBER (38,8),
SALINITY NUMBER (38,8),
SHRINKAGE_FACTOR NUMBER (38,8),
SG_BASE_CONDITION NUMBER (38,8),
STD_POUR_POINT NUMBER (38,8),
TEMP_MUD1_MEASUREMENT NUMBER (38,8),
TEMP_MUD2_MEASUREMENT NUMBER (38,8),
VALVE_FREEZE_TEST NUMBER (38,8),
VAPOR_PRESSURE NUMBER (38,8),
WATER_CONTENT_IN_GAS NUMBER (38,8),
WATER_DENSITY NUMBER (38,8),
WATER_VISCOSITY NUMBER (38,8),
WATER_DENSITY_STD_CONDITION NUMBER (38,8),
WATER_DEWPOINT NUMBER (38,8),
WATER_PERCENTAGE_IN_OIL NUMBER (38,8),
Z_FACTOR_BASE_CONDITION NUMBER (38,8),
Z_FACTOR_STD_CONDITION NUMBER (38,8),
Z_FACTOR_LINE_CONDITION NUMBER (38,8),
DATAPOINT_1 NUMBER (38,8),
DATAPOINT_2 NUMBER (38,8),
DATAPOINT_3 NUMBER (38,8),
DATAPOINT_4 NUMBER (38,8),
DATAPOINT_5 NUMBER (38,8),
DATAPOINT_6 NUMBER (38,8),
DATAPOINT_7 NUMBER (38,8),
DATAPOINT_8 NUMBER (38,8),
DATAPOINT_9 NUMBER (38,8),
DATAPOINT_10 NUMBER (38,8),
DATAPOINT_11 NUMBER (38,8),
DATAPOINT_12 NUMBER (38,8),
DATAPOINT_13 NUMBER (38,8),
DATAPOINT_14 NUMBER (38,8),
DATAPOINT_15 NUMBER (38,8),
DATAPOINT_16 NUMBER (38,8),
DATAPOINT_17 NUMBER (38,8),
DATAPOINT_18 NUMBER (38,8),
DATAPOINT_19 NUMBER (38,8),
DATAPOINT_20 NUMBER (38,8),
DATAPOINT_21 NUMBER (38,8),
DATAPOINT_22 NUMBER (38,8),
DATAPOINT_23 NUMBER (38,8),
DATAPOINT_24 NUMBER (38,8),
DATAPOINT_25 NUMBER (38,8),
HEAT_CONTENT NUMBER (38,8),
H2SPPM NUMBER (38,8),
DENSITY NUMBER (38,8),
ANALYSIS_CODE VARCHAR2 (255) ) ;

CREATE TABLE FV_GAS_EXPANSION_DATA (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
TEMPERATURE_0 FLOAT,
TEMPERATURE_1 FLOAT,
TEMPERATURE_2 FLOAT,
TEMPERATURE_3 FLOAT,
TEMPERATURE_4 FLOAT,
PRESSURE_0 FLOAT,
PRESSURE_1 FLOAT,
PRESSURE_2 FLOAT,
PRESSURE_3 FLOAT,
PRESSURE_4 FLOAT,
FACTOR_00 FLOAT,
FACTOR_01 FLOAT,
FACTOR_02 FLOAT,
FACTOR_03 FLOAT,
FACTOR_04 FLOAT,
FACTOR_10 FLOAT,
FACTOR_11 FLOAT,
FACTOR_12 FLOAT,
FACTOR_13 FLOAT,
FACTOR_14 FLOAT,
FACTOR_20 FLOAT,
FACTOR_21 FLOAT,
FACTOR_22 FLOAT,
FACTOR_23 FLOAT,
FACTOR_24 FLOAT,
FACTOR_30 FLOAT,
FACTOR_31 FLOAT,
FACTOR_32 FLOAT,
FACTOR_33 FLOAT,
FACTOR_34 FLOAT,
FACTOR_40 FLOAT,
FACTOR_41 FLOAT,
FACTOR_42 FLOAT,
FACTOR_43 FLOAT,
FACTOR_44 FLOAT,
END_DATE DATE ) ;

CREATE TABLE FV_GAS_PLANT_APP_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
TOTAL_GAS_PRODUCTION NUMBER,
TOTAL_GAS_INJECTION NUMBER,
TOTAL_OIL_PRODUCTION NUMBER,
TOTAL_WATER_PRODUCTION NUMBER,
TOTAL_COND_PRODUCTION NUMBER,
TOTAL_NGL_PRODUCTION NUMBER,
TOTAL_C3_PRODUCTION NUMBER,
TOTAL_C4_PRODUCTION NUMBER,
TOTAL_C5_PRODUCTION NUMBER,
TOTAL_SULPHUR_PRODUCTION NUMBER,
TRUCKED_C3_DISP NUMBER,
TRUCKED_C4_DISP NUMBER,
TRUCKED_C5_DISP NUMBER,
TRUCKED_SULPHUR_DISP NUMBER,
TRUCKED_C3_RECPT NUMBER,
TRUCKED_C4_RECPT NUMBER,
TRUCKED_C5_RECPT NUMBER,
TRUCKED_SULPHUR_RECPT NUMBER,
CALC_GAS_INPUT NUMBER,
CALC_OIL_INPUT NUMBER,
CALC_WATER_INPUT NUMBER,
CALC_COND_INPUT NUMBER,
TOTAL_OIL_PROD_MASS FLOAT,
TOTAL_COND_PROD_MASS FLOAT,
CALC_OIL_DENSITY FLOAT,
CALC_COND_DENSITY FLOAT,
TOTAL_OIL_PRODUCTION_60F FLOAT,
TOTAL_COND_PRODUCTION_60F FLOAT,
TOTAL_OIL_PRODUCTION_15C FLOAT,
TOTAL_COND_PRODUCTION_15C FLOAT ) ;

CREATE TABLE FV_GAS_PLANT_CALC_INPUT_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
CALC_GAS_INPUT NUMBER,
CALC_OIL_INPUT NUMBER,
CALC_WATER_INPUT NUMBER,
CALC_COND_INPUT NUMBER ) ;

CREATE TABLE FV_GAS_PLANT_GAS_PROD2_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
TOTAL_GAS_PRODUCTION NUMBER ) ;

CREATE TABLE FV_GAS_PLANT_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
GAS_SHRINK_METHOD FLOAT,
MANUAL_GAS_SHRINK FLOAT,
LPG_SHRINK_METHOD FLOAT,
MANUAL_LPG_SHRINK FLOAT,
PROCESS_MIX_STATUS FLOAT,
C3_TARGET FLOAT,
C4_TARGET FLOAT,
C5_TARGET FLOAT,
MIXTURE_TARGET FLOAT,
WATER_TARGET FLOAT,
COND_TARGET FLOAT,
SULPHUR_TARGET FLOAT,
CHEMICAL_TARGET FLOAT,
GAS_PLANT_TYPE FLOAT,
ALLOCATION_STATUS FLOAT,
END_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_GAS_PLANT_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS_ON FLOAT,
COND_RVP FLOAT,
WATER_DEWPOINT FLOAT,
HC_DEWPOINT FLOAT,
CARRIED_FORWARD NUMBER (5) ) ;

CREATE TABLE FV_GAS_WELL_EXP_PROD_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
EXPECTED_GAS_PRODUCTION NUMBER,
EXPECTED_OIL_PRODUCTION NUMBER,
EXPECTED_WATER_PRODUCTION NUMBER,
EXPECTED_COND_PRODUCTION NUMBER ) ;

CREATE TABLE FV_GAS_WELL_LOST_PROD_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
LOST_CONDENSATE_PRODUCTION NUMBER,
LOST_WATER_PRODUCTION NUMBER,
LOST_GAS_PRODUCTION NUMBER ) ;

CREATE TABLE FV_GAS_WELL_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
UNIT_ID VARCHAR2 (23),
POOL_ID VARCHAR2 (23),
ZONE_ID VARCHAR2 (23),
AREA_ID VARCHAR2 (23),
LEASE VARCHAR2 (60),
AGREEMENT VARCHAR2 (60),
WELL_DEPTH FLOAT,
LOCATION_OF_FLARE FLOAT,
LOCATION_OF_FUEL FLOAT,
THEORETICAL_PROD FLOAT,
MAX_PROD_AVAILABLE FLOAT,
USE_WG_RATIO FLOAT,
USE_CG_RATIO FLOAT,
USE_LG_RATIO FLOAT,
WG_RATIO FLOAT,
CG_RATIO FLOAT,
LG_RATIO FLOAT,
GAS_TARGET_RATE FLOAT,
WATER_TARGET_RATE FLOAT,
COND_TARGET_RATE FLOAT,
MANUAL_SHRINKAGE FLOAT,
USE_MANUAL_SHRINKAGE FLOAT,
REGULATORY_STATUS VARCHAR2 (69),
CHOKE_SIZE FLOAT,
RESERVOIR_ID VARCHAR2 (23),
GAS_WELL_TYPE FLOAT,
OIL_DENSITY FLOAT,
ALLOCATION_STATUS FLOAT,
OIL_TARGET_RATE FLOAT,
END_DATE DATE,
REASON_NOT_IN_USE_ID VARCHAR2 (23),
REGULATORY_WELL_TYPE_ID VARCHAR2 (23),
REGULATORY_OP_METHOD_ID VARCHAR2 (23),
WATER_DISPOSITION_ID VARCHAR2 (23),
OPERATOR_ID VARCHAR2 (23),
UPDATE_DATE DATE DEFAULT Sysdate NOT NULL,
MAX_TUBING_CHOKE_SIZE FLOAT,
MAX_CASING_CHOKE_SIZE FLOAT,
LEASE_ID VARCHAR2 (23),
DISTRICT_ID VARCHAR2 (23),
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_GAS_WELL_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS_ON FLOAT,
CASING_PRESS FLOAT,
CASING_LEVEL FLOAT,
TUBING_PRESS FLOAT,
TUBING_TEMP FLOAT,
WELL_HEAD_PRESS FLOAT,
WELL_HEAD_TEMP FLOAT,
PIPELINE_PRESS FLOAT,
PIPELINE_TEMP FLOAT,
GAS_BLOW_DOWN FLOAT,
BATH_TEMP FLOAT,
HOURS_INJECTING FLOAT,
CARRIED_FORWARD NUMBER (5),
TUBING_CHOKE_SIZE FLOAT,
CASING_CHOKE_SIZE FLOAT,
CHOKE_SIZE FLOAT,
TIMER_HOURS_ON FLOAT,
UPDATE_DATE DATE DEFAULT Sysdate NOT NULL ) ;

CREATE TABLE FV_GEOGRAPHIC_LOCATIONS (
LIST_ID VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (120),
SHORT_NAME VARCHAR2 (30),
CODE VARCHAR2 (60),
SEC_CODE VARCHAR2 (60),
DESCRIPTION VARCHAR2 (765),
LIST_TYPE FLOAT NOT NULL,
DELETE_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_GP_INLET_GAS_PROD_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INLET_GAS_PRODUCTION NUMBER ) ;

CREATE TABLE FV_GP_LIQ_METER_RECPT_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
METER_OIL_RECPTS FLOAT,
METER_WATER_RECPTS FLOAT,
METER_COND_RECPTS FLOAT,
METER_C3_RECPTS FLOAT,
METER_C4_RECPTS FLOAT,
METER_C5_RECPTS FLOAT,
METER_NGL_RECPTS FLOAT,
METER_SULPHUR_RECPTS FLOAT,
METER_GAS_RECPTS FLOAT ) ;

CREATE TABLE FV_GRAPH_TEMPLATES (
REPORT_ID VARCHAR2 (23) NOT NULL,
DETAIL_KEY NUMBER NOT NULL,
TEMPLATE_DATA LONG RAW ) ;

CREATE TABLE FV_GROUPS (
GROUP_ID VARCHAR2 (23) NOT NULL,
USER_ID VARCHAR2 (23),
NAME VARCHAR2 (120) NOT NULL,
ALL_SITES FLOAT,
VIEW_CONNECTION FLOAT,
FILTER_VARIABLE FLOAT,
FILTER_OPERATOR FLOAT,
FILTER_VALUE FLOAT,
INCLUDE_EMPTY FLOAT,
GUID VARCHAR2 (38),
DELETE_DATE DATE,
QUERY_ID VARCHAR2 (25),
FOLDER_TYPE NUMBER (1) DEFAULT 0 NOT NULL,
PARENT_GROUP_ID VARCHAR2 (23),
DESCRIPTION VARCHAR2 (768) ) ;

CREATE TABLE FV_GROUP_SITE (
GROUP_ID VARCHAR2 (23) NOT NULL,
SITE_ID VARCHAR2 (23) NOT NULL,
LIST_POSITION FLOAT ) ;

CREATE TABLE FV_INJECTION_WELL_PROD_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INJECTED_SRC_WATER NUMBER,
INJECTED_PROD_WATER NUMBER,
INJECTED_GAS NUMBER,
INJECTED_CO2 NUMBER,
CUMULATIVE_INJECTED_VOLUME NUMBER ) ;

CREATE TABLE FV_INJ_FACILITY_APP_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
TOTAL_INJECTED NUMBER,
METER_PROD_WATER_OUT NUMBER,
METER_PROD_WATER_IN NUMBER,
METER_SRC_WATER_OUT NUMBER,
METER_SRC_WATER_IN NUMBER,
OPEN_PROD_WATER_INV NUMBER,
PROD_WATER_INV NUMBER,
OPEN_SRC_WATER_INV NUMBER,
SRC_WATER_INV NUMBER,
TRUCKED_PROD_WATER_RECPT NUMBER,
TRUCKED_PROD_WATER_DISP NUMBER,
TRUCKED_SRC_WATER_RECPT NUMBER,
TRUCKED_SRC_WATER_DISP NUMBER,
SOURCE_CO2 NUMBER,
PRODUCE_CO2 NUMBER,
SOURCE_HC NUMBER,
PRODUCE_HC NUMBER,
TOTAL_INJECTED_GAS NUMBER,
TOTAL_INJECTED_LIQUID NUMBER,
SOURCE_CO2_OUT NUMBER,
PRODUCE_CO2_OUT NUMBER,
SOURCE_HC_OUT NUMBER,
PRODUCE_HC_OUT NUMBER ) ;

CREATE TABLE FV_INJ_FAC_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
INJECTION_TARGET FLOAT,
END_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_INJ_FAC_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS_ON FLOAT,
CARRIED_FORWARD NUMBER (5) ) ;

CREATE TABLE FV_INJ_WELL_APP_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INJECTED_PROD_WATER NUMBER,
INJECTED_SRC_WATER NUMBER,
INJECTED_GAS NUMBER,
INJECTED_CO2 NUMBER,
INJECTED_HC NUMBER ) ;

CREATE TABLE FV_INJ_WELL_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
ZONE_ID VARCHAR2 (23),
POOL_ID VARCHAR2 (23),
UNIT_ID VARCHAR2 (23),
AREA_ID VARCHAR2 (23),
LEASE VARCHAR2 (60),
AGREEMENT VARCHAR2 (60),
TARGET_RATE FLOAT,
CHOKE_SIZE FLOAT,
INJECTOR_TYPE FLOAT,
REGULATORY_STATUS VARCHAR2 (69),
CALCULATION_TYPE FLOAT,
RESERVOIR_ID VARCHAR2 (23),
END_DATE DATE,
TARGET_PRESSURE FLOAT,
TARGET_VOLUME FLOAT,
REASON_NOT_IN_USE_ID VARCHAR2 (23),
REGULATORY_WELL_TYPE_ID VARCHAR2 (23),
SOURCE_OF_WATER_ID VARCHAR2 (23),
WATER_TYPE_ID VARCHAR2 (23),
OPERATOR_ID VARCHAR2 (23),
MAX_TUBING_CHOKE_SIZE FLOAT,
MAX_CASING_CHOKE_SIZE FLOAT,
LEASE_ID VARCHAR2 (23),
DISTRICT_ID VARCHAR2 (23),
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_INJ_WELL_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS FLOAT,
WELL_HEAD_PRESS FLOAT,
CASING_PRESS FLOAT,
SALINITY FLOAT,
ESTIMATED_VOLUME FLOAT,
CARRIED_FORWARD NUMBER (5),
WATER_PRESSURE FLOAT,
GAS_PRESSURE FLOAT,
GAS_TEMPERATURE FLOAT,
DOWNTIME_SCHEDULED NUMBER (5),
TUBING_CHOKE_SIZE FLOAT,
CASING_CHOKE_SIZE FLOAT,
CHOKE_SIZE FLOAT,
TUBING_PRESS FLOAT ) ;

CREATE TABLE FV_INLET_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
SHRINKAGE FLOAT,
USE_SULPHUR_CALC FLOAT,
ALLOCATION_STATUS FLOAT,
GAS_SHRINK_METHOD FLOAT,
END_DATE DATE,
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_INLET_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
PRESS FLOAT,
TEMPERATURE FLOAT,
H2S_PERCENT FLOAT,
CARRIED_FORWARD NUMBER (5) ) ;

CREATE TABLE FV_INTERFACE_VAR_TYPES (
VERSION VARCHAR2 (23) NOT NULL,
VARIABLE_ID_STRING VARCHAR2 (150) NOT NULL,
VARIABLE_ID NUMBER (10),
LONG_NAME VARCHAR2 (75),
SHORT_NAME VARCHAR2 (60),
VARIABLE_TYPE VARCHAR2 (60),
UNIT_TYPE VARCHAR2 (60),
DISPLAY_FORMAT VARCHAR2 (30),
LOWER_LIMIT VARCHAR2 (120),
UPPER_LIMIT VARCHAR2 (120),
CATEGORY NUMBER (5),
SCOPE VARCHAR2 (120) ) ;

CREATE TABLE FV_INTRA_DAY_METER_CALC (
CALC_ID VARCHAR2 (23) NOT NULL,
EQUIP_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INTRADAY_SEQUENCE_ID NUMBER (18) NOT NULL,
TEST_WELL_ID VARCHAR2 (23) NOT NULL,
COND_VOLUME FLOAT,
OIL_VOLUME FLOAT,
SAND_VOLUME FLOAT,
WATER_VOLUME FLOAT,
GAS_VOLUME FLOAT,
ESTIMATED FLOAT,
CO2_VOLUME FLOAT,
CORRECTED_VOLUME FLOAT,
EMULSION_VOLUME FLOAT,
MIXTURE_VOLUME FLOAT,
NGL_VOLUME FLOAT,
C3_VOLUME FLOAT,
C4_VOLUME FLOAT,
STEAM_VOLUME FLOAT,
SLOP_VOLUME FLOAT,
CORRECTED_COND_VOLUME FLOAT,
CALC_TOTAL_VOLUME FLOAT,
CALCULATED_VOLUME FLOAT,
CORRECTED_DENSITY FLOAT,
CORRECTION_FACTOR FLOAT,
CALC_MASS FLOAT,
MASS FLOAT,
GAS_OIL_RATIO FLOAT,
SHRINKAGE FLOAT,
YIELD_GAS_FACTOR FLOAT,
CONDENSATE_GAS_FACTOR FLOAT,
CORRECTED_GAS_VOLUME FLOAT,
HYDROCARBON_MASS FLOAT ) ;

CREATE TABLE FV_INTRA_DAY_TANK_CALC (
CALC_ID VARCHAR2 (23) NOT NULL,
EQUIP_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INTRADAY_SEQUENCE_ID CHAR (10) NOT NULL,
TEST_WELL_ID VARCHAR2 (23) NOT NULL,
LIQUID_VOLUME FLOAT,
COND_VOLUME FLOAT,
OIL_VOLUME FLOAT,
WATER_VOLUME FLOAT,
SAND_VOLUME FLOAT,
DELTA_COND FLOAT,
DELTA_OIL FLOAT,
DELTA_WATER FLOAT,
DELTA_SAND FLOAT,
ESTIMATED NUMBER (10),
CORRECTED_VOLUME FLOAT,
CHEMICAL_VOLUME FLOAT,
EMULSION_VOLUME FLOAT,
MIXTURE_VOLUME FLOAT,
NGL_VOLUME FLOAT,
SULPHUR_VOLUME FLOAT,
C3_VOLUME FLOAT,
C4_VOLUME FLOAT,
SLOP_VOLUME FLOAT,
DELTA_CHEMICAL FLOAT,
DELTA_EMULSION FLOAT,
DELTA_MIXTURE FLOAT,
DELTA_NGL FLOAT,
DELTA_SULPHUR FLOAT,
DELTA_C3 FLOAT,
DELTA_C4 FLOAT,
DELTA_SLOP FLOAT,
CORRECTED_COND_VOLUME FLOAT,
CORRECTION_FACTOR FLOAT,
CALC_TOTAL_VOLUME FLOAT,
CALC_CORRECTED_GRAVITY FLOAT,
DELTA_LIQUID_VOLUME FLOAT,
DELTA_PRIMARY_FLUID_VOLUME FLOAT,
FREE_WATER_VOLUME FLOAT,
CALC_MASS FLOAT,
MASS FLOAT,
HYDROCARBON_MASS FLOAT ) ;

CREATE TABLE FV_MATERIAL_COMPOSITION (
FLUID_ANALYSIS_ID VARCHAR2 (23) NOT NULL,
FLUID_PHASE NUMBER (10) NOT NULL,
MATERIAL_TYPE NUMBER (10) NOT NULL,
MASS FLOAT,
MOLE FLOAT,
VOLUME FLOAT,
CONCENTRATION FLOAT ) ;

CREATE TABLE FV_METER_CALC (
EQUIP_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
COND_VOLUME FLOAT,
OIL_VOLUME FLOAT,
SAND_VOLUME FLOAT,
WATER_VOLUME FLOAT,
GAS_VOLUME FLOAT,
ESTIMATED NUMBER (10),
CO2_VOLUME FLOAT,
CORRECTED_VOLUME FLOAT,
CALCULATED_VOLUME FLOAT,
EMULSION_VOLUME FLOAT,
MIXTURE_VOLUME FLOAT,
NGL_VOLUME FLOAT,
C3_VOLUME FLOAT,
C4_VOLUME FLOAT,
STEAM_VOLUME FLOAT,
SLOP_VOLUME FLOAT,
CORRECTED_DENSITY FLOAT,
CORRECTION_FACTOR FLOAT,
CORRECTED_COND_VOLUME FLOAT,
CALC_TOTAL_VOLUME FLOAT,
CALC_MASS FLOAT,
MASS FLOAT,
GAS_OIL_RATIO FLOAT,
SHRINKAGE FLOAT,
YIELD_GAS_FACTOR FLOAT,
CONDENSATE_GAS_FACTOR FLOAT,
CORRECTED_GAS_VOLUME FLOAT,
HYDROCARBON_MASS FLOAT,
CHEMICAL_VOLUME FLOAT,
DRY_GAS_MASS FLOAT,
WET_GAS_VOLUME_LINE FLOAT,
WET_GAS_MASS FLOAT,
CONDENSATE_MASS FLOAT,
UNSTABILIZED_FLUID_VOLUME FLOAT,
UNSTABILIZED_FLUID_MASS FLOAT,
WATER_VOLUME_LINE FLOAT,
WATER_VOLUME_STD FLOAT,
WATER_MASS FLOAT,
OIL_MASS FLOAT,
TOTAL_FLUID_MASS FLOAT,
Z_FACTOR_LINE FLOAT,
Z_FACTOR_STANDARD FLOAT,
Z_FACTOR_BASE FLOAT,
GAS_DENSITY_LINE FLOAT,
GAS_DENSITY_STANDARD FLOAT,
GAS_DENSITY_BASE FLOAT,
VOLUMETRIC_FLOW_RATE FLOAT,
MASS_FLOW_RATE FLOAT,
GAS_ENERGY_STANDARD FLOAT ) ;

CREATE TABLE FV_METER_FLAGS_R_CALC (
DATE_STAMP DATE,
SITE_ID VARCHAR2 (23),
CONNECTION_METER_ID VARCHAR2 (23),
REAL_METER_ID VARCHAR2 (23),
SALES_FLAG FLOAT,
PRODUCTION_FLAG FLOAT,
FIELD_PRODUCTION_FLAG FLOAT,
ALLOCATION_FLAG FLOAT,
METER_GAS FLOAT,
METER_FUEL_GAS FLOAT,
METER_FLARE_GAS FLOAT,
METER_BUYBACK_GAS FLOAT,
METER_OIL FLOAT,
METER_WATER FLOAT,
METER_COND FLOAT,
METER_C3 FLOAT,
METER_C4 FLOAT,
METER_C5 FLOAT,
METER_NGL FLOAT,
METER_SULPHUR FLOAT,
METER_SAND FLOAT,
METER_MIXTURE FLOAT,
METER_CO2 FLOAT,
METER_INJECTED_GAS FLOAT,
METER_STD_DEV FLOAT DEFAULT 0.0,
METER_OIL_MASS FLOAT,
METER_COND_MASS FLOAT ) ;

CREATE TABLE FV_METER_NON_PROD (
NON_PROD_ID VARCHAR2 (23) NOT NULL,
EQUIP_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
TIME_OF_DAY FLOAT,
FLUID_TYPE FLOAT,
METER_TAPS_TYPE FLOAT,
METER_FACTOR FLOAT,
INPUT_TYPE FLOAT,
METAL_TYPE FLOAT,
LINE_SIZE FLOAT,
COUNTER_METER_TYPE FLOAT,
GAS_EQUIV_FACTOR FLOAT,
STATIC_PRESS_LOC FLOAT,
FULL_SCALE_TEMP FLOAT,
FULL_SCALE_STATIC FLOAT,
FULL_SCALE_DIFF FLOAT,
Z_FACTOR_CALC_TYPE FLOAT,
DENSITY FLOAT,
BASE_PRESS FLOAT,
BASE_TEMP FLOAT,
METER_PURPOSE FLOAT,
USE_IN_BALANCE FLOAT,
FLUID_DIRECTION FLOAT,
LATITUDE FLOAT,
ELEVATION FLOAT,
CHART_TYPE_TEMP FLOAT,
BOTTOM_SCALE_TEMP FLOAT,
BOTTOM_SCALE_STATIC FLOAT,
BOTTOM_SCALE_DIFF FLOAT,
CHART_TYPE_STATIC FLOAT,
CHART_TYPE_DIFF FLOAT,
MIN_TEMP_SCALE FLOAT,
INITIAL_READING FLOAT,
ROLLOVER_COUNT FLOAT,
CONVERSION_FACTOR FLOAT,
AUTO_CALC_READINGS FLOAT,
CALC_GAS_EQUIVALENT FLOAT,
END_DATE DATE,
ALLOCATION_FLAG NUMBER (5),
RECOMBINATION_FLAG NUMBER (5),
PRODUCTION_FLAG NUMBER (5),
FIELD_PRODUCTION_FLAG NUMBER (5),
SALES_FLAG NUMBER (5),
STREAM_ID VARCHAR2 (23),
GAS_PD_CONV_FACTOR FLOAT,
MAPPED_CONVERSION FLOAT,
GRAVITY FLOAT,
READINGS_FLAG NUMBER (5),
TEMP_CORR_FLAG FLOAT DEFAULT 1 NOT NULL,
CORRECTION_UNIT FLOAT DEFAULT 0 NOT NULL,
PROD_GAS_ALLOC_BASE NUMBER (1) DEFAULT 0,
SALES_GAS_ALLOC_BASE NUMBER (1) DEFAULT 0,
OIL_ALLOC_BASE NUMBER (1) DEFAULT 0,
WATER_ALLOC_BASE NUMBER (1) DEFAULT 0,
COND_ALLOC_BASE NUMBER (1) DEFAULT 0,
CO2_ALLOC_BASE NUMBER (1) DEFAULT 0,
ALLOC_AS_PROD_GAS NUMBER (1) DEFAULT 0,
ALLOC_AS_SALES_GAS NUMBER (1) DEFAULT 0,
ALLOC_AS_OIL NUMBER (1) DEFAULT 0,
ALLOC_AS_WATER NUMBER (1) DEFAULT 0,
ALLOC_AS_COND NUMBER (1) DEFAULT 0,
ALLOC_AS_CO2 NUMBER (1) DEFAULT 0,
DERIVED_VOLUME_UNIT FLOAT,
LINE_METAL_TYPE FLOAT,
CALC_CORRECTION_FLAG NUMBER (5) DEFAULT 1,
CO2_CONVERSION_FACTOR FLOAT,
VOLUME_FROM_MASS_DENSITY NUMBER (5) DEFAULT 1,
CONFIDENCE_FACTOR FLOAT DEFAULT 0.0,
COMPANY_ID VARCHAR2 (23),
PURCHASER_METER_ID VARCHAR2 (50),
USE_AS_SALES_FOR_PA FLOAT,
DISPOSITION_TYPE NUMBER (5),
CHANGE_COUNTER NUMBER (15),
FLOW_RATE_CALC_TYPE NUMBER (1),
CONNECTED_TO_EQUIP_ID VARCHAR2 (23),
PD_METER_BASE_PRESS FLOAT,
PD_METER_BASE_TEMP FLOAT,
MEASUREMENT_TYPE NUMBER (5),
FLUID_GROUP NUMBER (5),
STANDARD_PRESSURE FLOAT,
STANDARD_TEMPERATURE FLOAT,
DERIVED_RESULT_TYPE FLOAT,
MASS_CONVERSION_FACTOR FLOAT,
DERIVED_FUNCTION_FLAG NUMBER (1) DEFAULT 0 NOT NULL,
DERIVED_FUNCTION_NAME VARCHAR2 (30) ) ;

CREATE TABLE FV_MODEL_TYPE (
MODEL_TYPE NUMBER (5) NOT NULL,
NAME VARCHAR2 (50) NOT NULL,
FORMULA VARCHAR2 (250),
PARAM_OUT_UNIT_NAME VARCHAR2 (25),
CONST_A_LABEL VARCHAR2 (25),
SHOW_CONST_A NUMBER (1) DEFAULT 0 NOT NULL,
CONST_B_LABEL VARCHAR2 (25),
SHOW_CONST_B NUMBER (1) DEFAULT 0 NOT NULL,
CONST_C_LABEL VARCHAR2 (25),
SHOW_CONST_C NUMBER (1) DEFAULT 0 NOT NULL,
CONST_D_LABEL VARCHAR2 (25),
SHOW_CONST_D NUMBER (1) DEFAULT 0 NOT NULL,
CONST_E_LABEL VARCHAR2 (25),
SHOW_CONST_E NUMBER (1) DEFAULT 0 NOT NULL,
PARAM_1_VARIDSTR VARCHAR2 (25),
PARAM_1_UNIT_NAME VARCHAR2 (25),
SHOW_PARAM_1 NUMBER (1) DEFAULT 0 NOT NULL,
PARAM_2_VARIDSTR VARCHAR2 (25),
PARAM_2_UNIT_NAME VARCHAR2 (25),
SHOW_PARAM_2 NUMBER (1) DEFAULT 0 NOT NULL,
PARAM_3_VARIDSTR VARCHAR2 (25),
PARAM_3_UNIT_NAME VARCHAR2 (25),
SHOW_PARAM_3 NUMBER (1) DEFAULT 0 NOT NULL,
PARAM_4_VARIDSTR VARCHAR2 (25),
PARAM_4_UNIT_NAME VARCHAR2 (25),
SHOW_PARAM_4 NUMBER (1) DEFAULT 0 NOT NULL,
PARAM_5_VARIDSTR VARCHAR2 (25),
PARAM_5_UNIT_NAME VARCHAR2 (25),
SHOW_PARAM_5 NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_BSW NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_GOR NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_CGR NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_WGR NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_CONF_FACTOR NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_OIL_DENSITY NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_WATER_DENSITY NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_GAS_DENSITY NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_VOL_CONF_FACTOR NUMBER (1) DEFAULT 0 NOT NULL,
SHOW_DENS_CONF_FACTOR NUMBER (1) DEFAULT 0 NOT NULL,
PROCEDURE_NAME VARCHAR2 (60),
CONST_F_LABEL VARCHAR2 (25),
SHOW_CONST_F NUMBER (1) DEFAULT 0 NOT NULL,
CONST_G_LABEL VARCHAR2 (25),
SHOW_CONST_G NUMBER (1) DEFAULT 0 NOT NULL,
CONST_H_LABEL VARCHAR2 (25),
SHOW_CONST_H NUMBER (1) DEFAULT 0 NOT NULL,
CONST_I_LABEL VARCHAR2 (25),
SHOW_CONST_I NUMBER (1) DEFAULT 0 NOT NULL,
CONST_J_LABEL VARCHAR2 (25),
SHOW_CONST_J NUMBER (1) DEFAULT 0 NOT NULL ) ;

CREATE TABLE FV_MULTI_WELL_TEST (
MULTI_WELL_TEST_ID VARCHAR2 (23) NOT NULL,
FACILITY_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE NOT NULL,
TEST_TYPE FLOAT NOT NULL,
TEST_VESSEL_ID VARCHAR2 (23),
HOURS_TEST_DATA FLOAT,
CHOKE_OPENING FLOAT,
MULTI_WELL_HEAD_PRESSURE FLOAT,
MULTI_WELL_HEAD_TEMPERATURE FLOAT,
MULTI_WELL_HEAD_DIFF_PRESSURE FLOAT,
GAS_LIFT_FLOWRATE FLOAT,
MWH_GAS_LIFT_PRESSURE FLOAT,
MWH_GAS_LIFT_TEMPERATURE FLOAT,
GAS_LIFT_PRESSURE FLOAT,
GAS_LIFT_TEMPERATURE FLOAT,
MULTI_WELL_PROD_LIQ_FR_CALC FLOAT,
MULTI_WELL_PROD_GAS_FR_CALC FLOAT,
MANIFOLD_1_PRESSURE FLOAT,
MANIFOLD_1_TEMPERATURE FLOAT,
MANIFOLD_2_PRESSURE FLOAT,
MANIFOLD_2_TEMPERATURE FLOAT,
MANIFOLD_3_PRESSURE FLOAT,
MANIFOLD_3_TEMPERATURE FLOAT,
SEPARATOR_PRESSURE FLOAT,
SEPARATOR_TEMPERATURE FLOAT,
SEPARATOR_GAS_TEMP FLOAT,
SEPARATOR_GAS_DENSITY FLOAT,
SEPARATOR_BSW FLOAT,
SEPARATOR_ANLYZR_LIQ_FR FLOAT,
ANHYDROUS_OIL_FLOWRATE FLOAT,
PRODUCTION_WATER_FLOWRATE FLOAT,
PRODUCTION_GAS_FLOWRATE FLOAT,
CALC_GAS_LIFT_FLOWRATE FLOAT,
BSW FLOAT,
GOR FLOAT,
GORI FLOAT,
GLRT FLOAT,
MULTI_WELL_COMMENT VARCHAR2 (768),
DATAPOINT_1 FLOAT,
DATAPOINT_2 FLOAT,
DATAPOINT_3 FLOAT,
DATAPOINT_4 FLOAT,
DATAPOINT_5 FLOAT,
DATAPOINT_6 FLOAT,
DATAPOINT_7 FLOAT,
DATAPOINT_8 FLOAT,
DATAPOINT_9 FLOAT,
DATAPOINT_10 FLOAT,
DATAPOINT_11 VARCHAR2 (768),
DATAPOINT_12 VARCHAR2 (768),
DATAPOINT_13 VARCHAR2 (768),
DATAPOINT_14 VARCHAR2 (768),
DATAPOINT_15 VARCHAR2 (768) ) ;

CREATE TABLE FV_MULTI_WELL_TEST_TYPE_REF (
MULTI_WELL_TEST_TYPE_ID FLOAT NOT NULL,
MULTI_WELL_TEST_TYPES VARCHAR2 (150) NOT NULL ) ;

CREATE TABLE FV_MULTI_WELL_TEST_WELL_DATA (
MULTI_WELL_TEST_ID VARCHAR2 (23) NOT NULL,
FACILITY_ID VARCHAR2 (23) NOT NULL,
CHOKE_OPENING FLOAT,
BOTTOM_PRESSURE FLOAT,
BOTTOM_TEMPERATURE FLOAT,
HEAD_PRESSURE FLOAT,
HEAD_TEMPERATURE FLOAT,
DOWNSTREAM_CHOKE FLOAT,
PRESSURE FLOAT,
ANNULUS_PRESSURE FLOAT,
PROD_LIQ_FLOWRATE_CALC FLOAT,
PROD_GAS_FLOWRATE_CALC FLOAT,
NETWORK_PRESSURE FLOAT,
NETWORK_TEMPERATURE FLOAT,
USE_IN_TEST FLOAT,
DATAPOINT_1 FLOAT,
DATAPOINT_2 FLOAT,
DATAPOINT_3 FLOAT,
DATAPOINT_4 FLOAT,
DATAPOINT_5 FLOAT,
DATAPOINT_6 FLOAT,
DATAPOINT_7 FLOAT,
DATAPOINT_8 FLOAT,
DATAPOINT_9 FLOAT,
DATAPOINT_10 FLOAT,
DATAPOINT_11 VARCHAR2 (768),
DATAPOINT_12 VARCHAR2 (768),
DATAPOINT_13 VARCHAR2 (768),
DATAPOINT_14 VARCHAR2 (768),
DATAPOINT_15 VARCHAR2 (768) ) ;

CREATE TABLE FV_NETWORK (
NETWORK_ID VARCHAR2 (23) NOT NULL,
START_TIME DATE NOT NULL,
END_TIME DATE,
NAME VARCHAR2 (120),
DESCRIPTION VARCHAR2 (765) ) ;

CREATE TABLE FV_NET_ROYALTY_INTEREST (
NET_ROYALTY_INTEREST_ID VARCHAR2 (23) NOT NULL,
COMPANY_ID VARCHAR2 (23) NOT NULL,
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
NET_ROYALTY_INTEREST FLOAT,
PRIORITY FLOAT,
END_DATE DATE ) ;

CREATE TABLE FV_NON_OP_DATA (
NON_OP_ID VARCHAR2 (23) NOT NULL,
SITE_ID VARCHAR2 (23),
START_DATE DATE,
OIL_PROD FLOAT,
WATER_PROD FLOAT,
GAS_PROD FLOAT,
CONDENSATE FLOAT,
TARGET_OIL FLOAT,
TARGET_GAS FLOAT,
TARGET_CONDENSATE FLOAT,
NGL_YIELD FLOAT,
CARRIED_FORWARD NUMBER (5) ) ;

CREATE TABLE FV_OIL_WELL_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
LOAD_OIL_LEFT FLOAT,
LOAD_WATER_LEFT FLOAT,
LOAD_OIL_MASS_LEFT FLOAT ) ;

CREATE TABLE FV_OIL_WELL_INJECTED_VOLUMES (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
INJECTED_CO2 FLOAT,
INJECTED_GAS FLOAT,
INJECTED_COND FLOAT,
INJECTED_H2O FLOAT,
INJECTED_OIL FLOAT ) ;

CREATE TABLE FV_OIL_WELL_LOST_PROD_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
LOST_OIL_PRODUCTION NUMBER,
LOST_WATER_PRODUCTION NUMBER,
LOST_GAS_PRODUCTION NUMBER ) ;

CREATE TABLE FV_OIL_WELL_NET_HOURS_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
NET_HOURS NUMBER ) ;

CREATE TABLE FV_OIL_WELL_NON_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
POOL_ID VARCHAR2 (23),
ZONE_ID VARCHAR2 (23),
UNIT_ID VARCHAR2 (23),
AREA_ID VARCHAR2 (23),
LEASE VARCHAR2 (60),
AGREEMENT VARCHAR2 (60),
WELL_DEPTH FLOAT,
WELL_TYPE FLOAT,
OIL_TARGET_RATE FLOAT,
GAS_TARGET_RATE FLOAT,
WATER_TARGET_RATE FLOAT,
OIL_SHRINKAGE FLOAT,
WATER_SHRINKAGE FLOAT,
GAS_SHRINKAGE FLOAT,
OIL_DENSITY FLOAT,
WATER_DENSITY FLOAT,
CHOKE_SIZE FLOAT,
REGULATORY_STATUS VARCHAR2 (69),
ALLOWABLE FLOAT,
SWB_STATUS FLOAT,
SWB_WHEAD_CUT_CALC FLOAT,
RESERVOIR_ID VARCHAR2 (23),
WELL_TEST_OIL_TOLERANCE FLOAT,
WELL_TEST_WATER_TOLERANCE FLOAT,
WELL_TEST_GAS_TOLERANCE FLOAT,
WELL_TEST_SAMPLE_SIZE FLOAT,
H2S_PARTS_PER_MILLION FLOAT,
ALLOCATION_STATUS FLOAT,
END_DATE DATE,
RECOMMENDED_GLYCOL_RATE FLOAT,
RECOMMENDED_DEMULSYFIER_RATE FLOAT,
GAS_LIFT_TARGET_RATE FLOAT,
TEST_VESSEL_ID VARCHAR2 (23),
REASON_NOT_IN_USE_ID VARCHAR2 (23),
REGULATORY_WELL_TYPE_ID VARCHAR2 (23),
REGULATORY_OP_METHOD_ID VARCHAR2 (23),
WATER_DISPOSITION_ID VARCHAR2 (23),
OPERATOR_ID VARCHAR2 (23),
CONDENSATE_TARGET_RATE FLOAT,
SAND_TOLERANCE FLOAT,
CO2_TOLERANCE FLOAT,
COND_TOLERANCE FLOAT,
ALLOWABLE_GAS FLOAT,
GOR FLOAT,
CGR FLOAT,
WGR FLOAT,
UPDATE_DATE DATE DEFAULT Sysdate NOT NULL,
MAX_TUBING_CHOKE_SIZE FLOAT,
MAX_CASING_CHOKE_SIZE FLOAT,
MAX_WELL_TEST_CHOKE_SIZE FLOAT,
CONDENSATE_SHRINKAGE FLOAT,
LEASE_ID VARCHAR2 (23),
DISTRICT_ID VARCHAR2 (23),
CHANGE_COUNTER NUMBER (15) ) ;

CREATE TABLE FV_OIL_WELL_PROD (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
DOWN_TIME_ID VARCHAR2 (23),
HOURS_ON FLOAT,
CASING_PRESS FLOAT,
CASING_FLUID_LEVEL FLOAT,
TUBING_PRESS FLOAT,
WELL_HEAD_PRESS FLOAT,
LOAD_OIL_USED FLOAT,
LOAD_WATER_USED FLOAT,
LOAD_OIL_RECEIVED FLOAT,
LOAD_WATER_RECEIVED FLOAT,
GAS_LIFT FLOAT,
PIPELINE_TEMP FLOAT,
PIPELINE_PRESS FLOAT,
WELL_HEAD_TEMP FLOAT,
SALINITY FLOAT,
SWB_WHEAD_WATER_CUT FLOAT,
SWB_WHEAD_SAND_CUT FLOAT,
SWB_WHEAD_CALC_SAND_CUT FLOAT,
SWB_GAS_PRODUCTION FLOAT,
SWB_WHEAD_BSW_CUT FLOAT,
SWB_HEAD_CALC_BSW_CUT FLOAT,
SWB_WHEAD_SOLIDS_CUT FLOAT,
CARRIED_FORWARD NUMBER (5),
INJECTION_RATE FLOAT,
ACTUAL_GLYCOL_RATE FLOAT,
ACTUAL_DEMULSYFIER_RATE FLOAT,
DOWNTIME_SCHEDULED NUMBER (5),
GAS_PRESSURE FLOAT,
GAS_TEMPERATURE FLOAT,
BATH_TEMP FLOAT,
TUBING_CHOKE_SIZE FLOAT,
CASING_CHOKE_SIZE FLOAT,
CHOKE_SIZE FLOAT,
TIMER_HOURS_ON FLOAT,
UPDATE_DATE DATE DEFAULT Sysdate NOT NULL,
LIQUID_VOLUME FLOAT,
HOURS_INJECTING FLOAT,
EXPORT_FACTOR FLOAT,
GAS_DENSITY FLOAT ) ;

CREATE TABLE FV_OIL_WELL_PUMP_EFF_CALC (
SITE_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
PUMP_EFFICIENCY NUMBER ) ;

CREATE TABLE FV_ORIFICE_METER_PROD (
EQUIP_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
TIME_OF_DAY FLOAT,
HOURS FLOAT,
ESTIMATED_PROD FLOAT,
ACTUAL_PROD FLOAT,
TEMPERATURE FLOAT,
STATIC_PRESS FLOAT,
DIFF_PRESS FLOAT,
ORIFICE_SIZE FLOAT,
ACTUAL_HEAT FLOAT,
CARRIED_FORWARD NUMBER (5),
LINE_PRESSURE FLOAT,
ACTUAL_CO2_SPLIT FLOAT,
ESTIMATED_CO2_SPLIT FLOAT,
GAS_DENSITY FLOAT,
WATER_CUT FLOAT,
ACTUAL_OIL_VOLUME_LINE FLOAT,
ACTUAL_OIL_VOLUME_STANDARD FLOAT,
ACTUAL_GAS_VOLUME_LINE FLOAT,
ACTUAL_GAS_VOLUME_STANDARD FLOAT,
ACTUAL_WATER_VOLUME_LINE FLOAT,
ACTUAL_WATER_VOLUME_STANDARD FLOAT,
ACTUAL_OIL_MASS FLOAT,
ACTUAL_WATER_MASS FLOAT,
ACTUAL_GAS_MASS FLOAT,
ACTUAL_TOTAL_MASS FLOAT,
ACTUAL_TOTAL_VOLUME FLOAT,
DEVIATION FLOAT,
MANOMETRIC_HEIGHT FLOAT ) ;

CREATE TABLE FV_PA_EXPORT_TABLE (
TABLE_NAME VARCHAR2 (32) NOT NULL,
ID_COLUMN_NAME VARCHAR2 (32),
CREATION_ORDER FLOAT NOT NULL,
DATA_DELETED FLOAT DEFAULT 0 NOT NULL,
CURRENT_UPDATE_COUNTER NUMBER (13) DEFAULT 0 NOT NULL ) ;

CREATE TABLE FV_PERF_VARIABLE_HEADER (
PROD_ID NUMBER (10) NOT NULL,
OBJECT_TYPE FLOAT NOT NULL,
OBJECT_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE,
PERIOD_TYPE NUMBER (5) ) ;

CREATE TABLE FV_PERF_VARIABLE_PROD (
PROD_ID NUMBER (10) NOT NULL,
VARIABLE_FLUID_ID NUMBER (10) NOT NULL,
VALUE FLOAT ) ;

CREATE TABLE FV_PHYSICAL_CRYSTAL_REPORT (
PHYSICAL_CRYSTAL_REPORT_ID VARCHAR2 (23) NOT NULL,
FILE_NAME VARCHAR2 (255) NOT NULL ) ;

CREATE TABLE FV_POLY_CONSTS_NON_PROD (
EQUIP_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
END_DATE DATE,
FORMULA_TYPE NUMBER (5) DEFAULT 0 NOT NULL,
ACTIVE FLOAT DEFAULT 1 NOT NULL,
A FLOAT DEFAULT 0 NOT NULL,
B FLOAT DEFAULT 0 NOT NULL,
C FLOAT DEFAULT 0 NOT NULL,
D FLOAT DEFAULT 0 NOT NULL,
E FLOAT DEFAULT 0 NOT NULL,
F FLOAT DEFAULT 0 NOT NULL,
BSW FLOAT DEFAULT 0 NOT NULL,
GOR FLOAT DEFAULT 0 NOT NULL,
MODEL_COMMENT VARCHAR2 (150),
OIL_DENSITY FLOAT,
WATER_DENSITY FLOAT,
GAS_DENSITY FLOAT,
VOLUME_CONFIDENCE_FACTOR FLOAT,
DENSITY_CONFIDENCE_FACTOR FLOAT,
MODEL_TYPE NUMBER (5),
CGR FLOAT DEFAULT 0 NOT NULL,
WGR FLOAT DEFAULT 0 NOT NULL,
G FLOAT DEFAULT 0 NOT NULL,
H FLOAT DEFAULT 0 NOT NULL,
I FLOAT DEFAULT 0 NOT NULL,
J FLOAT DEFAULT 0 NOT NULL ) ;

CREATE TABLE FV_PROD_RATES_BY_TYPE (
SITE_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NULL,
OIL_RATE FLOAT DEFAULT 0.0,
GAS_RATE FLOAT DEFAULT 0.0,
COND_RATE FLOAT DEFAULT 0.0,
WATER_RATE FLOAT DEFAULT 0.0,
TYPE_ID NUMBER (5) NOT NULL ) ;

CREATE TABLE FV_PROFILE (
PROFILE_ID VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (120),
DESCRIPTION VARCHAR2 (762),
CREATED_BY VARCHAR2 (150),
CREATED_DATE DATE,
LAST_CHANGED_BY VARCHAR2 (150),
LAST_CHANGED_DATE DATE,
UNIT_SYSTEM_ID VARCHAR2 (23) ) ;

CREATE TABLE FV_PROFILE_CONTROL_VALUE (
PROFILE_ID VARCHAR2 (23) NOT NULL,
CONTROL_NAME VARCHAR2 (90) NOT NULL,
CONTROL_STRING VARCHAR2 (150) ) ;

CREATE TABLE FV_PUMP_CALC (
EQUIP_ID VARCHAR2 (23) NOT NULL,
DATE_STAMP DATE NOT NULL,
PUMP_CAPACITY FLOAT ) ;

CREATE TABLE FV_PUMP_MODEL (
PUMP_MODEL_ID VARCHAR2 (23) NOT NULL,
NAME VARCHAR2 (120),
DESCRIPTION VARCHAR2 (765),
PUMP_TYPE FLOAT,
PUMP_DIAMETER FLOAT,
PUMP_FACTOR FLOAT,
PUMP_DEPTH FLOAT,
MAXIMUM_PULL_FORCE FLOAT,
MAXIMUM_BYPASS FLOAT,
DELETE_DATE DATE ) ;

CREATE TABLE FV_PUMP_NON_PROD (
EQUIP_ID VARCHAR2 (23) NOT NULL,
START_DATE DATE NOT NU

 

[Turkbear]

Hi,

(Santa, I was born, it seems sometimes, years before anybody else )

I cannot imagine a join with that many tables!!!

Regardless, if you EquiJoin the FV_DATES to the others any records where no Date matches in that table will not be returned..

That is just a guess, since you failed to supply:
What is Joined ( by what field(s)
What Crystal version



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

MAQAQM,

The code, below, should work for you even without your FV_DATES table...The code uses an in-line VIEW that generates the necessary dates "on-the-fly". You can replace the hardcoded dates that I have used with some replacement mechanism such as a bind variable or SQL*Plus's "literal-replacement"-definition feature ("&some_label"). Here, then, is code that will list dates that are missing from <table_name>.<date_column_name>:

select Missing_dates
from (select to_date('09/09/06','dd/mm/rr')+rn missing_dates
        from (select rownum-1 rn from all_objects)
       where missing_dates <= to_date('24/09/06','dd/mm/rr'))
minus
select trunc(<date_column_name>) from <table_name>
/

Since I do not have Crystal Reports, I ran this code from SQL*Plus (with real table and date-column names, of course).

Let us know how this works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[SantaMufasa]

After reading Turkbear's post, it made me realise that I didn't obtain clarification from you whether you wanted the query to show "unrepresented dates" from EACH of the tables individually or from ALL of the tables collectively (i.e., if you harvest ALL of the DATEs from [/I][/B]ALL[/I][/B] of the tables, then which dates do not appear within the START_DATE-to-END_DATE range.)

My code is for the former; if you want the latter, we can still do that. Just let us know what you want, and we can make it work. (I'll wait for your reply before I start posting code that you might not want/need.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

this is indeed what I want, but I will try and use this one if it works. My Crystal Report version is 10.

please can you work out a solution with this:
"unrepresented dates" from EACH of the tables individually or from ALL of the tables collectively (i.e., if you harvest ALL of the DATEs from [/I][/B]ALL[/I][/B] of the tables, then which dates do not appear within the START_DATE-to-END_DATE range.)
thanks
AQM

 

[SantaMufasa]

MAQAQM,

First, several of the tables you list, above, have no DATE column...Why include them in the list of tables to check for DATEs?

Following is the code model that you can use to produce a listing of DATEs (between the start and end dates) that do not appear in any of the DATE columns of the tables you list:

select Missing_dates
from (select to_date('09/09/06','dd/mm/rr')+rn missing_dates
        from (select rownum-1 rn from all_objects)
       where missing_dates <= to_date('24/09/06','dd/mm/rr'))
minus
[b](     select trunc(DATE_STAMP) from FV_BATTERY_APP_CALC
union select trunc(START_DATE) from FV_BATTERY_NON_PROD
union select trunc(START_DATE) from FV_BATTERY_PROD
...<same format for rest of tables with dates>
union select trunc(DATE_STAMP) from FV_GAS_PLANT_GAS_PROD2_CALC
)[/b]
/

The above code lists all of the dates between '09/09/06' and '24/09/06' which do not appear amongst any of the DATEs that harvest below the MINUS operator.

Let us know if this answers your question(s).

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

I tried this code below but the SQL*plus gives this error:

Invalid Identifier "missing_dates" column.
cna you please explain if this is a column of Oracle all_objects or I must replace that with a column named similar from my database?

thanks
MAQAQM

 

[SantaMufasa]

MAQAQM,

Sorry...My bad. I absent-mindedly imagined my "missing_dates" query one level deeper than it actually was. I shudda taken the few extra moments to test the code.

Here then is your corrected code:

select Missing_dates
from (select to_date('09/09/06','dd/mm/rr')+rn missing_dates
        from (select rownum-1 rn from all_objects)
       where [b]to_date('09/09/06','dd/mm/rr')+rn[/b]
          <= to_date('24/09/06','dd/mm/rr'))
minus
(     select trunc(DATE_STAMP) from FV_BATTERY_APP_CALC
union select trunc(START_DATE) from FV_BATTERY_NON_PROD
union select trunc(START_DATE) from FV_BATTERY_PROD
...<same format for rest of tables with dates>
union select trunc(DATE_STAMP) from FV_GAS_PLANT_GAS_PROD2_CALC
)
/

Let us know how this works for you.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

it does work but can you help to view the columns in these tables of which data is missing? because this query displays the dates only and not their respective column where data is missing. I want to specifically display Oil , water and meter data if you check the table scrips you will see these columns

thanks

 

[SantaMufasa]

...can you help to view the columns in these tables of which data is missing?

So, if the data are missing, you want me to display NULLs? Yep, I can do that.


I'm sure that I am misunderstanding your question, MAQAQM, but aren't you basically asking for data similar to: "On days with no crimes in NYC, list the perpetrators of those crimes"?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

sorry for my basic ignorance in queries. these column EXPECTED_OIL_PROD, EXPECTED_WATER_PROD from FV_BATTERY_NON_PROD tables could be an example and then the rest I will add to try it.

 

[SantaMufasa]

MAQAQM,

I don't want you to think that I'm trying to make you jump through hoops...I simply don't know what you want to display. Could you please post some sample output that you would like to see. For example, create a CODE box as I have done below, and fill in a few rows of data that you would expect to see:

10/09/06: <some sample output here>
11/09/06: <more sample output here>
et cetera

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[MAQAQM]

I actually thought to bind this query to an atribute. so I did a select(select * from fv_data_dictionary where column_name like '%CARRIED%'
order by column_name) to see which tables do I have this atribute that I will use to identify whether data was entered or it just did a carryforward. this CARRYFORWARD column, shows me a blue arrow in the application indicating that that specific well, that was not entered but it just carried it from the previous date.
these below are the tables where I have CARRYFORWARD:
FV_COUNTER_METER_PROD CARRIED_FORWARD
FV_BATTERY_PROD CARRIED_FORWARD
FV_EQUIPMENT_PROD CARRIED_FORWARD
FV_GAS_WELL_PROD CARRIED_FORWARD
FV_INJ_FAC_PROD CARRIED_FORWARD
FV_INJ_WELL_PROD CARRIED_FORWARD
FV_INLET_PROD CARRIED_FORWARD
FV_NON_OP_DATA CARRIED_FORWARD
FV_OIL_WELL_PROD CARRIED_FORWARD
FV_GAS_PLANT_PROD CARRIED_FORWARD
FV_ORIFICE_METER_PROD CARRIED_FORWARD
FV_PUMP_PROD CARRIED_FORWARD
FV_SITE_PROD CARRIED_FORWARD
FV_SITE_USER_OBJECT_PROD CARRIED_FORWARD
FV_SOURCE_WELL_PROD CARRIED_FORWARD
FV_TANK_PROD CARRIED_FORWARD

and this works like the following: when this carryforward column is = 1 that was not entered manually by operators and when it is = 0 then there was a manual typing of data.

so could you help design some binding code to get me this?

thanks you are a great guy! you actually spend you time to support my greatest ignorance
MAQAQM