Table: FLS_GEARS_FISHED
Southeast Fisheries Science Center
Entity
(ENT)
| ID: 6869
| Published / External
Created: 2007-12-20
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 6802
ID: 6869
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: FLS_GEARS_FISHED |
---|---|
Short Name | FLS_GEARS_FISHED |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Contains Gear Information Per fishing Activity Record |
* Purpose | |
Notes |
Loaded by batch 2043, 12-20-2007 08: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 |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Southeast Fisheries Science Center |
---|---|
• » City | Miami |
• » State/Province | FL |
• Country | USA |
• » Location Description |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | FLS |
» Description |
Contains Gear Information Per fishing Activity Record |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | FISHING_ACTIVITY_KEY | NUMBER | A link to the FLS_FISHING_ACTIVITIES table. This key establishes the relationship between the gear that was used during the fishing trip and the fishing activity during which this gear was used. 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 Fishing Activities table before it can be used in the Gears Fished table. In other words, a Fishing Activity must have been described before it can be associated with Gear Fished information. |
100 | Yes | Yes | 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 | Yes | No | GEAR_CODE_NMFS | VARCHAR2 | A code that represents the gear fished.Validation:A foreign key on the GEAR_CODE_NMFS column ensures that only valid NMFS codes are entered and that when a new Snapper/Grouper-Gulf Reef codes is entered the gear already exists in the FLS_GEAR_CODES_NMFS table.This column is not optional and cannot be left empty. |
100 | No | No | GEAR_QUANTITY | NUMBER | How many units of the specified gear were fished. Each of the gears is described in the table FLS_INT_GEAR_DESCRIPTIONS.Validation: Information in this column must be numeric and up to 4 digits long. |
100 | Yes | No | GEAR_QUALIFIER | VARCHAR2 | What The units are of the specified gear |
Attribute Details
Attribute Name | FISHING_ACTIVITY_KEY |
---|---|
Seq. Order | 1 |
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 FLS_FISHING_ACTIVITIES table. This key establishes the relationship between the gear that was used during the fishing trip and the fishing activity during which this gear was used. 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 Fishing Activities table before it can be used in the Gears Fished table. In other words, a Fishing Activity must have been described before it can be associated with Gear Fished information. |
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 | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
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 | GEAR_CODE_NMFS |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code that represents the gear fished.Validation:A foreign key on the GEAR_CODE_NMFS column ensures that only valid NMFS codes are entered and that when a new Snapper/Grouper-Gulf Reef codes is entered the gear already exists in the FLS_GEAR_CODES_NMFS table.This column is not optional and cannot 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 | GEAR_QUANTITY |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
How many units of the specified gear were fished. Each of the gears is described in the table FLS_INT_GEAR_DESCRIPTIONS.Validation: Information in this column must be numeric and up to 4 digits long. |
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_QUALIFIER |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
What The units are of the specified gear |
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 | |
---|---|
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
* » 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 | 6869 |
---|---|
Metadata Record Created By | Lee M Weinberger |
Metadata Record Created | 2007-12-20 08:10+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:10+0000 |
Metadata Record Published | 2021-05-07 |
Owner Org | SEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-05-07 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-05-07 |
Tags |
---|