HER_PUMP_STOP
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 54810
| Published / External
Created: 2018-11-13
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 53562
ID: 54810
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | HER_PUMP_STOP |
---|---|
Short Name | HER_PUMP_STOP |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Herring Pumping Stop Event |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Spreadsheet |
---|---|
Active Version? | Y |
Alias | |
Schema Name | |
» Description |
Herring Pumping Stop Event |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | No | TRIP_ID | NUMBER | Unique trip identifier generated when the data is loaded to Oracle raw tables. |
100 | Yes | No | 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 | Yes | No | 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 | No | No | HAUL_NUMBER | NUMBER | Fishing event haul number in which this pump stop event occurred. |
100 | Yes | No | 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 | Yes | No | 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 | Yes | No | 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 | No | No | DATE_TIME_UTC | VARCHAR2 | UTC translation of TIME |
100 | No | No | YEAR_UTC | VARCHAR2 | Extract UTC year from TIME |
100 | No | No | MONTH_UTC | VARCHAR2 | Extract UTC month from TIME |
100 | No | No | DAY_UTC | VARCHAR2 | Extract UTC day from TIME |
100 | No | No | TIME_UTC | VARCHAR2 | Extract UTC time from TIME |
100 | No | No | NOTES | VARCHAR2 | Comments provided by the reviewer during the video review process. |
100 | No | No | 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
Attribute Name | TRIP_ID |
---|---|
Seq. Order | 1 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REVIEWER_ID |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PSE_ID |
---|---|
Seq. Order | 3 |
Data Storage Type | NUMBER |
Max Length | 3 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HAUL_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | NUMBER |
Max Length | 6 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE |
---|---|
Seq. Order | 5 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE |
---|---|
Seq. Order | 6 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME |
---|---|
Seq. Order | 7 |
Data Storage Type | NUMBER |
Max Length | 16 |
Min Length | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DATE_TIME_UTC |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 19 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UTC translation of TIME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEAR_UTC |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC year from TIME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONTH_UTC |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC month from TIME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DAY_UTC |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC day from TIME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TIME_UTC |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC time from TIME |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NOTES |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Comments provided by the reviewer during the video review process. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PUMP_STOP_REASON_CODE_STR |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
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 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 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 Workflow State | Published / External |
Metadata Last Review Date | 2018-11-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2019-11-13 |
Tags |
---|