Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Dealer Reporting > Pelagic Dealer Compliance > Pelagic Dealer Commercial Landings Monitoring (... >

Table: PDC_SPECIES_RANGES

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:5429  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

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: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+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