HER_DISCARD
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:54804 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Herring Discard Event
DescriptionHerring Discard Event
Entity Information
Entity Type
Spreadsheet
Data Attribute / Type | Description |
---|---|
TRIP_ID
NUMBER |
Unique trip identifier generated when the data is loaded to Oracle raw tables. |
REVIEWER_ID
VARCHAR2 |
A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation. |
DISC_ID
NUMBER |
Unique identifier for this discard event record for the associated trip identifer and reviewer identifier combination. It is generated when the data is loaded to Oracle raw tables. |
HAUL_NUMBER
NUMBER |
Fishing event haul number in which this discard event occurred. |
LATITUDE
NUMBER |
Latitude where this discard event occurred as determined by the video reviewer. Actual latitude as defined by when the discard event occurred may be different than this latitude. |
LONGITUDE
NUMBER |
Longitude where this discard event occurred as determined by the video reviewer. Actual longitude as defined by when the discard event occurred may be different than this longitude. |
TIME
NUMBER |
Date and time that this discard event occurred as determined by the video reviewer. Actual time as defined by when the discard event occurred may be different than this date and time. |
DATE_TIME_UTC
VARCHAR2 |
UTC translation of TIME |
YEAR_UTC
VARCHAR2 |
Extract UTC year from TIME |
MONTH_UTC
VARCHAR2 |
Extract UTC month from TIME |
DAY_UTC
VARCHAR2 |
Extract UTC day from TIME |
TIME_UTC
VARCHAR2 |
Extract UTC time from TIME |
EST_TOTAL_DISCARD_LBS
NUMBER |
Estimated total weight of discarded fish in pounds. |
NOTES
VARCHAR2 |
Comments provided by the reviewer during the video review process. |
FISH_DISPOSITION
VARCHAR2 |
Code for how the discarded fish referred to on this discard event record was disposed of as determined by the video reviewer. See the EMFISHDISP table for a list of codes and their definitions. |
DISCARD_EVENT_TYPE_STR
VARCHAR2 |
String value which includes all of the discard event type codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes;and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISC_EVENT_TYPE table. |
DISCARD_VIEW_CODE_STR
VARCHAR2 |
String value which includes all of the discard view codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes; and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISCARD_VIEW table. |
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: | HER_DISCARD |
---|---|
Short Name: | HER_DISCARD |
Status: | Completed |
Abstract: |
Herring Discard Event |
Entity Information
Entity Type: | Spreadsheet |
---|---|
Active Version?: | Yes |
Description: |
Herring Discard Event |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
TRIP_ID | NUMBER | Unique trip identifier generated when the data is loaded to Oracle raw tables. | |
100
|
REVIEWER_ID | VARCHAR2 | A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation. | |
100
|
DISC_ID | NUMBER | Unique identifier for this discard event record for the associated trip identifer and reviewer identifier combination. It is generated when the data is loaded to Oracle raw tables. | |
100
|
HAUL_NUMBER | NUMBER | Fishing event haul number in which this discard event occurred. | |
100
|
LATITUDE | NUMBER | Latitude where this discard event occurred as determined by the video reviewer. Actual latitude as defined by when the discard event occurred may be different than this latitude. | |
100
|
LONGITUDE | NUMBER | Longitude where this discard event occurred as determined by the video reviewer. Actual longitude as defined by when the discard event occurred may be different than this longitude. | |
100
|
TIME | NUMBER | Date and time that this discard event occurred as determined by the video reviewer. Actual time as defined by when the discard event occurred may be different than this date and time. | |
100
|
DATE_TIME_UTC | VARCHAR2 | UTC translation of TIME | |
100
|
YEAR_UTC | VARCHAR2 | Extract UTC year from TIME | |
100
|
MONTH_UTC | VARCHAR2 | Extract UTC month from TIME | |
100
|
DAY_UTC | VARCHAR2 | Extract UTC day from TIME | |
100
|
TIME_UTC | VARCHAR2 | Extract UTC time from TIME | |
100
|
EST_TOTAL_DISCARD_LBS | NUMBER | Estimated total weight of discarded fish in pounds. | |
100
|
NOTES | VARCHAR2 | Comments provided by the reviewer during the video review process. | |
100
|
FISH_DISPOSITION | VARCHAR2 | Code for how the discarded fish referred to on this discard event record was disposed of as determined by the video reviewer. See the EMFISHDISP table for a list of codes and their definitions. | |
100
|
DISCARD_EVENT_TYPE_STR | VARCHAR2 | String value which includes all of the discard event type codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes;and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISC_EVENT_TYPE table. | |
100
|
DISCARD_VIEW_CODE_STR | VARCHAR2 | String value which includes all of the discard view codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes; and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISCARD_VIEW table. |
Attribute Details
TRIP_ID
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 6 |
Required: | Yes |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Unique trip identifier generated when the data is loaded to Oracle raw tables. |
General Data Type: | NUMBER |
REVIEWER_ID
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation. |
General Data Type: | VARCHAR2 |
DISC_ID
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Unique identifier for this discard event record for the associated trip identifer and reviewer identifier combination. It is generated when the data is loaded to Oracle raw tables. |
General Data Type: | NUMBER |
HAUL_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 0 |
Status: | Active |
Description: |
Fishing event haul number in which this discard event occurred. |
General Data Type: | NUMBER |
LATITUDE
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 9 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 4 |
Status: | Active |
Description: |
Latitude where this discard event occurred as determined by the video reviewer. Actual latitude as defined by when the discard event occurred may be different than this latitude. |
General Data Type: | NUMBER |
LONGITUDE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 9 |
Required: | Yes |
Primary Key: | No |
Precision: | 9 |
Scale: | 4 |
Status: | Active |
Description: |
Longitude where this discard event occurred as determined by the video reviewer. Actual longitude as defined by when the discard event occurred may be different than this longitude. |
General Data Type: | NUMBER |
TIME
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 16 |
Required: | Yes |
Primary Key: | No |
Precision: | 16 |
Scale: | 2 |
Status: | Active |
Description: |
Date and time that this discard event occurred as determined by the video reviewer. Actual time as defined by when the discard event occurred may be different than this date and time. |
General Data Type: | NUMBER |
DATE_TIME_UTC
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 19 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
UTC translation of TIME |
General Data Type: | VARCHAR2 |
YEAR_UTC
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extract UTC year from TIME |
General Data Type: | VARCHAR2 |
MONTH_UTC
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extract UTC month from TIME |
General Data Type: | VARCHAR2 |
DAY_UTC
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extract UTC day from TIME |
General Data Type: | VARCHAR2 |
TIME_UTC
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Extract UTC time from TIME |
General Data Type: | VARCHAR2 |
EST_TOTAL_DISCARD_LBS
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 2 |
Status: | Active |
Description: |
Estimated total weight of discarded fish in pounds. |
General Data Type: | NUMBER |
NOTES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 750 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments provided by the reviewer during the video review process. |
General Data Type: | VARCHAR2 |
FISH_DISPOSITION
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for how the discarded fish referred to on this discard event record was disposed of as determined by the video reviewer. See the EMFISHDISP table for a list of codes and their definitions. |
General Data Type: | VARCHAR2 |
DISCARD_EVENT_TYPE_STR
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
String value which includes all of the discard event type codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes;and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISC_EVENT_TYPE table. |
General Data Type: | VARCHAR2 |
DISCARD_VIEW_CODE_STR
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 200 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
String value which includes all of the discard view codes for this discard event. Note that this value: may or may not include square brackets around the entire list; individual values may be surrounded by single quotes, double quotes or no quotes; and multiple values will be separated by a pipe symbol (|). See individual codes in the HER_DISC_DISCARD_VIEW table. |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 54804 |
---|---|
GUID: | gov.noaa.nmfs.inport:54804 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2018-11-13 16:56+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-11-13 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-11-13 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-11-13 |