| ColumnName |
Domain |
Datatype |
NULL |
Definition |
| evid |
|
NUMBER(15, 0) |
YES |
Event identifier. Each event is assigned a unique integer which identifies it in a database |
| auth |
|
VARCHAR2(15) |
NO |
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 |
| subsource |
|
VARCHAR2(8) |
NO |
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 |
| net |
|
VARCHAR2(8) |
NO |
Unique network identifier. This character string is the name of a seismic network |
| sta |
|
VARCHAR2(8) |
NO |
Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used |
| seedchan |
|
VARCHAR2(8) |
NO |
SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code |
| staauth |
|
VARCHAR2(15) |
NO |
Purpose unknown (always same as subsource) |
| channel |
|
VARCHAR2(8) |
NO |
Channel name |
| datetime_on |
|
NUMBER(25, 10) |
NO |
Start time of time window to save |
| datetime_off |
|
NUMBER(25, 10) |
NO |
End time of time window to save |
| request_type |
|
VARCHAR2(1) |
NO |
Single character flag describing request type |
| lddate |
|
DATE |
YES |
Load date. Date and time that the record was created or last modified, in Oracle date datatype |
rcid |
|
NUMBER(15, 0) |
NO |
Unique request row number. Derived from REQSEQ. |
| location |
|
VARCHAR2(2) |
NO |
Describes the individual sites on an array station, operated by the same network operator |
| retry |
|
NUMBER(38, 0) |
YES |
Count of attempts to retrieve this waveform |
| lastretry |
|
DATE |
YES |
Time of last attempt to retrieve this waveform |
| priority |
|
NUMBER |
YES |
Rows are processed in priority order, 1 is highest priority |