Table: FLS_CATCHES

Southeast Fisheries Science Center
Entity (ENT) | ID: 7147 | Published / External
Created: 2008-02-28   |   Last Modified: 2021-05-06

Parent: Coastal Logbook Survey (Vessels)
Data Set (DS) | ID: 7144

ID: 7147
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title Table: FLS_CATCHES
Short Name FLS_CATCHES
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract

Table Indcating What Catch That Took Place On a Trip
* Purpose

Primary data table holding catch information
Notes

Loaded by batch 2103, 02-28-2008 14:10
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
None Species
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data Table
Active Version? Y
Alias  
Schema Name FLS
» Description

Table Indcating What Catch That Took Place On a Trip
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 Yes Yes CATCH_KEY NUMBER Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.
100 No No SPECIES_CODE_QUALIFIER VARCHAR2 Significant in the Pelagic Logbook only, it identifies the SHARK OTHER code as Pelagic when appropriate.Validation:None.The column is not mandatory and may be left empty.
100 Yes No SPECIES_CODE_NMFS VARCHAR2 Four digit NMFS code that identifies each species.
100 No No TOTAL_WHOLE_POUNDS NUMBER Total Whole (Round) Weight in Pounds to the nearest tenth of a pound. The value for this field is derived from the table FLS_CATCH_DESCRIPTIONS and it is the sum of all of the pounds for the corresponding rows in that table reported as whole pounds plus the gutted pounds converted to whole weight. The conversion factors are stored in the table FLS_SPECIES_RANGES.This process is necessary because the fishers may report the catch for the same species in both Gutted and Whole pounds.Validation:Information in this column or field must be numeric. The maximum and minimum value in this column are checked against data in the FLS_SPECIES_RANGES table and are provided by species. Each species may have a different value.
100 No No AREA_FISHED NUMBER Grid number that represents a body of water were fishing occurred.Validation:The code must be numeric and less than 4 digits long.This column is validated against FLS_AREA_FISHED_BY_STATE, which requires that the state code be obtained from the FLS_INT_LOCATIONS table where the Location Type is 'Landing Location' A foreign key could not be used because there is no state code in the catches table.This column is also mandatory, which means that it cannot be left empty.
100 Yes No GEAR_FISHED_KEY NUMBER A link to the Gear Fished table. This key establishes the relationship between the gear that was used during the fishing trip and the catch that was made using this gear. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the gear table before it can be used in the catch record. In other words, a gear must have been described before it can be associated with catch informatin.
100 No No PRICE_PER_POUND NUMBER Price Per Pound
100 No No VALUE NUMBER Value
100 No No SIZE_CODE VARCHAR2 Size Code/Market Category (A coded item)
100 No No DEPTH NUMBER Depth Fish was Caught

Attribute Details

Attribute Name CATCH_KEY
Seq. Order 1
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key Yes
Precision 10
Scale 0
Status Active
Description

Sequence number automatically generated by the system to uniquely identify each row in the table. Since these keys are not data dependent, if any element of data is changed, the link to the other tables in the system are not broken.Validation:Managed by the database. Each row in the table must have a unique value.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES_CODE_QUALIFIER
Seq. Order 2
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Significant in the Pelagic Logbook only, it identifies the SHARK OTHER code as Pelagic when appropriate.Validation:None.The column is not mandatory and may be left empty.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES_CODE_NMFS
Seq. Order 3
Data Storage Type VARCHAR2
Max Length 4
Min Length  
Required Yes
Primary Key No
Precision  
Scale  
Status Active
Description

Four digit NMFS code that identifies each species.
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOTAL_WHOLE_POUNDS
Seq. Order 4
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 10
Scale 1
Status Active
Description

Total Whole (Round) Weight in Pounds to the nearest tenth of a pound. The value for this field is derived from the table FLS_CATCH_DESCRIPTIONS and it is the sum of all of the pounds for the corresponding rows in that table reported as whole pounds plus the gutted pounds converted to whole weight. The conversion factors are stored in the table FLS_SPECIES_RANGES.This process is necessary because the fishers may report the catch for the same species in both Gutted and Whole pounds.Validation:Information in this column or field must be numeric. The maximum and minimum value in this column are checked against data in the FLS_SPECIES_RANGES table and are provided by species. Each species may have a different value.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name AREA_FISHED
Seq. Order 5
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 4
Scale 0
Status Active
Description

Grid number that represents a body of water were fishing occurred.Validation:The code must be numeric and less than 4 digits long.This column is validated against FLS_AREA_FISHED_BY_STATE, which requires that the state code be obtained from the FLS_INT_LOCATIONS table where the Location Type is 'Landing Location' A foreign key could not be used because there is no state code in the catches table.This column is also mandatory, which means that it cannot be left empty.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name GEAR_FISHED_KEY
Seq. Order 6
Data Storage Type NUMBER
Max Length 22
Min Length  
Required Yes
Primary Key No
Precision 10
Scale 0
Status Active
Description

A link to the Gear Fished table. This key establishes the relationship between the gear that was used during the fishing trip and the catch that was made using this gear. This key is used internally by the forms or screens and reports used to manipulate the data. It should not be necessary for the user to be familiar with this link.Validation:The foreign key enforces that the referenced record must be present in the gear table before it can be used in the catch record. In other words, a gear must have been described before it can be associated with catch informatin.
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PRICE_PER_POUND
Seq. Order 7
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 5
Scale 2
Status Active
Description

Price Per Pound
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name VALUE
Seq. Order 8
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 6
Scale 2
Status Active
Description

Value
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_CODE
Seq. Order 9
Data Storage Type VARCHAR2
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Size Code/Market Category (A coded item)
General Data Type VARCHAR2
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DEPTH
Seq. Order 10
Data Storage Type NUMBER
Max Length 22
Min Length  
Required No
Primary Key No
Precision 5
Scale 0
Status Active
Description

Depth Fish was Caught
General Data Type NUMBER
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 7147
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 Workflow State Published / External
Metadata Last Review Date  
Metadata Review Frequency 1 Year
Metadata Next Review Date  
Tags