Metadata Rubric

100%

6 / 6

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

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

	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.

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