Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_TRIP_SUMMARY

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6874  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Provides Summary Information Per FIshing Trip

Description

Provides Summary Information Per FIshing Trip

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOGBOOK_KEY
NUMBER 		A consecutive number that identifies a logbook
SCHEDULE_NUMBER
VARCHAR2 		A number stamped on each logbook form
VESSEL_ID_NUMBER
VARCHAR2 		Vessel ID
DEPARTURE_DATE
DATE 		Departure date
FIRST_SET_DATE
DATE 		First day of fishing in this trip
LAST_SET_DATE
DATE 		Last day of fishing in this trip
LANDING_DATE
DATE 		Landing Date
PORT_OF_DEPARTURE
VARCHAR2 		Port of Departure
DAYS_FISHED
NUMBER 		Number of day the vessel fished in this trip
NUMBER_OF_CREW
NUMBER 		Number of Crew
NUMBER_OF_SETS
NUMBER 		Number of sets in this trip
PORT_OF_LANDING
VARCHAR2 		Port of Landing
DEALER_NUMBER_1
VARCHAR2 		Dealer that bought fish from this trip
DEALER_NUMBER_2
VARCHAR2 		Dealer that bought fish from this trip
DEALER_NUMBER_3
VARCHAR2 		Dealer that bought fish from this trip
DATA_ENTRY_DATE
DATE 		Date in which the record was entered
OPENED_DATE
DATE 		Date the logbooks where brought to the agency from the post office and opened. It also indicates the date on which each logbook was stamped with a unique number (i.e.schedule number) and date
FIRST_OFF_LOAD_DATE
DATE 		First Off Load Date
LAST_OFF_LOAD_DATE
DATE 		Last Off Load Date
SOURCE_FILE
VARCHAR2 		Most likely will be NULL, otherwise it shows the loaded file were this record comes from
DATA_ENTRY_NAME
VARCHAR2 		Name of the person that entered a record
TRIP_TICKET
VARCHAR2 		Trip Ticket Number
STATE_CODE_NMFS_DEPARTURE
VARCHAR2 		State code of the Departure Port.
STATE_CODE_NMFS_LANDING
VARCHAR2 		State code of the Landing Port.
DEALER_NUMBER_4
VARCHAR2 		Dealer that bought fish from this trip
DEALER_NUMBER_5
VARCHAR2 		Dealer that bought fish from this trip
DEALER_NUMBER_6
VARCHAR2 		Dealer that bought fish from this trip
SE_DLR_NBR_1
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
SE_DLR_NBR_2
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
SE_DLR_NBR_3
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
SE_DLR_NBR_4
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
SE_DLR_NBR_5
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
SE_DLR_NBR_6
VARCHAR2 		SERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_1
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_2
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_3
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_4
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_5
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
NE_DLR_NBR_6
VARCHAR2 		NERO Dealer (number) that bought fish for this trip
POP_TRIP_NUMBER
VARCHAR2 		Observer Trip Number (link with POPOL/Observer application)
OBSERVER_ON_BOARD
VARCHAR2 		Was an observer on board? (POP application related)
TRIP_TICKET_2
VARCHAR2 		Trip Ticket Number
TRIP_TICKET_3
VARCHAR2 		Trip Ticket Number
PERSONAL_USE
VARCHAR2 		Was The catch on this trip used for personal use
NO_CATCH
VARCHAR2 		Were There No Catch Records On This Trip
NEW_HAMPSHIRE_ID_NUMBER
VARCHAR2 		New Hampshire ID Number

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

Provides Summary Information Per FIshing Trip
Notes:

Loaded by batch 2043, 12-20-2007 08:10

Entity Information

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

Provides Summary Information Per FIshing Trip

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 LOGBOOK_KEY NUMBER A consecutive number that identifies a logbook
100
 Primary Key SCHEDULE_NUMBER VARCHAR2 A number stamped on each logbook form
