Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Herring Protected Species Incident Event

Description

Herring Protected Species Incident 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.
PSI_ID
NUMBER
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.
HAUL_NUMBER
NUMBER
Fishing event haul number in which this protected species incident event record occurred.
LATITUDE
NUMBER
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.
LONGITUDE
NUMBER
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.
TIME
NUMBER
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.
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
EVENT_TYPE
VARCHAR2
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.
SPECIES_CODE
VARCHAR2
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.
NOTES
VARCHAR2
Comments provided by the reviewer during the video review process.

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_PSI
Short Name: HER_PSI
Status: Completed
Abstract:

Herring Protected Species Incident Event

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Herring Protected Species Incident 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
PSI_ID NUMBER 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.
100
HAUL_NUMBER NUMBER Fishing event haul number in which this protected species incident event record occurred.
100
LATITUDE NUMBER 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.
100
LONGITUDE NUMBER 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.
100
TIME NUMBER 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.
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
EVENT_TYPE VARCHAR2 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.
100
SPECIES_CODE VARCHAR2 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.
100
NOTES VARCHAR2 Comments provided by the reviewer during the video review process.

Attribute Details

TRIP_ID

CC ID: 799313
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: 799314
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

PSI_ID

CC ID: 799315
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 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.

General Data Type: NUMBER

HAUL_NUMBER

CC ID: 799316
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 protected species incident event record occurred.

General Data Type: NUMBER

LATITUDE

CC ID: 801031
Seq. Order: 5
Data Storage Type: NUMBER
Required: Yes
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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.

LONGITUDE

CC ID: 799318
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 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.

General Data Type: NUMBER

TIME

CC ID: 799319
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 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.

General Data Type: NUMBER

DATE_TIME_UTC

CC ID: 799320
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: 799321
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: 799322
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: 799323
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: 799324
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

EVENT_TYPE

CC ID: 799325
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: Yes
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

SPECIES_CODE

CC ID: 799326
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 4
Required: Yes
Primary Key: No
Status: Active
Description:

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.

General Data Type: VARCHAR2

NOTES

CC ID: 799327
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 500
Required: Yes
Primary Key: No
Status: Active
Description:

Comments provided by the reviewer during the video review process.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 54851
GUID: gov.noaa.nmfs.inport:54851
Metadata Record Created By: Patricia L Jones
Metadata Record Created: 2018-11-14 08:34+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-11-14
Owner Org: NEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-11-14
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-11-14