ampid 
Base Table  amp 
Attribute Name  ampid 
ColumnName  ampid 
Logical Rolename   
RoleName   
Definition  Amplitude identification. Each amplitude is assigned a unique positive integer identifying it. This number is used in the AssocAmO relation along with the origin identifier to link Amp and Origin. This number is used also in the AssocAmM relation along with the magnitude identifier to link Amp and Netmag 
Note 
Range:             ampid > 0
 

commid 
Base Table  amp 
Attribute Name  commid 
ColumnName  commid 
Logical Rolename   
RoleName   
Definition  Comment identification. This is a key used to point to free-form comments entered in the Remark relation. These comments store additional information about a tuple in another relation. Within the Remark relation, there may be many tuples with the same commid and different lineno, but the same commid will appear in only one other tuple among the rest of the relations in the database 
Note 
Range:             commid > 0
 

datetime 
Base Table  amp 
Attribute Name  datetime 
ColumnName  datetime 
Logical Rolename   
RoleName   
Definition  The date of associated with information in the record, in true epoch format

* In the current real time system, we know the exact amplitude time as well as the window.
Therefore, we can set values for the datetime, wstart & duration fields.

* In the case where we know only the time of the amplitude but not the window, we set:
datetime = [AMPLITUDE TIME]
wstart = [AMPLITUDE TIME]
duration = 0

* In the case where we do not know the amplitude time nor the window, we set:
datetime = NULL
wstart = [ORIGIN TIME]
duration = NULL
 
Note 
Range:		Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000

Units:		Seconds
 

sta 
Base Table  amp 
Attribute Name  sta 
ColumnName  sta 
Logical Rolename   
RoleName   
Definition  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
Note 
Range:             Any free-format string up to 6 characters
 

net 
Base Table  amp 
Attribute Name  net 
ColumnName  net 
Logical Rolename   
RoleName   
Definition  Unique network identifier. This character string is the name of a seismic network 
Note 
Range:             Any free-format string up to 8 characters. If available, use the two character FDSN code for the network
 

auth 
Base Table  amp 
Attribute Name  auth 
ColumnName  auth 
Logical Rolename   
RoleName   
Definition  The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record 
Note 
Range:            Any free-format string up to 15 characters
 

subsource 
Base Table  amp 
Attribute Name  subsource 
ColumnName  subsource 
Logical Rolename   
RoleName   
Definition  A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE 
Note 
Range:             Any free-format string up to 8 characters
 

channel 
Base Table  amp 
Attribute Name  channel 
ColumnName  channel 
Logical Rolename   
RoleName   
Definition  Channel name 
Note 
Range:             	Any valid channel name, which may be network-specific. Networks using SEED channel names should use the same value for channel and seedchan
 

channelsrc 
Base Table  amp 
Attribute Name  channelsrc 
ColumnName  channelsrc 
Logical Rolename   
RoleName   
Definition  Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) 
Note 
Range:             Any free-format string up to 8 characters long
 

seedchan 
Base Table  amp 
Attribute Name  seedchan 
ColumnName  seedchan 
Logical Rolename   
RoleName   
Definition  SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code 
Note 
Range:		seedchan = {E | S | H | B | M | L | V | U | R} U
		                   {A | B | D | F | G | H | I | K | L | M | P | R | S | V | T | W} U
		                   {Z | N | E | A | B | C | T | R | 1 | 2 | 3 | U | V | W}
		Band code:
						Sample rate (Hz)	Corner period (sec)
		E = extremely short period		³ 80			< 10
		S = short period			³ 10 to < 80		< 10
		H = high broad band		³ 80			³ 10
		B = broad band			³ 10 to < 80		³ 10
		M = mid period			> 1 to < 10
		L = long period			~ 1
		V = very long period			~ 0.1
		U = ultra long period			~ 0.01
		R = extremely long period		~ 0.001

		Instrument code:
		A = tiltmeter			B = creepmeter
		D = pressure			F = magnetometer
		G = gravimeter/accelerometer		H = high gain seismometer			
		I = humidity			K = temperature
		L = low gain seismometer		M = mass position seismometer
		P = geophone			R = rainfall
		S = linear strainmeter		V = volumetric strain
		T = tide meter			W = wind

		Component code:
		N = north-south		E = east-west
		T = transverse		R = radial
		Z = vertical
		A, B, C = triaxial
		1, 2, 3 = orthogonal components but non-traditional orientations
		U, V, W = optional components
 

