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

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 Information

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

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_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: 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