Metadata Rubric

100%

6 / 6

SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_TRIPS

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

Summary

Item Identification

Physical Location

Entity Info

Data Attributes

Catalog Details

Abstract

Contains trip information per fishing trip.

Description

Contains trip information per fishing trip.

Entity Type
Data Table

Data Attribute / Type	Description
LOGBOOK_KEY NUMBER	Automatic sequence that links all the tables that hold information related to trips.
SCHEDULE_NUMBER VARCHAR2	A number stamped on each logbook form.
VESSEL_ID VARCHAR2	Vessel Identifier
VESSEL_NAME VARCHAR2	Name of the vessel that matches the vessel id.
TELEPHONE VARCHAR2	Phone number that appears on the logbook.
DAYS_FISHED NUMBER	Number of days during which fishing occurred.
DAYS_AWAY NUMBER	Number of days from, departure to landing, the vessel was away from port.
FIRST_SET_DATE DATE	Date on which the first set occurred, i.e., when gear was first deployed.
LAST_SET_DATE DATE	Date on which the last set of gear were retrieved before saling back to port.
LANDING_DATE DATE	Date when the catch was unloaded at a dealer
NUMBER_OF_CREW NUMBER	Number of personnel engaged in fishing during the trip.
CARCASS_WEIGHT_SHEET VARCHAR2	Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached.
FISHED_SAME_DAY VARCHAR2	Indicates whether there were more fishing trips on the same day.
VESSEL_VERIFIED VARCHAR2	Indicates whether the vessel id was verified.
ERRORS_IN_THIS_TABLE VARCHAR2	Validation errors in this record?
ERRORS_IN_THIS_LOGBOOK VARCHAR2	Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook
BATCH_NUMBER VARCHAR2	The batch number is the number of the batch where the trip was processed.
SOURCE_FILE VARCHAR2	Name of the file loaded into the system of which this logbook is a part.
UNLOAD_DATE DATE	Unload Date
TRIP_TICKET VARCHAR2	Trip Ticket Number
FORMTYPE VARCHAR2	The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data
OPERATOR_NAME VARCHAR2	Operator Name
OPERATOR_NUMBER VARCHAR2	Operator Number

Data Attribute / Type

Description

LOGBOOK_KEY
NUMBER

Automatic sequence that links all the tables that hold information related to trips.

SCHEDULE_NUMBER
VARCHAR2

A number stamped on each logbook form.

VESSEL_ID
VARCHAR2

Vessel Identifier

VESSEL_NAME
VARCHAR2

Name of the vessel that matches the vessel id.

TELEPHONE
VARCHAR2

Phone number that appears on the logbook.

DAYS_FISHED
NUMBER

Number of days during which fishing occurred.

DAYS_AWAY
NUMBER

Number of days from, departure to landing, the vessel was away from port.

FIRST_SET_DATE
DATE

Date on which the first set occurred, i.e., when gear was first deployed.

LAST_SET_DATE
DATE

Date on which the last set of gear were retrieved before saling back to port.

LANDING_DATE
DATE

Date when the catch was unloaded at a dealer

NUMBER_OF_CREW
NUMBER

Number of personnel engaged in fishing during the trip.

CARCASS_WEIGHT_SHEET
VARCHAR2

Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached.

FISHED_SAME_DAY
VARCHAR2

Indicates whether there were more fishing trips on the same day.

VESSEL_VERIFIED
VARCHAR2

Indicates whether the vessel id was verified.

ERRORS_IN_THIS_TABLE
VARCHAR2

Validation errors in this record?

ERRORS_IN_THIS_LOGBOOK
VARCHAR2

Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook

BATCH_NUMBER
VARCHAR2

The batch number is the number of the batch where the trip was processed.

SOURCE_FILE
VARCHAR2

Name of the file loaded into the system of which this logbook is a part.

UNLOAD_DATE
DATE

Unload Date

TRIP_TICKET
VARCHAR2

Trip Ticket Number

FORMTYPE
VARCHAR2

The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data

OPERATOR_NAME
VARCHAR2

Operator Name

OPERATOR_NUMBER
VARCHAR2

Operator Number

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: FLS_TRIPS
Short Name:	FLS_TRIPS
Status:	Completed
Abstract:	Contains trip information per fishing trip.
Notes:	Loaded by batch 2043, 12-20-2007 08:10

Organization:	Southeast Fisheries Science Center
City:	Miami
State/Province:	FL
Country:	USA

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	FLS
Description:	Contains trip information per fishing trip.

Attribute Summary

	Name	Type	Description
