View: OPCATCH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33361 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: OPCATCH |
|---|---|
| Short Name: | OPCATCH |
| Status: | Completed |
| Abstract: |
Preliminary Observer Catch Data |
| Notes: |
Loaded by batch 8952, 07-06-2016 15:07 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | OBPRELIM |
| Description: |
Preliminary Observer Catch 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
|
NESPP4 | VARCHAR2 | Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC. | |
|
100
|
HAILWT | NUMBER | The dressed or round, actual or estimated weight for each caught species. | |
|
100
|
FISHDISP | VARCHAR2 | Three digit code for disposition of each species. See OBDBS.OBFISHDISP. | |
|
100
|
ROUND | CHAR | Indicator of whether the species in the record was dressed=1, round=2, unknown=0. |
Attribute Details
LINK1
| 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
| 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
| 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
| 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
| 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 |
NESPP4
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC. |
| General Data Type: | VARCHAR2 |
HAILWT
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | Yes |
| Primary Key: | No |
| Precision: | 7 |
| Scale: | 1 |
| Status: | Active |
| Description: |
The dressed or round, actual or estimated weight for each caught species. |
| General Data Type: | NUMBER |
FISHDISP
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Three digit code for disposition of each species. See OBDBS.OBFISHDISP. |
| General Data Type: | VARCHAR2 |
ROUND
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | CHAR |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether the species in the record was dressed=1, round=2, unknown=0. |
| General Data Type: | CHAR |
Catalog Details
| Catalog Item ID: | 33361 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33361 |
| 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 |