Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Fisheries Sampling Branch (FSB) > Herring Fishery Electronic Monitoring Project D... >

HER_DISCARD

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

Summary

Abstract

Herring Discard Event

Description

Herring 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

Rubric Score Primary Key? 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

CC ID: 798832
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

CC ID: 798833
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

CC ID: 798834
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

CC ID: 798835
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

CC ID: 798836
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

CC ID: 798837
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

CC ID: 798838
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

CC ID: 798839
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

CC ID: 798840
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

CC ID: 798841
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

CC ID: 798842
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

CC ID: 798843
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

CC ID: 798844
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

CC ID: 798845
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

CC ID: 798846
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

CC ID: 798847
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

CC ID: 798848
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