Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer Preliminary Database (OBPRELIM) >

View: OPCATCH

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33361  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Preliminary Observer Catch Data

Description

Preliminary Observer Catch Data

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK1
VARCHAR2 		15 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6)
LINK3
VARCHAR2 		19 character key field: PROGRAM(3) + YEAR(4) + MONTH(2) + TRIPID(6) + HAULNUM(4)
YEAR
VARCHAR2 		Year landed. Characters 4-7 of LINK1.
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.
HAULNUM
VARCHAR2 		Ordinal number assigned to the haul or haul number associated with catch, discard event or incidental take.
NESPP4
VARCHAR2 		Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBDBS.OBSPEC.
HAILWT
NUMBER 		The dressed or round, actual or estimated weight for each caught species.
FISHDISP
VARCHAR2 		Three digit code for disposition of each species. See OBDBS.OBFISHDISP.
ROUND
CHAR 		Indicator of whether the species in the record was dressed=1, round=2, unknown=0.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

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

Rubric Score Primary Key? 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

CC ID: 331365
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: 331366
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: 331367
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: 331368
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: 331369
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

CC ID: 331370
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

CC ID: 331371
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

CC ID: 331372
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

CC ID: 331373
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