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

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

At Sea Monitor LongLine Hauls

Description

At Sea Monitor LongLine Hauls

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.
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.
LINK4 VARCHAR2	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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.
GEARNUM VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
WTMPSBEG NUMBER	Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.
WTMPSEND NUMBER	Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.
WTMPHBEG NUMBER	Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.
RATLRUSD VARCHAR2	Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown
NRATLRS NUMBER	Number of rattlers used on gear.
SURLTUSD VARCHAR2	Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown
NSURLT NUMBER	Number of surface lights used on gear.
ADDWGTUSD VARCHAR2	Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)
NADDWGTS NUMBER	Number of additional line weights.
ADDWGTLBS NUMBER	Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
NHKSET NUMBER	Total number of hooks used for set.
NHKHAUL NUMBER	Total number of hooks hauled from this set (3/2007)
NHKLOST NUMBER	Total number of hooks lost from set.
NHKTEND NUMBER	Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.
NHKREBA NUMBER	Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.
BAIT1LBS NUMBER	Amount of primary bait used for haul, in whole pounds.
BAIT1KND VARCHAR2	Code for primary bait kind. see OBBAIT table.
BAIT1TYP VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
BAIT1CND VARCHAR2	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
BAIT2LBS NUMBER	Amount of secondary bait used for haul, in whole pounds.
BAIT2KND VARCHAR2	Code for bait kind. See OBBAIT table.
BAIT2TYP VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
BAIT2CND VARCHAR2	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
BAIT3LBS NUMBER	Amount of third bait used for haul, in whole lbs.
BAIT3KND VARCHAR2	Code for bait kind. see OBBAIT table
BAIT3TYP VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
BAIT3CND VARCHAR2	Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other
MLLEN NUMBER	Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.
SETSPEED NUMBER	Speed of vessel setting net during set, nearest 10th of knot.
HKDEPMIN NUMBER	Shallowest depth, from surface, in which hooks fished, in whole fathoms.
HKDEPMAX NUMBER	Deepest depth, from surface, in which hooks fished, in whole fathoms.
SETMETHOD VARCHAR2	Method of manner in which gear was set for haul. See OBSETMETHOD table.
LLHCOMMENTS VARCHAR2	Comments on line haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
ASMTEST_STATUS VARCHAR2	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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.

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.

LINK4
VARCHAR2

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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.

GEARNUM
VARCHAR2

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

WTMPSBEG
NUMBER

Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.

WTMPSEND
NUMBER

Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.

WTMPHBEG
NUMBER

Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.

RATLRUSD
VARCHAR2

Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown

NRATLRS
NUMBER

Number of rattlers used on gear.

SURLTUSD
VARCHAR2

Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown

NSURLT
NUMBER

Number of surface lights used on gear.

ADDWGTUSD
VARCHAR2

Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)

NADDWGTS
NUMBER

Number of additional line weights.

ADDWGTLBS
NUMBER

Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )

NHKSET
NUMBER

Total number of hooks used for set.

NHKHAUL
NUMBER

Total number of hooks hauled from this set (3/2007)

NHKLOST
NUMBER

Total number of hooks lost from set.

NHKTEND
NUMBER

Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.

NHKREBA
NUMBER

Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.

BAIT1LBS
NUMBER

Amount of primary bait used for haul, in whole pounds.

BAIT1KND
VARCHAR2

Code for primary bait kind. see OBBAIT table.

BAIT1TYP
VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.

BAIT1CND
VARCHAR2

Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

BAIT2LBS
NUMBER

Amount of secondary bait used for haul, in whole pounds.

BAIT2KND
VARCHAR2

Code for bait kind. See OBBAIT table.

BAIT2TYP
VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

BAIT2CND
VARCHAR2

Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

BAIT3LBS
NUMBER

Amount of third bait used for haul, in whole lbs.

BAIT3KND
VARCHAR2

Code for bait kind. see OBBAIT table

BAIT3TYP
VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

BAIT3CND
VARCHAR2

Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other

MLLEN
NUMBER

Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.

SETSPEED
NUMBER

Speed of vessel setting net during set, nearest 10th of knot.

HKDEPMIN
NUMBER

