Metadata Rubric

99%

5.91 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Caribbean Commercial Landings (CCL) Tables... >

Table: TRIP_CATCH

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28559 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.

Description

Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.

Entity Type
Data Table

Data Attribute / Type	Description
TRIP_CATCH_ID NUMBER	Primary key for this table.
TRIP_GEAR_TYPE_ID NUMBER	FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.
SPECIES_CD VARCHAR2	FK to SPECIES_LIST. Identifies the Species caught on the Trip.
TRIP_GEAR_TYPE_GEAR_ID NUMBER	When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.
CATCH_LBS NUMBER	Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.
PRICE_PER_LBS NUMBER	Records the price per lbs for the fish.
LU_DT DATE	Last update date.
LU_USER_ID NUMBER	Last update user.
CATCH_GUTTED_LBS NUMBER	USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.
CREATED_DT DATE	Control column giving timestamp of records creation
CREATED_BY_USER_ID NUMBER

Data Attribute / Type

Description

TRIP_CATCH_ID
NUMBER

Primary key for this table.

TRIP_GEAR_TYPE_ID
NUMBER

FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.

SPECIES_CD
VARCHAR2

FK to SPECIES_LIST. Identifies the Species caught on the Trip.

TRIP_GEAR_TYPE_GEAR_ID
NUMBER

When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.

CATCH_LBS
NUMBER

Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.

PRICE_PER_LBS
NUMBER

Records the price per lbs for the fish.

LU_DT
DATE

Last update date.

LU_USER_ID
NUMBER

Last update user.

CATCH_GUTTED_LBS
NUMBER

USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.

CREATED_DT
DATE

Control column giving timestamp of records creation

CREATED_BY_USER_ID
NUMBER

No Child Items for this record.

No contact information is available for this record.

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

Title:	Table: TRIP_CATCH
Short Name:	TRIP_CATCH
Status:	Completed
Abstract:	Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
Notes:	Loaded by batch 7533, 11-05-2015 16:10

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CCL
Description:	Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.

Attribute Summary

	Name	Type	Description
100	TRIP_CATCH_ID	NUMBER	Primary key for this table.
100	TRIP_GEAR_TYPE_ID	NUMBER	FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.
100	SPECIES_CD	VARCHAR2	FK to SPECIES_LIST. Identifies the Species caught on the Trip.
100	TRIP_GEAR_TYPE_GEAR_ID	NUMBER	When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.
100	CATCH_LBS	NUMBER	Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.
100	PRICE_PER_LBS	NUMBER	Records the price per lbs for the fish.
100	LU_DT	DATE	Last update date.
100	LU_USER_ID	NUMBER	Last update user.
100	CATCH_GUTTED_LBS	NUMBER	USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.
100	CREATED_DT	DATE	Control column giving timestamp of records creation
67	CREATED_BY_USER_ID	NUMBER

Name

Type

Description

100

TRIP_CATCH_ID

NUMBER

Primary key for this table.

100

TRIP_GEAR_TYPE_ID

NUMBER

FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.

100

SPECIES_CD

VARCHAR2

FK to SPECIES_LIST. Identifies the Species caught on the Trip.

100

TRIP_GEAR_TYPE_GEAR_ID

NUMBER

When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.

100

CATCH_LBS

NUMBER

100

PRICE_PER_LBS

NUMBER

Records the price per lbs for the fish.

100

LU_DT

DATE

Last update date.

100

LU_USER_ID

NUMBER

Last update user.

100

CATCH_GUTTED_LBS

NUMBER

USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.

100

CREATED_DT

DATE

Control column giving timestamp of records creation

CREATED_BY_USER_ID

NUMBER

Attribute Details

TRIP_CATCH_ID

CC ID: 247092

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Primary key for this table.
General Data Type:	NUMBER

TRIP_GEAR_TYPE_ID

CC ID: 247090

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	FK to TRIP_GEAR. Identifies the Gear used to Catch the Species.
General Data Type:	NUMBER
Foreign Key Relations:	CCL.TRIP_GEAR_TYPE

SPECIES_CD

CC ID: 247089

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	Yes
Primary Key:	No
Status:	Active
Description:	FK to SPECIES_LIST. Identifies the Species caught on the Trip.
General Data Type:	VARCHAR2
Foreign Key Relations:	CCL.SPECIES_LIST

TRIP_GEAR_TYPE_GEAR_ID

CC ID: 247091

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	When we know the catch by gear, as apposed to knowing the catch by gear type, we record it here.
General Data Type:	NUMBER
Foreign Key Relations:	CCL.TRIP_GEAR_TYPE_GEAR

CATCH_LBS

CC ID: 247095

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	Records the pounds of fish caught for a particular Catch, Gear, and Species. In Puerto Rico the form does not specify the condition. In the USVI there is a seperate field for gutted lbs. So, for USVI this field (catch_lbs) represents whole.
General Data Type:	NUMBER

PRICE_PER_LBS

CC ID: 247096

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Records the price per lbs for the fish.
General Data Type:	NUMBER

LU_DT

CC ID: 247097

Seq. Order:	7
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Last update date.
General Data Type:	DATE

LU_USER_ID

CC ID: 247098

Seq. Order:	8
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Precision:	38
Status:	Active
Description:	Last update user.
General Data Type:	NUMBER

CATCH_GUTTED_LBS

CC ID: 247099

Seq. Order:	9
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	USVI gutted catch in pounds of fish caught for a particular Catch, Gear, and Species.
General Data Type:	NUMBER

CREATED_DT

CC ID: 247093

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Control column giving timestamp of records creation
General Data Type:	DATE

CREATED_BY_USER_ID

CC ID: 247094

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
General Data Type:	NUMBER

Catalog Item ID:	28559
GUID:	gov.noaa.nmfs.inport:28559
Metadata Record Created By:	Joshua Bennett
Metadata Record Created:	2015-11-05 16:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:11+0000
Metadata Record Published:	2021-05-06
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-06
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-06

Table: TRIP_CATCH

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_CATCH_ID

TRIP_GEAR_TYPE_ID

SPECIES_CD

TRIP_GEAR_TYPE_GEAR_ID

CATCH_LBS

PRICE_PER_LBS

LU_DT

LU_USER_ID

CATCH_GUTTED_LBS

CREATED_DT

CREATED_BY_USER_ID

Catalog Details