View: CFAGEyyyy

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

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.

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

Name of county., ex.ESSEX.

The year in which the landings or negative report occurred.

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.

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

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).

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.

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.

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.

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

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

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.

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

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.

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

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

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

The length of specimen in centimeters.

The number of length frequency pairs.

The age of specimen in years.

The number of specimens at a given age.

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