location 
Base Table  amp 
Attribute Name  location 
ColumnName  location 
Logical Rolename   
RoleName   
Definition  Describes the individual sites on an array station, operated by the same network operator 
Note 
Range:             Any free-format string up to 2 characters long
 

iphase 
Base Table  amp 
Attribute Name  iphase 
ColumnName  iphase 
Logical Rolename   
RoleName   
Definition  Reported phase. This eight-character field holds the name initially given to a seismic phase. Standard seismological labels for the types of signals (or phases) are used (e.g., P, PKP, PcP, pP). Both upper and lower case letters are available and should be used when appropriate, for example, pP or PcP 
Note 
Range:            Any free-format string up to 8 characters
 

amplitude 
Base Table  amp 
Attribute Name  amplitude 
ColumnName  amplitude 
Logical Rolename   
RoleName   
Definition  Amplitude in appropriate units for type 
Note 
Range:             amplitude > 0.0
 

amptype 
Base Table  amp 
Attribute Name  amptype 
ColumnName  amptype 
Logical Rolename   
RoleName   
Definition  Amplitude type 
Note 
Range:		amptype = {WA | WAS | WASF | PGA | PGV | PGD | WAC | WAU | IV2 | SP.3 | SP1.0 | SP3.0 | ML100 | ME100 | EGY}
		WA = Wood-Anderson photographic
		WAS = Wood-Anderson synthetic
		WASF = Wood-Anderson synthetic that has had extra filtering
		PGA = peak ground acceleration
		PGV = peak ground velocity
		PGD = peak ground displacement
		WAC = Wood-Anderson corrected
		WAU = Wood-Anderson uncorrected
		IV2 = integral of velocity squared
		SP.3 = spectral peak
		SP1.0 = spectral peak
		SP3.0 = spectral peak
		ML100 = local magnitude
		ME100 = energy magnitude
		EGY = energy
 

units 
Base Table  amp 
Attribute Name  units 
ColumnName  units 
Logical Rolename   
RoleName   
Definition  Units of amplitude 
Note 
Range:		units = {c | s | mm | cm | m | ms | mss | cms | cmss | mms | mmss | mc | nm | e | cmcms}
		c = counts
		s = seconds
		mm = millimeters
		cm = centimeters
		m = meters
		ms = meters per second
		mss = meters per second per second
		cms = centimeters per second
		cmss = centimeters per second per second
		mms = millimeters per second
		mmss = millimeters per second per second
		mc = microns
		nm = nanometers
		e = ergs
		cmcms = cm^2 * sec
 

ampmeas 
Base Table  amp 
Attribute Name  ampmeas 
ColumnName  ampmeas 
Logical Rolename   
RoleName   
Definition  Amplitude measure 
Note 
Range:		ampmeas = {0 | 1}
		0 = peak-to-peak
		1 = zero-to-peak
 

eramp 
Base Table  amp 
Attribute Name  eramp 
ColumnName  eramp 
Logical Rolename   
RoleName   
Definition  Uncertainty in amplitude measurement 
Note 
Range:             eramp >= 0.0
 

flagamp 
Base Table  amp 
Attribute Name  flagamp 
ColumnName  flagamp 
Logical Rolename   
RoleName   
Definition  This attribute is a flag to indicate whether amplitude is over P packet, S packet, entire waveform, etc 
Note 
Range:            flagamp = {SUR | P | S | ALL}
                       SUR = surface wave
                       P = P packet
                       S = S packet
                       ALL = entire waveform
 

