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_SYS_PERF

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

Summary

Abstract

Herring System Performance Issue Event

Description

Herring System Performance Issue 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.
SPI_ID
NUMBER 		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.
HAUL_NUMBER
NUMBER 		Fishing event haul number in which this system performance issue event record occurred.
BEGIN_TIME
NUMBER 		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.
BEGIN_DATE_TIME_UTC
VARCHAR2 		UTC translation of BEGIN_TIME
BEGIN_YEAR_UTC
VARCHAR2 		Extract UTC year from BEGIN_TIME
BEGIN_MONTH_UTC
VARCHAR2 		Extract UTC month from BEGIN_TIME
BEGIN_DAY_UTC
VARCHAR2 		Extract UTC day from BEGIN_TIME
BEGIN_TIME_UTC
VARCHAR2 		Extract UTC time from BEGIN_TIME
END_TIME
NUMBER 		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.
END_DATE_TIME_UTC
VARCHAR2 		UTC translation of END_TIME
END_YEAR_UTC
VARCHAR2 		Extract UTC year from END_TIME
END_MONTH_UTC
VARCHAR2 		Extract UTC month from END_TIME
END_DAY_UTC
VARCHAR2 		Extract UTC day from END_TIME
END_TIME_UTC
VARCHAR2 		Extract UTC time from END_TIME
BEGIN_LATITUDE
NUMBER 		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.
BEGIN_LONGITUDE
NUMBER 		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.
END_LATITUDE
NUMBER 		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.
END_LONGITUDE
NUMBER 		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.
NOTES
VARCHAR2 		Comments provided by the reviewer during the video review process.
PERFORMANCE_ISSUE_TYPE_STR
VARCHAR2 		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.

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_SYS_PERF
Short Name: HER_SYS_PERF
Status: Completed
Abstract:

Herring System Performance Issue Event

Entity Information

Entity Type: Spreadsheet
Active Version?: Yes
Description:

Herring System Performance Issue 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
 SPI_ID NUMBER 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.
100
 HAUL_NUMBER NUMBER Fishing event haul number in which this system performance issue event record occurred.
100
 BEGIN_TIME NUMBER 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.
100
 BEGIN_DATE_TIME_UTC VARCHAR2 UTC translation of BEGIN_TIME
100
 BEGIN_YEAR_UTC VARCHAR2 Extract UTC year from BEGIN_TIME
100
 BEGIN_MONTH_UTC VARCHAR2 Extract UTC month from BEGIN_TIME
100
 BEGIN_DAY_UTC VARCHAR2 Extract UTC day from BEGIN_TIME
100
 BEGIN_TIME_UTC VARCHAR2 Extract UTC time from BEGIN_TIME
100
 END_TIME NUMBER 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.
100
 END_DATE_TIME_UTC VARCHAR2 UTC translation of END_TIME
100
 END_YEAR_UTC VARCHAR2 Extract UTC year from END_TIME
100
 END_MONTH_UTC VARCHAR2 Extract UTC month from END_TIME
100
 END_DAY_UTC VARCHAR2 Extract UTC day from END_TIME
100
 END_TIME_UTC VARCHAR2 Extract UTC time from END_TIME
100
 BEGIN_LATITUDE NUMBER 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.
100
 BEGIN_LONGITUDE NUMBER 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.
100
 END_LATITUDE NUMBER 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.
100
 END_LONGITUDE NUMBER 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.
100
 NOTES VARCHAR2 Comments provided by the reviewer during the video review process.
100
 PERFORMANCE_ISSUE_TYPE_STR VARCHAR2 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.

Attribute Details

TRIP_ID

CC ID: 798962
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: 798963
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

SPI_ID

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

HAUL_NUMBER

CC ID: 798965
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 system performance issue event record occurred.
General Data Type: NUMBER

BEGIN_TIME

CC ID: 798966
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 16
Required: Yes
Primary Key: No
Precision: 16
Scale: 2
Status: Active
Description:

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

BEGIN_DATE_TIME_UTC

CC ID: 798967
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

UTC translation of BEGIN_TIME
General Data Type: VARCHAR2

BEGIN_YEAR_UTC

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

Extract UTC year from BEGIN_TIME
General Data Type: VARCHAR2

BEGIN_MONTH_UTC

CC ID: 798969
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC month from BEGIN_TIME
General Data Type: VARCHAR2

BEGIN_DAY_UTC

CC ID: 798970
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC day from BEGIN_TIME
General Data Type: VARCHAR2

BEGIN_TIME_UTC

CC ID: 798971
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC time from BEGIN_TIME
General Data Type: VARCHAR2

END_TIME

CC ID: 798972
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 16
Required: Yes
Primary Key: No
Precision: 16
Scale: 2
Status: Active
Description:

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

END_DATE_TIME_UTC

CC ID: 798973
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 19
Required: No
Primary Key: No
Status: Active
Description:

UTC translation of END_TIME
General Data Type: VARCHAR2

END_YEAR_UTC

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

Extract UTC year from END_TIME
General Data Type: VARCHAR2

END_MONTH_UTC

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

Extract UTC month from END_TIME
General Data Type: VARCHAR2

END_DAY_UTC

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

Extract UTC day from END_TIME
General Data Type: VARCHAR2

END_TIME_UTC

CC ID: 798977
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Extract UTC time from END_TIME
General Data Type: VARCHAR2

BEGIN_LATITUDE

CC ID: 798978
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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

BEGIN_LONGITUDE

CC ID: 798979
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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

END_LATITUDE

CC ID: 798980
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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

END_LONGITUDE

CC ID: 798981
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 4
Status: Active
Description:

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

NOTES

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

Comments provided by the reviewer during the video review process.
General Data Type: VARCHAR2

PERFORMANCE_ISSUE_TYPE_STR

CC ID: 798983
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

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.
General Data Type: VARCHAR2

Catalog Details

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