| orid |
| Base Entity | origin |
| Attribute Name | orid |
| Logical Rolename | orid |
| ColumnName | orid |
| RoleName | orid |
| 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 Entity | origin |
| Attribute Name | evid |
| Logical Rolename | evid |
| ColumnName | evid |
| RoleName | evid |
| 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 Entity | origin |
| Attribute Name | magid |
| Logical Rolename | prefmag |
| ColumnName | prefmag |
| 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 Entity | origin |
| Attribute Name | mecid |
| Logical Rolename | prefmec |
| ColumnName | prefmec |
| 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 Entity | origin |
| Attribute Name | commid |
| Logical Rolename | commid |
| ColumnName | commid |
| RoleName | commid |
| 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 Entity | origin |
| Attribute Name | bogusflag |
| Logical Rolename | bogusflag |
| ColumnName | bogusflag |
| RoleName | bogusflag |
| Definition | This field describes whether an origin is bogus or not |
| Note | Range: bogusflag = {0 | 1} 0 = no 1 = yes |
| datetime |
| Base Entity | origin |
| Attribute Name | datetime |
| Logical Rolename | datetime |
| ColumnName | datetime |
| RoleName | datetime |
| 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 Entity | origin |
| Attribute Name | lat |
| Logical Rolename | lat |
| ColumnName | lat |
| RoleName | lat |
| 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 Entity | origin |
| Attribute Name | lon |
| Logical Rolename | lon |
| ColumnName | lon |
| RoleName | lon |
| 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 Entity | origin |
| Attribute Name | depth |
| Logical Rolename | depth |
| ColumnName | depth |
| RoleName | depth |
| 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 Entity | origin |
| Attribute Name | type |
| Logical Rolename | type |
| ColumnName | type |
| RoleName | type |
| Definition | Type of location |
| Note | Range: type = {H | C | A} H = hypocenter C = centroid A = amplitude |
| algorithm |
| Base Entity | origin |
| Attribute Name | algorithm |
| Logical Rolename | algorithm |
| ColumnName | algorithm |
| RoleName | algorithm |
| 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 Entity | origin |
| Attribute Name | algo_assoc |
| Logical Rolename | algo_assoc |
| ColumnName | algo_assoc |
| RoleName | algo_assoc |
| 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 Entity | origin |
| Attribute Name | auth |
| Logical Rolename | auth |
| ColumnName | auth |
| RoleName | auth |
| 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 Entity | origin |
| Attribute Name | subsource |
| Logical Rolename | subsource |
| ColumnName | subsource |
| RoleName | subsource |
| 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 Entity | origin |
| Attribute Name | datumhor |
| Logical Rolename | datumhor |
| ColumnName | datumhor |
| RoleName | datumhor |
| Definition | Datum type for horizontal (latitude and longitude) coordinates |
| Note | Range: datumhor = { NAD27 | WGS84} |
| datumver |
| Base Entity | origin |
| Attribute Name | datumver |
| Logical Rolename | datumver |
| ColumnName | datumver |
| RoleName | datumver |
| Definition | Datum type for depth or elevation |
| Note | Range: datumver = { NAD27 | WGS84 | AVERAGE} AVERAGE = average of stations |
| gap |
| Base Entity | origin |
| Attribute Name | gap |
| Logical Rolename | gap |
| ColumnName | gap |
| RoleName | gap |
| Definition | Gap in azimuthal coverage |
| Note | Range: 0.0 <= gap <= 360.0 Units: Degrees |
| distance |
| Base Entity | origin |
| Attribute Name | distance |
| Logical Rolename | distance |
| ColumnName | distance |
| RoleName | distance |
| Definition | Distance from the origin to the nearest station |
| Note | Range: distance >= 0.0 Units: Kilometers |
| wrms |
| Base Entity | origin |
| Attribute Name | wrms |
| Logical Rolename | wrms |
| ColumnName | wrms |
| RoleName | wrms |
| Definition | This attribute denotes the weighted RMS |
| Note | Range: wrms > 0.0 |
| stime |
| Base Entity | origin |
| Attribute Name | stime |
| Logical Rolename | stime |
| ColumnName | stime |
| RoleName | stime |
| Definition | Origin time error. This attribute denotes the standard deviation of the origin time |
| Note | Range: stime >= 0.0 Units: Seconds |
| erhor |
| Base Entity | origin |
| Attribute Name | erhor |
| Logical Rolename | erhor |
| ColumnName | erhor |
| RoleName | erhor |
| Definition | Horizontal error. This attribute denotes the location uncertainty that accompanies the location |
| Note | Range: erhor >= 0.0 Units: Kilometers |
| sdep |
| Base Entity | origin |
| Attribute Name | sdep |
| Logical Rolename | sdep |
| ColumnName | sdep |
| RoleName | sdep |
| Definition | Depth error. This is the standard deviation of the depth estimate |
| Note | Range: sdep >= 0.0 Units: Kilometers |
| erlat |
| Base Entity | origin |
| Attribute Name | erlat |
| Logical Rolename | erlat |
| ColumnName | erlat |
| RoleName | erlat |
| Definition | Error in latitude. This is the standard deviation of the latitude estimate |
| Note | Range: erlat >= 0.0 Units: Kilometers |
| erlon |
| Base Entity | origin |
| Attribute Name | erlon |
| Logical Rolename | erlon |
| ColumnName | erlon |
| RoleName | erlon |
| Definition | Error in longitude. This is the standard deviation of the longitude estimate |
| Note | Range: erlon >= 0.0 Units: Kilometers |
| totalarr |
| Base Entity | origin |
| Attribute Name | totalarr |
| Logical Rolename | totalarr |
| ColumnName | totalarr |
| RoleName | totalarr |
| 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 Entity | origin |
| Attribute Name | totalamp |
| Logical Rolename | totalamp |
| ColumnName | totalamp |
| RoleName | totalamp |
| 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 Entity | origin |
| Attribute Name | ndef |
| Logical Rolename | ndef |
| ColumnName | ndef |
| RoleName | ndef |
| Definition | This attribute denotes the number of phases with non-zero output weights used in hypocenter calculation |
| Note | Range: ndef >= 0 |
| nbs |
| Base Entity | origin |
| Attribute Name | nbs |
| Logical Rolename | nbs |
| ColumnName | nbs |
| RoleName | nbs |
| Definition | Number of S phase readings with non-zero output weights |
| Note | Range: nbs >= 0 |
| nbfm |
| Base Entity | origin |
| Attribute Name | nbfm |
| Logical Rolename | nbfm |
| ColumnName | nbfm |
| RoleName | nbfm |
| Definition | Number of P first motions with non-zero input weights |
| Note | Range: nbfm >= 0 |
| locevid |
| Base Entity | origin |
| Attribute Name | locevid |
| Logical Rolename | locevid |
| ColumnName | locevid |
| RoleName | locevid |
| 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 Entity | origin |
| Attribute Name | quality |
| Logical Rolename | quality |
| ColumnName | quality |
| RoleName | quality |
| 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 Entity | origin |
| Attribute Name | fdepth |
| Logical Rolename | fdepth |
| ColumnName | fdepth |
| RoleName | fdepth |
| 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 Entity | origin |
| Attribute Name | fepi |
| Logical Rolename | fepi |
| ColumnName | fepi |
| RoleName | fepi |
| 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 Entity | origin |
| Attribute Name | ftime |
| Logical Rolename | ftime |
| ColumnName | ftime |
| RoleName | ftime |
| 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 Entity | origin |
| Attribute Name | vmodelid |
| Logical Rolename | vmodelid |
| ColumnName | vmodelid |
| RoleName | vmodelid |
| Definition | Velocity model identification |
| Note | Range: vmodelid > 0 |
| cmodelid |
| Base Entity | origin |
| Attribute Name | cmodelid |
| Logical Rolename | cmodelid |
| ColumnName | cmodelid |
| RoleName | cmodelid |
| Definition | Crustal model identifier |
| Note | Range: cmodelid > 0 |
| rflag |
| Base Entity | origin |
| Attribute Name | rflag |
| Logical Rolename | rflag |
| ColumnName | rflag |
| RoleName | rflag |
| 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 |
| lddate |
| Base Entity | origin |
| Attribute Name | lddate |
| Logical Rolename | lddate |
| ColumnName | lddate |
| RoleName | lddate |
| 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 |