net
Base Entity Channel_Comment
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Channel_Comment
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Channel_Comment
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Channel_Comment
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Channel_Comment
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


comment_id
Base Entity Channel_Comment
Logical Rolename comment_id
RoleName comment_id
Domain
Definition The comment code key of the associated Comment Description Dictionary

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Channel_Comment
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Channel_Comment
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Channel_Comment
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


comment_level
Base Entity Channel_Comment
Logical Rolename
RoleName
Domain
Definition The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel

Logical Attribute Properties
Logical Attribute Name comment_level
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Channel_Comment
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Channel_Data
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Channel_Data
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Channel_Data
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


inid
Base Entity Channel_Data
Logical Rolename inid
RoleName inid
Domain
Definition Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


remark
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications

Logical Attribute Properties
Logical Attribute Name remark
Datatype VARCHAR(30)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_signal
Base Entity Channel_Data
Logical Rolename unit_signal
RoleName unit_signal
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_calib
Base Entity Channel_Data
Logical Rolename unit_calib
RoleName unit_calib
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lat
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Logical Attribute Properties
Logical Attribute Name lat
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lon
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Logical Attribute Properties
Logical Attribute Name lon
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


elev
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Logical Attribute Properties
Logical Attribute Name elev
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


edepth
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev

Logical Attribute Properties
Logical Attribute Name edepth
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


azimuth
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition The azimuth of the instrument from north, clockwise

Logical Attribute Properties
Logical Attribute Name azimuth
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


dip
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition The dip of the instrument, down from horizontal

Logical Attribute Properties
Logical Attribute Name dip
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


format_id
Base Entity Channel_Data
Logical Rolename format_id
RoleName format_id
Domain
Definition A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


record_length
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition The exponent (as a power of two) of the record length for these data

Logical Attribute Properties
Logical Attribute Name record_length
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


samprate
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Sampling rate. This attribute is the sample rate in samples/second

Logical Attribute Properties
Logical Attribute Name samprate
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


clock_drift
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series

Logical Attribute Properties
Logical Attribute Name clock_drift
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


flags
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Channel flags

Logical Attribute Properties
Logical Attribute Name flags
Datatype VARCHAR(27)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Channel_Data
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Coefficients
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Coefficients
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Coefficients
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Coefficients
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Coefficients
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


stage_seq
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition This attribute denotes the stage number

Logical Attribute Properties
Logical Attribute Name stage_seq
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


dc_key
Base Entity Coefficients
Logical Rolename dc_key
RoleName dc_key
Domain
Definition Response (Coefficients) key

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_in
Base Entity Coefficients
Logical Rolename unit_in
RoleName unit_in
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_out
Base Entity Coefficients
Logical Rolename unit_out
RoleName unit_out
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


tf_type
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition A single character describing the type of stage

Logical Attribute Properties
Logical Attribute Name tf_type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Coefficients
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


id
Base Entity D_Abbreviation
Logical Rolename
RoleName
Domain
Definition A cross reference code to indicate this particular dictionary entry

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


description
Base Entity D_Abbreviation
Logical Rolename
RoleName
Domain
Definition This is a description of an abbreviation

Logical Attribute Properties
Logical Attribute Name description
Datatype VARCHAR(70)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


id
Base Entity D_Comment
Logical Rolename
RoleName
Domain
Definition A cross reference code to indicate this particular dictionary entry

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


class
Base Entity D_Comment
Logical Rolename
RoleName
Domain
Definition A single letter that determines to what the code refers

Logical Attribute Properties
Logical Attribute Name class
Datatype VARCHAR(1)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


description
Base Entity D_Comment
Logical Rolename
RoleName
Domain
Definition This is a description of a comment

Logical Attribute Properties
Logical Attribute Name description
Datatype VARCHAR(70)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit
Base Entity D_Comment
Logical Rolename
RoleName
Domain
Definition Units of comment level

Logical Attribute Properties
Logical Attribute Name unit
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


id
Base Entity D_Format
Logical Rolename
RoleName
Domain
Definition A cross reference code to indicate this particular dictionary entry

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity D_Format
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


family
Base Entity D_Format
Logical Rolename
RoleName
Domain
Definition This field is used by the data decoder to describe the data family type. It tells a potential program what general algorithm to use to decode the associated data. Each algorithm requires some number of decoder keys that contain special additional information, enabling the algorithm to decode the data