Shallowest depth, from surface, in which hooks fished, in whole fathoms.

HKDEPMAX
NUMBER

Deepest depth, from surface, in which hooks fished, in whole fathoms.

SETMETHOD
VARCHAR2

Method of manner in which gear was set for haul. See OBSETMETHOD table.

LLHCOMMENTS
VARCHAR2

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

ASMTEST_STATUS
VARCHAR2

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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: ASMLLH
Short Name:	ASMLLH
Status:	Completed
Abstract:	At Sea Monitor LongLine Hauls
Notes:	Loaded by batch 9053, 07-27-2016 19:10

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	At Sea Monitor LongLine Hauls

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	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	LINK4	VARCHAR2	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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	GEARNUM	VARCHAR2	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
100	WTMPSBEG	NUMBER	Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.
100	WTMPSEND	NUMBER	Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.
100	WTMPHBEG	NUMBER	Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.
100	RATLRUSD	VARCHAR2	Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown
100	NRATLRS	NUMBER	Number of rattlers used on gear.
100	SURLTUSD	VARCHAR2	Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown
100	NSURLT	NUMBER	Number of surface lights used on gear.
100	ADDWGTUSD	VARCHAR2	Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)
100	NADDWGTS	NUMBER	Number of additional line weights.
100	ADDWGTLBS	NUMBER	Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
100	NHKSET	NUMBER	Total number of hooks used for set.
100	NHKHAUL	NUMBER	Total number of hooks hauled from this set (3/2007)
100	NHKLOST	NUMBER	Total number of hooks lost from set.
100	NHKTEND	NUMBER	Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.
100	NHKREBA	NUMBER	Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.
100	BAIT1LBS	NUMBER	Amount of primary bait used for haul, in whole pounds.
100	BAIT1KND	VARCHAR2	Code for primary bait kind. see OBBAIT table.
100	BAIT1TYP	VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
100	BAIT1CND	VARCHAR2	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100	BAIT2LBS	NUMBER	Amount of secondary bait used for haul, in whole pounds.
100	BAIT2KND	VARCHAR2	Code for bait kind. See OBBAIT table.
100	BAIT2TYP	VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
100	BAIT2CND	VARCHAR2	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
100	BAIT3LBS	NUMBER	Amount of third bait used for haul, in whole lbs.
100	BAIT3KND	VARCHAR2	Code for bait kind. see OBBAIT table
100	BAIT3TYP	VARCHAR2	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
100	BAIT3CND	VARCHAR2	Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other
100	MLLEN	NUMBER	Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.
100	SETSPEED	NUMBER	Speed of vessel setting net during set, nearest 10th of knot.
100	HKDEPMIN	NUMBER	Shallowest depth, from surface, in which hooks fished, in whole fathoms.
100	HKDEPMAX	NUMBER	Deepest depth, from surface, in which hooks fished, in whole fathoms.
100	SETMETHOD	VARCHAR2	Method of manner in which gear was set for haul. See OBSETMETHOD table.
100	LLHCOMMENTS	VARCHAR2	Comments on line haul record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable.
100	ASMTEST_STATUS	VARCHAR2	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

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

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

LINK4

VARCHAR2

Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. 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

GEARNUM

VARCHAR2

Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.

100

WTMPSBEG

NUMBER

Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.

100

WTMPSEND

NUMBER

Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.

100

WTMPHBEG

NUMBER

Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.

100

RATLRUSD

VARCHAR2

Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown

100

NRATLRS

NUMBER

Number of rattlers used on gear.

100

SURLTUSD

VARCHAR2

Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown

100

NSURLT

NUMBER

Number of surface lights used on gear.

100

ADDWGTUSD

VARCHAR2

Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)

100

NADDWGTS

NUMBER

Number of additional line weights.

100

ADDWGTLBS

NUMBER

Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )

100

NHKSET

NUMBER

Total number of hooks used for set.

100

NHKHAUL

NUMBER

Total number of hooks hauled from this set (3/2007)

100

NHKLOST

NUMBER

Total number of hooks lost from set.

100

NHKTEND

NUMBER

Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.

100

NHKREBA

NUMBER

Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.

