Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Data Management Systems (DMS) > Commercial Fisheries Database Biological Sample... >

View: WOAGEyy

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Commercial Fisheries Age Data for 1961, 1965 to 1993.

Description

Commercial Fisheries Age Data for 1961, 1965 to 1993.

Entity Type
Data View

Data Attribute / Type	Description
PORT VARCHAR2	A combined code for state, port and county. The port in which the vessel landed the catch.
STATE VARCHAR2	The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.
PORT2 VARCHAR2	The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
COUNTY VARCHAR2	Name of county., ex.ESSEX.
YEAR NUMBER	The year in which the landings or negative report occurred.
LINK VARCHAR2	The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros.
MONTH VARCHAR2	The month (01-12) of the vessel landing or negative dealer report. 00 = unknown.
DOCN VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15).
AREA VARCHAR2	The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown.
NEMAREA VARCHAR2	The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown.
SAMPAREA VARCHAR2	The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.
NESPP4 VARCHAR2	The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123.
NESPP3 VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes.
QTR VARCHAR2	The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
TONCLASS VARCHAR2	The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table.
NEGEAR VARCHAR2	Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X.
NEGEAR2 VARCHAR2	First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.
DEPTHCD VARCHAR2	The depth to bottom, in fathoms, coded as follows: <br> 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; <br> 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. <br> When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null.
SAMPMETH NUMBER	The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz.
CATDISP NUMBER	Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept.
AGESTRCT NUMBER	The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.
SEX NUMBER	Sex code: 0=unsexed; 1=male; 2=female.
LENGTH NUMBER	The length of specimen in centimeters.
NPAIRS NUMBER	The number of length frequency pairs.
AGE NUMBER	The age of specimen in years.
NUMAGE NUMBER	The number of specimens at a given age.
NO_LEN_MATCH VARCHAR2	Flag indicating that there is no matching length record for the age record.

Data Attribute / Type

Description

PORT
VARCHAR2

A combined code for state, port and county. The port in which the vessel landed the catch.

STATE
VARCHAR2

The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.

PORT2
VARCHAR2

The 3rd and 4th digit of the port code--meaningless without the rest of the port code.

COUNTY
VARCHAR2

Name of county., ex.ESSEX.

YEAR
NUMBER

The year in which the landings or negative report occurred.

LINK
VARCHAR2

The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros.

MONTH
VARCHAR2

The month (01-12) of the vessel landing or negative dealer report. 00 = unknown.

DOCN
VARCHAR2

Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15).

AREA
VARCHAR2

The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown.

NEMAREA
VARCHAR2

The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown.

SAMPAREA
VARCHAR2

The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.

NESPP4
VARCHAR2

The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123.

NESPP3
VARCHAR2

The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes.

QTR
VARCHAR2

The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.

TONCLASS
VARCHAR2

The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table.

NEGEAR
VARCHAR2

Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X.

NEGEAR2
VARCHAR2

First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.

DEPTHCD
VARCHAR2

The depth to bottom, in fathoms, coded as follows: 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null.

SAMPMETH
NUMBER

The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz.

CATDISP
NUMBER

Indicates if the catch from which the sample was taken was: 0=discarded, 1=kept.

AGESTRCT
NUMBER

The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.

SEX
NUMBER

Sex code: 0=unsexed; 1=male; 2=female.

LENGTH
NUMBER

The length of specimen in centimeters.

NPAIRS
NUMBER

The number of length frequency pairs.

AGE
NUMBER

The age of specimen in years.

NUMAGE
NUMBER

The number of specimens at a given age.

NO_LEN_MATCH
VARCHAR2

Flag indicating that there is no matching length record for the age record.

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: WOAGEyy
Short Name:	WOAGEyy
Status:	Completed
Abstract:	Commercial Fisheries Age Data for 1961, 1965 to 1993.
Notes:	Loaded by batch 8988, 07-11-2016 08:41

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	CFDBS
Description:	Commercial Fisheries Age Data for 1961, 1965 to 1993.

Attribute Summary

	Name	Type	Description
100	PORT	VARCHAR2	A combined code for state, port and county. The port in which the vessel landed the catch.
100	STATE	VARCHAR2	The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.
100	PORT2	VARCHAR2	The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
100	COUNTY	VARCHAR2	Name of county., ex.ESSEX.
100	YEAR	NUMBER	The year in which the landings or negative report occurred.
100	LINK	VARCHAR2	The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros.
100	MONTH	VARCHAR2	The month (01-12) of the vessel landing or negative dealer report. 00 = unknown.
100	DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15).
100	AREA	VARCHAR2	The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown.
100	NEMAREA	VARCHAR2	The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown.
100	SAMPAREA	VARCHAR2	The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.
100	NESPP4	VARCHAR2	The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123.
100	NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes.
100	QTR	VARCHAR2	The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
100	TONCLASS	VARCHAR2	The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table.
100	NEGEAR	VARCHAR2	Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X.
100	NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.
100	DEPTHCD	VARCHAR2	The depth to bottom, in fathoms, coded as follows: <br> 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; <br> 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. <br> When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null.
100	SAMPMETH	NUMBER	The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz.
100	CATDISP	NUMBER	Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept.
100	AGESTRCT	NUMBER	The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.
100	SEX	NUMBER	Sex code: 0=unsexed; 1=male; 2=female.
100	LENGTH	NUMBER	The length of specimen in centimeters.
100	NPAIRS	NUMBER	The number of length frequency pairs.
100	AGE	NUMBER	The age of specimen in years.
100	NUMAGE	NUMBER	The number of specimens at a given age.
100	NO_LEN_MATCH	VARCHAR2	Flag indicating that there is no matching length record for the age record.