Logical Attribute Properties
Logical Attribute Name family
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ms_id
Base Entity D_Format
Logical Rolename
RoleName
Domain
Definition This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group

Logical Attribute Properties
Logical Attribute Name ms_id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


id
Base Entity D_Format_Data
Logical Rolename id
RoleName id
Domain
Definition A cross reference code to indicate this particular dictionary entry

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


row_id
Base Entity D_Format_Data
Logical Rolename
RoleName
Domain
Definition Row identifier for the decoder keys

Logical Attribute Properties
Logical Attribute Name row_id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key_d
Base Entity D_Format_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the decoder keys used by the data family type

Logical Attribute Properties
Logical Attribute Name key_d
Datatype VARCHAR(80)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


id
Base Entity D_Unit
Logical Rolename
RoleName
Domain
Definition A cross reference code to indicate this particular dictionary entry

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity D_Unit
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


description
Base Entity D_Unit
Logical Rolename
RoleName
Domain
Definition This is a description of a unit

Logical Attribute Properties
Logical Attribute Name description
Datatype VARCHAR(70)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity DC
Logical Rolename
RoleName
Domain
Definition This attribute denotes a unique identifier for a response (digital coefficients)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity DC
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


symmetry
Base Entity DC
Logical Rolename
RoleName
Domain
Definition This attribute denotes the eventual symmetry of a response

Logical Attribute Properties
Logical Attribute Name symmetry
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


storage
Base Entity DC
Logical Rolename
RoleName
Domain
Definition This attribute denotes if half or all the coefficients are stored in the DC_Data table

Logical Attribute Properties
Logical Attribute Name storage
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity DC
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity DC_Data
Logical Rolename key
RoleName key
Domain
Definition This attribute denotes a unique identifier for a response (digital coefficients)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


row_key
Base Entity DC_Data
Logical Rolename
RoleName
Domain
Definition Row key for responses

Logical Attribute Properties
Logical Attribute Name row_key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


type
Base Entity DC_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes whether a value is associated with a numerator/denominator

Logical Attribute Properties
Logical Attribute Name type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


coefficient
Base Entity DC_Data
Logical Rolename
RoleName
Domain
Definition The numerator/denominator coefficient value

Logical Attribute Properties
Logical Attribute Name coefficient
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


error
Base Entity DC_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the numerator/denominator error

Logical Attribute Properties
Logical Attribute Name error
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Decimation
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Decimation
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Decimation
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Decimation
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Decimation
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


stage_seq
Base Entity Decimation
Logical Rolename
RoleName
Domain
Definition This attribute denotes the stage number

Logical Attribute Properties
Logical Attribute Name stage_seq
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Decimation
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Decimation
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Decimation
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


dm_key
Base Entity Decimation
Logical Rolename dm_key
RoleName dm_key
Domain
Definition Decimation key

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Decimation
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity DM
Logical Rolename
RoleName
Domain
Definition This attribute denotes a unique identifier for a decimation

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity DM
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


samprate
Base Entity DM
Logical Rolename
RoleName
Domain
Definition Sampling rate. This attribute is the sample rate in samples/second

Logical Attribute Properties
Logical Attribute Name samprate
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


factor
Base Entity DM
Logical Rolename
RoleName
Domain
Definition The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor

Logical Attribute Properties
Logical Attribute Name factor
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offset
Base Entity DM
Logical Rolename
RoleName
Domain
Definition This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor

Logical Attribute Properties
Logical Attribute Name offset
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


delay
Base Entity DM
Logical Rolename
RoleName
Domain
Definition The estimated pure delay for the stage

Logical Attribute Properties
Logical Attribute Name delay
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


correction
Base Entity DM
Logical Rolename
RoleName
Domain
Definition The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion.This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done

Logical Attribute Properties
Logical Attribute Name correction
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity DM
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity PN
Logical Rolename
RoleName
Domain
Definition This attribute denotes a unique identifier for a response (poles & zeros)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity PN
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


poly_type
Base Entity PN
Logical Rolename
RoleName
Domain
Definition This attribute represents the type of polynomial approximation

Logical Attribute Properties
Logical Attribute Name poly_type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lower_bound
Base Entity PN
Logical Rolename
RoleName
Domain
Definition This attribute denotes the polynomial lower bound

Logical Attribute Properties
Logical Attribute Name lower_bound
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