100

BAIT1LBS

NUMBER

Amount of primary bait used for haul, in whole pounds.

100

BAIT1KND

VARCHAR2

Code for primary bait kind. see OBBAIT table.

100

BAIT1TYP

VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.

100

BAIT1CND

VARCHAR2

Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

100

BAIT2LBS

NUMBER

Amount of secondary bait used for haul, in whole pounds.

100

BAIT2KND

VARCHAR2

Code for bait kind. See OBBAIT table.

100

BAIT2TYP

VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

100

BAIT2CND

VARCHAR2

Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.

100

BAIT3LBS

NUMBER

Amount of third bait used for haul, in whole lbs.

100

BAIT3KND

VARCHAR2

Code for bait kind. see OBBAIT table

100

BAIT3TYP

VARCHAR2

Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other

100

BAIT3CND

VARCHAR2

Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other

100

MLLEN

NUMBER

Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.

100

SETSPEED

NUMBER

Speed of vessel setting net during set, nearest 10th of knot.

100

HKDEPMIN

NUMBER

Shallowest depth, from surface, in which hooks fished, in whole fathoms.

100

HKDEPMAX

NUMBER

Deepest depth, from surface, in which hooks fished, in whole fathoms.

100

SETMETHOD

VARCHAR2

Method of manner in which gear was set for haul. See OBSETMETHOD table.

100

LLHCOMMENTS

VARCHAR2

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

100

ASMTEST_STATUS

VARCHAR2

Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested

Attribute Details

LINK3

CC ID: 334042

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	19
Required:	Yes
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

PROGRAM

CC ID: 334053

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

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

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

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

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

LINK4

CC ID: 334082

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	17
Required:	No
Primary Key:	No
Status:	Active
Description:	Key field linking tables at the gear level; made up of: link1 + (2-character ) gearnum. Collected for ASM where applicable.
General Data Type:	VARCHAR2

LINK1

CC ID: 334083

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

GEARNUM

CC ID: 334084

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Sequential number assigned to gear number, unique by trip. Collected for ASM where applicable.
General Data Type:	VARCHAR2

WTMPSBEG

CC ID: 334043

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Surface water temperature at beginning of set, Fahrenheit to nearest tenth of degree.
General Data Type:	NUMBER

WTMPSEND

CC ID: 334044

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Surface water temperature at end of set, Fahrenheit to nearest tenth of degree.
General Data Type:	NUMBER

WTMPHBEG

CC ID: 334045

Seq. Order:	12
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Surface water temperature at beginning of haul, Fahrenheit to nearest tenth of degree.
General Data Type:	NUMBER

RATLRUSD

CC ID: 334046

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether rattlers used on gear. 0 = no , 1 = yes 9 = unknown
General Data Type:	VARCHAR2

NRATLRS

CC ID: 334047

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of rattlers used on gear.
General Data Type:	NUMBER

SURLTUSD

CC ID: 334048

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether surface lights used on gear. 0 = no 1 = yes 9 = unknown
General Data Type:	VARCHAR2

NSURLT

CC ID: 334049

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Number of surface lights used on gear.
General Data Type:	NUMBER

ADDWGTUSD

CC ID: 334050

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of additional line weights attached to leadline (GGG) or mainline (LLH). 0 = no, 1 = yes, 9 = unknown. Not collected prior to 2001 (all set to 9 = unknown)
General Data Type:	VARCHAR2

NADDWGTS

CC ID: 334051

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of additional line weights.
General Data Type:	NUMBER

ADDWGTLBS

CC ID: 334052

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total weight of additional weights used on leadline or mainline, in whole pounds. Not collected prior to 2001 (all set to null )
General Data Type:	NUMBER

NHKSET

CC ID: 334054

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total number of hooks used for set.
General Data Type:	NUMBER

NHKHAUL

CC ID: 334055

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total number of hooks hauled from this set (3/2007)
General Data Type:	NUMBER

NHKLOST

CC ID: 334056

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Total number of hooks lost from set.
General Data Type:	NUMBER

NHKTEND

CC ID: 334057

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of hooks pulled during "hotlining". Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