100	LOGBOOK_KEY	NUMBER	Automatic sequence that links all the tables that hold information related to trips.
100	SCHEDULE_NUMBER	VARCHAR2	A number stamped on each logbook form.
100	VESSEL_ID	VARCHAR2	Vessel Identifier
100	VESSEL_NAME	VARCHAR2	Name of the vessel that matches the vessel id.
100	TELEPHONE	VARCHAR2	Phone number that appears on the logbook.
100	DAYS_FISHED	NUMBER	Number of days during which fishing occurred.
100	DAYS_AWAY	NUMBER	Number of days from, departure to landing, the vessel was away from port.
100	FIRST_SET_DATE	DATE	Date on which the first set occurred, i.e., when gear was first deployed.
100	LAST_SET_DATE	DATE	Date on which the last set of gear were retrieved before saling back to port.
100	LANDING_DATE	DATE	Date when the catch was unloaded at a dealer
100	NUMBER_OF_CREW	NUMBER	Number of personnel engaged in fishing during the trip.
100	CARCASS_WEIGHT_SHEET	VARCHAR2	Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached.
100	FISHED_SAME_DAY	VARCHAR2	Indicates whether there were more fishing trips on the same day.
100	VESSEL_VERIFIED	VARCHAR2	Indicates whether the vessel id was verified.
100	ERRORS_IN_THIS_TABLE	VARCHAR2	Validation errors in this record?
100	ERRORS_IN_THIS_LOGBOOK	VARCHAR2	Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook
100	BATCH_NUMBER	VARCHAR2	The batch number is the number of the batch where the trip was processed.
100	SOURCE_FILE	VARCHAR2	Name of the file loaded into the system of which this logbook is a part.
100	UNLOAD_DATE	DATE	Unload Date
100	TRIP_TICKET	VARCHAR2	Trip Ticket Number
100	FORMTYPE	VARCHAR2	The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data
100	OPERATOR_NAME	VARCHAR2	Operator Name
100	OPERATOR_NUMBER	VARCHAR2	Operator Number

Name

Type

Description

100

LOGBOOK_KEY

NUMBER

Automatic sequence that links all the tables that hold information related to trips.

100

SCHEDULE_NUMBER

VARCHAR2

A number stamped on each logbook form.

100

VESSEL_ID

VARCHAR2

Vessel Identifier

100

VESSEL_NAME

VARCHAR2

Name of the vessel that matches the vessel id.

100

TELEPHONE

VARCHAR2

Phone number that appears on the logbook.

100

DAYS_FISHED

NUMBER

Number of days during which fishing occurred.

100

DAYS_AWAY

NUMBER

Number of days from, departure to landing, the vessel was away from port.

100

FIRST_SET_DATE

DATE

Date on which the first set occurred, i.e., when gear was first deployed.

100

LAST_SET_DATE

DATE

Date on which the last set of gear were retrieved before saling back to port.

100

LANDING_DATE

DATE

Date when the catch was unloaded at a dealer

100

NUMBER_OF_CREW

NUMBER

Number of personnel engaged in fishing during the trip.

100

CARCASS_WEIGHT_SHEET

VARCHAR2

Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached.

100

FISHED_SAME_DAY

VARCHAR2

Indicates whether there were more fishing trips on the same day.

100

VESSEL_VERIFIED

VARCHAR2

Indicates whether the vessel id was verified.

100

ERRORS_IN_THIS_TABLE

VARCHAR2

Validation errors in this record?

100

ERRORS_IN_THIS_LOGBOOK

VARCHAR2

Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook

100

BATCH_NUMBER

VARCHAR2

The batch number is the number of the batch where the trip was processed.

100

SOURCE_FILE

VARCHAR2

Name of the file loaded into the system of which this logbook is a part.

100

UNLOAD_DATE

DATE

Unload Date

100

TRIP_TICKET

VARCHAR2

Trip Ticket Number

100

FORMTYPE

VARCHAR2

The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data

100

OPERATOR_NAME

VARCHAR2

Operator Name

100

OPERATOR_NUMBER

VARCHAR2

Operator Number

Attribute Details

LOGBOOK_KEY

CC ID: 25011

Seq. Order:	1
Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	Automatic sequence that links all the tables that hold information related to trips.
General Data Type:	NUMBER

SCHEDULE_NUMBER

CC ID: 25012

Seq. Order:	2
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	A number stamped on each logbook form.
General Data Type:	VARCHAR2

VESSEL_ID

CC ID: 25013

Seq. Order:	3
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Vessel Identifier
General Data Type:	VARCHAR2

VESSEL_NAME

CC ID: 25014

Seq. Order:	4
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the vessel that matches the vessel id.
General Data Type:	VARCHAR2

TELEPHONE

CC ID: 25015

Seq. Order:	5
Data Storage Type:	VARCHAR2
Max Length:	15
Required:	No
Primary Key:	No
Status:	Active
Description:	Phone number that appears on the logbook.
General Data Type:	VARCHAR2

DAYS_FISHED

