Metadata Rubric

100%

6 / 6

NEFSC Metadata Library > Fishery Monitoring & Research Division (FMRD) > Northeast Cooperative Research Program (NCRP) > Northeast Regional Cod Tagging Program >

Table: GMRI_COD_TRIP

Entity (ENT) | Northeast Fisheries Science Center (NEFSC)
GUID: gov.noaa.nmfs.inport:34411 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Information about each trip.

Description

Information about each trip.

Entity Type
Data Table

Data Attribute / Type	Description
TRIP_ID NUMBER	Unique ID
VESSEL_ID NUMBER	Vessel used for trip – from COD_VESSEL LUT
ORGANIZATION_ID NUMBER	Organization associated with trip – from COD_ORGANIZATION LUT
GEAR_ID NUMBER	Type of gear used – from COD_GEAR LUT
TAGGING_AREA_ID NUMBER	Location of trip – from COD_TAGGING_AREA LUT
DEPTH_UNIT_ID NUMBER	Depth measuring units – from COD_UNIT LUT
TEMP_UNIT_ID NUMBER	Temperature measuring units – from COD_UNIT LUT
LOCATION_UNIT_ID NUMBER	Location coordinates type – from COD_UNIT LUT
LOCATION_FORMAT_UNIT_ID NUMBER	When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT
TRIP_NUMBER NUMBER	User assigned
CAPTAIN VARCHAR2	Names of vessel captain and crew (redacted)
START_DATE DATE	Date trip began
END_DATE DATE	Date trip ended
LORAN_CHAIN NUMBER	LORAN chain number
PENDING NUMBER	0= Trip information approved 1= Trip information pending admin approval
REQUESTED_APPROVAL NUMBER	0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved)
COUNT_TAGGED NUMBER	Number of fish tagged per trip
COUNT_NONTAGGED NUMBER	Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish)

Data Attribute / Type

Description

TRIP_ID
NUMBER

Unique ID

VESSEL_ID
NUMBER

Vessel used for trip – from COD_VESSEL LUT

ORGANIZATION_ID
NUMBER

Organization associated with trip – from COD_ORGANIZATION LUT

GEAR_ID
NUMBER

Type of gear used – from COD_GEAR LUT

TAGGING_AREA_ID
NUMBER

Location of trip – from COD_TAGGING_AREA LUT

DEPTH_UNIT_ID
NUMBER

Depth measuring units – from COD_UNIT LUT

TEMP_UNIT_ID
NUMBER

Temperature measuring units – from COD_UNIT LUT

LOCATION_UNIT_ID
NUMBER

Location coordinates type – from COD_UNIT LUT

LOCATION_FORMAT_UNIT_ID
NUMBER

When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT

TRIP_NUMBER
NUMBER

User assigned

CAPTAIN
VARCHAR2

Names of vessel captain and crew (redacted)

START_DATE
DATE

Date trip began

END_DATE
DATE

Date trip ended

LORAN_CHAIN
NUMBER

LORAN chain number

PENDING
NUMBER

0= Trip information approved 1= Trip information pending admin approval

REQUESTED_APPROVAL
NUMBER

0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved)

COUNT_TAGGED
NUMBER

Number of fish tagged per trip

COUNT_NONTAGGED
NUMBER

Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish)

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (NEFSC) for inquiries on this record.

Title:	Table: GMRI_COD_TRIP
Short Name:	GMRI_COD_TRIP
Status:	Completed
Abstract:	Information about each trip.
Notes:	Loaded by batch 9211, 08-23-2016 14:45

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CO_OP_RESEARCH
Description:	Information about each trip.

Attribute Summary

	Name	Type	Description
100	TRIP_ID	NUMBER	Unique ID
100	VESSEL_ID	NUMBER	Vessel used for trip – from COD_VESSEL LUT
100	ORGANIZATION_ID	NUMBER	Organization associated with trip – from COD_ORGANIZATION LUT
100	GEAR_ID	NUMBER	Type of gear used – from COD_GEAR LUT
100	TAGGING_AREA_ID	NUMBER	Location of trip – from COD_TAGGING_AREA LUT
100	DEPTH_UNIT_ID	NUMBER	Depth measuring units – from COD_UNIT LUT
100	TEMP_UNIT_ID	NUMBER	Temperature measuring units – from COD_UNIT LUT
100	LOCATION_UNIT_ID	NUMBER	Location coordinates type – from COD_UNIT LUT
100	LOCATION_FORMAT_UNIT_ID	NUMBER	When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT
100	TRIP_NUMBER	NUMBER	User assigned
100	CAPTAIN	VARCHAR2	Names of vessel captain and crew (redacted)
100	START_DATE	DATE	Date trip began
100	END_DATE	DATE	Date trip ended
100	LORAN_CHAIN	NUMBER	LORAN chain number
100	PENDING	NUMBER	0= Trip information approved 1= Trip information pending admin approval
100	REQUESTED_APPROVAL	NUMBER	0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved)
100	COUNT_TAGGED	NUMBER	Number of fish tagged per trip
100	COUNT_NONTAGGED	NUMBER	Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish)

