Metadata Rubric

99%

5.92 / 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_DISCARD

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Records the count of fish/lobsters discarded during a fishing trip.

Description

Records the count of fish/lobsters discarded during a fishing trip.

Entity Type
Data Table

Data Attribute / Type	Description
TRIP_DISCARD_ID NUMBER	Primary key for this table.
TRIP_ID NUMBER	FK to Trip.
TRIP_GEAR_TYPE_ID NUMBER	FK to optional gear type.
FISH_LIVE_CNT NUMBER	The number (count) of live fish discarded during the trip, regardless of species.
FISH_DEAD_CNT NUMBER	The number (count) of dead fish discarded during the trip, regardless of species.
LOBSTER_LIVE_CNT NUMBER	The number (count) of live lobster discarded during the trip.
LOBSTER_DEAD_CNT NUMBER	The number (count) of dead lobster discarded during the trip.
LU_DT DATE	Last update date.
LU_USER_ID NUMBER	Last update user.
OTHER_CNT NUMBER	The number (count) of unspecified species discard ed during the trip.
CREATED_DT DATE	Control column giving timestamp of records creation
CREATED_BY_USER_ID NUMBER

Data Attribute / Type

Description

TRIP_DISCARD_ID
NUMBER

Primary key for this table.

TRIP_ID
NUMBER

FK to Trip.

TRIP_GEAR_TYPE_ID
NUMBER

FK to optional gear type.

FISH_LIVE_CNT
NUMBER

The number (count) of live fish discarded during the trip, regardless of species.

FISH_DEAD_CNT
NUMBER

The number (count) of dead fish discarded during the trip, regardless of species.

LOBSTER_LIVE_CNT
NUMBER

The number (count) of live lobster discarded during the trip.

LOBSTER_DEAD_CNT
NUMBER

The number (count) of dead lobster discarded during the trip.

LU_DT
DATE

Last update date.

LU_USER_ID
NUMBER

Last update user.

OTHER_CNT
NUMBER

The number (count) of unspecified species discard ed during the trip.

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_DISCARD
Short Name:	TRIP_DISCARD
Status:	Completed
Abstract:	Records the count of fish/lobsters discarded during a fishing trip.
Notes:	Loaded by batch 7533, 11-05-2015 16:10

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	CCL
Description:	Records the count of fish/lobsters discarded during a fishing trip.

Attribute Summary

	Name	Type	Description
100	TRIP_DISCARD_ID	NUMBER	Primary key for this table.
100	TRIP_ID	NUMBER	FK to Trip.
100	TRIP_GEAR_TYPE_ID	NUMBER	FK to optional gear type.
100	FISH_LIVE_CNT	NUMBER	The number (count) of live fish discarded during the trip, regardless of species.
100	FISH_DEAD_CNT	NUMBER	The number (count) of dead fish discarded during the trip, regardless of species.
100	LOBSTER_LIVE_CNT	NUMBER	The number (count) of live lobster discarded during the trip.
100	LOBSTER_DEAD_CNT	NUMBER	The number (count) of dead lobster discarded during the trip.
100	LU_DT	DATE	Last update date.
100	LU_USER_ID	NUMBER	Last update user.
100	OTHER_CNT	NUMBER	The number (count) of unspecified species discard ed during the trip.
100	CREATED_DT	DATE	Control column giving timestamp of records creation
67	CREATED_BY_USER_ID	NUMBER

Name

Type

Description

100

TRIP_DISCARD_ID

NUMBER

Primary key for this table.

100

TRIP_ID

NUMBER

FK to Trip.

100

TRIP_GEAR_TYPE_ID

NUMBER

FK to optional gear type.

100

FISH_LIVE_CNT

NUMBER

The number (count) of live fish discarded during the trip, regardless of species.

100

FISH_DEAD_CNT

NUMBER

The number (count) of dead fish discarded during the trip, regardless of species.

100

LOBSTER_LIVE_CNT

NUMBER

The number (count) of live lobster discarded during the trip.

100

LOBSTER_DEAD_CNT

NUMBER

The number (count) of dead lobster discarded during the trip.

100

LU_DT

DATE

Last update date.

100

LU_USER_ID

NUMBER

Last update user.

100

OTHER_CNT

NUMBER

The number (count) of unspecified species discard ed during the trip.

100

CREATED_DT

DATE

Control column giving timestamp of records creation

CREATED_BY_USER_ID

NUMBER

Attribute Details

TRIP_DISCARD_ID

CC ID: 247102

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

TRIP_ID

CC ID: 247100

Seq. Order:	2
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	No
Status:	Active
Description:	FK to Trip.
General Data Type:	NUMBER
Foreign Key Relations:	CCL.TRIP

TRIP_GEAR_TYPE_ID

CC ID: 247101

Seq. Order:	3
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	FK to optional gear type.
General Data Type:	NUMBER
Foreign Key Relations:	CCL.TRIP_GEAR_TYPE

FISH_LIVE_CNT

CC ID: 247106

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The number (count) of live fish discarded during the trip, regardless of species.
General Data Type:	NUMBER

FISH_DEAD_CNT

CC ID: 247107

Seq. Order:	5
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The number (count) of dead fish discarded during the trip, regardless of species.
General Data Type:	NUMBER

LOBSTER_LIVE_CNT

CC ID: 247108

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The number (count) of live lobster discarded during the trip.
General Data Type:	NUMBER

LOBSTER_DEAD_CNT

CC ID: 247109

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	The number (count) of dead lobster discarded during the trip.
General Data Type:	NUMBER

LU_DT

CC ID: 247110

Seq. Order:	8
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: 247111

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

OTHER_CNT

CC ID: 247103

Seq. Order:	10
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	38
Status:	Active
Description:	The number (count) of unspecified species discard ed during the trip.
General Data Type:	NUMBER

CREATED_DT

CC ID: 247104

Seq. Order:	11
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: 247105

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

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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_DISCARD_ID

TRIP_ID

TRIP_GEAR_TYPE_ID

FISH_LIVE_CNT

FISH_DEAD_CNT

LOBSTER_LIVE_CNT

LOBSTER_DEAD_CNT

LU_DT

LU_USER_ID

OTHER_CNT

CREATED_DT

CREATED_BY_USER_ID

Catalog Details