Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Fisheries Statistics Division > FISHERIES MONITORING > Commercial Catch and Effort > Commercial Landings Project > Commercial Fisheries Landings for U.S. Caribbea... > U.S. Caribbean Commercial Landings (CCL) Tables... >

Table: TRIP

Entity (ENT) | Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:28557 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

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

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

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

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 Type:	Data Table
Active Version?:	Yes
Schema Name:	CCL
Description:	A unique list of Fishing Trips. One record for each Fishing Trip reported.

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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

Table: TRIP

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

TRIP_ID

FORM_TEMPLATE_CD

VESSEL_CD

TRIP_DT

TRIP_TICKET_NUM

TRIP_LANDING_LOCATION

IS_DATA_TAKEN

IS_DAY_TRIP

IS_FEDERAL_WATERS

IS_TRIP_LEASED

LU_DT

LU_USER_ID

TRIP_LANDING_CENTER

TRIP_HELPERS_NUM

USVI_ISLAND_CD

IS_SPLIT_CATCH

TOTAL_TRIP_POUNDS

TOTAL_TRAPS_IN_WATER

IS_INCOMPLETE

TRIP_TRAPS_DAYS_SOAKED

CREATED_DT

CREATED_BY_USER_ID

LOGBOOK_RECEIVED_DT

Catalog Details