orid

Base Table | origin
Attribute Name | orid
ColumnName | orid
Logical Rolename |
RoleName |
Definition | Origin identification. Each origin is assigned a unique positive integer which identifies it in the database. The orid is used to identify one of the many hypotheses of the actual location of the event
Note |
    Range:             orid > 0

evid

Base Table | origin
Attribute Name | evid
ColumnName | evid
Logical Rolename |
RoleName |
Definition | Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network’s event identifier, which is stored in the Origin table. This allows merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier
Note |
    Range:	            evid > 0

prefmag

Base Table | origin
Attribute Name | magid
ColumnName | prefmag
Logical Rolename |
RoleName | prefmag
Definition | Preferred magnitude. This attribute holds the magnitude identifier, magid, that points to the preferred magnitude for a seismic event or an origin
Note |
    Range:             prefmag > 0

prefmec

Base Table | origin
Attribute Name | mecid
ColumnName | prefmec
Logical Rolename |
RoleName | prefmec
Definition | Preferred mechanism. This attribute holds the mechanism identifier, mecid, that points to the preferred mechanism for a seismic event or an origin
Note |
    Range:             prefmec > 0

commid

Base Table | origin
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

bogusflag

Base Table | origin
Attribute Name | bogusflag
ColumnName | bogusflag
Logical Rolename |
RoleName |
Definition | This field describes whether an origin is bogus or not
Note |
    Range:		bogusflag = {0 | 1}
    		0 = no
    		1 = yes

datetime

Base Table | origin
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

lat

Base Table | origin
Attribute Name | lat
ColumnName | lat
Logical Rolename |
RoleName |
Definition | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
Note |
    Range:		-90.0 <= lat <= 90.0

    Units:		Degrees

lon

Base Table | origin
Attribute Name | lon
ColumnName | lon
Logical Rolename |
RoleName |
Definition | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
Note |
    Range:		-180.0 <= lon <= 180.0

    Units:		Degrees

depth

Base Table | origin
Attribute Name | depth
ColumnName | depth
Logical Rolename |
RoleName |
Definition | Source depth. This attribute gives the depth of the event origin. The reference depth of 0 is usually defined as the average elevation of stations used to determine the origin, although other data may be specified. Positive values are down, negative values are up from the reference point
Note |
    Range:		-10.0 <= depth <= 1000.0

    Units:		Kilometers

type

Base Table | origin
Attribute Name | type
ColumnName | type
Logical Rolename |
RoleName |
Definition | Type of location
Note |
    Range:		type = {H | C | A}
    		H = hypocenter
    		C = centroid
    		A = amplitude

algorithm

Base Table | origin
Attribute Name | algorithm
ColumnName | algorithm
Logical Rolename |
RoleName |
Definition | Algorithm used. This is a brief textual description of the algorithm used to compute a seismic origin
Note |
    Range:             Any free-format string up to 15 characters

algo_assoc

Base Table | origin
Attribute Name | algo_assoc
ColumnName | algo_assoc
Logical Rolename |
RoleName |
Definition | Association algorithm used. This is a textual description of the algorithm used for associating the data
Note |
    Range:             Any free-format string up to 80 characters

auth

Base Table | origin
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 | origin
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

datumhor

Base Table | origin
Attribute Name | datumhor
ColumnName | datumhor
Logical Rolename |
RoleName |
Definition | Datum type for horizontal (latitude and longitude) coordinates
Note |
    Range:             datumhor = { NAD27 | WGS84}

datumver

Base Table | origin
Attribute Name | datumver
ColumnName | datumver
Logical Rolename |
RoleName |
Definition | Datum type for depth or elevation
Note |
    Range:             datumver = { NAD27 | WGS84 | AVERAGE}
                            AVERAGE = average of stations

gap

Base Table | origin
Attribute Name | gap
ColumnName | gap
Logical Rolename |
RoleName |
Definition | Gap in azimuthal coverage
Note |
    Range:		0.0 <= gap <= 360.0

    Units:		Degrees

distance

Base Table | origin
Attribute Name | distance
ColumnName | distance
Logical Rolename |
RoleName |
Definition | Distance from the origin to the nearest station
Note |
    Range:		distance >= 0.0

    Units:		Kilometers

wrms

Base Table | origin
Attribute Name | wrms
ColumnName | wrms
Logical Rolename |
RoleName |
Definition | This attribute denotes the weighted RMS
Note |
    Range:             wrms > 0.0

stime

