Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fishery Monitoring Operations Branch (FMOB) > Observer and At Sea Monitor Database (OBDBS) >

View: OBCRU

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33561 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Crustacean Sample Logs

Description

Observer Crustacean Sample Logs

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.
SEQNUM VARCHAR2	Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. 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.
NESPP4 VARCHAR2	Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable.
NCRUSTCN NUMBER	Total number of crustacean caught in haul.
CNTTYPE VARCHAR2	Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated.
DISEASEPCT NUMBER	Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown
CRLEN NUMBER	Length for lobsters, width for crab, in whole millimeters.
FISHDISP VARCHAR2	Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
SEX VARCHAR2	One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
EGG VARCHAR2	Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.
VNOTCH VARCHAR2	Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new
MOLT VARCHAR2	Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter
NCLAWS NUMBER	Number of claws on lobster sampled.
CRUCOMMENTS VARCHAR2	Comments on crustacean record. Prior to 2001 only true (1), false (0)

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.

SEQNUM
VARCHAR2

Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. 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.

NESPP4
VARCHAR2

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

NCRUSTCN
NUMBER

Total number of crustacean caught in haul.

CNTTYPE
VARCHAR2

Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated.

DISEASEPCT
NUMBER

Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown

CRLEN
NUMBER

Length for lobsters, width for crab, in whole millimeters.

FISHDISP
VARCHAR2

Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.

SEX
VARCHAR2

One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.

EGG
VARCHAR2

Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.

VNOTCH
VARCHAR2

Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new

MOLT
VARCHAR2

Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter

NCLAWS
NUMBER

Number of claws on lobster sampled.

CRUCOMMENTS
VARCHAR2

Comments on crustacean record. Prior to 2001 only true (1), false (0)

No Child Items for this record.

No contact information is available for this record.

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

Title:	View: OBCRU
Short Name:	OBCRU
Status:	Completed
Abstract:	Observer Crustacean Sample Logs
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Crustacean Sample Logs

Attribute Summary

	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	SEQNUM	VARCHAR2	Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. 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	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	NCRUSTCN	NUMBER	Total number of crustacean caught in haul.
100	CNTTYPE	VARCHAR2	Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated.
100	DISEASEPCT	NUMBER	Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown
100	CRLEN	NUMBER	Length for lobsters, width for crab, in whole millimeters.
100	FISHDISP	VARCHAR2	Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
100	SEX	VARCHAR2	One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
100	EGG	VARCHAR2	Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.
100	VNOTCH	VARCHAR2	Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new
100	MOLT	VARCHAR2	Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter
100	NCLAWS	NUMBER	Number of claws on lobster sampled.
100	CRUCOMMENTS	VARCHAR2	Comments on crustacean record. Prior to 2001 only true (1), false (0)

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

SEQNUM

VARCHAR2

Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. 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

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

NCRUSTCN

NUMBER

Total number of crustacean caught in haul.

100

CNTTYPE

VARCHAR2

Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated.

100

DISEASEPCT

NUMBER

Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown

100

CRLEN

NUMBER

Length for lobsters, width for crab, in whole millimeters.

100

FISHDISP

VARCHAR2

100

SEX

VARCHAR2

One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.

100

EGG

VARCHAR2

Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.

100

VNOTCH

VARCHAR2

Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new

100

MOLT

VARCHAR2

Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter

100

NCLAWS

NUMBER

Number of claws on lobster sampled.

100

CRUCOMMENTS

VARCHAR2

Comments on crustacean record. Prior to 2001 only true (1), false (0)

Attribute Details

LINK3

CC ID: 334311

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: 334322

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

SEQNUM

CC ID: 334323

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Sequential numbers (by haul) assigned to each animal or debris item recorded on IAL log. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PROGRAM

CC ID: 334324

Seq. Order:	4
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: 334325

Seq. Order:	5
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: 334326

Seq. Order:	6
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: 334327

Seq. Order:	7
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

NESPP4

CC ID: 334328

Seq. Order:	8
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

NCRUSTCN

CC ID: 334329

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Total number of crustacean caught in haul.
General Data Type:	NUMBER

CNTTYPE

CC ID: 334312

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether number recorded was actual or estimated. 1 = actual 2 = estimated.
General Data Type:	VARCHAR2

DISEASEPCT

CC ID: 334313

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Percentage of animals, of species sampled, that show signs of shell disease. unknown = null Not collected prior to 2001 set to null = unknown
General Data Type:	NUMBER

CRLEN

CC ID: 334314

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Length for lobsters, width for crab, in whole millimeters.
General Data Type:	NUMBER

FISHDISP

CC ID: 334315

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable.
General Data Type:	VARCHAR2

SEX

CC ID: 334316

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female.
General Data Type:	VARCHAR2

EGG

CC ID: 334317

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether eggs are visible underneath back part of abdomen of animal sampled. See OBEGGS table.
General Data Type:	VARCHAR2

VNOTCH

CC ID: 334318

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether vnotch exists on lobster being sampled.0 = unknown 1 = no 2 = yes, old 3 = yes, new
General Data Type:	VARCHAR2

MOLT

CC ID: 334319

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Condition of shell of lobster being sampled.0=unknown 1=soft 2=paper 3=hard 4=splitter
General Data Type:	VARCHAR2

NCLAWS

CC ID: 334320

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Number of claws on lobster sampled.
General Data Type:	NUMBER

CRUCOMMENTS

CC ID: 334321

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on crustacean record. Prior to 2001 only true (1), false (0)
General Data Type:	VARCHAR2

Catalog Item ID:	33561
GUID:	gov.noaa.nmfs.inport:33561
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-27 19:10+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

View: OBCRU

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK3

LINK1

SEQNUM

PROGRAM

YEAR

MONTH

TRIPID

NESPP4

NCRUSTCN

CNTTYPE

DISEASEPCT

CRLEN

FISHDISP

SEX

EGG

VNOTCH

MOLT

NCLAWS

CRUCOMMENTS

Catalog Details