CC ID: 25016

Seq. Order:	6
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of days during which fishing occurred.
General Data Type:	NUMBER

DAYS_AWAY

CC ID: 25017

Seq. Order:	7
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of days from, departure to landing, the vessel was away from port.
General Data Type:	NUMBER

FIRST_SET_DATE

CC ID: 25018

Seq. Order:	8
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date on which the first set occurred, i.e., when gear was first deployed.
General Data Type:	DATE

LAST_SET_DATE

CC ID: 25019

Seq. Order:	9
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Date on which the last set of gear were retrieved before saling back to port.
General Data Type:	DATE

LANDING_DATE

CC ID: 25020

Seq. Order:	10
Data Storage Type:	DATE
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Date when the catch was unloaded at a dealer
General Data Type:	DATE

NUMBER_OF_CREW

CC ID: 25021

Seq. Order:	11
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Number of personnel engaged in fishing during the trip.
General Data Type:	NUMBER

CARCASS_WEIGHT_SHEET

CC ID: 25022

Seq. Order:	12
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether a carcass weight (i.e., dealer weighout sheet) was attached.
General Data Type:	VARCHAR2

FISHED_SAME_DAY

CC ID: 25023

Seq. Order:	13
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether there were more fishing trips on the same day.
General Data Type:	VARCHAR2

VESSEL_VERIFIED

CC ID: 25024

Seq. Order:	14
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether the vessel id was verified.
General Data Type:	VARCHAR2

ERRORS_IN_THIS_TABLE

CC ID: 25025

Seq. Order:	15
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Validation errors in this record?
General Data Type:	VARCHAR2

ERRORS_IN_THIS_LOGBOOK

CC ID: 25026

Seq. Order:	16
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether there were any rows with errors in any of the main data tables that hold data for a specific logbook
General Data Type:	VARCHAR2

BATCH_NUMBER

CC ID: 25027

Seq. Order:	17
Data Storage Type:	VARCHAR2
Max Length:	10
Required:	No
Primary Key:	No
Status:	Active
Description:	The batch number is the number of the batch where the trip was processed.
General Data Type:	VARCHAR2

SOURCE_FILE

CC ID: 25028

Seq. Order:	18
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the file loaded into the system of which this logbook is a part.
General Data Type:	VARCHAR2

UNLOAD_DATE

CC ID: 25029

Seq. Order:	19
Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	Unload Date
General Data Type:	DATE

TRIP_TICKET

CC ID: 25030

Seq. Order:	20
Data Storage Type:	VARCHAR2
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Trip Ticket Number
General Data Type:	VARCHAR2

FORMTYPE

CC ID: 25031

Seq. Order:	21
Data Storage Type:	VARCHAR2
Max Length:	9
Required:	No
Primary Key:	No
Status:	Active
Description:	The form may change at the end of each year; therefore, a column is necessary to identify which form was used to collect the data
General Data Type:	VARCHAR2

OPERATOR_NAME

CC ID: 25032

Seq. Order:	22
Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Operator Name
General Data Type:	VARCHAR2

OPERATOR_NUMBER

CC ID: 25033

Seq. Order:	23
Data Storage Type:	VARCHAR2
Max Length:	8
Required:	No
Primary Key:	No
Status:	Active
Description:	Operator Number
General Data Type:	VARCHAR2

Catalog Item ID:	6872
GUID:	gov.noaa.nmfs.inport:6872
Metadata Record Created By:	Lee M Weinberger
Metadata Record Created:	2007-12-20 08:10+0000
Metadata Record Last Modified By:	SysAdmin InPortAdmin
Metadata Record Last Modified:	2022-08-09 17:10+0000
Metadata Record Published:	2021-05-07
Owner Org:	SEFSC
Metadata Publication Status:	Published Externally
Do Not Publish?:	N
Metadata Last Review Date:	2021-05-07
Metadata Review Frequency:	1 Year
Metadata Next Review Date:	2022-05-07

Table: FLS_TRIPS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Physical Location

Entity Information

Data Attributes

Attribute Summary

Attribute Details

LOGBOOK_KEY

SCHEDULE_NUMBER

VESSEL_ID

VESSEL_NAME

TELEPHONE

DAYS_FISHED

DAYS_AWAY

FIRST_SET_DATE

LAST_SET_DATE

LANDING_DATE

NUMBER_OF_CREW

CARCASS_WEIGHT_SHEET

FISHED_SAME_DAY

VESSEL_VERIFIED

ERRORS_IN_THIS_TABLE

ERRORS_IN_THIS_LOGBOOK

BATCH_NUMBER

SOURCE_FILE

UNLOAD_DATE

TRIP_TICKET

FORMTYPE

OPERATOR_NAME

OPERATOR_NUMBER

Catalog Details