Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > Puerto Rico Commercial Landings Statistics 1983... >

Table: PR_SPECIES_ERDMAN_ITIS_XREF

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:29956 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.

Description

Entity Type
Data Table

Data Attribute / Type	Description
ERDMAN_CODE VARCHAR2	This is the primary index based on species coding (Erdman 1987).
ERDMAN_COMMON_NAME VARCHAR2	The species or species group common name (Erdman 1987)
ERDMAN_SCIENTIFIC_NAME VARCHAR2	The species or species group scientific name (Erdman 1987).
SPECIES_ITIS VARCHAR2	The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
ITIS_COMMON_NAME VARCHAR2	The ITIS common name for the species or species group. This is the standard common name.
ITIS_SCIENTIFIC_NAME VARCHAR2	The scientific name for species or species group.
GENUS_ITIS VARCHAR2	The standard ITIS code for the genus. Is null if species group classed higher than genus.
GENUS_NAME VARCHAR2	The scientific name for the genus. Is null if initial species group classed higher than genus.
FAMILY_ITIS VARCHAR2	The standard ITIS code for family. Is null if initial species group is classed higher than family
FAMILY_NAME VARCHAR2	The scientific name for the family. Is null if species group initially classed higher than family.
ORDER_ITIS VARCHAR2	The standard ITIS code for order. Is null if species or species group initally classed higher than order.
ORDER_NAME VARCHAR2	The scientific name for the order. Is null if species group initially classed higher than order.
NMFS_CODE VARCHAR2	The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.
NMFS_COMMON_NAME VARCHAR2	The NMFS common name for the species or species group.
FMU VARCHAR2	The Caribbean Fishery Management Unit for the species or species group.
FAMILY VARCHAR2	The common family name for species or species group.
T_LEVEL VARCHAR2	The first initial for the taxonomic level of the species or species group.
ACL_UNIT VARCHAR2	The current ACL (Allowable Catch Level) unit for the species or species group.
ACL_YEAR VARCHAR2	The year that the ACL was established.
SERO_SAS_COMMON_NAME VARCHAR2	The common name for the species or species goup as extracted by the NOAA-SERO.
SERO_SAS_ACL_UNIT VARCHAR2	The name for the original NOAA-SERO ACL Unit for the species or species group.
FISHERY_TYPE VARCHAR2	The general fishery type for the species or species group.

Data Attribute / Type

Description

ERDMAN_CODE
VARCHAR2

This is the primary index based on species coding (Erdman 1987).

ERDMAN_COMMON_NAME
VARCHAR2

The species or species group common name (Erdman 1987)

ERDMAN_SCIENTIFIC_NAME
VARCHAR2

The species or species group scientific name (Erdman 1987).

SPECIES_ITIS
VARCHAR2

The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.

ITIS_COMMON_NAME
VARCHAR2

The ITIS common name for the species or species group. This is the standard common name.

ITIS_SCIENTIFIC_NAME
VARCHAR2

The scientific name for species or species group.

GENUS_ITIS
VARCHAR2

The standard ITIS code for the genus. Is null if species group classed higher than genus.

GENUS_NAME
VARCHAR2

The scientific name for the genus. Is null if initial species group classed higher than genus.

FAMILY_ITIS
VARCHAR2

The standard ITIS code for family. Is null if initial species group is classed higher than family

FAMILY_NAME
VARCHAR2

The scientific name for the family. Is null if species group initially classed higher than family.

ORDER_ITIS
VARCHAR2

The standard ITIS code for order. Is null if species or species group initally classed higher than order.

ORDER_NAME
VARCHAR2

The scientific name for the order. Is null if species group initially classed higher than order.

NMFS_CODE
VARCHAR2

The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.

NMFS_COMMON_NAME
VARCHAR2

The NMFS common name for the species or species group.

FMU
VARCHAR2

The Caribbean Fishery Management Unit for the species or species group.

FAMILY
VARCHAR2

The common family name for species or species group.

T_LEVEL
VARCHAR2

The first initial for the taxonomic level of the species or species group.

ACL_UNIT
VARCHAR2

The current ACL (Allowable Catch Level) unit for the species or species group.

ACL_YEAR
VARCHAR2

The year that the ACL was established.

SERO_SAS_COMMON_NAME
VARCHAR2

The common name for the species or species goup as extracted by the NOAA-SERO.

SERO_SAS_ACL_UNIT
VARCHAR2

The name for the original NOAA-SERO ACL Unit for the species or species group.

FISHERY_TYPE
VARCHAR2

The general fishery type for the species or species group.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Title:	Table: PR_SPECIES_ERDMAN_ITIS_XREF
Short Name:	PR_SPECIES_ERDMAN_ITIS_XREF
Status:	Completed
Abstract:	This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.
Notes:	Loaded by batch 7906, 12-22-2015 14:11

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	ALS
Description:	This is the primary species or species group lookup table for Puerto Rico commercial landings data. It uses the code developed by Erdman (1987) as its primary key. Table cross-reference ITIS coding at various taxonomic levels as well as NMFS coding and Caribbean ACL Unit.

