View: OPHAU
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33362 | Updated: August 9, 2022 | Published / External
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | OBPRELIM |
| Description: |
Preliminary Observer Haul Data |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
LINK1 | VARCHAR2 | 15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) | |
|
100
|
LINK3 | VARCHAR2 | 19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4) | |
|
100
|
YEAR | VARCHAR2 | Year landed. Characters 4-7 of LINK1. | |
|
100
|
TRIPID | VARCHAR2 | 6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year. | |
|
100
|
HAULNUM | VARCHAR2 | Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take. | |
|
100
|
NEGEAR | VARCHAR2 | Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR. | |
|
100
|
OBSRFLAG | VARCHAR2 | Indicator of whether haul was observed for discards. 0=No, 1=Yes. | |
|
100
|
CATEXIST | VARCHAR2 | Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes. | |
|
100
|
LATHBEG | VARCHAR2 | Latitude location where haul began. | |
|
100
|
LONHBEG | VARCHAR2 | Longitude location where haul began. | |
|
100
|
GIS_LATHBEG | VARCHAR2 | GIS converted LATHBEG. | |
|
100
|
GIS_LONHBEG | VARCHAR2 | GIS converted LONHBEG. This number is negative. | |
|
100
|
LATHEND | VARCHAR2 | Latitude location where haul ended or position information where take occurred for incidental take. | |
|
100
|
LONHEND | VARCHAR2 | Longitude location where haul ended or position information where take occurred for incidental take. | |
|
100
|
GIS_LATHEND | VARCHAR2 | GIS converted LATHEND. | |
|
100
|
GIS_LONHEND | VARCHAR2 | GIS converted LONHEND. This number is negative. | |
|
100
|
AREA | VARCHAR2 | Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul. | |
|
100
|
HAUCOMMENTS | VARCHAR2 | Additional information regarding the haul. |
Attribute Details
LINK1
CC ID: 331374
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 15 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) |
| General Data Type: | VARCHAR2 |
LINK3
CC ID: 331384
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 19 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4) |
| General Data Type: | VARCHAR2 |
YEAR
CC ID: 331385
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Year landed. Characters 4-7 of LINK1. |
| General Data Type: | VARCHAR2 |
TRIPID
CC ID: 331386
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
6-character trip identification. First 3 characters are the observer ID number (OBSID) and the characters following are the ordinal number of trips the observer has taken for the current year. |
| General Data Type: | VARCHAR2 |
HAULNUM
CC ID: 331387
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take. |
| General Data Type: | VARCHAR2 |
NEGEAR
CC ID: 331388
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Northeast gear code. Primary gear used on trip or gear code used on the haul. See OBGEAR. |
| General Data Type: | VARCHAR2 |
OBSRFLAG
CC ID: 331389
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether haul was observed for discards. 0=No, 1=Yes. |
| General Data Type: | VARCHAR2 |
CATEXIST
CC ID: 331390
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether gear from haul holds any catch, kept or discarded. 0=No, 1=Yes. |
| General Data Type: | VARCHAR2 |
LATHBEG
CC ID: 331391
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude location where haul began. |
| General Data Type: | VARCHAR2 |
LONHBEG
CC ID: 331375
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude location where haul began. |
| General Data Type: | VARCHAR2 |
GIS_LATHBEG
CC ID: 331376
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
GIS converted LATHBEG. |
| General Data Type: | VARCHAR2 |
GIS_LONHBEG
CC ID: 331377
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
GIS converted LONHBEG. This number is negative. |
| General Data Type: | VARCHAR2 |
LATHEND
CC ID: 331378
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latitude location where haul ended or position information where take occurred for incidental take. |
| General Data Type: | VARCHAR2 |
LONHEND
CC ID: 331379
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Longitude location where haul ended or position information where take occurred for incidental take. |
| General Data Type: | VARCHAR2 |
GIS_LATHEND
CC ID: 331380
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
GIS converted LATHEND. |
| General Data Type: | VARCHAR2 |
GIS_LONHEND
CC ID: 331381
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
GIS converted LONHEND. This number is negative. |
| General Data Type: | VARCHAR2 |
AREA
CC ID: 331382
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Entered and computed field. For trip, statistical area code where the majority of hauls occurred on the trip. For haul, statistical area code for this haul. |
| General Data Type: | VARCHAR2 |
HAUCOMMENTS
CC ID: 331383
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 200 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional information regarding the haul. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 33362 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33362 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-06 15:07+0000 |
| Metadata Record Last Modified By: | SysAdmin InPortAdmin |
| Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
| Metadata Record Published: | 2016-07-06 |
| Owner Org: | NEFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2016-07-06 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-07-06 |