Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
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_BEGIN_FISHING

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:54802  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: HER_BEGIN_FISHING
Short Name: HER_BEGIN_FISHING
Status: Completed
Abstract:

Herring Begin Fishing Event

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Herring Begin Fishing 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
 BF_ID NUMBER 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.
100
 HAUL_NUMBER NUMBER Fishing event haul number in which this begin fishing event occurred.
100
 LATITUDE NUMBER 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.
100
 LONGITUDE NUMBER 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.
100
 TIME NUMBER 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.
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

Attribute Details

TRIP_ID

CC ID: 798808
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: 798809
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

BF_ID

CC ID: 798810
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 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.
General Data Type: NUMBER

HAUL_NUMBER

CC ID: 798811
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 begin fishing event occurred.
General Data Type: NUMBER

LATITUDE

CC ID: 798812
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 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.
General Data Type: NUMBER

LONGITUDE

CC ID: 798813
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 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.
General Data Type: NUMBER

TIME

CC ID: 798814
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 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.
General Data Type: NUMBER

DATE_TIME_UTC

CC ID: 798815
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: 798816
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: 798817
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: 798818
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: 798819
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

Catalog Details

Catalog Item ID: 54802
GUID: gov.noaa.nmfs.inport:54802
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