Poles_Zeros

Logical Entity Name | Poles_Zeros
Default Table Name | Poles_Zeros
Definition | Data associating a channel with poles & zeros

Poles_Zeros Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan |  | VARCHAR(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
location |  | VARCHAR(2) | NO | Describes the individual sites on an array station, operated by the same network operator
ondate |  | DATE | NO | This attribute denotes the start date
stage_seq |  | NUMERIC(8, 0) | NO | This attribute denotes the stage number
channel |  | VARCHAR(8) | YES | Channel name
channelsrc |  | VARCHAR(8) | YES | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)
offdate |  | DATE | YES | This attribute denotes the end date
pz_key |  | NUMERIC(8, 0) | NO | Response (Poles & zeros) key
tf_type |  | VARCHAR(1) | YES | A single character describing the type of stage
unit_in |  | NUMERIC(8, 0) | NO | 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
unit_out |  | NUMERIC(8, 0) | NO | 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
AO |  | FLOAT | NO | This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1
AF |  | FLOAT | YES | Frequency fn, at which the value in field AO is normalized (if any)
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Poles_Zeros Keys

Key Name | Key Type | Keys
P_Z00 | PrimaryKey | net, sta, seedchan, location, ondate, stage_seq

Poles_Zeros Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Channel_Data | Identifying | One To Zero or More |  |  |  | net, sta, seedchan, location, ondate | NO
D_Unit | Non-Identifying | One To Zero or More |  |  |  | unit_in | NO
D_Unit | Non-Identifying | One To Zero or More |  |  |  | unit_out | NO
PZ | Non-Identifying | One To Zero or More |  |  |  | pz_key | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

Poles_Zeros Check Constraints

Check Constraint Name | CheckConstraint
P_Z01 | AF >= 0.0
P_Z02 | stage_seq >= 0
P_Z03 | tf_type IN ('A','B','C','D','P')