upper_bound
Base Entity PN
Logical Rolename
RoleName
Domain
Definition This attribute denotes the polynomial upper bound

Logical Attribute Properties
Logical Attribute Name upper_bound
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


max_error
Base Entity PN
Logical Rolename
RoleName
Domain
Definition This attribute represents the maximum error of polynomial approximation

Logical Attribute Properties
Logical Attribute Name max_error
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity PN
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity PN_Data
Logical Rolename key
RoleName key
Domain
Definition This attribute denotes a unique identifier for a response (poles & zeros)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


row_key
Base Entity PN_Data
Logical Rolename
RoleName
Domain
Definition Row key for responses

Logical Attribute Properties
Logical Attribute Name row_key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_value
Base Entity PN_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the coefficient value of a polynomial

Logical Attribute Properties
Logical Attribute Name pn_value
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Poles_Zeros
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Poles_Zeros
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Poles_Zeros
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Poles_Zeros
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Poles_Zeros
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


stage_seq
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition This attribute denotes the stage number

Logical Attribute Properties
Logical Attribute Name stage_seq
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pz_key
Base Entity Poles_Zeros
Logical Rolename pz_key
RoleName pz_key
Domain
Definition Response (Poles & zeros) key

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


tf_type
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition A single character describing the type of stage

Logical Attribute Properties
Logical Attribute Name tf_type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_in
Base Entity Poles_Zeros
Logical Rolename unit_in
RoleName unit_in
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_out
Base Entity Poles_Zeros
Logical Rolename unit_out
RoleName unit_out
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


AO
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1

Logical Attribute Properties
Logical Attribute Name AO
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


AF
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition Frequency fn, at which the value in field AO is normalized (if any)

Logical Attribute Properties
Logical Attribute Name AF
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Poles_Zeros
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Polynomial
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Polynomial
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Polynomial
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Polynomial
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Polynomial
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


stage_seq
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition This attribute denotes the stage number

Logical Attribute Properties
Logical Attribute Name stage_seq
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


pn_key
Base Entity Polynomial
Logical Rolename pn_key
RoleName pn_key
Domain
Definition Response (Polynomial) key

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_in
Base Entity Polynomial
Logical Rolename unit_in
RoleName unit_in
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


unit_out
Base Entity Polynomial
Logical Rolename unit_out
RoleName unit_out
Domain
Definition A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


tf_type
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition A single character describing the type of stage

Logical Attribute Properties
Logical Attribute Name tf_type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Polynomial
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity PZ
Logical Rolename
RoleName
Domain
Definition This attribute denotes a unique identifier for a response (poles & zeros)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


name
Base Entity PZ
Logical Rolename
RoleName
Domain
Definition Descriptive name

Logical Attribute Properties
Logical Attribute Name name
Datatype VARCHAR(80)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity PZ
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


key
Base Entity PZ_Data
Logical Rolename key
RoleName key
Domain
Definition This attribute denotes a unique identifier for a response (poles & zeros)

Logical Attribute Properties
Logical Attribute Name key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


row_key
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition Row key for responses

Logical Attribute Properties
Logical Attribute Name row_key
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


type
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes whether a value is associated with a pole/zero

Logical Attribute Properties
Logical Attribute Name type
Datatype VARCHAR(1)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


r_value
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition The real portion of a complex pole/zero

Logical Attribute Properties
Logical Attribute Name r_value
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


r_error
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition The error value for the real portion of a complex pole/zero

Logical Attribute Properties
Logical Attribute Name r_error
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


i_value
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition The imaginary portion of a complex pole/zero

Logical Attribute Properties
Logical Attribute Name i_value
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


i_error
Base Entity PZ_Data
Logical Rolename
RoleName
Domain
Definition The error value for the imaginary portion of a complex pole/zero

Logical Attribute Properties
Logical Attribute Name i_error
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Sensitivity
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Sensitivity
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Sensitivity
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Sensitivity
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Sensitivity
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


stage_seq
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition This attribute denotes the stage number

Logical Attribute Properties
Logical Attribute Name stage_seq
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sensitivity
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition The gain (Sd) at this stage, or the sensitivity (Sd) for the channel

Logical Attribute Properties
Logical Attribute Name sensitivity
Datatype FLOAT
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


frequency
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition The frequency (fs) at which the value in sensitivity is correct