Attribute Summary

	Name	Type	Description
100	ERDMAN_CODE	VARCHAR2	This is the primary index based on species coding (Erdman 1987).
100	ERDMAN_COMMON_NAME	VARCHAR2	The species or species group common name (Erdman 1987)
100	ERDMAN_SCIENTIFIC_NAME	VARCHAR2	The species or species group scientific name (Erdman 1987).
100	SPECIES_ITIS	VARCHAR2	The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
100	ITIS_COMMON_NAME	VARCHAR2	The ITIS common name for the species or species group. This is the standard common name.
100	ITIS_SCIENTIFIC_NAME	VARCHAR2	The scientific name for species or species group.
100	GENUS_ITIS	VARCHAR2	The standard ITIS code for the genus. Is null if species group classed higher than genus.
100	GENUS_NAME	VARCHAR2	The scientific name for the genus. Is null if initial species group classed higher than genus.
100	FAMILY_ITIS	VARCHAR2	The standard ITIS code for family. Is null if initial species group is classed higher than family
100	FAMILY_NAME	VARCHAR2	The scientific name for the family. Is null if species group initially classed higher than family.
100	ORDER_ITIS	VARCHAR2	The standard ITIS code for order. Is null if species or species group initally classed higher than order.
100	ORDER_NAME	VARCHAR2	The scientific name for the order. Is null if species group initially classed higher than order.
100	NMFS_CODE	VARCHAR2	The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.
100	NMFS_COMMON_NAME	VARCHAR2	The NMFS common name for the species or species group.
100	FMU	VARCHAR2	The Caribbean Fishery Management Unit for the species or species group.
100	FAMILY	VARCHAR2	The common family name for species or species group.
100	T_LEVEL	VARCHAR2	The first initial for the taxonomic level of the species or species group.
100	ACL_UNIT	VARCHAR2	The current ACL (Allowable Catch Level) unit for the species or species group.
100	ACL_YEAR	VARCHAR2	The year that the ACL was established.
100	SERO_SAS_COMMON_NAME	VARCHAR2	The common name for the species or species goup as extracted by the NOAA-SERO.
100	SERO_SAS_ACL_UNIT	VARCHAR2	The name for the original NOAA-SERO ACL Unit for the species or species group.
100	FISHERY_TYPE	VARCHAR2	The general fishery type for the species or species group.

Name

Type

Description

100

ERDMAN_CODE

VARCHAR2

This is the primary index based on species coding (Erdman 1987).

100

ERDMAN_COMMON_NAME

VARCHAR2

The species or species group common name (Erdman 1987)

100

ERDMAN_SCIENTIFIC_NAME

VARCHAR2

The species or species group scientific name (Erdman 1987).

100

SPECIES_ITIS

VARCHAR2

The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.

100

ITIS_COMMON_NAME

VARCHAR2

The ITIS common name for the species or species group. This is the standard common name.

100

ITIS_SCIENTIFIC_NAME

VARCHAR2

The scientific name for species or species group.

100

GENUS_ITIS

VARCHAR2

The standard ITIS code for the genus. Is null if species group classed higher than genus.

100

GENUS_NAME

VARCHAR2

The scientific name for the genus. Is null if initial species group classed higher than genus.

100

FAMILY_ITIS

VARCHAR2

The standard ITIS code for family. Is null if initial species group is classed higher than family

100

FAMILY_NAME

VARCHAR2

The scientific name for the family. Is null if species group initially classed higher than family.

100

ORDER_ITIS

VARCHAR2

The standard ITIS code for order. Is null if species or species group initally classed higher than order.

100

ORDER_NAME

VARCHAR2

The scientific name for the order. Is null if species group initially classed higher than order.

100

NMFS_CODE

VARCHAR2

The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.

100

NMFS_COMMON_NAME

VARCHAR2

The NMFS common name for the species or species group.

100

FMU

VARCHAR2

The Caribbean Fishery Management Unit for the species or species group.

100

FAMILY

VARCHAR2

The common family name for species or species group.

100

T_LEVEL

VARCHAR2

The first initial for the taxonomic level of the species or species group.

100

ACL_UNIT

VARCHAR2

The current ACL (Allowable Catch Level) unit for the species or species group.

100

ACL_YEAR

VARCHAR2

The year that the ACL was established.

100

SERO_SAS_COMMON_NAME

VARCHAR2

The common name for the species or species goup as extracted by the NOAA-SERO.

100

SERO_SAS_ACL_UNIT

VARCHAR2

The name for the original NOAA-SERO ACL Unit for the species or species group.

100

FISHERY_TYPE

VARCHAR2

The general fishery type for the species or species group.

Attribute Details

ERDMAN_CODE

CC ID: 267307

Seq. Order:	1
Data Storage Type:	VARCHAR2
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	This is the primary index based on species coding (Erdman 1987).
General Data Type:	VARCHAR2

ERDMAN_COMMON_NAME

