Search Help Show/Hide Menu
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