Name

Type

Description

100

PORT

VARCHAR2

A combined code for state, port and county. The port in which the vessel landed the catch.

100

STATE

VARCHAR2

The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.

100

PORT2

VARCHAR2

The 3rd and 4th digit of the port code--meaningless without the rest of the port code.

100

COUNTY

VARCHAR2

Name of county., ex.ESSEX.

100

YEAR

NUMBER

The year in which the landings or negative report occurred.

100

LINK

VARCHAR2

100

MONTH

VARCHAR2

The month (01-12) of the vessel landing or negative dealer report. 00 = unknown.

100

DOCN

VARCHAR2

Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15).

100

AREA

VARCHAR2

100

NEMAREA

VARCHAR2

100

SAMPAREA

VARCHAR2

The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.

100

NESPP4

VARCHAR2

100

NESPP3

VARCHAR2

The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes.

100

QTR

VARCHAR2

The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.

100

TONCLASS

VARCHAR2

100

NEGEAR

VARCHAR2

100

NEGEAR2

VARCHAR2

First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.

100

DEPTHCD

VARCHAR2

100

SAMPMETH

NUMBER

100

CATDISP

NUMBER

Indicates if the catch from which the sample was taken was: 0=discarded, 1=kept.

100

AGESTRCT

NUMBER

The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.

100

SEX

NUMBER

Sex code: 0=unsexed; 1=male; 2=female.

100

LENGTH

NUMBER

The length of specimen in centimeters.

100

NPAIRS

NUMBER

The number of length frequency pairs.

100

AGE

NUMBER

The age of specimen in years.

100

NUMAGE

NUMBER

The number of specimens at a given age.

100

NO_LEN_MATCH

VARCHAR2

Flag indicating that there is no matching length record for the age record.

Attribute Details

PORT

CC ID: 332042

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	A combined code for state, port and county. The port in which the vessel landed the catch.
General Data Type:	VARCHAR2

STATE

CC ID: 332053

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The 2 digit numeric state code for the port of landing: <br> 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA.
General Data Type:	VARCHAR2

PORT2

CC ID: 332062

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	The 3rd and 4th digit of the port code--meaningless without the rest of the port code.
General Data Type:	VARCHAR2

COUNTY

CC ID: 332063

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of county., ex.ESSEX.
General Data Type:	VARCHAR2

YEAR

CC ID: 332064

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The year in which the landings or negative report occurred.
General Data Type:	NUMBER

LINK

CC ID: 332065

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros.
General Data Type:	VARCHAR2

MONTH

CC ID: 332066

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The month (01-12) of the vessel landing or negative dealer report. 00 = unknown.
General Data Type:	VARCHAR2

DOCN

CC ID: 332067

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15).
General Data Type:	VARCHAR2

AREA

CC ID: 332068

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown.
General Data Type:	VARCHAR2

NEMAREA

CC ID: 332043

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown.
General Data Type:	VARCHAR2

SAMPAREA

CC ID: 332044

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.
General Data Type:	VARCHAR2

NESPP4

CC ID: 332045

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123.
General Data Type:	VARCHAR2

NESPP3

CC ID: 332046

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes.
General Data Type:	VARCHAR2

QTR

CC ID: 332047

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The quarter of the calendar year in which weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
General Data Type:	VARCHAR2

TONCLASS

CC ID: 332048

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table.
General Data Type:	VARCHAR2

NEGEAR

CC ID: 332049

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X.
General Data Type:	VARCHAR2

NEGEAR2

CC ID: 332050

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes.
General Data Type:	VARCHAR2

DEPTHCD

CC ID: 332051

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The depth to bottom, in fathoms, coded as follows: <br> 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; <br> 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. <br> When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null.
General Data Type:	VARCHAR2

SAMPMETH

CC ID: 332052

Seq. Order:	19
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	The method used to sample the vessel's catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See "Manual for Sampling, Interviewing and Coding for the Northeast Region" by R.I. Schultz.
General Data Type:	NUMBER

CATDISP

CC ID: 332054

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Indicates if the catch from which the sample was taken was: <br> 0=discarded, 1=kept.
General Data Type:	NUMBER

AGESTRCT

CC ID: 332055

Seq. Order:	21
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.
General Data Type:	NUMBER

SEX

CC ID: 332056

Seq. Order:	22
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	1
Scale:	0
Status:	Active
Description:	Sex code: 0=unsexed; 1=male; 2=female.
General Data Type:	NUMBER

LENGTH

CC ID: 332057

Seq. Order:	23
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The length of specimen in centimeters.
General Data Type:	NUMBER

NPAIRS

CC ID: 332058

Seq. Order:	24
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The number of length frequency pairs.
General Data Type:	NUMBER

AGE

CC ID: 332059

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The age of specimen in years.
General Data Type:	NUMBER

NUMAGE

CC ID: 332060

Seq. Order:	26
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	The number of specimens at a given age.
General Data Type:	NUMBER

NO_LEN_MATCH

CC ID: 332061

Seq. Order:	27
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag indicating that there is no matching length record for the age record.
General Data Type:	VARCHAR2

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

View: WOAGEyy

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

PORT

STATE

PORT2

COUNTY

YEAR

LINK

MONTH

DOCN

AREA

NEMAREA

SAMPAREA

NESPP4

NESPP3

QTR

TONCLASS

NEGEAR

NEGEAR2

DEPTHCD

SAMPMETH

CATDISP

AGESTRCT

SEX

LENGTH

NPAIRS

AGE

NUMAGE

NO_LEN_MATCH

Catalog Details