100
 VESSEL_ID_NUMBER VARCHAR2 Vessel ID
100
 DEPARTURE_DATE DATE Departure date
100
 FIRST_SET_DATE DATE First day of fishing in this trip
100
 LAST_SET_DATE DATE Last day of fishing in this trip
100
 LANDING_DATE DATE Landing Date
100
 PORT_OF_DEPARTURE VARCHAR2 Port of Departure
100
 DAYS_FISHED NUMBER Number of day the vessel fished in this trip
100
 NUMBER_OF_CREW NUMBER Number of Crew
100
 NUMBER_OF_SETS NUMBER Number of sets in this trip
100
 PORT_OF_LANDING VARCHAR2 Port of Landing
100
 DEALER_NUMBER_1 VARCHAR2 Dealer that bought fish from this trip
100
 DEALER_NUMBER_2 VARCHAR2 Dealer that bought fish from this trip
100
 DEALER_NUMBER_3 VARCHAR2 Dealer that bought fish from this trip
100
 DATA_ENTRY_DATE DATE Date in which the record was entered
100
 OPENED_DATE DATE Date the logbooks where brought to the agency from the post office and opened. It also indicates the date on which each logbook was stamped with a unique number (i.e.schedule number) and date
100
 FIRST_OFF_LOAD_DATE DATE First Off Load Date
100
 LAST_OFF_LOAD_DATE DATE Last Off Load Date
100
 SOURCE_FILE VARCHAR2 Most likely will be NULL, otherwise it shows the loaded file were this record comes from
100
 DATA_ENTRY_NAME VARCHAR2 Name of the person that entered a record
100
 TRIP_TICKET VARCHAR2 Trip Ticket Number
100
 STATE_CODE_NMFS_DEPARTURE VARCHAR2 State code of the Departure Port.
100
 STATE_CODE_NMFS_LANDING VARCHAR2 State code of the Landing Port.
100
 DEALER_NUMBER_4 VARCHAR2 Dealer that bought fish from this trip
100
 DEALER_NUMBER_5 VARCHAR2 Dealer that bought fish from this trip
100
 DEALER_NUMBER_6 VARCHAR2 Dealer that bought fish from this trip
100
 SE_DLR_NBR_1 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 SE_DLR_NBR_2 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 SE_DLR_NBR_3 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 SE_DLR_NBR_4 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 SE_DLR_NBR_5 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 SE_DLR_NBR_6 VARCHAR2 SERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_1 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_2 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_3 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_4 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_5 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 NE_DLR_NBR_6 VARCHAR2 NERO Dealer (number) that bought fish for this trip
100
 POP_TRIP_NUMBER VARCHAR2 Observer Trip Number (link with POPOL/Observer application)
100
 OBSERVER_ON_BOARD VARCHAR2 Was an observer on board? (POP application related)
100
 TRIP_TICKET_2 VARCHAR2 Trip Ticket Number
100
 TRIP_TICKET_3 VARCHAR2 Trip Ticket Number
100
 PERSONAL_USE VARCHAR2 Was The catch on this trip used for personal use
100
 NO_CATCH VARCHAR2 Were There No Catch Records On This Trip
100
 NEW_HAMPSHIRE_ID_NUMBER VARCHAR2 New Hampshire ID Number

Attribute Details

LOGBOOK_KEY

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

A consecutive number that identifies a logbook
General Data Type: NUMBER

SCHEDULE_NUMBER

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

A number stamped on each logbook form
General Data Type: VARCHAR2

VESSEL_ID_NUMBER

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

Vessel ID
General Data Type: VARCHAR2

DEPARTURE_DATE

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

Departure date
General Data Type: DATE

FIRST_SET_DATE

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

First day of fishing in this trip
General Data Type: DATE

LAST_SET_DATE

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

Last day of fishing in this trip
General Data Type: DATE

LANDING_DATE

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

Landing Date
General Data Type: DATE

