Table: CATCH
Greater Atlantic Regional Fisheries Office
Entity
(ENT)
| ID: 17031
| Published / External
Created: 2012-11-16
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 11489
ID: 17031
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: CATCH |
---|---|
Short Name | CATCH |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
The Catch Table contains the primary catch information by species as reported by the vessel operator. |
* Purpose |
To store the FVTR catch data including species, pounds kept, pounds discarded, dealer(s) the fish was sold to & the date it was sold. Linked with the Images table via IMGID. |
Notes |
Loaded by batch 3737, 11-16-2012 09:32 |
Other Citation Details |
This table is linked to the Images table using the key attribute "IMGID". |
• Supplemental Information |
Server: NERO; Schema: NOAA; Table: Catch |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | logbook |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | 1978-present |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | new england |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | commercial fishing |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Greater Atlantic Regional Fisheries Office |
---|---|
• » City | Gloucester |
• » State/Province | MA |
• Country | USA |
• » Location Description |
Fisheries Data Services Division (FDSD) 55 Great Republic Drive |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | NOAA |
» Description |
FVTR catch information |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | CATCH_ID | NUMBER | Internal primary key. Oracle generated sequence. |
100 | Yes | No | IMGID | NUMBER | FVTR image identification number. Link to IMAGES table. |
100 | Yes | No | SPECIES_ID | VARCHAR2 | Species name abbreviation. Link to VLSPPSYN table. |
100 | No | No | KEPT | NUMBER | Amount kept. Commercial = pounds; Party/Charter = count. |
100 | No | No | DISCARDED | NUMBER | Amount discarded. Commercial = pounds; Party/Charter = count. |
100 | No | No | DEALER_NUM | NUMBER | Federally issued dealer catch was sold to. Link to PERMIT.DEALER table. |
100 | No | No | DATE_SOLD | DATE | Date catch was sold. |
100 | No | No | PORT_LANDED | VARCHAR2 | Port(city) where catch was landed. |
100 | No | No | STATE_LANDED | VARCHAR2 | State where catch was landed. |
100 | No | No | PORT_NUMBER | VARCHAR2 | Port Number identifying the port name and state where catch was landed. |
100 | No | No | LEGACY_PORT | NUMBER | Defines the origin of port data for the catch. 0 = actual port data captured at the catch level. 1 = port data was derived from legacy data derived at the trip level from the document table. NULL indicates data is still undefined as no port value has been entered. |
100 | No | No | DE | DATE | Date record was loaded into table. |
100 | No | No | UE | VARCHAR2 | User loading data into table. |
100 | No | No | DC | DATE | Date of most recent update(s) to record. |
100 | No | No | UC | VARCHAR2 | User making most recent update(s) to record. |
100 | Yes | No | ORIGIN | VARCHAR2 | Identifies origin of a record as being entered from a paper VTR (CID origin) or an electronic VTR (FVTR) |
Attribute Details
Attribute Name | CATCH_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | 18 |
Scale | 0 |
Status | Active |
Description |
Internal primary key. Oracle generated sequence. |
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 | IMGID |
---|---|
Seq. Order | 2 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 16 |
Scale | 0 |
Status | Active |
Description |
FVTR image identification number. Link to IMAGES table. |
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_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species name abbreviation. Link to VLSPPSYN table. |
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 | KEPT |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 0 |
Status | Active |
Description |
Amount kept. Commercial = pounds; Party/Charter = count. |
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 | DISCARDED |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | 0 |
Status | Active |
Description |
Amount discarded. Commercial = pounds; Party/Charter = count. |
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 | DEALER_NUM |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 5 |
Scale | 0 |
Status | Active |
Description |
Federally issued dealer catch was sold to. Link to PERMIT.DEALER table. |
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 | DATE_SOLD |
---|---|
Seq. Order | 7 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date catch was sold. |
General Data Type | DATE |
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 | PORT_LANDED |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Port(city) where catch was landed. |
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 | STATE_LANDED |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State where catch was landed. |
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 | PORT_NUMBER |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Port Number identifying the port name and state where catch was landed. |
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 | LEGACY_PORT |
---|---|
Seq. Order | 11 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Defines the origin of port data for the catch. 0 = actual port data captured at the catch level. 1 = port data was derived from legacy data derived at the trip level from the document table. NULL indicates data is still undefined as no port value has been entered. |
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 | DE |
---|---|
Seq. Order | 12 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date record was loaded into table. |
General Data Type | DATE |
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 | UE |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User loading data into table. |
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 | DC |
---|---|
Seq. Order | 14 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of most recent update(s) to record. |
General Data Type | DATE |
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 | UC |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
User making most recent update(s) to record. |
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 | ORIGIN |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifies origin of a record as being entered from a paper VTR (CID origin) or an electronic VTR (FVTR) |
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 | Data Steward |
---|---|
* » Date Effective From | 2012-02-01 |
Date Effective To | |
Person | St Cyr, James R |
Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address | james.stcyr@noaa.gov |
Phone | 978-281-9369 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2012-02-01 |
Date Effective To | |
Person | St Cyr, James R |
Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address | james.stcyr@noaa.gov |
Phone | 978-281-9369 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Process Contact |
---|---|
* » Date Effective From | 2012-02-01 |
Date Effective To | |
Person | Brosnan, Bethany |
Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address | Bethany.Brosnan@Noaa.gov |
Phone | |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » 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 1
* » Time Frame Type | Continuing |
---|---|
* » Start | 2010-05-01 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Weekly reporting began for vessels issued Federal Northeast Multispecies permits. |
Extent Group 1 / Time Frame 2
* » Time Frame Type | Continuing |
---|---|
* » Start | 2011-06-30 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Vessels participating in the multispecies catch share program or in the cooperative reseach program may use Fisheries Logbook Data Recording Software (FLDRS) to submit electronic VTRs |
Extent Group 1 / Time Frame 3
* » Time Frame Type | Continuing |
---|---|
* » Start | 2011-09-28 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Weekly reporting began for vessels issued Federal Northeast Atlantic Herring permits. |
Extent Group 1 / Time Frame 4
* » Time Frame Type | Continuing |
---|---|
* » Start | 1978 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
Beginning in 1978, participation in the surf clam fishery became conditional upon a set of requirements including detailed logbook reporting. In the early 1980's ocean quahog vessels became subject to the same detailed logbook reporting requirements. |
Extent Group 1 / Time Frame 5
* » Time Frame Type | Continuing |
---|---|
* » Start | 1994 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
The FVTR data collection program was implemented in 1994, to monitor the geographic distribution of fishing effort and catches of federally regulated species in the region. All Northeast Region federally permitted vessels must submit a VTR for each trip taken regardless of where the trip took place or species targeted. The one exception to this is for vessels that are only permitted for American Lobster. Beginning May 1, 2010, any vessel issued a Federal Northeast Multispecies or Atlantic Herring permit must submit VTRs on a weekly basis. Weekly reports are due by midnight Tuesday for all trips taken during the previous week. All other vessels must submit their VTR?s on a monthly basis. Monthly reports are due by the 15th day of the month following the month in which the trip occurred. |
Access Information
* » Security Class | Confidential |
---|---|
* Security Classification System |
Vessel trip reports are considered to be business confidential and may not be released without signed approval of the permit holder on record for the time period requested. |
Security Handling Description | |
• Data Access Policy |
Access to VTR data is governed by 50CFR600 - Confidentiality of Information. Access by state fishery management agency staff and Fisheries Management Council staff may be allowed through Memorandum of Understanding that are signed by the NE Regional Administrator and Directors of the State Agency or Councils that describe the need and uses of the data and list the individuals who will have access to the data. Contractors may be granted access provided they are working under contract to NOAA or a cooperating partner (state, Council, Commission) on a specific project under the oversight of a partner. |
» Data Access Procedure |
Contact POC to request access. |
• » Data Access Constraints |
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel. The APSD Data Request staff are the POC for non-disclosure forms. |
• Data Use Constraints |
Access to individual reports is restricted to NOAA employees and our partners who have signed non-disclosure agreements. Summary data may be made available based on the "rule of 3", i.e., there must be at least three entities included in a summary for the summary information to be made publically available. Data may be made available if there is no information included that could uniquely link the information to an individual entity (person, vessel operating unit, business, etc.). Individually identifiable information may not be released without written authorization from the provider or by court order. |
Metadata Access Constraints | |
Metadata Use Constraints |
There are no constraints on the use of the metadata associated with this program. |
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 | 17031 |
---|---|
Metadata Record Created By | Denise A Washick |
Metadata Record Created | 2012-11-16 09:32+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-02-29 |
Owner Org | GARFO |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-02-29 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-02-28 |
Tags |
---|