BA_Acquisition_2D


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

General Information

[Next]
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]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
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]

Copyright © 2018 Schlumberger. All rights reserved.