Slide Menu
System Maintenance Notice, Sunday, January 23, 2022 @ 8am-2pm Eastern. The Operations Team will be performing system maintenance on all server environments. During this scheduled downtime, InPort will not be available.
View All
Search Help Show/Hide Menu

Item Identification

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 Information

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.

Data Attributes

Attribute Summary

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

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 Details

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: Lee M Weinberger
Metadata Record Last Modified: 2021-05-06 22:24+0000
Metadata Record Published: 2021-05-06
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-05-07