Base Table | origin
Attribute Name | stime
ColumnName | stime
Logical Rolename |
RoleName |
Definition | Origin time error. This attribute denotes the standard deviation of the origin time
Note |
    Range:		stime >= 0.0

    Units:		Seconds

erhor

Base Table | origin
Attribute Name | erhor
ColumnName | erhor
Logical Rolename |
RoleName |
Definition | Horizontal error. This attribute denotes the location uncertainty that accompanies the location
Note |
    Range:		erhor >= 0.0

    Units:		Kilometers

sdep

Base Table | origin
Attribute Name | sdep
ColumnName | sdep
Logical Rolename |
RoleName |
Definition | Depth error. This is the standard deviation of the depth estimate
Note |
    Range:		sdep >= 0.0

    Units:		Kilometers

erlat

Base Table | origin
Attribute Name | erlat
ColumnName | erlat
Logical Rolename |
RoleName |
Definition | Error in latitude. This is the standard deviation of the latitude estimate
Note |
    Range:		erlat >= 0.0

    Units:		Kilometers

erlon

Base Table | origin
Attribute Name | erlon
ColumnName | erlon
Logical Rolename |
RoleName |
Definition | Error in longitude. This is the standard deviation of the longitude estimate
Note |
    Range:		erlon >= 0.0

    Units:		Kilometers

totalarr

Base Table | origin
Attribute Name | totalarr
ColumnName | totalarr
Logical Rolename |
RoleName |
Definition | Total number of phases in the database for the specified orid. This field signifies the number of P and S arrivals with non-zero input weights
Note |
    Range:             totalarr >= 0

totalamp

Base Table | origin
Attribute Name | totalamp
ColumnName | totalamp
Logical Rolename |
RoleName |
Definition | Total number of amplitudes in the database for the specified orid. Not all amplitudes have to associated with all magnitudes or origins
Note |
    Range:             totalamp >= 0

ndef

Base Table | origin
Attribute Name | ndef
ColumnName | ndef
Logical Rolename |
RoleName |
Definition | This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation
Note |
    Range:             ndef >= 0

nbs

Base Table | origin
Attribute Name | nbs
ColumnName | nbs
Logical Rolename |
RoleName |
Definition | Number of S phase readings with non-zero output weights
Note |
    Range:             nbs >= 0

nbfm

Base Table | origin
Attribute Name | nbfm
ColumnName | nbfm
Logical Rolename |
RoleName |
Definition | Number of P first motions with non-zero input weights
Note |
    Range:             nbfm >= 0

locevid

Base Table | origin
Attribute Name | locevid
ColumnName | locevid
Logical Rolename |
RoleName |
Definition | Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier
Note |
    Range:             Any free-format string up to 12 characters long

quality

Base Table | origin
Attribute Name | quality
ColumnName | quality
Logical Rolename |
RoleName |
Definition | This attribute denotes the quality of an origin, an arrival, or a mechanism. 1.0 = good, 0.0 = bad
Note |
    Range:             0.0 <= quality <= 1.0

fdepth

Base Table | origin
Attribute Name | fdepth
ColumnName | fdepth
Logical Rolename |
RoleName |
Definition | This attribute indicates if the depth was fixed or not to compute the solution
Note |
    Range:		fdepth = {y | n}
    		y = fixed depth
    		n = free depth

fepi

Base Table | origin
Attribute Name | fepi
ColumnName | fepi
Logical Rolename |
RoleName |
Definition | This attribute indicates if the epicenter was fixed or not to compute the solution
Note |
    Range:		fepi = {y | n}
    		y = fixed epicenter
    		n = free epicenter

ftime

Base Table | origin
Attribute Name | ftime
ColumnName | ftime
Logical Rolename |
RoleName |
Definition | This attribute indicates if the origin time was fixed or not to compute the solution
Note |
    Range:		ftime = {y | n}
    		y = fixed origin time
    		n = free origin time

vmodelid

Base Table | origin
Attribute Name | vmodelid
ColumnName | vmodelid
Logical Rolename |
RoleName |
Definition | Velocity model identification. This string identifies a version (instance) of the velocity model for the specified domain and algorithm. This version should be changed whenever the velocity model is changed. It is recommended that values 00 - 99 be used for this field
Note |

cmodelid

Base Table | origin
Attribute Name | cmodelid
ColumnName | cmodelid
Logical Rolename |
RoleName |
Definition | Velocity model domain. This string identifies the organization responsible for the velocity model. Recommendations for this field are the SEED network name, or a unique abbreviation of the processing center when using data from multiple networks
Note |

rflag

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

lddate

Base Table | origin
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