BA_Acquisition_2D

[Columns] [Composed Of] [Referenced By] [Refers To]

Name	BA_Acquisition_2D
Entity Type	ObjectView
Description	PSS 2013.1 BA_Acquisition_2D DOV
Submodel	Data_Object
Entity Scope	Project
Primary Key	Id
Natural Key
Generalizations
Specializations

Columns

[Previous] [Next] [Top]

Name	Value Domain	Property / Storage Unit	Description	Required / Default	Type
ACQUISITION_CONTRACTOR_ID	NUMBER2	NA	_	No	NUMBER(2)
ACQUISITION_CONTRACTOR_NAME	STRING255	NA	_	No	VARCHAR2(255)
ACQUISITION_DATA_TYPE	STRING64	NA	_	No	VARCHAR2(64)
ACQUISITION_FORMAT	STRING64	NA	_	No	VARCHAR2(64)
ACQUISITION_METHOD	STRING64	NA	_	No	VARCHAR2(64)
ACTIVITY_STATE	STRING64	NA	_	No	VARCHAR2(64)
ACTIVITY_TEMPLATE_ID	NUMBER2	NA	_	No	NUMBER(2)
AUXILIARY_CHANNEL_COUNT	NUMBER2	NA	_	No	NUMBER(2)
CABLE_DEPTH	NUMBER2	Depth m	_	No	NUMBER(2)
CABLE_LENGTH	NUMBER2	Length m	_	No	NUMBER(2)
CONTRACTOR_BA_INVL_ID	NUMBER2	NA	_	No	NUMBER(2)
CONTRACT_NUMBER	STRING64	NA	_	No	VARCHAR2(64)
END_DATE	DATE	NA	_	No	DATE
ENERGY_SOURCE_COUNT	NUMBER2	NA	_	No	NUMBER(2)
ENERGY_SOURCE_DEPTH	NUMBER2	Depth m	_	No	NUMBER(2)
ENERGY_SOURCE_SPACING	NUMBER2	Length m	_	No	NUMBER(2)
ENERGY_SOURCE_SYSTEM	STRING64	NA	_	No	VARCHAR2(64)
ENERGY_SWEEP_DURATION	NUMBER2	Time s	_	No	NUMBER(2)
ENVIRONMENT	STRING64	NA	_	No	VARCHAR2(64)
EXTERNAL_REFERENCE	STRING64	NA	_	No	VARCHAR2(64)
GROUP_CHANNEL_COUNT	NUMBER2	NA	_	No	NUMBER(2)
GUID	STRING128	NA	_	No	VARCHAR2(128)
ID	NUMBER2	NA	_	Yes	NUMBER(2)
INSERT_DATE	DATE	NA	_	No	DATE
INSERT_USER	STRING64	NA	_	No	VARCHAR2(64)
INTERNAL_REFERENCE	STRING64	NA	_	No	VARCHAR2(64)
LISTEN_TIME	NUMBER2	Time s	_	No	NUMBER(2)
NAME	STRING255	NA	_	No	VARCHAR2(255)
NAVIGATION_SYSTEM	STRING64	NA	_	No	VARCHAR2(64)
OPERATOR_BA_INVL_ID	NUMBER2	NA	_	No	NUMBER(2)
ORIGINAL_SOURCE	STRING64	NA	_	No	VARCHAR2(64)
PARTY_NUMBER	STRING64	NA	_	No	VARCHAR2(64)
PRODUCED_BY	STRING64	NA	_	No	VARCHAR2(64)
RECEIVER_GROUP_COUNT	NUMBER2	NA	_	No	NUMBER(2)
RECEIVER_GROUP_INTERVAL	NUMBER2	Length m	_	No	NUMBER(2)
RECEIVER_LINE_ID	NUMBER2	NA	_	No	NUMBER(2)
RECORDING_SYSTEM	STRING64	NA	_	No	VARCHAR2(64)
RECORD_LENGTH	NUMBER2	NA	_	No	NUMBER(2)
REMARKS	STRING2000	NA	_	No	VARCHAR2(2000)
REPLACEMENT_VELOCITY	NUMBER2	Acoustic_Velocity m/s	_	No	NUMBER(2)
SAMPLE_INTERVAL	NUMBER2	Short_Time ms	_	No	NUMBER(2)
SDAT_LABEL	NUMBER2	NA	_	No	NUMBER(2)
SEISMIC_RECEIVER_TYPE	STRING64	NA	_	No	VARCHAR2(64)
SHOOTING_DIRECTION	NUMBER2	NA	_	No	NUMBER(2)
SOURCE	STRING64	NA	_	No	VARCHAR2(64)
SOURCE_LINE_ID	NUMBER2	NA	_	No	NUMBER(2)
START_DATE	DATE	NA	_	No	DATE
SURVEY_2D_ID	NUMBER2	NA	_	No	NUMBER(2)
SURVEY_OPERATOR_ID	NUMBER2	NA	_	No	NUMBER(2)
SURVEY_OPERATOR_NAME	STRING255	NA	_	No	VARCHAR2(255)
SWEEP_FREQUENCY_HIGH	NUMBER2	Frequency Hz	_	No	NUMBER(2)
SWEEP_FREQUENCY_LOW	NUMBER2	Frequency Hz	_	No	NUMBER(2)
TIME_DELAY_CORRECTION	NUMBER2	Short_Time ms	_	No	NUMBER(2)
TOTAL_CHARGE_SIZE	NUMBER2	Mass kg	_	No	NUMBER(2)
TOTAL_GUN_PRESSURE	NUMBER2	Pressure kPa	_	No	NUMBER(2)
TOTAL_GUN_VOLUME	NUMBER2	Volume m3	_	No	NUMBER(2)
TRANSACTION_TYPE	STRING64	NA	_	No	VARCHAR2(64)
TRANSIENT_PERIOD	STRING64	NA	_	No	VARCHAR2(64)
TRIGGERING_EVENT_ID	NUMBER2	NA	_	No	NUMBER(2)
UPDATE_DATE	DATE	NA	_	No	DATE
UPDATE_USER	STRING64	NA	_	No	VARCHAR2(64)
VESSEL_NAME	STRING255	NA	_	No	VARCHAR2(255)