PORT_OF_DEPARTURE

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

Port of Departure
General Data Type: VARCHAR2

DAYS_FISHED

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

Number of day the vessel fished in this trip
General Data Type: NUMBER

NUMBER_OF_CREW

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

Number of Crew
General Data Type: NUMBER

NUMBER_OF_SETS

CC ID: 25053
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 3
Scale: 0
Status: Active
Description:

Number of sets in this trip
General Data Type: NUMBER

PORT_OF_LANDING

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

Port of Landing
General Data Type: VARCHAR2

DEALER_NUMBER_1

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

Dealer that bought fish from this trip
General Data Type: VARCHAR2

DEALER_NUMBER_2

CC ID: 25056
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dealer that bought fish from this trip
General Data Type: VARCHAR2

DEALER_NUMBER_3

CC ID: 25057
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dealer that bought fish from this trip
General Data Type: VARCHAR2

DATA_ENTRY_DATE

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

Date in which the record was entered
General Data Type: DATE

OPENED_DATE

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

Date the logbooks where brought to the agency from the post office and opened. It also indicates the date on which each logbook was stamped with a unique number (i.e.schedule number) and date
General Data Type: DATE

FIRST_OFF_LOAD_DATE

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

First Off Load Date
General Data Type: DATE

LAST_OFF_LOAD_DATE

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

Last Off Load Date
General Data Type: DATE

SOURCE_FILE

CC ID: 25062
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Most likely will be NULL, otherwise it shows the loaded file were this record comes from
General Data Type: VARCHAR2

DATA_ENTRY_NAME

CC ID: 25063
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Name of the person that entered a record
General Data Type: VARCHAR2

TRIP_TICKET

CC ID: 25064
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number
General Data Type: VARCHAR2

STATE_CODE_NMFS_DEPARTURE

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

State code of the Departure Port.
General Data Type: VARCHAR2

STATE_CODE_NMFS_LANDING

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

State code of the Landing Port.
General Data Type: VARCHAR2

DEALER_NUMBER_4

CC ID: 25067
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dealer that bought fish from this trip
General Data Type: VARCHAR2

DEALER_NUMBER_5

CC ID: 25068
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dealer that bought fish from this trip
General Data Type: VARCHAR2

DEALER_NUMBER_6

CC ID: 25069
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Dealer that bought fish from this trip
General Data Type: VARCHAR2

SE_DLR_NBR_1

CC ID: 25070
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

SE_DLR_NBR_2

CC ID: 25071
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

SE_DLR_NBR_3

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

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

SE_DLR_NBR_4

CC ID: 25073
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

SE_DLR_NBR_5

CC ID: 25074
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

SE_DLR_NBR_6

CC ID: 25075
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

SERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_1

CC ID: 25076
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_2

CC ID: 25077
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_3

CC ID: 25078
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 240
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_4

CC ID: 25079
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_5

CC ID: 25080
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

NE_DLR_NBR_6

CC ID: 25081
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

NERO Dealer (number) that bought fish for this trip
General Data Type: VARCHAR2

POP_TRIP_NUMBER

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

Observer Trip Number (link with POPOL/Observer application)
General Data Type: VARCHAR2

OBSERVER_ON_BOARD

CC ID: 25083
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was an observer on board? (POP application related)
General Data Type: VARCHAR2

TRIP_TICKET_2

CC ID: 25084
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number
General Data Type: VARCHAR2

TRIP_TICKET_3

CC ID: 25085
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number
General Data Type: VARCHAR2

PERSONAL_USE

CC ID: 25086
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was The catch on this trip used for personal use
General Data Type: VARCHAR2

NO_CATCH

CC ID: 25087
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Were There No Catch Records On This Trip
General Data Type: VARCHAR2

NEW_HAMPSHIRE_ID_NUMBER

CC ID: 25088
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

New Hampshire ID Number
General Data Type: VARCHAR2

Catalog Details

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