Metadata Rubric

100%

6 / 6

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

Table: AREA

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

Item Identification

Title:	Table: AREA
Short Name:	AREA
Status:	Completed
Abstract:	Commercial Fisheries Area Support Table.
Notes:	Loaded by batch 8988, 07-11-2016 08:41

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CFDBS
Description:	Commercial Fisheries Area Support Table.

Data Attributes

Attribute Summary

	Name	Type	Description
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	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	REGION	VARCHAR2	NMFS Region code: 0=Mississippi River; 1=New England; 2=Mid-Atlantic; 3=Chesapeake Bay; 4=South Atlantic; 5=Gulf of Mexico; 6=Pacific; 7=Great Lakes; 8= Hawaii.
100	STATECD	VARCHAR2	The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).
100	WATERCD	VARCHAR2	NMFS Water Body code.
100	AREANM	VARCHAR2	Descriptive name for area.
100	NAFODIV	VARCHAR2	The alpha NAFO Division code.
100	NAFDVCD	VARCHAR2	The numeric Northwest Atlantic Fisheries Organization (NAFO) Division code.
100	DOC	DATE	The date of the last change to this record.
100	COMMENTS	VARCHAR2	Comments related to associated record.
100	LISTCOL	VARCHAR2	Abbreviated Description Used for Select Lists

Name

Type

Description

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

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

REGION

VARCHAR2

NMFS Region code: 0=Mississippi River; 1=New England; 2=Mid-Atlantic; 3=Chesapeake Bay; 4=South Atlantic; 5=Gulf of Mexico; 6=Pacific; 7=Great Lakes; 8= Hawaii.

100

STATECD

VARCHAR2

The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).

100

WATERCD

VARCHAR2

NMFS Water Body code.

100

AREANM

VARCHAR2

Descriptive name for area.

100

NAFODIV

VARCHAR2

The alpha NAFO Division code.

100

NAFDVCD

VARCHAR2

The numeric Northwest Atlantic Fisheries Organization (NAFO) Division code.

100

DOC

DATE

The date of the last change to this record.

100

COMMENTS

VARCHAR2

Comments related to associated record.

100

LISTCOL

VARCHAR2

Abbreviated Description Used for Select Lists

Attribute Details

NEMAREA

CC ID: 331905

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

AREA

CC ID: 331908

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

REGION

CC ID: 331909

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS Region code: 0=Mississippi River; 1=New England; 2=Mid-Atlantic; 3=Chesapeake Bay; 4=South Atlantic; 5=Gulf of Mexico; 6=Pacific; 7=Great Lakes; 8= Hawaii.
General Data Type:	VARCHAR2

STATECD

CC ID: 331910

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown).
General Data Type:	VARCHAR2

WATERCD

CC ID: 331911

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	NMFS Water Body code.
General Data Type:	VARCHAR2

AREANM

CC ID: 331912

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	Descriptive name for area.
General Data Type:	VARCHAR2

NAFODIV

CC ID: 331913

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	The alpha NAFO Division code.
General Data Type:	VARCHAR2

NAFDVCD

CC ID: 331914

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	The numeric Northwest Atlantic Fisheries Organization (NAFO) Division code.
General Data Type:	VARCHAR2

DOC

CC ID: 331915

Seq. Order:	9
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date of the last change to this record.
General Data Type:	DATE

COMMENTS

CC ID: 331906

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	160
Required:	No
Primary Key:	No
Status:	Active
Description:	Comments related to associated record.
General Data Type:	VARCHAR2

LISTCOL

CC ID: 331907

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Abbreviated Description Used for Select Lists
General Data Type:	VARCHAR2

Catalog Details

Catalog Item ID:	33429
GUID:	gov.noaa.nmfs.inport:33429
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-11
Owner Org:	NEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2016-07-11
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2017-07-11