Slide Menu
Search Help Show/Hide Menu

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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 Details

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07