Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: Table: TRIP
Short Name: TRIP
Status: Completed
Abstract:

A unique list of Fishing Trips. One record for each Fishing Trip reported.

Notes:

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

Entity Information

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

A unique list of Fishing Trips. One record for each Fishing Trip reported.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key TRIP_ID NUMBER Primary key for this table.
100
FORM_TEMPLATE_CD VARCHAR2 FK to FORM_TEMPLATE_LIST. Identifies the Form Template (both paper and online) used to record the Fishing Trip information.
100
VESSEL_CD VARCHAR2 Vessel identification value
100
TRIP_DT DATE Trip report date
100
TRIP_TICKET_NUM VARCHAR2 Preprinted Trip Ticket number
100
TRIP_LANDING_LOCATION VARCHAR2 Location where the Trip landed the catch.
100
IS_DATA_TAKEN NUMBER Trip Surveyed/sampled by DFW Sampler
100
IS_DAY_TRIP NUMBER Did the fishing trip take place mainly during the day?.1 = Day fishing trip..
100
IS_FEDERAL_WATERS NUMBER Was the Fishing Trip in Federal Waters. Yes, if more than 3 miles off shore for USVI and more than 9 miles off shore for Puerto Rico.
100
IS_TRIP_LEASED NUMBER Is the Trip leased with paying customers.
100
LU_DT DATE Last update date.
100
LU_USER_ID NUMBER Last update user.
100
TRIP_LANDING_CENTER VARCHAR2 Specific place where the Trip landed the catch (Port for Puerto Rico)
100
TRIP_HELPERS_NUM NUMBER Number of helpers (excluding partners) on the trip
100
USVI_ISLAND_CD CHAR Identifies which island for USVI catch reports..C) St. Croix.T) St. Thomas.J) St. John
100
IS_SPLIT_CATCH NUMBER Did other Permit Holders Split Catch 0 No, 1 Yes
100
TOTAL_TRIP_POUNDS NUMBER Total trip pounds
100
TOTAL_TRAPS_IN_WATER NUMBER Total # of Traps in water
100
IS_INCOMPLETE NUMBER Flag to indicate if the logbook was saved as incomplete.
100
TRIP_TRAPS_DAYS_SOAKED NUMBER Number Of days that the gear was in the water
100
CREATED_DT DATE Date when the record was originally created
100
CREATED_BY_USER_ID NUMBER User who created the record
100
LOGBOOK_RECEIVED_DT DATE Date the logbook was received at the office

Attribute Details

TRIP_ID

CC ID: 247059
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

FORM_TEMPLATE_CD

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

FK to FORM_TEMPLATE_LIST. Identifies the Form Template (both paper and online) used to record the Fishing Trip information.

General Data Type: VARCHAR2
Foreign Key Relations:

CCL.FORM_TEMPLATE_LIST

VESSEL_CD

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

Vessel identification value

General Data Type: VARCHAR2

TRIP_DT

CC ID: 247075
Seq. Order: 4
Data Storage Type: DATE
Max Length: 7
Required: Yes
Primary Key: No
Status: Active
Description:

Trip report date

General Data Type: DATE

TRIP_TICKET_NUM

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

Preprinted Trip Ticket number

General Data Type: VARCHAR2

TRIP_LANDING_LOCATION

CC ID: 247077
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Location where the Trip landed the catch.

General Data Type: VARCHAR2

IS_DATA_TAKEN

CC ID: 247078
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Trip Surveyed/sampled by DFW Sampler

General Data Type: NUMBER

IS_DAY_TRIP

CC ID: 247079
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Did the fishing trip take place mainly during the day?.1 = Day fishing trip..

General Data Type: NUMBER

IS_FEDERAL_WATERS

CC ID: 247080
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Was the Fishing Trip in Federal Waters. Yes, if more than 3 miles off shore for USVI and more than 9 miles off shore for Puerto Rico.

General Data Type: NUMBER

IS_TRIP_LEASED

CC ID: 247060
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Is the Trip leased with paying customers.

General Data Type: NUMBER

LU_DT

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

Last update user.

General Data Type: NUMBER

TRIP_LANDING_CENTER

CC ID: 247063
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 60
Required: No
Primary Key: No
Status: Active
Description:

Specific place where the Trip landed the catch (Port for Puerto Rico)

General Data Type: VARCHAR2

TRIP_HELPERS_NUM

CC ID: 247064
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Number of helpers (excluding partners) on the trip

General Data Type: NUMBER

USVI_ISLAND_CD

CC ID: 247065
Seq. Order: 15
Data Storage Type: CHAR
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Identifies which island for USVI catch reports..C) St. Croix.T) St. Thomas.J) St. John

General Data Type: CHAR

IS_SPLIT_CATCH

CC ID: 247066
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Scale: 0
Status: Active
Description:

Did other Permit Holders Split Catch 0 No, 1 Yes

General Data Type: NUMBER

TOTAL_TRIP_POUNDS

CC ID: 247067
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Total trip pounds

General Data Type: NUMBER

TOTAL_TRAPS_IN_WATER

CC ID: 247068
Seq. Order: 18
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Total # of Traps in water

General Data Type: NUMBER

IS_INCOMPLETE

CC ID: 247069
Seq. Order: 19
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 1
Scale: 0
Status: Active
Description:

Flag to indicate if the logbook was saved as incomplete.

General Data Type: NUMBER

TRIP_TRAPS_DAYS_SOAKED

CC ID: 247070
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 6
Scale: 0
Status: Active
Description:

Number Of days that the gear was in the water

General Data Type: NUMBER

CREATED_DT

CC ID: 247071
Seq. Order: 21
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date when the record was originally created

General Data Type: DATE

CREATED_BY_USER_ID

CC ID: 247072
Seq. Order: 22
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

User who created the record

General Data Type: NUMBER

LOGBOOK_RECEIVED_DT

CC ID: 247073
Seq. Order: 23
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date the logbook was received at the office

General Data Type: DATE

Catalog Details

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