per 
Base Table  amp 
Attribute Name  per 
ColumnName  per 
Logical Rolename   
RoleName   
Definition  Signal period. This attribute is the period of the signal described by the amplitude record 
Note 
Range:		per > 0.0

Units:		Seconds
 

snr 
Base Table  amp 
Attribute Name  snr 
ColumnName  snr 
Logical Rolename   
RoleName   
Definition  Signal-to-noise ratio. This is an estimate of the signal relative to that of the noise immediately preceding it 
Note 
Range:             snr > 0.0
 

tau 
Base Table  amp 
Attribute Name  tau 
ColumnName  tau 
Logical Rolename   
RoleName   
Definition  Coda duration (F-P time) 
Note 
Range:		tau > 0.0

Units:		Seconds
 

quality 
Base Table  amp 
Attribute Name  quality 
ColumnName  quality 
Logical Rolename   
RoleName   
Definition  This attribute describes the completeness of the time window of data. A complete time window is 1.0, an incomplete time window is 0.0. If an incomplete time window has been human-reviewed and the analyst is confident that the peak amplitude was recorded and properly computed despite the presence of data gaps, the value is set to 0.5 to indicate the window contains data gaps, but is usable 
Note 
Range:             0.0 <= quality <= 1.0
 

rflag 
Base Table  amp 
Attribute Name  rflag 
ColumnName  rflag 
Logical Rolename   
RoleName   
Definition  This flag describes whether an observation was generated automatically, by a human, or has been finalized 
Note 
Range:		rflag = {A | H | F}
		A = automatic
		H = reviewed by human
		F = finalized
 

cflag 
Base Table  amp 
Attribute Name  cflag 
ColumnName  cflag 
Logical Rolename   
RoleName   
Definition  This flag indicates whether the amplitude value is below noise, on scale or clipped 
Note 
Range:             cflag in { BN | OS | CL}
                        BN = below noise
                        OS = on scale
                        CL = clipped
 

wstart 
Base Table  amp 
Attribute Name  wstart 
ColumnName  wstart 
Logical Rolename   
RoleName   
Definition  Start of time window of amplitude measurement

* In the current real time system, we know the exact amplitude time as well as the window.
Therefore, we can set values for the datetime, wstart & duration fields.

* In the case where we know only the time of the amplitude but not the window, we set:
datetime = [AMPLITUDE TIME]
wstart = [AMPLITUDE TIME]
duration = 0

* In the case where we do not know the amplitude time nor the window, we set:
datetime = NULL
wstart = [ORIGIN TIME]
duration = NULL
 
Note 
Range:		Any valid float. wstart = 0.0 on January 01, 1970 at 00:00:00.0000

Units:		Seconds
 

duration 
Base Table  amp 
Attribute Name  duration 
ColumnName  duration 
Logical Rolename   
RoleName   
Definition  Duration of amplitude reading

* In the current real time system, we know the exact amplitude time as well as the window.
Therefore, we can set values for the datetime, wstart & duration fields.

* In the case where we know only the time of the amplitude but not the window, we set:
datetime = [AMPLITUDE TIME]
wstart = [AMPLITUDE TIME]
duration = 0

* In the case where we do not know the amplitude time nor the window, we set:
datetime = NULL
wstart = [ORIGIN TIME]
duration = NULL
 
Note 
Range:		duration > 0.0

Units:		Seconds
 

lddate 
Base Table  amp 
Attribute Name  lddate 
ColumnName  lddate 
Logical Rolename   
RoleName   
Definition  Load date. Date and time that the record was created, in Oracle date datatype 
Note 
Range:		Any valid date between January 01, 4712 BC and January 01, 4712 AD

Units:		 YYYY/MM/DD HH24:MI:SS