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

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

Item Identification

Title:	View: ASMTRG
Short Name:	ASMTRG
Status:	Completed
Abstract:	At Sea Monitor Trip-Gear Data
Notes:	Loaded by batch 8948, 07-06-2016 08:22

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBDBS
Description:	At Sea Monitor Trip-Gear Data

Data Attributes

Attribute Summary

	Name	Type	Description
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	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	NEGEAR	VARCHAR2	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
100	PRIMGEAR	VARCHAR2	Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.
100	GEARUSD	VARCHAR2	Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.
100	NONBOARD	NUMBER	Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.
100	NSOAKING	NUMBER	Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.
100	CAPTYRS	NUMBER	In whole year, the number of years Captain in fishery with type of gear recorded in negear
100	TARGSPEC1	VARCHAR2	NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100	TARGSPEC2	VARCHAR2	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
100	TARGSPEC3	VARCHAR2	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	TARGSPEC4	VARCHAR2	NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	TARGSPEC5	VARCHAR2	NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
100	TRGCOMMENTS	VARCHAR2	Additional information regarding the trip/gear. Prior to 2001 only true or false. 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

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

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

NEGEAR

VARCHAR2

Northeast gear code. See OBGEAR table. Collected for ASM where applicable.

100

PRIMGEAR

VARCHAR2

Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.

100

GEARUSD

VARCHAR2

Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.

100

NONBOARD

NUMBER

Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.

100

NSOAKING

NUMBER

Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.

100

CAPTYRS

NUMBER

In whole year, the number of years Captain in fishery with type of gear recorded in negear

100

TARGSPEC1

VARCHAR2

NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

100

TARGSPEC2

VARCHAR2

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.

100

TARGSPEC3

VARCHAR2

NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

TARGSPEC4

VARCHAR2

NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

TARGSPEC5

VARCHAR2

NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.

100

TRGCOMMENTS

VARCHAR2

Additional information regarding the trip/gear. Prior to 2001 only true or false. 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

PROGRAM

CC ID: 329304

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

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

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

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

LINK1

CC ID: 329317

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

NEGEAR

CC ID: 329318

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Northeast gear code. See OBGEAR table. Collected for ASM where applicable.
General Data Type:	VARCHAR2

PRIMGEAR

CC ID: 329319

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Indicator that negear is principal gear used on trip. 0=no 1 = yes. Collected for ASM where applicable.
General Data Type:	VARCHAR2

GEARUSD

CC ID: 329320

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicator of whether the gear was used during the trip. 0 = No, 1 = yes.
General Data Type:	VARCHAR2

NONBOARD

CC ID: 329321

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Number of gear of this negear code onboard the vessel. Not collected prior to 5/1994; set to unknown.
General Data Type:	NUMBER

NSOAKING

CC ID: 329305

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Number of gear indicated by negear Captain has soaking in water at beginning of trip. Not collected prior to 5/1994; set to unknown for set gear, 0 for mobile gear.
General Data Type:	NUMBER

CAPTYRS

CC ID: 329306

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	In whole year, the number of years Captain in fishery with type of gear recorded in negear
General Data Type:	NUMBER

TARGSPEC1

CC ID: 329307

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TARGSPEC2

CC ID: 329308

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear. Collected for ASM where applicable.
General Data Type:	VARCHAR2

TARGSPEC3

CC ID: 329309

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

TARGSPEC4

CC ID: 329310

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 code for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

TARGSPEC5

CC ID: 329311

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NESPP4 for any one of the species named by captain as targeted for haul or trip; named before haul or trip, not after. Not necessarily same as majority of catch. May differ by haul or gear.
General Data Type:	VARCHAR2

TRGCOMMENTS

CC ID: 329312

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	250
Required:	No
Primary Key:	No
Status:	Active
Description:	Additional information regarding the trip/gear. Prior to 2001 only true or false. Collected for ASM where applicable.
General Data Type:	VARCHAR2

ASMTEST_STATUS

CC ID: 329313

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

Catalog Item ID:	33281
GUID:	gov.noaa.nmfs.inport:33281
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-07-06 08:22+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