Slide Menu
Search Help Show/Hide Menu

Item Identification

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

Stores outlier values for numbers and pounds by species, as well as conversion factors for converting gutted weights to whole weight

Notes:

Loaded by batch 2103, 02-28-2008 14:10

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None conversion table
None gutted weight
None range check
None species table
None whole weight

Entity Information

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

Stores outlier values for numbers and pounds by species, as well as conversion factors for converting gutted weights to whole weight

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key SPECIES_CODE_NMFS VARCHAR2 Four digit NMFS code that identifies each species.
100
Primary Key DISPOSITION_STATUS VARCHAR2 Indicates how the catch was disposed of, whether kept dead, discarded dead or alive, etc.Validation:The domain DISPOSITION_STATUS ensures that only the codes defined are allowed into the database.
100
CONVERSION_FACTOR NUMBER A number by which the pounds reported can be converted to obtain weight in a different weight type. For example, weight reported in gutted pounds can be multiplied by this number to obtain the equivalent whole pounds.The conversion factors are supplied by the RMD.Validation:The information in this column must be numeric.
100
CONVERSION_FACTOR_TYPE NUMBER Indicates whether the conversion is from gutted weight to whole, whole to gutted, etc.Validation:None.
100
MAXIMUM_NUMBER NUMBER Maximum number of individuals that can be caught of a specific species.Validation:Information in this column must be numeric. The column is optional.
100
MAXIMUM_TOTAL_WHOLE_WEIGHT NUMBER Maximum whole weight of this species that can be caught or discarded.Validation:The information in this column must be numeric.
100
MAXIMUM_TOTAL_GUTTED_WEIGHT NUMBER Maximum weight that can be caught of this species, when reported in gutted pounds.Validation:The information in this column must be numeric.
100
GROUP_NAME VARCHAR2 Name of a category under which certain species can be grouped. For example, in a report we may be interested in sharks, regardless of the species. Then tiger shark, bull shark, silky sharks, etc. would all be grouped under 'shark.'Validation:None.
100
ENABLED VARCHAR2 Indicates whether the code is currently used for validation.Validation:Validated through a domain called YES_NO, which allows only Yes and No as values. Since the column is not mandatory, null is also a valid entry.(Note: the use of the domain was not implemented as of January 28, 1999)
100
OTHER_VALIDATION LONG Indicates the type of data validated. Possible values TRIP, SETTRIP, SETSET, NOFISH.Validation: None.
100
Primary Key DATA_TYPE VARCHAR2 Other validation that has to be performed programmatically. For reference only.

Attribute Details

SPECIES_CODE_NMFS

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

Four digit NMFS code that identifies each species.

General Data Type: VARCHAR2

DISPOSITION_STATUS

CC ID: 27349
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: Yes
Status: Active
Description:

Indicates how the catch was disposed of, whether kept dead, discarded dead or alive, etc.Validation:The domain DISPOSITION_STATUS ensures that only the codes defined are allowed into the database.

General Data Type: VARCHAR2

CONVERSION_FACTOR

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

A number by which the pounds reported can be converted to obtain weight in a different weight type. For example, weight reported in gutted pounds can be multiplied by this number to obtain the equivalent whole pounds.The conversion factors are supplied by the RMD.Validation:The information in this column must be numeric.

General Data Type: NUMBER

CONVERSION_FACTOR_TYPE

CC ID: 27351
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 12
Scale: 6
Status: Active
Description:

Indicates whether the conversion is from gutted weight to whole, whole to gutted, etc.Validation:None.

General Data Type: NUMBER

MAXIMUM_NUMBER

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

Maximum number of individuals that can be caught of a specific species.Validation:Information in this column must be numeric. The column is optional.

General Data Type: NUMBER

MAXIMUM_TOTAL_WHOLE_WEIGHT

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

Maximum whole weight of this species that can be caught or discarded.Validation:The information in this column must be numeric.

General Data Type: NUMBER

MAXIMUM_TOTAL_GUTTED_WEIGHT

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

Maximum weight that can be caught of this species, when reported in gutted pounds.Validation:The information in this column must be numeric.

General Data Type: NUMBER

GROUP_NAME

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

Name of a category under which certain species can be grouped. For example, in a report we may be interested in sharks, regardless of the species. Then tiger shark, bull shark, silky sharks, etc. would all be grouped under 'shark.'Validation:None.

General Data Type: VARCHAR2

ENABLED

CC ID: 27356
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates whether the code is currently used for validation.Validation:Validated through a domain called YES_NO, which allows only Yes and No as values. Since the column is not mandatory, null is also a valid entry.(Note: the use of the domain was not implemented as of January 28, 1999)

General Data Type: VARCHAR2

OTHER_VALIDATION

CC ID: 27358
Seq. Order: 10
Data Storage Type: LONG
Required: No
Primary Key: No
Status: Active
Description:

Indicates the type of data validated. Possible values TRIP, SETTRIP, SETSET, NOFISH.Validation: None.

General Data Type: LONG

DATA_TYPE

CC ID: 27357
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 10
Required: Yes
Primary Key: Yes
Status: Active
Description:

Other validation that has to be performed programmatically. For reference only.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7170
GUID: gov.noaa.nmfs.inport:7170
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-02-28 14:10+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