Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Data Management Systems (DMS) > Vessel Electronic Reporting System (VERS) >

Table: VERS_CATCH

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34234  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Table contains catch level records for electronically reported data

Description

Table contains catch level records for electronically reported data

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TRIP_ID
NUMBER 		Unique trip identifier
EFFORT_NUM
NUMBER 		Unique effort identifier within a trip
CATCH_NUM
NUMBER 		Unique catch identifier within an effort
SPECIES_ITIS
VARCHAR2 		ACCSP species ITIS code for the species caught
MARKET_CODE
VARCHAR2 		ACCSP market code
GRADE_CODE
VARCHAR2 		ACCSP grade code
HAIL_AMOUNT
NUMBER 		Quantity of catch reported
HAIL_AMOUNT_UOM
VARCHAR2 		Unit of measure for the quatity of catch reported
DISPOSITION_CODE
VARCHAR2 		ACCSP disposition code
CATCH_ENTRY_DATE_GMT
DATE 		Datetime (UTC) at which the catch record was entered into the ELB
UPLOAD_DATE_GMT
DATE 		Datetime (UTC) at which the submitted data was loaded to NEFSC servers

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Item Identification

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

Table contains catch level records for electronically reported data
Notes:

Loaded by batch 9189, 08-11-2016 10:02

Entity Information

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

Table contains catch level records for electronically reported data

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key TRIP_ID NUMBER Unique trip identifier
100
 Primary Key EFFORT_NUM NUMBER Unique effort identifier within a trip
100
 Primary Key CATCH_NUM NUMBER Unique catch identifier within an effort
100
 SPECIES_ITIS VARCHAR2 ACCSP species ITIS code for the species caught
100
 MARKET_CODE VARCHAR2 ACCSP market code
100
 GRADE_CODE VARCHAR2 ACCSP grade code
100
 HAIL_AMOUNT NUMBER Quantity of catch reported
100
 HAIL_AMOUNT_UOM VARCHAR2 Unit of measure for the quatity of catch reported
100
 DISPOSITION_CODE VARCHAR2 ACCSP disposition code
100
 CATCH_ENTRY_DATE_GMT DATE Datetime (UTC) at which the catch record was entered into the ELB
100
 UPLOAD_DATE_GMT DATE Datetime (UTC) at which the submitted data was loaded to NEFSC servers

Attribute Details

TRIP_ID

CC ID: 343962
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 14
Scale: 0
Status: Active
Description:

Unique trip identifier
General Data Type: NUMBER
Foreign Key Relations:

FVTR.VERS_EFFORT

EFFORT_NUM

CC ID: 343963
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 3
Scale: 0
Status: Active
Description:

Unique effort identifier within a trip
General Data Type: NUMBER
Foreign Key Relations:

FVTR.VERS_EFFORT

CATCH_NUM

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

Unique catch identifier within an effort
General Data Type: NUMBER

SPECIES_ITIS

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

ACCSP species ITIS code for the species caught
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SPECIES_CODES

MARKET_CODE

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

ACCSP market code
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SPECIES_CODES

GRADE_CODE

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

ACCSP grade code
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SPECIES_CODES

HAIL_AMOUNT

CC ID: 343967
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 8
Scale: 1
Status: Active
Description:

Quantity of catch reported
General Data Type: NUMBER

HAIL_AMOUNT_UOM

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

Unit of measure for the quatity of catch reported
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_SPECIES_CODES

DISPOSITION_CODE

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

ACCSP disposition code
General Data Type: VARCHAR2
Foreign Key Relations:

FVTR.FVTR_DISPOSITIONS

CATCH_ENTRY_DATE_GMT

CC ID: 343964
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) at which the catch record was entered into the ELB
General Data Type: DATE

UPLOAD_DATE_GMT

CC ID: 343965
Seq. Order: 11
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Datetime (UTC) at which the submitted data was loaded to NEFSC servers
General Data Type: DATE

Catalog Details

Catalog Item ID: 34234
GUID: gov.noaa.nmfs.inport:34234
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2016-08-11 10:02+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-08-23
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-08-23
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-08-23