Metadata Rubric

100%

6 / 6

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

View: OBLNH

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Observer Animal Length Header Data from standard observer trips

Description

Observer Animal Length Header Data from standard observer trips

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.
HAULNUM VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
LINK5 VARCHAR2	field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. 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.
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.
CATDISP VARCHAR2	Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. 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.
DREDGEPOS VARCHAR2	Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;
SAMPWEIGHT NUMBER	Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.
AGESTRCT VARCHAR2	Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).
NAGESTRCT NUMBER	Total number of animals from which age samples were collected.
VOLMEATS NUMBER	Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.
LNHCOMMENTS VARCHAR2	Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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.

HAULNUM
VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

LINK5
VARCHAR2

field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. 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.

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.

CATDISP
VARCHAR2

Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. 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.

DREDGEPOS
VARCHAR2

Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;

SAMPWEIGHT
NUMBER

Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.

AGESTRCT
VARCHAR2

Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).

NAGESTRCT
NUMBER

Total number of animals from which age samples were collected.

VOLMEATS
NUMBER

Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.

LNHCOMMENTS
VARCHAR2

Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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: OBLNH
Short Name:	OBLNH
Status:	Completed
Abstract:	Observer Animal Length Header Data from standard observer trips
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	Observer Animal Length Header Data from standard observer trips

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	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	HAULNUM	VARCHAR2	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
100	LINK5	VARCHAR2	field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. 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	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	CATDISP	VARCHAR2	Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. 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	DREDGEPOS	VARCHAR2	Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;
100	SAMPWEIGHT	NUMBER	Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.
100	AGESTRCT	VARCHAR2	Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).
100	NAGESTRCT	NUMBER	Total number of animals from which age samples were collected.
100	VOLMEATS	NUMBER	Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.
100	LNHCOMMENTS	VARCHAR2	Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

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

100

HAULNUM

VARCHAR2

Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.

100

LINK5

VARCHAR2

field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. 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

FISHDISP

VARCHAR2

100

CATDISP

VARCHAR2

Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. 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

DREDGEPOS

VARCHAR2

Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;

100

SAMPWEIGHT

NUMBER

Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.

100

AGESTRCT

VARCHAR2

Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).

100

NAGESTRCT

NUMBER

Total number of animals from which age samples were collected.

100

VOLMEATS

NUMBER

Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.

100

LNHCOMMENTS

VARCHAR2

Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.

Attribute Details

LINK3

CC ID: 334630

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

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

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

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

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

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

HAULNUM

CC ID: 334645

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK5

CC ID: 334646

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	29
Required:	No
Primary Key:	No
Status:	Active
Description:	field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. Collected for ASM where applicable.
General Data Type:	VARCHAR2

NESPP4

CC ID: 334647

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

FISHDISP

CC ID: 334631

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

CATDISP

CC ID: 334632

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable.
General Data Type:	VARCHAR2

SEX

CC ID: 334633

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

DREDGEPOS

CC ID: 334634

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown;
General Data Type:	VARCHAR2

SAMPWEIGHT

CC ID: 334635

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable.
General Data Type:	NUMBER

AGESTRCT

CC ID: 334636

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments).
General Data Type:	VARCHAR2

NAGESTRCT

CC ID: 334637

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Total number of animals from which age samples were collected.
General Data Type:	NUMBER

VOLMEATS

CC ID: 334638

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	0
Status:	Active
Description:	Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown.
General Data Type:	NUMBER

LNHCOMMENTS

CC ID: 334639

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
General Data Type:	VARCHAR2

Catalog Item ID:	33567
GUID:	gov.noaa.nmfs.inport:33567
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: OBLNH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK3

LINK1

PROGRAM

YEAR

MONTH

TRIPID

HAULNUM

LINK5

NESPP4

FISHDISP

CATDISP

SEX

DREDGEPOS

SAMPWEIGHT

AGESTRCT

NAGESTRCT

VOLMEATS

LNHCOMMENTS

Catalog Details