54804 HER_DISCARD Entity Published / External 53562 Herring Fishery Electronic Monitoring Project Data (EMREVIEW) Data Set Completed Herring Discard Event Spreadsheet Yes Herring Discard Event 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Unique trip identifier generated when the data is loaded to Oracle raw tables. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active A unique reviewer identifier assigned to each reviewer of EM videos. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 DISC_ID NUMBER 3 Yes No 3 0 Active 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. NUMBER 4 HAUL_NUMBER NUMBER 6 No No 6 0 Active Fishing event haul number in which this discard event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active 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. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active 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. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active 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. NUMBER 8 DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of TIME VARCHAR2 9 YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from TIME VARCHAR2 10 MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from TIME VARCHAR2 11 DAY_UTC VARCHAR2 2 No No Active Extract UTC day from TIME VARCHAR2 12 TIME_UTC VARCHAR2 8 No No Active Extract UTC time from TIME VARCHAR2 13 EST_TOTAL_DISCARD_LBS NUMBER 8 No No 8 2 Active Estimated total weight of discarded fish in pounds. NUMBER 14 NOTES VARCHAR2 750 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 15 FISH_DISPOSITION VARCHAR2 3 No No Active 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. VARCHAR2 16 DISCARD_EVENT_TYPE_STR VARCHAR2 200 No No Active 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. VARCHAR2 17 DISCARD_VIEW_CODE_STR VARCHAR2 200 No No Active 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. VARCHAR2 gov.noaa.nmfs.inport:54804 Patricia Jones 2018-11-13T16:56:25 SysAdmin InPortAdmin 2022-08-09T17:11:42 2018-11-13 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2018-11-13 1 Year 2019-11-13