Metadata Rubric

100%

6 / 6

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

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

	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	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.

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

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