Logical Attribute Properties
Logical Attribute Name frequency
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Sensitivity
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Simple_Response
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Simple_Response
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


seedchan
Base Entity Simple_Response
Logical Rolename seedchan
RoleName seedchan
Domain
Definition SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code

Logical Attribute Properties
Logical Attribute Name seedchan
Datatype VARCHAR(3)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


location
Base Entity Simple_Response
Logical Rolename location
RoleName location
Domain
Definition Describes the individual sites on an array station, operated by the same network operator

Logical Attribute Properties
Logical Attribute Name location
Datatype VARCHAR(2)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Simple_Response
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channel
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Channel name

Logical Attribute Properties
Logical Attribute Name channel
Datatype VARCHAR(3)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


channelsrc
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)

Logical Attribute Properties
Logical Attribute Name channelsrc
Datatype VARCHAR(8)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


natural_frequency
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Natural frequency

Logical Attribute Properties
Logical Attribute Name natural_frequency
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


damping_constant
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition This attribute denotes the damping constant of the system

Logical Attribute Properties
Logical Attribute Name damping_constant
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute

Logical Attribute Properties
Logical Attribute Name gain
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


gain_units
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition This attribute denotes the units of the gain of the system, as given by the gain attribute

Logical Attribute Properties
Logical Attribute Name gain_units
Datatype VARCHAR(20)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


low_freq_corner
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Low frequency corner

Logical Attribute Properties
Logical Attribute Name low_freq_corner
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


high_freq_corner
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition High frequency corner

Logical Attribute Properties
Logical Attribute Name high_freq_corner
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


dlogsens
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Digitizer sensitivity

Logical Attribute Properties
Logical Attribute Name dlogsens
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Simple_Response
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Station_Comment
Logical Rolename net
RoleName net
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Station_Comment
Logical Rolename sta
RoleName sta
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Station_Comment
Logical Rolename ondate
RoleName ondate
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


comment_id
Base Entity Station_Comment
Logical Rolename comment_id
RoleName comment_id
Domain
Definition The comment code key of the associated Comment Description Dictionary

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Station_Comment
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


comment_level
Base Entity Station_Comment
Logical Rolename
RoleName
Domain
Definition The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel

Logical Attribute Properties
Logical Attribute Name comment_level
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Station_Comment
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Unique network identifier. This character string is the name of a seismic network

Logical Attribute Properties
Logical Attribute Name net
Datatype VARCHAR(8)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


sta
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used

Logical Attribute Properties
Logical Attribute Name sta
Datatype VARCHAR(6)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


ondate
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the start date

Logical Attribute Properties
Logical Attribute Name ondate
Datatype DATE
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lat
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes

Logical Attribute Properties
Logical Attribute Name lat
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lon
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian

Logical Attribute Properties
Logical Attribute Name lon
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


elev
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Elevation. This attribute is the elevation of a seismic station relative to mean sea level

Logical Attribute Properties
Logical Attribute Name elev
Datatype FLOAT
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


staname
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Station name/description. This is the full name of the station whose code-name is in sta

Logical Attribute Properties
Logical Attribute Name staname
Datatype VARCHAR(50)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


net_id
Base Entity Station_Data
Logical Rolename net_id
RoleName net_id
Domain
Definition The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs

Logical Attribute Properties
Logical Attribute Name id
Datatype NUMERIC(8, 0)
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


word_32
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition The swap order in which 32-bit quantities are specified in the data headers

Logical Attribute Properties
Logical Attribute Name word_32
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


word_16
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition 16-bit quantity byte swapping order, for the data headers only

Logical Attribute Properties
Logical Attribute Name word_16
Datatype NUMERIC(8, 0)
Nullable NO

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


offdate
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition This attribute denotes the end date

Logical Attribute Properties
Logical Attribute Name offdate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default
Bound Default

Attachments
Name Datatype Value Override Default Value Description


lddate
Base Entity Station_Data
Logical Rolename
RoleName
Domain
Definition Load date. Date and time that the record was created or last modified, in Oracle date datatype

Logical Attribute Properties
Logical Attribute Name lddate
Datatype DATE
Nullable YES

Domain Restrictions
CheckConstraint
Check Constraint Name
Bound Rule
Declared Default (SYSDATE)
Bound Default

Attachments
Name Datatype Value Override Default Value Description