Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

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

Description

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

Entity Information

Entity Type
Data Table

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

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