Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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 Information

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

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

Item Identification

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 Information

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

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key 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

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 Details

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