Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Yellowtail Tagging Data (MRDBS) >

Table: MRTRIP

Entity (ENT)  |  Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:33881  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Trip cruise information

Description

Trip cruise 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].
DATESAIL
DATE 		Date sailed.
DATELAND
DATE 		Date landed.
MRTRIP_CATEGORY
VARCHAR2 		Trip category code, see support table MRTRIPCATEGORY for descriptions. (unused for yellowtail)
HULLNUM
VARCHAR2 		Hull number, USCG doc. or state registration number, see support table MRVESSELS for descriptions. (redacted)
PORT
VARCHAR2 		Port (6-character code), see support table MRPORTS for descriptions.
STATE
VARCHAR2 		State abbreviation code.
CAPTAIN
VARCHAR2 		Name of captain. (redacted)
VTRSERNO
VARCHAR2 		Vessel tracking report serial number. (redacted)
FED_VESS_PERMIT
VARCHAR2 		Federally issued vessel permit number. (redacted)
SHVESSEL
VARCHAR2 		Vessel (used by shark cruises), see support table MRSHVESSELS for descriptions. (unused for yellowtail)
SHNATION
VARCHAR2 		Vessel nation (used by shark cruises), see support table MRNATIONS for descriptions. (unused for yellowtail)
SHOCCUPATION
VARCHAR2 		Occupation (used by shark cruises), see support table MROCCUPATIONS for descriptions. (unused for yellowtail)
TRIPCOMMENTS
VARCHAR2 		Trip 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.

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: MRTRIP
Short Name: MRTRIP
Status: Completed
Abstract:

Trip cruise information
Notes:

Loaded by batch 9110, 08-01-2016 12:11

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: MRDBS
Description:

Trip cruise information

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key FISHERY VARCHAR2 Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions.
100
 Primary Key TRIPID VARCHAR2 Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year].
100
 DATESAIL DATE Date sailed.
100
 DATELAND DATE Date landed.
100
 MRTRIP_CATEGORY VARCHAR2 Trip category code, see support table MRTRIPCATEGORY for descriptions. (unused for yellowtail)
100
 HULLNUM VARCHAR2 Hull number, USCG doc. or state registration number, see support table MRVESSELS for descriptions. (redacted)
100
 PORT VARCHAR2 Port (6-character code), see support table MRPORTS for descriptions.
100
 STATE VARCHAR2 State abbreviation code.
100
 CAPTAIN VARCHAR2 Name of captain. (redacted)
100
 VTRSERNO VARCHAR2 Vessel tracking report serial number. (redacted)
100
 FED_VESS_PERMIT VARCHAR2 Federally issued vessel permit number. (redacted)
100
 SHVESSEL VARCHAR2 Vessel (used by shark cruises), see support table MRSHVESSELS for descriptions. (unused for yellowtail)
100
 SHNATION VARCHAR2 Vessel nation (used by shark cruises), see support table MRNATIONS for descriptions. (unused for yellowtail)
100
 SHOCCUPATION VARCHAR2 Occupation (used by shark cruises), see support table MROCCUPATIONS for descriptions. (unused for yellowtail)
100
 TRIPCOMMENTS VARCHAR2 Trip 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.

Attribute Details

FISHERY

CC ID: 340978
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.MRFISHERY

TRIPID

CC ID: 340991
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

DATESAIL

CC ID: 340996
Seq. Order: 3
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date sailed.
General Data Type: DATE

DATELAND

CC ID: 340997
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date landed.
General Data Type: DATE

MRTRIP_CATEGORY

CC ID: 340979
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Trip category code, see support table MRTRIPCATEGORY for descriptions. (unused for yellowtail)
General Data Type: VARCHAR2
Foreign Key Relations:

MRDBS.MRTRIP_CATEGORY

HULLNUM

CC ID: 340980
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Hull number, USCG doc. or state registration number, see support table MRVESSELS for descriptions. (redacted)
General Data Type: VARCHAR2
Foreign Key Relations:

MRDBS.MRVESSELS

PORT

CC ID: 340998
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 6
Required: No
Primary Key: No
Status: Active
Description:

Port (6-character code), see support table MRPORTS for descriptions.
General Data Type: VARCHAR2

STATE

CC ID: 340999
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

State abbreviation code.
General Data Type: VARCHAR2

CAPTAIN

CC ID: 341000
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of captain. (redacted)
General Data Type: VARCHAR2

VTRSERNO

CC ID: 340981
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Vessel tracking report serial number. (redacted)
General Data Type: VARCHAR2

FED_VESS_PERMIT

CC ID: 340982
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 18
Required: No
Primary Key: No
Status: Active
Description:

Federally issued vessel permit number. (redacted)
General Data Type: VARCHAR2

SHVESSEL

CC ID: 340983
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Vessel (used by shark cruises), see support table MRSHVESSELS for descriptions. (unused for yellowtail)
General Data Type: VARCHAR2

SHNATION

CC ID: 340984
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Vessel nation (used by shark cruises), see support table MRNATIONS for descriptions. (unused for yellowtail)
General Data Type: VARCHAR2

SHOCCUPATION

CC ID: 340985
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Occupation (used by shark cruises), see support table MROCCUPATIONS for descriptions. (unused for yellowtail)
General Data Type: VARCHAR2

TRIPCOMMENTS

CC ID: 340986
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

Trip comments
General Data Type: VARCHAR2

DOE

CC ID: 340987
Seq. Order: 16
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

CC ID: 340988
Seq. Order: 17
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

CC ID: 340989
Seq. Order: 18
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

CC ID: 340990
Seq. Order: 19
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

CC ID: 340992
Seq. Order: 20
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

CC ID: 340993
Seq. Order: 21
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

CC ID: 340994
Seq. Order: 22
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

CC ID: 340995
Seq. Order: 23
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

Catalog Details

Catalog Item ID: 33881
GUID: gov.noaa.nmfs.inport:33881
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