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