Table: PDC_SPECIES_RANGES
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:5429 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
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.
DescriptionTable 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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 |