Table: VERS_CATCH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34234 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table contains catch level records for electronically reported data
DescriptionTable 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
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
![]() |
TRIP_ID | NUMBER | Unique trip identifier |
100
|
![]() |
EFFORT_NUM | NUMBER | Unique effort identifier within a trip |
100
|
![]() |
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
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
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
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
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
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
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
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
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
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
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
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 |