Table: TRIP_CATCH
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28559 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Table to store the Catch information by Gear for a Fishing Trip, such as the species caught and how many pounds.
DescriptionTable 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
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 |
Attribute Details
TRIP_CATCH_ID
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
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
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
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
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
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
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
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
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
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
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 |