53562 Herring Fishery Electronic Monitoring Project Data (EMREVIEW) Data Set Published / External 22550 Fishery Monitoring Operations Branch (FMOB) Project In Work Herring Fishery Electronic Monitoring (EM) Project Data (EMREVIEW) contains data collected on commercial fishing vessels by em systems from 2016 - 2017. The data include detailed effort information as well as bycatch of finfish and protected species. Data is collected by trained video and gps sensors then video is video and data is recorded by trained reviewers a for scientific and fisheries management purposes. Data set was generated as part of a pilot project exploring the utility of EM to provide specific information about large at sea discard events (slippage). Theme bycatch Theme electronic monitoring Theme trawl Temporal 2016 Temporal 2017 Spatial Georges Bank Spatial Gulf of Maine Spatial Mid-Atlantic Spatial NY Bight Spatial Northeast Spatial Northwest Atlantic Northeast Fisheries Science Center Woods Hole MA USA Data Set Oracle Database Table (digital) Electronic Monitoring System (via Saltwater Inc.) Ship Mid-water trawl 54801 HER_ANNOTATION Published / External Completed Herring Annotation Event Spreadsheet Yes Herring Annotation 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 ANN_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this annotation 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 annotation event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this annotation event occurred as determined by the video reviewer. Actual latitude as defined by when the annotation event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this annotation event occurred as determined by the video reviewer. Actual longitude as defined by when the annotation event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this annotation event occurred as determined by the video reviewer. Actual time as defined by when the annotation 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 ANNOTATION VARCHAR2 500 Yes No Active Comments provided by the reviewer during the video review process. VARCHAR2 54802 HER_BEGIN_FISHING Published / External Completed Herring Begin Fishing Event Spreadsheet Yes Herring Begin Fishing 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 BF_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this begin fishing 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 begin fishing event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this begin fishing event occurred as determined by the video reviewer. Actual latitude as defined by when the begin fishing event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this begin fishing event occurred as determined by the video reviewer. Actual longitude as defined by when the begin fishing event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this begin fishing event occurred as determined by the video reviewer. Actual time as defined by when the begin fishing 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 54803 HER_BEGIN_HAUL Published / External Completed Herring Begin Haul Event Spreadsheet Yes Herring Begin Haul 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 BH_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this begain haul 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 0 0 Active Fishing event haul number in which this begin haul event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this begin haul event occurred as determined by the video reviewer. Actual latitude as defined by when the begin haul event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this begin haul event occurred as determined by the video reviewer. Actual longitude as defined by when the begin haul event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this begin haul event occurred as determined by the video reviewer. Actual time as defined by when the begin haul 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 54804 HER_DISCARD Published / External 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 54805 HER_END_HAUL Published / External Completed Herring End Haul Event Spreadsheet Yes Herring End Haul 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 EH_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this end haul 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 end haul event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this end haul event occurred as determined by the video reviewer. Actual latitude as defined by when the end haul event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this end haul event occurred as determined by the video reviewer. Actual longitude as defined by when the end haul event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this end haul event occurred as determined by the video reviewer. Actual time as defined by when the end haul 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 54806 HER_FISHING_EVENT Published / External Completed Herring Fishing Event Spreadsheet Yes Herring Fishing 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 FE_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this fishing event record for the associated trip identifer. It is generated when the data is loaded to Oracle raw tables. NUMBER 4 HAUL_NUMBER NUMBER 6 No No 0 0 Active Unique haul number assigned by the reviewer for this fishing event record for the associated trip identifer. NUMBER 5 BEGIN_TIME NUMBER 16 No No 16 2 Active Date and time that this fishing event began as determined by the video reviewer. Actual fishing event begin time as defined by when the vessel departed to go fishing may be different than this date and time. NUMBER 6 BEGIN_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of BEGIN_TIME VARCHAR2 7 BEGIN_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from BEGIN_TIME VARCHAR2 8 BEGIN_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from BEGIN_TIME VARCHAR2 9 BEGIN_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from BEGIN_TIME VARCHAR2 10 BEGIN_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from BEGIN_TIME VARCHAR2 11 END_TIME NUMBER 16 No No 16 2 Active Date and time that this fishing event ended as determined by the video reviewer. Actual fishing event end time as defined by when the vessel returned from fishing may be different than this date and time. NUMBER 12 END_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of END_TIME VARCHAR2 13 END_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from END_TIME VARCHAR2 14 END_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from END_TIME VARCHAR2 15 END_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from END_TIME VARCHAR2 16 END_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from END_TIME VARCHAR2 17 BEGIN_LATITUDE NUMBER 9 No No 9 4 Active Beginning latitude where this fishing event started as determined by the video reviewer. Actual beginning latitude as defined by when the vessel departed to go fishing may be different than this beginning latitude. NUMBER 18 BEGIN_LONGITUDE NUMBER 9 No No 9 4 Active Beginning longitude where this fishing event started as determined by the video reviewer. Actual beginning longitude as defined by when the vessel departed to go fishing may be different than this beginning longitude. NUMBER 19 END_LATITUDE NUMBER 9 No No 9 4 Active Ending latitude where this fishing event ended as determined by the video reviewer. Actual ending latitude as defined by when the vessel returned from fishing may be different than this ending latitude. NUMBER 20 END_LONGITUDE NUMBER 9 No No 9 4 Active Ending longitude where this fishing event ended as determined by the video reviewer. Actual ending longitude as defined by when the vessel returned from fishing may be different than this ending longitude. NUMBER 21 SENSOR_DETECTION VARCHAR2 1 No No Active Whether or not sensor detection was used on this trip as determined by the video reviewer. See the SENSOR_DETECTION table for a list of codes and their definitions. VARCHAR2 22 VESSEL_PUMPED_FISH VARCHAR2 1 No No Active Whether or not the vessel pumped fish on this trip as determined by the video reviewer. See the VESSEL_PUMPED_FISH table for a list of codes and their definitions. VARCHAR2 23 SEE_CODEEND_BUNT_CONTENTS VARCHAR2 1 No No Active Whether or not the video reviewer was able to see the codeend bunt contents when reviewing this trip. See the BUNT_CONTENTS table for a list of codes and their definitions. VARCHAR2 24 DISCARD_EVENT_OCCURRED VARCHAR2 1 No No Active Whether or not a discard event occurred on this trip as determined by the video reviewer. See the DISCARD_EVENT_OCCURRED table for a list of codes and their definitions. VARCHAR2 25 TRIPLEX_USED VARCHAR2 1 No No Active Whether or not a triplex was used on this trip as determined by the video reviewer. See the TRIPLEX_USED table for a list of codes and their definitions. VARCHAR2 26 FISH_PUMPED_TO_OTHER_VESSEL VARCHAR2 15 No No Active If fish were pumped to another vessel, this would be the Federal or State vessel registration number for the other vessel and it is usually visable on the vessel hull. See the EMVESSELS table for a list of vessel registration numbers, names and permit numbers. VARCHAR2 27 IMAGE_QUALITY_ASSESSMENT VARCHAR2 1 No No Active Code for the image quality assessment of the video for this trip as determined by the video reviewer. See the IMAGE_QUALITY table for a list of codes and their definitions. VARCHAR2 28 NOTES VARCHAR2 500 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 29 VIDEO_ISSUES_STR VARCHAR2 200 No No Active String formatted value which includes all of the video issues codes for this fishing 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_FE_VIDEO_ISSUES table. VARCHAR2 54807 HER_FISH_PUMP_BEGINS Published / External Completed Herring Fish Pumping Begins Event Spreadsheet Yes Herring Fish Pumping Begins 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 No 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 FPB_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this fish pumping begins 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 0 0 Active Fishing event haul number in which this fish pumping begins event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this fish pumping begins event occurred as determined by the video reviewer. Actual latitude as defined by when the fish pumping begins event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this fish pumping begins event occurred as determined by the video reviewer. Actual longitude as defined by when the fish pumping begins event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this fish pumping begins event occurred as determined by the video reviewer. Actual time as defined by when the fish pumping begins 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 54808 HER_FISH_PUMP_ENDS Published / External Completed Herring Fish Pumping Ends Event Spreadsheet Yes Herring Fish Pumping Ends 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 FPE_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this fish pumping ends 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 0 0 Active Fishing event haul number in which this fish pumping ends event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this fish pumping ends event occurred as determined by the video reviewer. Actual latitude as defined by when the fish pumping ends event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this fish pumping ends event occurred as determined by the video reviewer. Actual longitude as defined by when the fish pumping ends event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this fish pumping ends event occurred as determined by the video reviewer. Actual time as defined by when the fish pumping ends 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 54809 HER_GEAR_ONBOARD Published / External Completed Herring Gear Brought On Board Vessel Event Spreadsheet Yes Herring Gear Brought On Board Vessel 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 GO_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this gear onboard 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 Active Fishing event haul number in which this gear onboard event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this gear onboard event occurred as determined by the video reviewer. Actual latitude as defined by when the gear onboard event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this gear onboard event occurred as determined by the video reviewer. Actual longitude as defined by when the gear onboard event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this gear onboard event occurred as determined by the video reviewer. Actual time as defined by when the gear onboard 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 54810 HER_PUMP_STOP Published / External Completed Herring Pumping Stop Event Spreadsheet Yes Herring Pumping Stop 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 PSE_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this pump stop 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 pump stop event occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this pump stop event occurred as determined by the video reviewer. Actual latitude as defined by when the pump stop event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this pump stop event occurred as determined by the video reviewer. Actual longitude as defined by when the pump stop event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this pump stop event occurred as determined by the video reviewer. Actual time as defined by when the pump stop 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 NOTES VARCHAR2 500 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 14 PUMP_STOP_REASON_CODE_STR VARCHAR2 No No Active String value which includes all of the pump stop reason codes for this pump stop event and may or may not include square brackets around the entire list and individual values may be surrounded by single quotes, double quotes or no quotes. Multiple values will be separated by a pipe symbol (|). See individual codes in the HER_PSE_PUMP_STOP_REASON table. VARCHAR2 54811 HER_PUMP_STOP_DUR Published / External Completed Herring Duration of Stopped Pumping Event Spreadsheet Yes Herring Duration of Stopped Pumping 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 PSD_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this pump stop duration 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 pump stop duration record occurred. NUMBER 5 BEGIN_TIME NUMBER 16 Yes No 16 2 Active Date and time that this pump stop duration event began as determined by the video reviewer. Actual pump stop duration began time as defined by when the incident occurred may be different than this date and time. NUMBER 6 BEGIN_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of BEGIN_TIME VARCHAR2 7 BEGIN_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from BEGIN_TIME VARCHAR2 8 BEGIN_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from BEGIN_TIME VARCHAR2 9 BEGIN_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from BEGIN_TIME VARCHAR2 10 BEGIN_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from BEGIN_TIME VARCHAR2 11 END_TIME NUMBER 16 Yes No 16 2 Active Date and time that this pump stop duration event ended as determined by the video reviewer. Actual pump stop duration end time as defined by when the incident occurred may be different than this date and time. NUMBER 12 END_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of END_TIME VARCHAR2 13 END_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from END_TIME VARCHAR2 14 END_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from END_TIME VARCHAR2 15 END_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from END_TIME VARCHAR2 16 END_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from END_TIME VARCHAR2 17 BEGIN_LATITUDE NUMBER 9 Yes No 9 4 Active Beginning latitude where this pump stop duration event started as determined by the video reviewer. Actual beginning latitude as defined by when the pump stop duration event may be different than this beginning latitude. NUMBER 18 BEGIN_LONGITUDE NUMBER 9 Yes No 9 4 Active Beginning longitude where this pump stop duration event started as determined by the video reviewer. Actual beginning longitude as defined by when the pump stop duration event may be different than this beginning longitude. NUMBER 19 END_LATITUDE NUMBER 9 Yes No 9 4 Active Ending latitude where this pump stop duration event ended as determined by the video reviewer. Actual ending latitude as defined by when the pump stop duration event ended may be different than this ending latitude. NUMBER 20 END_LONGITUDE NUMBER 9 Yes No 9 4 Active Ending longitude where this pump stop duration event ended as determined by the video reviewer. Actual ending longitude as defined by when the pump stop duration event may be different than this ending longitude. NUMBER 21 NOTES VARCHAR2 500 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 22 PUMP_STOP_REASON_CODE_STR VARCHAR2 200 No No Active String value which includes all of the pump stop reason codes for this pump stop duration 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_PSD_PUMP_STOP_REASON table. VARCHAR2 54812 HER_SYS_PERF Published / External Completed Herring System Performance Issue Event Spreadsheet Yes Herring System Performance Issue 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 SPI_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this system performance issue 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 system performance issue event record occurred. NUMBER 5 BEGIN_TIME NUMBER 16 Yes No 16 2 Active Date and time that this system performance issue event began as determined by the video reviewer. Actual system performance issue event began time as defined by when the incident occurred may be different than this date and time. NUMBER 6 BEGIN_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of BEGIN_TIME VARCHAR2 7 BEGIN_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from BEGIN_TIME VARCHAR2 8 BEGIN_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from BEGIN_TIME VARCHAR2 9 BEGIN_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from BEGIN_TIME VARCHAR2 10 BEGIN_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from BEGIN_TIME VARCHAR2 11 END_TIME NUMBER 16 Yes No 16 2 Active Date and time that this system performance issue event ended as determined by the video reviewer. Actual system performance issue event ended time as defined by when the incident occurred may be different than this date and time. NUMBER 12 END_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of END_TIME VARCHAR2 13 END_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from END_TIME VARCHAR2 14 END_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from END_TIME VARCHAR2 15 END_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from END_TIME VARCHAR2 16 END_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from END_TIME VARCHAR2 17 BEGIN_LATITUDE NUMBER 9 Yes No 9 4 Active Beginning latitude where this system performance issue event started as determined by the video reviewer. Actual beginning latitude as defined by when the system performance issue event started may be different than this beginning latitude. NUMBER 18 BEGIN_LONGITUDE NUMBER 9 Yes No 9 4 Active Beginning longitude where this system performance issue event started as determined by the video reviewer. Actual beginning longitude as defined by when the system performance issue event started may be different than this beginning longitude. NUMBER 19 END_LATITUDE NUMBER 9 Yes No 9 4 Active Ending latitude where the system performance issue event ended as determined by the video reviewer. Actual ending latitude as defined by when the system performance issue event ended may be different than this ending latitude. NUMBER 20 END_LONGITUDE NUMBER 9 Yes No 9 4 Active Ending longitude where the system performance issue event ended as determined by the video reviewer. Actual ending longitude as defined by when the system performance issue event ended may be different than this ending longitude. NUMBER 21 NOTES VARCHAR2 500 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 22 PERFORMANCE_ISSUE_TYPE_STR VARCHAR2 200 No No Active String value which includes all of the performance issue type codes for this performance issue 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_SPI_PERF_ISSUE_TYPE table. VARCHAR2 54813 HER_TRIP Published / External Completed Herring Trip Begin and End Events Spreadsheet Yes Herring Trip Begin and End Events 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 BEGIN_TIME NUMBER 16 Yes No 16 2 Active Date and time that the trip began as determined by the video reviewer. Actual trip begin time as defined by when the vessel departed to go fishing may be different than this date and time. NUMBER 4 BEGIN_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of BEG_TIME VARCHAR2 5 BEGIN_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from BEG_TIME VARCHAR2 6 BEGIN_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from BEG_TIME VARCHAR2 7 BEGIN_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from BEG_TIME VARCHAR2 8 BEGIN_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from BEG_TIME VARCHAR2 9 END_TIME NUMBER 16 Yes No 16 2 Active Date and time that the trip ended as determined by the video reviewer. Actual trip end time as defined by when the vessel returned from fishing may be different than this date and time. NUMBER 10 END_DATE_TIME_UTC VARCHAR2 19 No No Active UTC translation of END_TIME VARCHAR2 11 END_YEAR_UTC VARCHAR2 4 No No Active Extract UTC year from END_TIME VARCHAR2 12 END_MONTH_UTC VARCHAR2 2 No No Active Extract UTC month from END_TIME VARCHAR2 13 END_DAY_UTC VARCHAR2 2 No No Active Extract UTC day from END_TIME VARCHAR2 14 END_TIME_UTC VARCHAR2 8 No No Active Extract UTC time from END_TIME VARCHAR2 15 BEGIN_LATITUDE NUMBER 9 Yes No 9 4 Active Beginning latitude where the trip started as determined by the video reviewer. Actual beginning latitude as defined by when the vessel departed to go fishing may be different than this beginning latitude. NUMBER 16 BEGIN_LONGITUDE NUMBER 9 Yes No 9 4 Active Beginning longitude where the trip started as determined by the video reviewer. Actual beginning longitude as defined by when the vessel departed to go fishing may be different than this beginning longitude. NUMBER 17 END_LATITUDE NUMBER 9 Yes No 9 4 Active Ending latitude where the trip ended as determined by the video reviewer. Actual ending latitude as defined by when the vessel returned from fishing may be different than this ending latitude. NUMBER 18 END_LONGITUDE NUMBER 9 Yes No 9 4 Active Ending longitude where the trip ended as determined by the video reviewer. Actual ending longitude as defined by when the vessel returned from fishing may be different than this ending longitude. NUMBER 19 HULLNUM VARCHAR2 15 Yes No Active Federal or State vessel registration number usually visable on the vessel hull. See the EMVESSELS table for a list of vessel registration numbers, names and permit numbers. VARCHAR2 20 PERMIT NUMBER No No Active Federal fishing permit number from EMVESSELS for the hull number for this vessel. NUMBER 21 EVTR_TRIP_NUMBER NUMBER 20 Yes No 20 0 Active Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the primary vessel. NUMBER 22 EVTR_PAIR_VESSEL_TRIP_NUMBER NUMBER 20 No No 20 0 Active Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the paired vessel, if any. NUMBER 23 GEAR VARCHAR2 3 Yes No Active NMFS Northeast gear code. See the OBDBS.OBGEAR code table for a list of codes and their definitions. VARCHAR2 24 START_PORT VARCHAR2 6 Yes No Active Port code where the trip started from as determined by the video reviewer. Actual starting port as defined by where the vessel departed from may be different than this starting port. See the EMPORT table for a list of port codes and their locations. VARCHAR2 25 END_PORT VARCHAR2 6 Yes No Active Port code where the trip ended from as determined by the video reviewer. Actual ending port as defined by where the vessel returned to may be different than this ending port. See the EMPORT table for a list of port codes and their locations. VARCHAR2 26 FISHING_OCCURRED VARCHAR2 1 Yes No Active Whether or not fishing occurred on this trip as determined by the video reviewer. See the FISHING_OCCURRED table for a list of codes and their definitions. VARCHAR2 27 OBSERVER_ONBOARD VARCHAR2 1 Yes No Active Whether or not there was an observer onboard on this trip as determined by the video reviewer. See the OBSERVER_ONBOARD table for a list of codes and their definitions. VARCHAR2 28 NOTES VARCHAR2 750 No No Active Comments provided by the reviewer during the video review process. VARCHAR2 29 REVIEW_TOTAL_MINUTES NUMBER 4 No No 4 0 Active Number of minutes the reviewer took to proces the video and record the meta data. NUMBER 30 REVIEWER_NAME VARCHAR2 70 Yes No Active Name or initals of the reviewer. See the REVIEWERS table for a list of reviewers and their affiliation. VARCHAR2 31 SLIPPAGE_OCCURRED VARCHAR2 1 Yes No Active Whether or not slippage occurred on this trip as determined by the video reviewer. See the SLIPPAGE_OCCURRED table for a list of codes and their definitions. VARCHAR2 54814 HER_DISC_DISCARD_VIEW Published / External Completed Herring Discard Event Sub-Table for Multiple Discard View Types Spreadsheet Yes Herring Discard Event Sub-Table for Multiple Discard View Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Trip identifier for the discard event record to which this discard view code belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the discard event record to which this discard view code belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 DISC_ID NUMBER 3 Yes No 3 0 Active Identifier for the discard event record on which this discard view was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and DISCID ties this record to a specific record in the HER_DISCARD table. There may be more than one record in this table pointing to the same record in the HER_DISCARD table. NUMBER 4 DISCARD_VIEW_CODE VARCHAR2 1 Yes No Active One of possibly multiple discard view codes for this discard event record. See the DISCARD_VIEW_TYPES table for a list of codes and their definitions. VARCHAR2 54815 HER_DISC_DISC_EVENT_TYPE Published / External Completed Herring Discard Event Sub-Table for Multiple Discard Event Types Spreadsheet Yes Herring Discard Event Sub-Table for Multiple Discard Event Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Trip identifier for the discard event record to which this discard event type code belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the discard event record to which this discard event type code belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 DISCID NUMBER 3 Yes No 3 0 Active Identifier for the discard event record on which this discard event type was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and DISCID ties this record to a specific record in the HER_DISCARD table. There may be more than one record in this table pointing to the same record in the HER_DISCARD table. NUMBER 4 DISCARD_EVENT_TYPE_CODE VARCHAR2 1 Yes No Active One of possibly multiple discard event type codes for this discard event record. See the DISCARD_EVENT_TYPES table for a list of codes and their definitions. VARCHAR2 54816 HER_FE_VIDEO_ISSUE Published / External Completed Herring Fishing Event Sub-Table for Multiple Video Issue Types Spreadsheet Yes Herring Fishing Event Sub-Table for Multiple Video Issue Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Trip identifier for the fishing event record to which this video issue code belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the fishing event record to which this video issue code belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 FE_ID NUMBER 3 Yes No 3 0 Active Identifier for the fishing event record on which this video issue code was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and FEID ties this record to a specific record in the HER_FISHING_EVENT table. There may be more than one record in this table pointing to the same record in the HER_FISHING_EVENT table. NUMBER 4 VIDEO_ISSUE_CODE VARCHAR2 2 Yes No Active One of possibly multiple video issue codes for this trip and fishing event record. See the VIDEO_ISSUE_TYPES table for a list of codes and their definitions. VARCHAR2 54817 HER_PSD_PUMP_STOP_REASON Published / External Completed Herring Pump Stop Duration Event Sub-Table for Multiple Pump Stop Reason Types Spreadsheet Yes Herring Pump Stop Duration Event Sub-Table for Multiple Pump Stop Reason Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Trip identifier for the pump stop duration event record to which this pump stop reason belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the pump stop duration event record to which this pump stop reason belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 PSD_ID NUMBER 3 Yes No 3 0 Active Identifier for the pump stop duration event record on which this pump stop reason was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and PSDID ties this record to a specific record in the HER_PUMP_STOP_DUR table. There may be more than one record in this table pointing to the same record in the HER_PUMP_STOP_DUR table. NUMBER 4 PUMP_STOP_REASON_CODE VARCHAR2 1 Yes No Active One of possibly multiple pump stop reason codes for this pump stop duration event record. See the PUMP_STOP_REASON_TYPES table for a list of codes and their definitions. VARCHAR2 54818 HER_PSE_PUMP_STOP_REASON Published / External Completed Herring Pump Stop Duration Event Sub-Table for Multiple Pump Stop Reason Types Spreadsheet Yes Herring Pump Stop Duration Event Sub-Table for Multiple Pump Stop Reason Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Trip identifier for the pump stop event record to which this pump stop reason belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the pump stop event record to which this pump stop reason code belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 PSE_ID NUMBER 3 Yes No 3 0 Active Identifier for the pump stop event record on which this pump stop reason was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and PSEID ties this record to a specific record in the HER_PUMP_STOP table. There may be more than one record in this table pointing to the same record in the HER_PUMP_STOP table. NUMBER 4 PUMP_STOP_REASON_CODE VARCHAR2 1 Yes No Active One of possibly multiple pump stop reason codes for this pump stop event record. See the PUMP_STOP_REASON_TYPES table for a list of codes and their definitions. VARCHAR2 54819 HER_SPI_PERF_ISSUE_TYPE Published / External Completed Herring System Performance Issue Event Sub-Table for Multiple Performance Issue Types Spreadsheet Yes Herring System Performance Issue Event Sub-Table for Multiple Performance Issue Types 1 TRIP_ID NUMBER 6 Yes No 6 0 Active Identifier for the system performance issue record to which this performance isue type belongs. NUMBER 2 REVIEWER_ID VARCHAR2 4 Yes No Active Reviewer identifier for the system performance issue event record to which this system performance issue code belongs. See the REVIEWERS table for a list of reviewer names and their affliation. VARCHAR2 3 SPI_ID NUMBER 3 Yes No 3 0 Active Identifier for the system performance issue event record on which this performance issue type was noted by the video reviewer. The combination of the TRIP_ID, REVIEWER_ID and SPIID ties this record to a specific record in the HER_SYS_PERF table. There may be more than one record in this table pointing to the same record in the HER_SYS_PERF table. NUMBER 4 PERFORMANCE_ISSUE_TYPE_CODE VARCHAR2 1 Yes No Active One of possibly multiple performance issue type codes for this system performance issue event record. See the PERFORMANCE_ISSUE_TYPES table for a list of codes and their definitions. VARCHAR2 54820 BUNT_CONTENTS Published / External Completed Bunt Contents Type Codes Look Up Table Spreadsheet Yes Bunt Contents Type Codes Look Up Table 1 BUNT_CONTENTS_CODE VARCHAR2 1 Yes Yes Active Code for this bunt contents type. VARCHAR2 2 BUNT_CONTENTS VARCHAR2 40 Yes No Active Description for this bunt contents type. VARCHAR2) 54821 DISCARD_EVENT_OCCURRED Published / External Completed Discard Event Occurred Type Codes Look Up Table Spreadsheet Yes Discard Event Occurred Type Codes Look Up Table 1 DISCARD_EVENT_OCCURRED_CODE VARCHAR2 1 Yes Yes Active Code for this discard event occurred type. VARCHAR2 2 DISCARD_EVENT_OCCURRED VARCHAR2 20 Yes No Active Description for this discard event occurred type. VARCHAR2 54822 DISCARD_EVENT_TYPES Published / External Completed Discard Event Type Codes Look Up Table Spreadsheet Yes Discard Event Type Codes Look Up Table 1 DISCARD_EVENT_TYPE_CODE (PK) VARCHAR2 1 Yes Yes Active Code for this discard event type. VARCHAR2 2 DISCARD_EVENT_TYPE VARCHAR2 40 Yes No Active Description for this discard event type. VARCHAR2 54823 DISCARD_VIEW_TYPES Published / External Completed Discard View Type Codes Look Up Table Spreadsheet Yes Discard View Type Codes Look Up Table 1 DISCARD_VIEW_CODE (PK) VARCHAR2 1 Yes Yes Active Code for this discard view type. VARCHAR2 2 DISCARD_VIEW VARCHAR2 20 Yes No Active Description for this discard view type. VARCHAR2 54824 EMFISHDISP Published / External Completed Fish Disposition Type Codes Look Up Table Spreadsheet Yes Fish Disposition Type Codes Look Up Table 1 FISHDISP VARCHAR2 3 Yes Yes Active Code for this fish disposition type. VARCHAR2 2 FISHDISPDESC VARCHAR2 80 Yes No Active Description for this fish disposition type. VARCHAR2 3 FISHDISPCOMMENTS VARCHAR2 250 No No Active Comments for this fish disposition type. VARCHAR2 54825 EMSPECIES Published / External Completed Species Codes Look Up Table Spreadsheet Yes Species Codes Look Up Table 1 NESPP4 VARCHAR2 4 Yes Yes Active Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. VARCHAR2 2 COMMON_NAME VARCHAR2 35 Yes No Active Common name for this species. VARCHAR2 3 SCIENTIFIC_NAME VARCHAR2 45 No No Active Latin name for this species. VARCHAR2 4 SPECIES_ITIS VARCHAR2 11 No No Active The Integrated Taxonomic Information System (ITIS) serial number for this species. VARCHAR2 5 MARKET VARCHAR2 20 No No Active The market for this species. 54826 EMVESSELS Published / External Completed Vessel Codes Look Up Table Spreadsheet Yes Vessel Codes Look Up Table 1 VESSELNAME VARCHAR2 50 Yes No Active Name of the vessel usually visable on the vessel hull. VARCHAR2 2 HULLNUM VARCHAR2 15 Yes No Active Federal or State vessel registration number usually visable on the vessel hull. VARCHAR2 3 PERMIT_NUM NUMBER Yes No Active Federal fishing permit number for this vessel. NUMBER 4 INSTALL_DATE DATE No No Active Not currently used. DATE 5 UNINSTALL_DATE DATE No No Active Not currently used. DATE 6 VMP_APPROVAL DATE No No Active Not currently used. DATE 7 FISHERY VARCHAR2 10 No No Active Not currently used. VARCHAR2 8 PROVIDERCD VARCHAR2 2 No No Active Not currently used. VARCHAR2 9 EM_PROGRAM VARCHAR2 4 No No Active Not currently used. VARCHAR2 54827 FISHING_OCCURRED Published / External Completed Fishing Occurred Type Codes Look Up Table Spreadsheet Yes Fishing Occurred Type Codes Look Up Table 1 FISHING_OCCURRED_CODE VARCHAR2 1 Yes Yes Active Code for this fishing occurred type. VARCHAR2 2 FISHING_OCCURRED VARCHAR2 10 Yes No Active Description for this discard event occurred type. VARCHAR2 54828 IMAGE_QUALITY Published / External Completed Image Quality Type Codes Look Up Table Spreadsheet Yes Image Quality Type Codes Look Up Table 1 IMAGE_QUALITY_CODE VARCHAR2 1 Yes Yes Active Code for this image quality type. VARCHAR2 2 IMAGE_QUALITY VARCHAR2 20 Yes No Active Description for this image quality type. VARCHAR2 54829 OBSERVER_ONBOARD Published / External Completed Observer On Board Type Codes Look Up Table Spreadsheet Yes Observer On Board Type Codes Look Up Table 1 OBSERVER_ON_BOARD_CODE VARCHAR2 1 Yes Yes Active Code for this observer on board type. VARCHAR2 2 OBSERVER_ON_BOARD VARCHAR2 10 Yes No Active Description for this observer on board type. VARCHAR2 54830 PERFORMANCE_ISSUE_TYPES Published / External Completed Performance Issue Type Codes Look Up Table Spreadsheet Yes Performance Issue Type Codes Look Up Table 1 PERFORMANCE_ISSUE_TYPE_CODE (PK) VARCHAR2 1 Yes Yes Active Code for this performance issue type. VARCHAR2 2 PERFORMANCE_ISSUE VARCHAR2 35 Yes No Active Description for this performance issue type. VARCHAR2 54831 PUMP_STOP_REASON_TYPES Published / External Completed Pump Stop Reason Type Codes Look Up Table Spreadsheet Yes Pump Stop Reason Type Codes Look Up Table 1 PUMP_STOP_REASON_CODE (PK) VARCHAR2 1 Yes Yes Active Code for this pump stop reason type. VARCHAR2 2 PUMP_STOP_REASON VARCHAR2 40 Yes No Active Description for this pump stop reason type. VARCHAR2 54832 REVIEWERS Published / External Completed Reviewer Codes Look Up Table Spreadsheet Yes Reviewer Codes Look Up Table 1 REVIEWER_ID VARCHAR2 4 Yes Yes Active Code for this reviewer. VARCHAR2 2 FIRST_NAME VARCHAR2 35 Yes No Active First name for this reviewer. VARCHAR2 3 LAST_NAME VARCHAR2 35 Yes No Active Last name for this reviewer. VARCHAR2 4 MIDDLE_INITIAL VARCHAR2 1 No No Active Middle initial for this reviewer. VARCHAR2 5 AFFILIATION VARCHAR2 30 Yes No Active Company where this reviewer works. VARCHAR2 54833 SENSOR_DETECTION Published / External Completed Sensor Detection Type Codes Look Up Table Spreadsheet Yes Sensor Detection Type Codes Look Up Table 1 SENSOR_DETECTION_CODE VARCHAR2 1 Yes Yes Active Code for this sensor detection type. VARCHAR2 2 SENSOR_DETECTION VARCHAR2 10 Yes No Active Description for this sensor detection type. VARCHAR2 54834 SLIPPAGE_OCCURRED Published / External Completed Slippage Occurred Type Codes Look Up Table Spreadsheet Yes Slippage Occurred Type Codes Look Up Table 1 SLIPPAGE_OCCURRED_CODE VARCHAR2 1 Yes Yes Active Code for this slippage occurred type. VARCHAR2 2 SLIPPAGE_OCCURRED VARCHAR2 10 Yes No Active Description for this slippage occurred type. VARCHAR2 54835 VESSEL_PUMPED_FISH Published / External Completed Vessel Pumped Fish Type Codes Look Up Table Spreadsheet Yes Vessel Pumped Fish Type Codes Look Up Table 1 VESSEL_PUMPED_FISH_CODE VARCHAR2 1 Yes Yes Active Code for this vessel pumped fish type. VARCHAR2 2 VESSEL_PUMPED_FISH VARCHAR2 10 Yes No Active Description for this vessel pumped fish type. VARCHAR2 54836 VIDEO_ISSUE_TYPES Published / External Completed Video Issue Type Codes Look Up Table Spreadsheet Yes Video Issue Type Codes Look Up Table 1 VIDEO_ISSUE_CODE (PK) VARCHAR2 2 Yes Yes Active Code for this video issue type. VARCHAR2 2 VIDEO_ISSUE VARCHAR2 30 Yes No Active Description for this video issue type. VARCHAR2 54850 HER_IAL Published / External Completed Herring Individual Animal Logging Event Spreadsheet Yes Herring Individual Animal Logging 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 IAL_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this individual animal log 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 individual animal log event record occurred. NUMBER 5 LATITUDE NUMBER 9 Yes No 9 4 Active Latitude where this individual animal log event occurred as determined by the video reviewer. Actual latitude as defined by when the individual animal log event occurred may be different than this latitude. NUMBER 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this individual animal log event occurred as determined by the video reviewer. Actual longitude as defined by when the individual animal log event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this individual animal log event occurred as determined by the video reviewer. Actual time as defined by when the individual animal log incident 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 SPECIES_CODE VARCHAR2 4 Yes No Active Species code for this individual animal log as determined by the video reviewer. Actual species code as may be different than this species code. See the EMSPECIES table for a list of species codes and their definitions. VARCHAR2 14 NOTES VARCHAR2 500 Yes No Active Comments provided by the reviewer during the video review process. VARCHAR2 54851 HER_PSI Published / External Completed Herring Protected Species Incident Event Spreadsheet Yes Herring Protected Species Incident 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 PSI_ID NUMBER 3 Yes No 3 0 Active Unique identifier for this protected species incident 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 protected species incident event record occurred. NUMBER 5 LATITUDE NUMBER Yes No 9 4 Active Latitude where this protected species incident event occurred as determined by the video reviewer. Actual latitude as defined by when the protected species incident event occurred may be different than this latitude. 6 LONGITUDE NUMBER 9 Yes No 9 4 Active Longitude where this protected species incident event occurred as determined by the video reviewer. Actual longitude as defined by when the protected species incident event occurred may be different than this longitude. NUMBER 7 TIME NUMBER 16 Yes No 16 2 Active Date and time that this protected species incident event occurred as determined by the video reviewer. Actual time as defined by when the protected species incident 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 EVENT_TYPE VARCHAR2 1 Yes No Active Event type for this protected species incident. See the PSI_EVENT_TYPES table for a list of protected species incident event type codes and their definitions. VARCHAR2 14 SPECIES_CODE VARCHAR2 4 Yes No Active Species code for this protected species incident as determined by the video reviewer. Actual species code as may be different than this species code. See the EMSPECIES table for a list of species codes and their definitions. VARCHAR2 15 NOTES VARCHAR2 500 Yes No Active Comments provided by the reviewer during the video review process. VARCHAR2 54931 EMPORT Published / External Completed Port Codes Look Up Table 1 PORT_CODE VARCHAR2 6 Yes Yes Active Code for this port. 2 PORT_NAME VARCHAR2 25 Yes No Active Name for this port. 3 STATE_ABBR VARCHAR2 2 No No Active Abbreviation for the state in which this port is located. 4 COUNTY VARCHAR2 30 No No Active Name of the county in which this port is located. 54932 PSI_EVENT_TYPES Published / External Completed Protected Species Interaction Event Type Codes Look Up Table 1 PROTECTED_SPECIES_INTERACTION_EVENT_TYPE_CODE VARCHAR2 1 Yes Yes Active Code for this protected species interaction event type. 2 PROTECTED_SPECIES_INTERACTION_EVENT_TYPE VARCHAR2 30 Yes No Active Description for this protected species interaction event type. 54933 TRIPLEX_USED Published / External Completed Triplex Used Type Codes Look Up Table 1 TRIPLEX_USED_CODE (PK) VARCHAR2 1 Yes Yes Active Code for this triplex used type. 2 TRIPLEX_USED VARCHAR2 20 Yes No Active Description for this triplex used type. Data Steward 2025 Person Tholke, Chris chris.tholke@noaa.gov 166 Water Street Woods Hole MA 02543 (508) 495-2024 Data Steward 2018 2024 Person Shield, Gina Gina.Shield@noaa.gov 25 Bernard East Saint Jean Drive East Falmouth MA 02536 508-495-2139 508-495-2124 Distributor 2018 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Metadata Contact 2018 Person Rossi, Nichole A nichole.rossi@noaa.gov 25 Bernard East Saint Jean Drive East Falmouth MA 02536 5084952128 Originator 2018 Organization Northeast Fisheries Science Center NEFSC https://ror.org/02nc0ck44 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.fisheries.noaa.gov/about/northeast-fisheries-science-center NEFSC Home Page Online Resource 8:00 a.m. to 4:30 p.m. Monday - Friday Point of Contact 2025 Person Tholke, Chris chris.tholke@noaa.gov 166 Water Street Woods Hole MA 02543 (508) 495-2024 Point of Contact 2018 2024 Person Martins, Amy amy.martins@noaa.gov 25 Bernard East Saint Jean Drive East Falmouth MA 02536 508-495-2266 -74 -66 44.5 39 New England and Mid-Atlantic Range 2016-10-01 2017-12-01 Custom Sensitive NEFSC Data Access Procedure: 1. Formal request in writing usually to the data owner/contact or Center Director; 2. Requester is contacted by data owner to review and verify the request content and details for data delivery options. 3. If data is confidential then owner will determine if the data may be released to the requester; 4. If data can be released, the data is downloaded and packaged for delivery electronically; or the requester may be directed to where the data is available online. NEFSC Data Access Constraint: Access as allowed by Magnuson-Stevens Fisheries Conservation and Management Act to only NMFS staff, Council staff, State Fisheries staff or other Federal staff responsible for fisheries management and enforcement. If data is stored on an internal NEFSC network, the requester may not have direct access to query the data unless they are also authorized for network access. Data can only be released to the general public in an aggregated format in order to protect the identity and business practices of the vessel/permit owner. Oracle database, centralized data management Data has limited quality control. Multiple reviews were compared as a part of the analysis. Corrections are ongoing. Yes Unknown Yes Yes ~1 year Other unknown Archival of source data preserving unaltered collected data, Scheduled backups, Remote storage backups, Password protection Video and sensor data is collected on vessels. Data is reviewed by trained third party and NMFS reviewers. Data is uploaded from reviews to oracle tables (EMREVIEW). 54820 Entity 54821 Entity 54822 Entity 54823 Entity 54824 Entity 54931 Entity 54825 Entity 54826 Entity 54827 Entity 54801 Entity 54802 Entity 54803 Entity 54804 Entity 54814 Entity 54815 Entity 54805 Entity 54816 Entity 54806 Entity 54807 Entity 54808 Entity 54809 Entity 54850 Entity 54817 Entity 54818 Entity 54851 Entity 54810 Entity 54811 Entity 54819 Entity 54812 Entity 54813 Entity 54828 Entity 54829 Entity 54830 Entity 54932 Entity 54831 Entity 54832 Entity 54833 Entity 54834 Entity 54933 Entity 54835 Entity 54836 Entity gov.noaa.nmfs.inport:53562 Patricia Jones 2018-09-06T16:50:11 SysAdmin InPortAdmin 2026-03-04T19:17:17 2018-09-10 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 No 2018-09-10 1 Year 2019-09-10