ampid 
Base Table  unassocamp 
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  unassocamp 
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  unassocamp 
Attribute Name  datetime 
ColumnName  datetime 
Logical Rolename   
RoleName   
Definition  The date of associated with information in the record, in true epoch format  
Note 
Range: Any valid float. datetime = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  
 

sta 
Base Table  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
Attribute Name  amplitude 
ColumnName  amplitude 
Logical Rolename   
RoleName   
Definition  Amplitude in appropriate units for type  
Note 
Range: amplitude > 0.0
 

amptype 
Base Table  unassocamp 
Attribute Name  amptype 
ColumnName  amptype 
Logical Rolename   
RoleName   
Definition  Amplitude type  
Note 
Range: amptype = {WA | WAS | PGA | PGV | PGD | WAC | WAU | IV2 | SP.3 | SP1.0 | SP3.0 | ML100 | ME100 | EGY} WA = Wood-Anderson photographic WAS = Wood-Anderson synthetic 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  unassocamp 
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 | iovs | spa } 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 iovs = integral of velocity squared spa = spectral peak amplitude  
 

ampmeas 
Base Table  unassocamp 
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  unassocamp 
Attribute Name  eramp 
ColumnName  eramp 
Logical Rolename   
RoleName   
Definition  Uncertainty in amplitude measurement  
Note 
Range: eramp >= 0.0
 

flagamp 
Base Table  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
Attribute Name  tau 
ColumnName  tau 
Logical Rolename   
RoleName   
Definition  Coda duration (F-P time)  
Note 
Range: tau > 0.0 Units: Seconds  
 

quality 
Base Table  unassocamp 
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  unassocamp 
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  unassocamp 
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  unassocamp 
Attribute Name  wstart 
ColumnName  wstart 
Logical Rolename   
RoleName   
Definition  Start of time window of amplitude measurement  
Note 
Range: Any valid float. wstart = 0.0 on January 01, 1970 at 00:00:00.0000 Units: Seconds  
 

duration 
Base Table  unassocamp 
Attribute Name  duration 
ColumnName  duration 
Logical Rolename   
RoleName   
Definition  Duration of amplitude reading  
Note 
Range: duration > 0.0 Units: Seconds  
 

lddate 
Base Table  unassocamp 
Attribute Name  lddate 
ColumnName  lddate 
Logical Rolename   
RoleName   
Definition  Load date. Date and time that the record was created or last modified, 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  
 

fileid 
Base Table  unassocamp 
Attribute Name  fileid 
ColumnName  fileid 
Logical Rolename   
RoleName   
Definition  The value is assigned to all new rows parsed from a single GMP channel packet. Rows having the same fileid value are associated with the same event origin 
Note