channelmap_ampparms 
Logical Entity Name  channelmap_ampparms 
Default Table Name  channelmap_ampparms 
Definition  
Channel clipping count values (used by magnitude algorithms)
 

channelmap_ampparms Columns 
ColumnName  Domain  Datatype  NULL  Definition 
net(PK)    VARCHAR2(8)  NO  
Unique network identifier. This character string is the name of a seismic network
 
sta(PK)    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)    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)    VARCHAR2(2)  NO  
Describes the individual sites on an array station, operated by the same network operator
 
ondate(PK)    DATE  NO  
This attribute denotes the start date
 
offdate    DATE  NO  
This attribute denotes the end date
 
channel    VARCHAR2(3)  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.)
 
clip    NUMBER(14, 2)  YES  
Sample counts at which signal clips
 
lddate    DATE  YES  
Load date. Date and time that the record was created or last modified, in Oracle date datatype
 

channelmap_ampparms Primary and Unique Keys 
Key Name  Key Type  Keys 
cm_amp_key  PrimaryKey  net, sta, seedchan, location, ondate 

channelmap_ampparms Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

channelmap_ampparms Check Constraints 
Check Constraint Name  CheckConstraint