View Definition

[Previous] [Top]


CREATE OR REPLACE FORCE VIEW BA_Acquisition_2D(INSERT_DATE, INSERT_USER, PRODUCED_BY, SDAT_LABEL, UPDATE_DATE, UPDATE_USER, GUID, ID, NAME, ORIGINAL_SOURCE, REMARKS, SOURCE, ACTIVITY_STATE, ACTIVITY_TEMPLATE_ID, END_DATE, EXTERNAL_REFERENCE, INTERNAL_REFERENCE, START_DATE, TRANSIENT_PERIOD, TRIGGERING_EVENT_ID, ACQUISITION_DATA_TYPE, ACQUISITION_FORMAT, ACQUISITION_METHOD, AUXILIARY_CHANNEL_COUNT, CABLE_DEPTH, CABLE_LENGTH, CONTRACT_NUMBER, ENERGY_SOURCE_COUNT, ENERGY_SOURCE_DEPTH, ENERGY_SOURCE_SPACING, ENERGY_SOURCE_SYSTEM, ENERGY_SWEEP_DURATION, ENVIRONMENT, GROUP_CHANNEL_COUNT, LISTEN_TIME, NAVIGATION_SYSTEM, PARTY_NUMBER, RECEIVER_GROUP_COUNT, RECEIVER_GROUP_INTERVAL, RECORD_LENGTH, RECORDING_SYSTEM, REPLACEMENT_VELOCITY, SAMPLE_INTERVAL, SEISMIC_RECEIVER_TYPE, SHOOTING_DIRECTION, SWEEP_FREQUENCY_HIGH, SWEEP_FREQUENCY_LOW, TIME_DELAY_CORRECTION, TOTAL_CHARGE_SIZE, TOTAL_GUN_PRESSURE, TOTAL_GUN_VOLUME, TRANSACTION_TYPE, VESSEL_NAME, RECEIVER_LINE_ID, SOURCE_LINE_ID, SURVEY_2D_ID, 
SURVEY_OPERATOR_ID, SURVEY_OPERATOR_NAME, ACQUISITION_CONTRACTOR_ID, ACQUISITION_CONTRACTOR_NAME, OPERATOR_BA_INVL_ID, CONTRACTOR_BA_INVL_ID) AS SELECT aq.INSERT_DATE,
       aq.INSERT_USER,
       aq.PRODUCED_BY,
       aq.SDAT_LABEL,
       aq.UPDATE_DATE,
       aq.UPDATE_USER,
       aq.GUID,
       aq.ID,
       aq.NAME,
       aq.ORIGINAL_SOURCE,
       aq.REMARKS,
       aq.SOURCE,
       aq.ACTIVITY_STATE,
       aq.ACTIVITY_TEMPLATE_ID,
       aq.END_DATE,
       aq.EXTERNAL_REFERENCE,
       aq.INTERNAL_REFERENCE,
       aq.START_DATE,
       aq.TRANSIENT_PERIOD,
       aq.TRIGGERING_EVENT_ID,
       aq.ACQUISITION_DATA_TYPE,
       aq.ACQUISITION_FORMAT,
       aq.ACQUISITION_METHOD,
       aq.AUXILIARY_CHANNEL_COUNT,
       aq.CABLE_DEPTH,
       aq.CABLE_LENGTH,
       aq.CONTRACT_NUMBER,
       aq.ENERGY_SOURCE_COUNT,
       aq.ENERGY_SOURCE_DEPTH,
       aq.ENERGY_SOURCE_SPACING,
       aq.ENERGY_SOURCE_SYSTEM,
       aq.ENERGY_SWEEP_DURATION,
       aq.ENVIRONMENT,
    
   aq.GROUP_CHANNEL_COUNT,
       aq.LISTEN_TIME,
       aq.NAVIGATION_SYSTEM,
       aq.PARTY_NUMBER,
       aq.RECEIVER_GROUP_COUNT,
       aq.RECEIVER_GROUP_INTERVAL,
       aq.RECORD_LENGTH,
       aq.RECORDING_SYSTEM,
       aq.REPLACEMENT_VELOCITY,
       aq.SAMPLE_INTERVAL,
       aq.SEISMIC_RECEIVER_TYPE,
       aq.SHOOTING_DIRECTION,
       aq.SWEEP_FREQUENCY_HIGH,
       aq.SWEEP_FREQUENCY_LOW,
       aq.TIME_DELAY_CORRECTION,
       aq.TOTAL_CHARGE_SIZE,
       aq.TOTAL_GUN_PRESSURE,
       aq.TOTAL_GUN_VOLUME,
       aq.TRANSACTION_TYPE,
       aq.VESSEL_NAME,
       aq.RECEIVER_LINE_ID,
       aq.SOURCE_LINE_ID,
       aq.SURVEY_2D_ID,
       abi_o.BUSINESS_ASSOCIATE_ID,
       c_o.NAME,
       abi_c.BUSINESS_ASSOCIATE_ID,
       c_c.NAME,
       abi_o.ID,
       abi_c.ID
FROM
   ACQUISITION_2D aq
        LEFT OUTER JOIN ACTIVITY_BA_INVL abi_c
           ON aq.ID = abi_c.ACTIVITY_ID AND
              abi_c.ACTIVITY_TBL = 'Acquisition_2D' AND
              
abi_c.ACTIVITY_ROLE = 'Contractor'
                 LEFT OUTER JOIN COMPANY c_c
                    ON abi_c.BUSINESS_ASSOCIATE_ID = c_c.ID
        LEFT OUTER JOIN ACTIVITY_BA_INVL abi_o
           ON aq.ID = abi_o.ACTIVITY_ID AND
              abi_o.ACTIVITY_TBL = 'Acquisition_2D' AND
              abi_o.ACTIVITY_ROLE = 'Seismic Survey Operator'
		 LEFT OUTER JOIN COMPANY c_o
                    ON abi_o.BUSINESS_ASSOCIATE_ID = c_o.ID

[Seabed Objects] [Entities in Schema Seabed] [Index]

BA_Acquisition_2D

Copyright © 2018 Schlumberger. All rights reserved.