NHKREBA

CC ID: 334058

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Number of hooks pulled, rebaited and reset. Not collected prior to 2001; set to unknown.
General Data Type:	NUMBER

BAIT1LBS

CC ID: 334059

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of primary bait used for haul, in whole pounds.
General Data Type:	NUMBER

BAIT1KND

CC ID: 334060

Seq. Order:	26
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait kind. see OBBAIT table.
General Data Type:	VARCHAR2

BAIT1TYP

CC ID: 334061

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other.
General Data Type:	VARCHAR2

BAIT1CND

CC ID: 334062

Seq. Order:	28
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition of primary bait used. 0 = unknown. 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
General Data Type:	VARCHAR2

BAIT2LBS

CC ID: 334063

Seq. Order:	29
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of secondary bait used for haul, in whole pounds.
General Data Type:	NUMBER

BAIT2KND

CC ID: 334065

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for bait kind. See OBBAIT table.
General Data Type:	VARCHAR2

BAIT2TYP

CC ID: 334066

Seq. Order:	31
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
General Data Type:	VARCHAR2

BAIT2CND

CC ID: 334067

Seq. Order:	32
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition of bait used. 0 = unknown, 1 = previously frozen, 2 = fresh, 3 = salted, 6 = frozen, 7 = semifrozen, 8 = combination, 9 = other.
General Data Type:	VARCHAR2

BAIT3LBS

CC ID: 334068

Seq. Order:	33
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Amount of third bait used for haul, in whole lbs.
General Data Type:	NUMBER

BAIT3KND

CC ID: 334069

Seq. Order:	34
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for bait kind. see OBBAIT table
General Data Type:	VARCHAR2

BAIT3TYP

CC ID: 334070

Seq. Order:	35
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for primary bait type used. 0 = unknown, 1 = whole, 2 = cut, 3 = live 9 = other
General Data Type:	VARCHAR2

BAIT3CND

CC ID: 334071

Seq. Order:	36
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for condition of bait used. 0 = unknown 1 = previously frozen 2 = fresh 3 = salted 6 = frozen 7 = semifrozen 8 = combination 9 = other
General Data Type:	VARCHAR2

MLLEN

CC ID: 334072

Seq. Order:	37
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Length of mainline, to the nearest 10th of nautical mile. Collected for ASM where applicable.
General Data Type:	NUMBER

SETSPEED

CC ID: 334073

Seq. Order:	38
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	1
Status:	Active
Description:	Speed of vessel setting net during set, nearest 10th of knot.
General Data Type:	NUMBER

HKDEPMIN

CC ID: 334074

Seq. Order:	39
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Shallowest depth, from surface, in which hooks fished, in whole fathoms.
General Data Type:	NUMBER

HKDEPMAX

CC ID: 334076

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Deepest depth, from surface, in which hooks fished, in whole fathoms.
General Data Type:	NUMBER

SETMETHOD

CC ID: 334077

Seq. Order:	41
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Method of manner in which gear was set for haul. See OBSETMETHOD table.
General Data Type:	VARCHAR2

LLHCOMMENTS

CC ID: 334078

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

ASMTEST_STATUS

CC ID: 334079

Seq. Order:	43
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested
General Data Type:	VARCHAR2

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LINK3

PROGRAM

YEAR

MONTH

TRIPID

HAULNUM

LINK4

LINK1

GEARNUM

WTMPSBEG

WTMPSEND

WTMPHBEG

RATLRUSD

NRATLRS

SURLTUSD

NSURLT

ADDWGTUSD

NADDWGTS

ADDWGTLBS

NHKSET

NHKHAUL

NHKLOST

NHKTEND

NHKREBA

BAIT1LBS

BAIT1KND

BAIT1TYP

BAIT1CND

BAIT2LBS

BAIT2KND

BAIT2TYP

BAIT2CND

BAIT3LBS

BAIT3KND

BAIT3TYP

BAIT3CND

MLLEN

SETSPEED

HKDEPMIN

HKDEPMAX

SETMETHOD

LLHCOMMENTS

ASMTEST_STATUS

Catalog Details