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_GEAR_TYPE_GEAR
Short Name: TRIP_GEAR_TYPE_GEAR
Status: Completed
Abstract:

Records which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.

Notes:

Loaded by batch 7533, 11-05-2015 16:10

Entity Information

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

Records which gears of the type identified for the trip were used. The USVI logbook paper form allows more than one gear to be recorded for a catch. Such as, "These species were caught using these kinds of Nets." Exmaple: Net - Gill AND Seine.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_GEAR_TYPE_GEAR_ID NUMBER Primary key for this table.
100
TRIP_GEAR_TYPE_ID NUMBER FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
100
GEAR_CD VARCHAR2 FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Control column giving oracle usercode of the last one that changed this record
100
CREATED_DT DATE Control column giving timestamp of records creation
100
CREATED_BY_USER_ID NUMBER Control column giving oracle usercode of records creater

Attribute Details

TRIP_GEAR_TYPE_GEAR_ID

CC ID: 247169
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: 247168
Seq. Order: 2
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.

General Data Type: NUMBER
Foreign Key Relations:

CCL.TRIP_GEAR_TYPE

GEAR_CD

CC ID: 247167
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 30
Required: Yes
Primary Key: No
Status: Active
Description:

FK to TRIP_GEAR_TYPE. Indetified the type of gear used on the fishing trip while catching the TRIP_CATCH species.

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.GEAR_LIST

LU_DT

CC ID: 247170
Seq. Order: 4
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: 247171
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Status: Active
Description:

Control column giving oracle usercode of the last one that changed this record

General Data Type: NUMBER

CREATED_DT

CC ID: 247172
Seq. Order: 6
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: 247173
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Control column giving oracle usercode of records creater

General Data Type: NUMBER

Catalog Details

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