HER_TRIP
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 54813
| Published / External
Created: 2018-11-13
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 53562
ID: 54813
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | HER_TRIP |
---|---|
Short Name | HER_TRIP |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Herring Trip Begin and End Events |
* 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 Trip Begin and End Events |
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 | BEGIN_TIME | NUMBER | Date and time that the trip began as determined by the video reviewer. Actual trip begin time as defined by when the vessel departed to go fishing may be different than this date and time. |
100 | No | No | BEGIN_DATE_TIME_UTC | VARCHAR2 | UTC translation of BEG_TIME |
100 | No | No | BEGIN_YEAR_UTC | VARCHAR2 | Extract UTC year from BEG_TIME |
100 | No | No | BEGIN_MONTH_UTC | VARCHAR2 | Extract UTC month from BEG_TIME |
100 | No | No | BEGIN_DAY_UTC | VARCHAR2 | Extract UTC day from BEG_TIME |
100 | No | No | BEGIN_TIME_UTC | VARCHAR2 | Extract UTC time from BEG_TIME |
100 | Yes | No | END_TIME | NUMBER | Date and time that the trip ended as determined by the video reviewer. Actual trip end time as defined by when the vessel returned from fishing may be different than this date and time. |
100 | No | No | END_DATE_TIME_UTC | VARCHAR2 | UTC translation of END_TIME |
100 | No | No | END_YEAR_UTC | VARCHAR2 | Extract UTC year from END_TIME |
100 | No | No | END_MONTH_UTC | VARCHAR2 | Extract UTC month from END_TIME |
100 | No | No | END_DAY_UTC | VARCHAR2 | Extract UTC day from END_TIME |
100 | No | No | END_TIME_UTC | VARCHAR2 | Extract UTC time from END_TIME |
100 | Yes | No | BEGIN_LATITUDE | NUMBER | Beginning latitude where the trip started as determined by the video reviewer. Actual beginning latitude as defined by when the vessel departed to go fishing may be different than this beginning latitude. |
100 | Yes | No | BEGIN_LONGITUDE | NUMBER | Beginning longitude where the trip started as determined by the video reviewer. Actual beginning longitude as defined by when the vessel departed to go fishing may be different than this beginning longitude. |
100 | Yes | No | END_LATITUDE | NUMBER | Ending latitude where the trip ended as determined by the video reviewer. Actual ending latitude as defined by when the vessel returned from fishing may be different than this ending latitude. |
100 | Yes | No | END_LONGITUDE | NUMBER | Ending longitude where the trip ended as determined by the video reviewer. Actual ending longitude as defined by when the vessel returned from fishing may be different than this ending longitude. |
100 | Yes | No | HULLNUM | VARCHAR2 | Federal or State vessel registration number usually visable on the vessel hull. See the EMVESSELS table for a list of vessel registration numbers, names and permit numbers. |
100 | No | No | PERMIT | NUMBER | Federal fishing permit number from EMVESSELS for the hull number for this vessel. |
100 | Yes | No | EVTR_TRIP_NUMBER | NUMBER | Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the primary vessel. |
100 | No | No | EVTR_PAIR_VESSEL_TRIP_NUMBER | NUMBER | Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the paired vessel, if any. |
100 | Yes | No | GEAR | VARCHAR2 | NMFS Northeast gear code. See the OBDBS.OBGEAR code table for a list of codes and their definitions. |
100 | Yes | No | START_PORT | VARCHAR2 | Port code where the trip started from as determined by the video reviewer. Actual starting port as defined by where the vessel departed from may be different than this starting port. See the EMPORT table for a list of port codes and their locations. |
100 | Yes | No | END_PORT | VARCHAR2 | Port code where the trip ended from as determined by the video reviewer. Actual ending port as defined by where the vessel returned to may be different than this ending port. See the EMPORT table for a list of port codes and their locations. |
100 | Yes | No | FISHING_OCCURRED | VARCHAR2 | Whether or not fishing occurred on this trip as determined by the video reviewer. See the FISHING_OCCURRED table for a list of codes and their definitions. |
100 | Yes | No | OBSERVER_ONBOARD | VARCHAR2 | Whether or not there was an observer onboard on this trip as determined by the video reviewer. See the OBSERVER_ONBOARD table for a list of codes and their definitions. |
100 | No | No | NOTES | VARCHAR2 | Comments provided by the reviewer during the video review process. |
100 | No | No | REVIEW_TOTAL_MINUTES | NUMBER | Number of minutes the reviewer took to proces the video and record the meta data. |
100 | Yes | No | REVIEWER_NAME | VARCHAR2 | Name or initals of the reviewer. See the REVIEWERS table for a list of reviewers and their affiliation. |
100 | Yes | No | SLIPPAGE_OCCURRED | VARCHAR2 | Whether or not slippage occurred on this trip as determined by the video reviewer. See the SLIPPAGE_OCCURRED table for a list of codes and their definitions. |
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 | BEGIN_TIME |
---|---|
Seq. Order | 3 |
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 the trip began as determined by the video reviewer. Actual trip begin time as defined by when the vessel departed to go fishing 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 | BEGIN_DATE_TIME_UTC |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 19 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UTC translation of BEG_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 | BEGIN_YEAR_UTC |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC year from BEG_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 | BEGIN_MONTH_UTC |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC month from BEG_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 | BEGIN_DAY_UTC |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC day from BEG_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 | BEGIN_TIME_UTC |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC time from BEG_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 | END_TIME |
---|---|
Seq. Order | 9 |
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 the trip ended as determined by the video reviewer. Actual trip end time as defined by when the vessel returned from fishing 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 | END_DATE_TIME_UTC |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 19 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
UTC translation of END_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 | END_YEAR_UTC |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC year from END_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 | END_MONTH_UTC |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC month from END_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 | END_DAY_UTC |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC day from END_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 | END_TIME_UTC |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Extract UTC time from END_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 | BEGIN_LATITUDE |
---|---|
Seq. Order | 15 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Beginning latitude where the trip started as determined by the video reviewer. Actual beginning latitude as defined by when the vessel departed to go fishing may be different than this beginning 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 | BEGIN_LONGITUDE |
---|---|
Seq. Order | 16 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Beginning longitude where the trip started as determined by the video reviewer. Actual beginning longitude as defined by when the vessel departed to go fishing may be different than this beginning 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 | END_LATITUDE |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Ending latitude where the trip ended as determined by the video reviewer. Actual ending latitude as defined by when the vessel returned from fishing may be different than this ending 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 | END_LONGITUDE |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 9 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 9 |
Scale | 4 |
Status | Active |
Description |
Ending longitude where the trip ended as determined by the video reviewer. Actual ending longitude as defined by when the vessel returned from fishing may be different than this ending 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 | HULLNUM |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Federal or State vessel registration number usually visable on the vessel hull. See the EMVESSELS table for a list of vessel registration numbers, names and permit numbers. |
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 | PERMIT |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Federal fishing permit number from EMVESSELS for the hull number for this vessel. |
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 | EVTR_TRIP_NUMBER |
---|---|
Seq. Order | 21 |
Data Storage Type | NUMBER |
Max Length | 20 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 20 |
Scale | 0 |
Status | Active |
Description |
Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the primary vessel. |
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 | EVTR_PAIR_VESSEL_TRIP_NUMBER |
---|---|
Seq. Order | 22 |
Data Storage Type | NUMBER |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 20 |
Scale | 0 |
Status | Active |
Description |
Federal fishing permit number plus trip start date year, month, day, hour (YYMMDDHH) or paper permit number for the paired vessel, if any. |
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 | GEAR |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NMFS Northeast gear code. See the OBDBS.OBGEAR code table for a list of codes and their definitions. |
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 | START_PORT |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Port code where the trip started from as determined by the video reviewer. Actual starting port as defined by where the vessel departed from may be different than this starting port. See the EMPORT table for a list of port codes and their locations. |
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 | END_PORT |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Port code where the trip ended from as determined by the video reviewer. Actual ending port as defined by where the vessel returned to may be different than this ending port. See the EMPORT table for a list of port codes and their locations. |
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 | FISHING_OCCURRED |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Whether or not fishing occurred on this trip as determined by the video reviewer. See the FISHING_OCCURRED table for a list of codes and their definitions. |
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 | OBSERVER_ONBOARD |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Whether or not there was an observer onboard on this trip as determined by the video reviewer. See the OBSERVER_ONBOARD table for a list of codes and their definitions. |
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 | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 750 |
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 | REVIEW_TOTAL_MINUTES |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Number of minutes the reviewer took to proces the video and record the meta data. |
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_NAME |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 70 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name or initals of the reviewer. See the REVIEWERS table for a list of reviewers and their affiliation. |
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 | SLIPPAGE_OCCURRED |
---|---|
Seq. Order | 31 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Whether or not slippage occurred on this trip as determined by the video reviewer. See the SLIPPAGE_OCCURRED table for a list of codes and their definitions. |
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 | 54813 |
---|---|
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 |
---|