Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBCMP

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

Summary

Abstract

Observer CAtch Composition for Purse Seine and Pair Trawl

Description

Observer CAtch Composition for Purse Seine and Pair Trawl

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LINK3
VARCHAR2 		Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
LINK1
VARCHAR2 		15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
PROGRAM
VARCHAR2 		First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
YEAR
VARCHAR2 		Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
MONTH
VARCHAR2 		Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
TRIPID
VARCHAR2 		May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
BSKTNUM
VARCHAR2 		Ordinal number of the basket in the haul
BSKTYEAR
VARCHAR2 		Year the basket is collected
BSKTMONTH
VARCHAR2 		Month the basket is collected
BSKTDAY
VARCHAR2 		Day the basket is collected
BSKTTIME
VARCHAR2 		Time the basket is collected
NESPP4
VARCHAR2 		Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
BSKTLBS
NUMBER 		Pounds of fish of given species and catch disposition in the basket
ESTPUMPDUR
NUMBER 		Estimated pumping time in minutes to pump the catch. Collected beginning with obdbs Version 10 (01/01/2011).
CMPCOMMENTS
VARCHAR2 		Catch Compoisiton Comments

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: OBCMP
Short Name: OBCMP
Status: Completed
Abstract:

Observer CAtch Composition for Purse Seine and Pair Trawl
Notes:

Loaded by batch 8949, 07-06-2016 08:23

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: OBDBS
Description:

Observer CAtch Composition for Purse Seine and Pair Trawl

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LINK3 VARCHAR2 Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
100
 LINK1 VARCHAR2 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
100
 PROGRAM VARCHAR2 First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
100
 YEAR VARCHAR2 Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
100
 MONTH VARCHAR2 Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
100
 TRIPID VARCHAR2 May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
100
 BSKTNUM VARCHAR2 Ordinal number of the basket in the haul
100
 BSKTYEAR VARCHAR2 Year the basket is collected
100
 BSKTMONTH VARCHAR2 Month the basket is collected
100
 BSKTDAY VARCHAR2 Day the basket is collected
100
 BSKTTIME VARCHAR2 Time the basket is collected
100
 NESPP4 VARCHAR2 Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
100
 BSKTLBS NUMBER Pounds of fish of given species and catch disposition in the basket
100
 ESTPUMPDUR NUMBER Estimated pumping time in minutes to pump the catch. Collected beginning with obdbs Version 10 (01/01/2011).
100
 CMPCOMMENTS VARCHAR2 Catch Compoisiton Comments

Attribute Details

LINK3

CC ID: 329552
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable.
General Data Type: VARCHAR2

LINK1

CC ID: 329559
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

PROGRAM

CC ID: 329560
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable.
General Data Type: VARCHAR2

YEAR

CC ID: 329561
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable.
General Data Type: VARCHAR2

MONTH

CC ID: 329562
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable.
General Data Type: VARCHAR2

TRIPID

CC ID: 329563
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable.
General Data Type: VARCHAR2

BSKTNUM

CC ID: 329564
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Ordinal number of the basket in the haul
General Data Type: VARCHAR2

BSKTYEAR

CC ID: 329565
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Year the basket is collected
General Data Type: VARCHAR2

BSKTMONTH

CC ID: 329566
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Month the basket is collected
General Data Type: VARCHAR2

BSKTDAY

CC ID: 329553
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Day the basket is collected
General Data Type: VARCHAR2

BSKTTIME

CC ID: 329554
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Time the basket is collected
General Data Type: VARCHAR2

NESPP4

CC ID: 329555
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
General Data Type: VARCHAR2

BSKTLBS

CC ID: 329556
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

Pounds of fish of given species and catch disposition in the basket
General Data Type: NUMBER

ESTPUMPDUR

CC ID: 329557
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Estimated pumping time in minutes to pump the catch. Collected beginning with obdbs Version 10 (01/01/2011).
General Data Type: NUMBER

CMPCOMMENTS

CC ID: 329558
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 250
Required: No
Primary Key: No
Status: Active
Description:

Catch Compoisiton Comments
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 33290
GUID: gov.noaa.nmfs.inport:33290
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-07-06 08:23+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-07-28
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-07-28
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-07-28