CC ID: 267318

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	The species or species group common name (Erdman 1987)
General Data Type:	VARCHAR2

ERDMAN_SCIENTIFIC_NAME

CC ID: 267322

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	28
Required:	No
Primary Key:	No
Status:	Active
Description:	The species or species group scientific name (Erdman 1987).
General Data Type:	VARCHAR2

SPECIES_ITIS

CC ID: 267323

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The International Taxonomic Information System (ITIS) code for the species or species group. This is the standard code.
General Data Type:	VARCHAR2

ITIS_COMMON_NAME

CC ID: 267324

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	28
Required:	No
Primary Key:	No
Status:	Active
Description:	The ITIS common name for the species or species group. This is the standard common name.
General Data Type:	VARCHAR2

ITIS_SCIENTIFIC_NAME

CC ID: 267325

Seq. Order:	6
Data Storage Type:	VARCHAR2
Max Length:	28
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name for species or species group.
General Data Type:	VARCHAR2

GENUS_ITIS

CC ID: 267326

Seq. Order:	7
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The standard ITIS code for the genus. Is null if species group classed higher than genus.
General Data Type:	VARCHAR2

GENUS_NAME

CC ID: 267327

Seq. Order:	8
Data Storage Type:	VARCHAR2
Max Length:	17
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name for the genus. Is null if initial species group classed higher than genus.
General Data Type:	VARCHAR2

FAMILY_ITIS

CC ID: 267328

Seq. Order:	9
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The standard ITIS code for family. Is null if initial species group is classed higher than family
General Data Type:	VARCHAR2

FAMILY_NAME

CC ID: 267308

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name for the family. Is null if species group initially classed higher than family.
General Data Type:	VARCHAR2

ORDER_ITIS

CC ID: 267309

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	6
Required:	No
Primary Key:	No
Status:	Active
Description:	The standard ITIS code for order. Is null if species or species group initally classed higher than order.
General Data Type:	VARCHAR2

ORDER_NAME

CC ID: 267310

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	18
Required:	No
Primary Key:	No
Status:	Active
Description:	The scientific name for the order. Is null if species group initially classed higher than order.
General Data Type:	VARCHAR2

NMFS_CODE

CC ID: 267311

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The National Marine Fisheries (NMFS) code for the species or species group. The NMFS codes are replaced by the ITIS system as the coding standard for NOAA.
General Data Type:	VARCHAR2

NMFS_COMMON_NAME

CC ID: 267312

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	33
Required:	No
Primary Key:	No
Status:	Active
Description:	The NMFS common name for the species or species group.
General Data Type:	VARCHAR2

FMU

CC ID: 267313

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	14
Required:	No
Primary Key:	No
Status:	Active
Description:	The Caribbean Fishery Management Unit for the species or species group.
General Data Type:	VARCHAR2

FAMILY

CC ID: 267314

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The common family name for species or species group.
General Data Type:	VARCHAR2

T_LEVEL

CC ID: 267315

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	The first initial for the taxonomic level of the species or species group.
General Data Type:	VARCHAR2

ACL_UNIT

CC ID: 267316

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	28
Required:	No
Primary Key:	No
Status:	Active
Description:	The current ACL (Allowable Catch Level) unit for the species or species group.
General Data Type:	VARCHAR2

ACL_YEAR

CC ID: 267317

Seq. Order:	19
Data Storage Type:	VARCHAR2
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	The year that the ACL was established.
General Data Type:	VARCHAR2

SERO_SAS_COMMON_NAME

CC ID: 267319

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	26
Required:	No
Primary Key:	No
Status:	Active
Description:	The common name for the species or species goup as extracted by the NOAA-SERO.
General Data Type:	VARCHAR2

SERO_SAS_ACL_UNIT

CC ID: 267320

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	The name for the original NOAA-SERO ACL Unit for the species or species group.
General Data Type:	VARCHAR2

FISHERY_TYPE

CC ID: 267321

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	24
Required:	No
Primary Key:	No
Status:	Active
Description:	The general fishery type for the species or species group.
General Data Type:	VARCHAR2

Catalog Item ID:	29956
GUID:	gov.noaa.nmfs.inport:29956
Metadata Record Created By:	Joshua Bennett
Metadata Record Created:	2015-12-22 14:11+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-05-06
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-06
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-06

Table: PR_SPECIES_ERDMAN_ITIS_XREF

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ERDMAN_CODE

ERDMAN_COMMON_NAME

ERDMAN_SCIENTIFIC_NAME

SPECIES_ITIS

ITIS_COMMON_NAME

ITIS_SCIENTIFIC_NAME

GENUS_ITIS

GENUS_NAME

FAMILY_ITIS

FAMILY_NAME

ORDER_ITIS

ORDER_NAME

NMFS_CODE

NMFS_COMMON_NAME

FMU

FAMILY

T_LEVEL

ACL_UNIT

ACL_YEAR

SERO_SAS_COMMON_NAME

SERO_SAS_ACL_UNIT

FISHERY_TYPE

Catalog Details