Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

Title: Table: PDC_SPECIES_RANGES
Short Name: PDC_SPECIES_RANGES
Status: Completed
Abstract:

Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring.

Notes:

Loaded by batch 1703, 10-15-2007 10:13

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: FLS
Description:

Table used for range checking of reported landings of species. The Group_name , sub_group, and category columns are also used for allow flexible summary and grouping for reports to Headquaters (HMS) on quota monitoring.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_CODE_NMFS VARCHAR2 NMFS 4 digit species code
100
COMMON_NAME VARCHAR2 Common Name Associated With The Species Code
100
MAXIMUM_TOTAL_WHOLE_WEIGHT NUMBER Maximum Whole Weight Reported To Trigger an error.inquiry
100
GROUP_NAME VARCHAR2 Which Group To Be Used in Reporting Data to HMS for quota monitoring
100
SUB_GROUP VARCHAR2 Which Sub-Group To Be Used in Reporting Data to HMS for quota monitoring
100
CATEGORY VARCHAR2 Which Category To Be Used in Reporting Data to HMS for quota monitoring

Attribute Details

SPECIES_CODE_NMFS

CC ID: 17061
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: Yes
Status: Active
Description:

NMFS 4 digit species code

General Data Type: VARCHAR2

COMMON_NAME

CC ID: 17060
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Common Name Associated With The Species Code

General Data Type: VARCHAR2

MAXIMUM_TOTAL_WHOLE_WEIGHT

CC ID: 17059
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 5
Scale: 0
Status: Active
Description:

Maximum Whole Weight Reported To Trigger an error.inquiry

General Data Type: NUMBER

GROUP_NAME

CC ID: 17058
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Which Group To Be Used in Reporting Data to HMS for quota monitoring

General Data Type: VARCHAR2

SUB_GROUP

CC ID: 17057
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Which Sub-Group To Be Used in Reporting Data to HMS for quota monitoring

General Data Type: VARCHAR2

CATEGORY

CC ID: 17056
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Which Category To Be Used in Reporting Data to HMS for quota monitoring

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 5429
GUID: gov.noaa.nmfs.inport:5429
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-10-15 10:13+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