Metadata Rubric

100%

6 / 6

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

View: CFAGEyyyy

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Commercial Fisheries Age Data from 1994 to date.

Description

Commercial Fisheries Age Data from 1994 to date.

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 VARCHAR2	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.
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.
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.
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 VARCHAR2	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 VARCHAR2	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: <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
VARCHAR2

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.

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.

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.

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
VARCHAR2

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
VARCHAR2

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: CFAGEyyyy
Short Name:	CFAGEyyyy
Status:	Completed
Abstract:	Commercial Fisheries Age Data from 1994 to date.
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 from 1994 to date.

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

VARCHAR2

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

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

NEGEAR

VARCHAR2

100

NEGEAR2

VARCHAR2

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

100

SAMPMETH

NUMBER

100

CATDISP

VARCHAR2

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

VARCHAR2

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

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

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	2
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: 331933

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	2
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: 331934

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

YEAR

CC ID: 331935

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

LINK

CC ID: 331936

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	8
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: 331937

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

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	6
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: 331939

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

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

NESPP4

CC ID: 331918

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

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	3
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: 331920

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

NEGEAR

CC ID: 331921

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

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

SAMPMETH

CC ID: 331923

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

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

AGESTRCT

CC ID: 331925

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

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

LENGTH

CC ID: 331928

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

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

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

NUMAGE

CC ID: 331931

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

Seq. Order:	24
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:	33430
GUID:	gov.noaa.nmfs.inport:33430
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: CFAGEyyyy

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

NESPP4

NESPP3

QTR

NEGEAR

NEGEAR2

SAMPMETH

CATDISP

AGESTRCT

SEX

LENGTH

NPAIRS

AGE

NUMAGE

NO_LEN_MATCH

Catalog Details