Name

Type

Description

100

TRIP_ID

NUMBER

Unique ID

100

VESSEL_ID

NUMBER

Vessel used for trip – from COD_VESSEL LUT

100

ORGANIZATION_ID

NUMBER

Organization associated with trip – from COD_ORGANIZATION LUT

100

GEAR_ID

NUMBER

Type of gear used – from COD_GEAR LUT

100

TAGGING_AREA_ID

NUMBER

Location of trip – from COD_TAGGING_AREA LUT

100

DEPTH_UNIT_ID

NUMBER

Depth measuring units – from COD_UNIT LUT

100

TEMP_UNIT_ID

NUMBER

Temperature measuring units – from COD_UNIT LUT

100

LOCATION_UNIT_ID

NUMBER

Location coordinates type – from COD_UNIT LUT

100

LOCATION_FORMAT_UNIT_ID

NUMBER

When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT

100

TRIP_NUMBER

NUMBER

User assigned

100

CAPTAIN

VARCHAR2

Names of vessel captain and crew (redacted)

100

START_DATE

DATE

Date trip began

100

END_DATE

DATE

Date trip ended

100

LORAN_CHAIN

NUMBER

LORAN chain number

100

PENDING

NUMBER

0= Trip information approved 1= Trip information pending admin approval

100

REQUESTED_APPROVAL

NUMBER

0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved)

100

COUNT_TAGGED

NUMBER

Number of fish tagged per trip

100

COUNT_NONTAGGED

NUMBER

Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish)

Attribute Details

TRIP_ID

CC ID: 345584

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Unique ID
General Data Type:	NUMBER

VESSEL_ID

CC ID: 345594

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Vessel used for trip – from COD_VESSEL LUT
General Data Type:	NUMBER

ORGANIZATION_ID

CC ID: 345595

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Organization associated with trip – from COD_ORGANIZATION LUT
General Data Type:	NUMBER

GEAR_ID

CC ID: 345596

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Type of gear used – from COD_GEAR LUT
General Data Type:	NUMBER

TAGGING_AREA_ID

CC ID: 345597

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Location of trip – from COD_TAGGING_AREA LUT
General Data Type:	NUMBER

DEPTH_UNIT_ID

CC ID: 345598

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Depth measuring units – from COD_UNIT LUT
General Data Type:	NUMBER

TEMP_UNIT_ID

CC ID: 345599

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Temperature measuring units – from COD_UNIT LUT
General Data Type:	NUMBER

LOCATION_UNIT_ID

CC ID: 345600

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Location coordinates type – from COD_UNIT LUT
General Data Type:	NUMBER

LOCATION_FORMAT_UNIT_ID

CC ID: 345601

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	When the coordinate type is lat/lon, this indicates whether values are written as degrees-minutes-seconds, or degrees-decimal minutes – from COD_UNIT LUT
General Data Type:	NUMBER

TRIP_NUMBER

CC ID: 345585

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	User assigned
General Data Type:	NUMBER

CAPTAIN

CC ID: 345586

Seq. Order:	11
Data Storage Type:	VARCHAR2
Max Length:	1020
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Names of vessel captain and crew (redacted)
General Data Type:	VARCHAR2

START_DATE

CC ID: 345587

Seq. Order:	12
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date trip began
General Data Type:	DATE

END_DATE

CC ID: 345588

Seq. Order:	13
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date trip ended
General Data Type:	DATE

LORAN_CHAIN

CC ID: 345589

Seq. Order:	14
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	LORAN chain number
General Data Type:	NUMBER

PENDING

CC ID: 345590

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	0= Trip information approved 1= Trip information pending admin approval
General Data Type:	NUMBER

REQUESTED_APPROVAL

CC ID: 345591

Seq. Order:	16
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	0= Not submitted for approval 1= Approval request submitted (this value stays even after approval, even if the trip is later unapproved)
General Data Type:	NUMBER

COUNT_TAGGED

CC ID: 345592

Seq. Order:	17
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Number of fish tagged per trip
General Data Type:	NUMBER

COUNT_NONTAGGED

CC ID: 345593

Seq. Order:	18
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	11
Scale:	0
Status:	Active
Description:	Number of fish assigned a non-tag ID per trip (e.g. poor condition, undersized fish)
General Data Type:	NUMBER

Catalog Item ID:	34411
GUID:	gov.noaa.nmfs.inport:34411
Metadata Record Created By:	Patricia L Jones
Metadata Record Created:	2016-08-23 14:45+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

Table: GMRI_COD_TRIP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_ID

VESSEL_ID

ORGANIZATION_ID

GEAR_ID

TAGGING_AREA_ID

DEPTH_UNIT_ID

TEMP_UNIT_ID

LOCATION_UNIT_ID

LOCATION_FORMAT_UNIT_ID

TRIP_NUMBER

CAPTAIN

START_DATE

END_DATE

LORAN_CHAIN

PENDING

REQUESTED_APPROVAL

COUNT_TAGGED

COUNT_NONTAGGED

Catalog Details