Table: MRHAUL
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33878
| Published / External
Created: 2016-08-01
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 27387
ID: 33878
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: MRHAUL |
---|---|
Short Name | MRHAUL |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Haul or Tow Information |
* Purpose | |
Notes |
Loaded by batch 9110, 08-01-2016 12:11 |
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 | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | MRDBS |
» Description |
Haul or Tow Information |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | Yes | Yes | FISHERY | VARCHAR2 | Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. |
100 | Yes | Yes | TRIPID | VARCHAR2 | Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. |
100 | Yes | Yes | HAULNUM | VARCHAR2 | Ordinal number of the haul within the trip, set number for shark cruises. |
100 | No | No | HAULDATE | DATE | Haul date. |
100 | No | No | BEGINTIME | VARCHAR2 | Beginning time for haul (24 hr.). |
100 | No | No | ENDTIME | VARCHAR2 | Ending time for haul (24 hr.). |
100 | No | No | HAULTIMEZONE | VARCHAR2 | Time zone used for begin and end time. |
100 | No | No | BEGLATDEG | VARCHAR2 | Beginning latitude degrees. (redacted) |
100 | No | No | BEGLATMIN | VARCHAR2 | Beginning latitude minutes. (redacted) |
100 | No | No | BEGLATSEC | VARCHAR2 | Beginning latitude seconds. (redacted) |
100 | No | No | ENDLATDEG | VARCHAR2 | Ending latitude degrees. (redacted) |
100 | No | No | ENDLATMIN | VARCHAR2 | Ending latitude minutes. (redacted) |
100 | No | No | ENDLATSEC | VARCHAR2 | Ending latitude seconds. (redacted) |
100 | No | No | MIDLATDEG | VARCHAR2 | Mid-point latitude degrees. (redacted) |
100 | No | No | MIDLATMIN | VARCHAR2 | Mid-point latitude minutes. (redacted) |
100 | No | No | MIDLATSEC | VARCHAR2 | Mid-point latitude seconds. (redacted) |
100 | No | No | BEGLONDEG | VARCHAR2 | Beginning longitude degrees. (redacted) |
100 | No | No | BEGLONMIN | VARCHAR2 | Beginning longitude minutes. (redacted) |
100 | No | No | BEGLONSEC | VARCHAR2 | Beginning longitude seconds. (redacted) |
100 | No | No | ENDLONDEG | VARCHAR2 | Ending longitude degrees. (redacted) |
100 | No | No | ENDLONMIN | VARCHAR2 | Ending longitude minutes. (redacted) |
100 | No | No | ENDLONSEC | VARCHAR2 | Ending longitude seconds. (redacted) |
100 | No | No | MIDLONDEG | VARCHAR2 | Mid-point longitude degrees. (redacted) |
100 | No | No | MIDLONMIN | VARCHAR2 | Mid-point longitude minutes. (redacted) |
100 | No | No | MIDLONSEC | VARCHAR2 | Mid-point longitude seconds. (redacted) |
100 | No | No | STOCK | VARCHAR2 | Stock area calculated from species and statarea, see support table MRSTOCKAREAS for descriptions. |
100 | No | No | STATAREA | VARCHAR2 | Statistical area calculated from latitude and longitude, may override during data entry, note: stat area 551, 552 are in Canadian water. |
100 | No | No | NEMAREA | VARCHAR2 | Inshore area calculated from latitude and longitude. |
100 | No | No | WINDSPEED | NUMBER | Wind speed. |
100 | No | No | WINDSPEEDUOM | VARCHAR2 | Unit of measure used for wind speed (KN, MPH). |
100 | No | No | WINDDIR | NUMBER | Wind direction (degrees). |
100 | No | No | DEPTH | NUMBER | Depth. |
100 | No | No | DEPTHUOM | VARCHAR2 | Unit of measure used for depth (FM,FT,M). |
100 | No | No | TOWSPEED | NUMBER | Tow speed. |
100 | No | No | TOWSPEEDUOM | VARCHAR2 | Unit of measure used for towspeed (KN,MPH). |
100 | No | No | WIREOUT | NUMBER | Wire out. |
100 | No | No | WIREOUTUOM | VARCHAR2 | Unit of measure used for wireout (FM,FT,M). |
100 | No | No | SURFTEMP | NUMBER | Surface water temperature . |
100 | No | No | SURFTEMPUOM | VARCHAR2 | Unit of measure used for surface water temperature (F,C). |
100 | No | No | BOTTEMP | NUMBER | Bottom water temperature. |
100 | No | No | BOTTEMPUOM | VARCHAR2 | Unit of measure used for surface water temperature (F,C). |
100 | No | No | HAULSITE | VARCHAR2 | Haul site code of publicity, see MRSITETYPES for descriptions (primarily used by black sea bass, scup). |
100 | No | No | GEAR | VARCHAR2 | Gear used, see support table MRGEARS for descriptions. |
100 | No | No | HAULCOMMENT | VARCHAR2 | Haul comments. |
100 | No | No | DOE | DATE | Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
100 | No | No | UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. |
100 | No | No | DOC | DATE | Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
100 | No | No | UOC | VARCHAR2 | The Oracle username of the individual who changed the current record. |
100 | No | No | WEB_DOE | DATE | Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). |
100 | No | No | WEB_UOE | VARCHAR2 | The username of the individual who entered the new record using the web application. |
100 | No | No | WEB_DOC | DATE | Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). |
100 | No | No | WEB_UOC | VARCHAR2 | The username of the individual who changed the current record using the web application. |
100 | No | No | ENTSTATAREA | VARCHAR2 | Statistical area as entered from captain's log, note: stat area 551, 552 are in Canadian water. |
100 | No | No | ENTSTOCK | VARCHAR2 | Stock area as entered from captain's log. |
Attribute Details
Attribute Name | FISHERY |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. |
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 |
MRDBS.MRTRIP |
Derivation | |
Validation Rules |
Attribute Name | TRIPID |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. |
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 |
MRDBS.MRTRIP |
Derivation | |
Validation Rules |
Attribute Name | HAULNUM |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | Yes |
Precision | |
Scale | |
Status | Active |
Description |
Ordinal number of the haul within the trip, set number for shark cruises. |
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 | HAULDATE |
---|---|
Seq. Order | 4 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul date. |
General Data Type | DATE |
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 | BEGINTIME |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning time for haul (24 hr.). |
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 | ENDTIME |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending time for haul (24 hr.). |
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 | HAULTIMEZONE |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Time zone used for begin and 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 | BEGLATDEG |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning latitude degrees. (redacted) |
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 | BEGLATMIN |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning latitude minutes. (redacted) |
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 | BEGLATSEC |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning latitude seconds. (redacted) |
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 | ENDLATDEG |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending latitude degrees. (redacted) |
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 | ENDLATMIN |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending latitude minutes. (redacted) |
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 | ENDLATSEC |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending latitude seconds. (redacted) |
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 | MIDLATDEG |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point latitude degrees. (redacted) |
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 | MIDLATMIN |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point latitude minutes. (redacted) |
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 | MIDLATSEC |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point latitude seconds. (redacted) |
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 | BEGLONDEG |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning longitude degrees. (redacted) |
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 | BEGLONMIN |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning longitude minutes. (redacted) |
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 | BEGLONSEC |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Beginning longitude seconds. (redacted) |
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 | ENDLONDEG |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending longitude degrees. (redacted) |
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 | ENDLONMIN |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending longitude minutes. (redacted) |
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 | ENDLONSEC |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ending longitude seconds. (redacted) |
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 | MIDLONDEG |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point longitude degrees. (redacted) |
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 | MIDLONMIN |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point longitude minutes. (redacted) |
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 | MIDLONSEC |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Mid-point longitude seconds. (redacted) |
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 | STOCK |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Stock area calculated from species and statarea, see support table MRSTOCKAREAS for descriptions. |
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 | STATAREA |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Statistical area calculated from latitude and longitude, may override during data entry, note: stat area 551, 552 are in Canadian water. |
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 | NEMAREA |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Inshore area calculated from latitude and longitude. |
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 | WINDSPEED |
---|---|
Seq. Order | 29 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Wind speed. |
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 | WINDSPEEDUOM |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for wind speed (KN, MPH). |
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 | WINDDIR |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 1 |
Status | Active |
Description |
Wind direction (degrees). |
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 | DEPTH |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Depth. |
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 | DEPTHUOM |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for depth (FM,FT,M). |
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 | TOWSPEED |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | 1 |
Status | Active |
Description |
Tow speed. |
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 | TOWSPEEDUOM |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for towspeed (KN,MPH). |
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 | WIREOUT |
---|---|
Seq. Order | 36 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 0 |
Status | Active |
Description |
Wire out. |
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 | WIREOUTUOM |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for wireout (FM,FT,M). |
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 | SURFTEMP |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 3 |
Status | Active |
Description |
Surface water temperature . |
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 | SURFTEMPUOM |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for surface water temperature (F,C). |
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 | BOTTEMP |
---|---|
Seq. Order | 40 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 3 |
Status | Active |
Description |
Bottom water temperature. |
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 | BOTTEMPUOM |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure used for surface water temperature (F,C). |
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 | HAULSITE |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul site code of publicity, see MRSITETYPES for descriptions (primarily used by black sea bass, scup). |
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 |
MRDBS.MRSITETYPES |
Derivation | |
Validation Rules |
Attribute Name | GEAR |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear used, see support table MRGEARS for descriptions. |
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 | HAULCOMMENT |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul comments. |
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 | DOE |
---|---|
Seq. Order | 45 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
General Data Type | DATE |
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 | UOE |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Oracle username of the individual who entered the new record. |
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 | DOC |
---|---|
Seq. Order | 47 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
General Data Type | DATE |
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 | UOC |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Oracle username of the individual who changed the current record. |
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 | WEB_DOE |
---|---|
Seq. Order | 49 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when record was inserted into Oracle by the web application. Date format (DD-MON-YYYY HH24:MI:SS). |
General Data Type | DATE |
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 | WEB_UOE |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The username of the individual who entered the new record using the web application. |
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 | WEB_DOC |
---|---|
Seq. Order | 51 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the current record was updated or changed by the web application. Date format (DD-MON-YYYY HH:MI:SS). |
General Data Type | DATE |
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 | WEB_UOC |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The username of the individual who changed the current record using the web application. |
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 | ENTSTATAREA |
---|---|
Seq. Order | 53 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Statistical area as entered from captain's log, note: stat area 551, 552 are in Canadian water. |
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 | ENTSTOCK |
---|---|
Seq. Order | 54 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Stock area as entered from captain's log. |
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 | 33878 |
---|---|
Metadata Record Created By | Patricia L Jones |
Metadata Record Created | 2016-08-01 12:11+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-02-24 |
Owner Org | NEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-24 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-24 |
Tags |
---|