Table: FLS_TRIP_SUMMARY
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6874 | Updated: August 9, 2022 | Published / External
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
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
LOGBOOK_KEY | NUMBER | A consecutive number that identifies a logbook | |
|
100
|
|
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 |