HER_PUMP_STOP
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:54810 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | HER_PUMP_STOP |
|---|---|
| Short Name: | HER_PUMP_STOP |
| Status: | Completed |
| Abstract: |
Herring Pumping Stop Event |
Entity Information
| Entity Type: | Spreadsheet |
|---|---|
| Active Version?: | Yes |
| Description: |
Herring Pumping Stop 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
|
PSE_ID | NUMBER | 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. | |
|
100
|
HAUL_NUMBER | NUMBER | Fishing event haul number in which this pump stop event occurred. | |
|
100
|
LATITUDE | NUMBER | 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. | |
|
100
|
LONGITUDE | NUMBER | 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. | |
|
100
|
TIME | NUMBER | 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. | |
|
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
|
NOTES | VARCHAR2 | Comments provided by the reviewer during the video review process. | |
|
100
|
PUMP_STOP_REASON_CODE_STR | VARCHAR2 | 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. |
Attribute Details
TRIP_ID
| 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
| 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 |
PSE_ID
| 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 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. |
| General Data Type: | NUMBER |
HAUL_NUMBER
| 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 pump stop event occurred. |
| General Data Type: | NUMBER |
LATITUDE
| 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 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. |
| General Data Type: | NUMBER |
LONGITUDE
| 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 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. |
| General Data Type: | NUMBER |
TIME
| 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 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. |
| General Data Type: | NUMBER |
DATE_TIME_UTC
| 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
| 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
| 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
| 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
| 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 |
NOTES
| Seq. Order: | 13 |
|---|---|
| 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 |
PUMP_STOP_REASON_CODE_STR
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
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. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 54810 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:54810 |
| 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 |