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

Poles_Zeros Columns 
ColumnName  Domain  Datatype  NULL  Definition 
net(PK)(FK)    VARCHAR2(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)(FK)    VARCHAR2(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
seedchan(PK)(FK)    VARCHAR2(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(PK)(FK)    VARCHAR2(2)  NO  Describes the individual sites on an array station, operated by the same network operator 
ondate(PK)(FK)    DATE  NO  This attribute denotes the start date 
stage_seq(PK)    NUMBER(8, 0)  NO  This attribute denotes the stage number 
channel    VARCHAR2(8)  YES  Channel name 
channelsrc    VARCHAR2(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(FK)    NUMBER(8, 0)  NO  Response (Poles & zeros) key 
tf_type    VARCHAR2(1)  YES  A single character describing the type of stage 
unit_in(FK)    NUMBER(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(FK)    NUMBER(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    DOUBLE PRECISION  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    DOUBLE PRECISION  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 Primary and Unique Keys 
Key Name  Key Type  Keys 
P_Z00  PrimaryKey  net, sta, seedchan, location, ondate, stage_seq 

Poles_Zeros Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Channel_Data  Identifying  One To Zero or More  Pol_Zer_Cha_Dat      net, sta, seedchan, location, ondate  NO  NO 
D_Unit  Non-Identifying  One To Zero or More  Pol_Zer_D_Uni      unit_in  NO  NO 
D_Unit  Non-Identifying  One To Zero or More  Pol_Zer_D_Uni2      unit_out  NO  NO 
PZ  Non-Identifying  One To Zero or More  Pol_Zer_PZ      pz_key  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 

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')