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

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

Summary

Abstract

Data Table Containg Annual Trip Costs

Description

Data Table Containg Annual Trip Costs

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANNUAL_TRIP_COSTS_ID
NUMBER 		Primary Key
YEAR
NUMBER 		(Trip Cost) Year
VESSEL_ID
VARCHAR2 		All information from sero's db sero_activev table
VESSEL_NAME
VARCHAR2 		Name of The Vessel
OWNER_NAME
VARCHAR2 		Name Of The Owner Of The Vessel
SIGNING_PERSON_NAME
VARCHAR2 		Name of the person completing the form
SIGNING_PERSON_PHONE
VARCHAR2 		Phone number of the person completing the form
DATA_ENTRY_DATE
DATE 		Date/Time Statmp of when data was enetred into the system
BOTTOM_FISHING_FLAG
NUMBER 		Does Vessel Engage in Bottom Fishing
TROLL_FISHING_FLAG
NUMBER 		Does Vessel Engage in Troll Fishing
CHARTER_FISHING_FLAG
NUMBER 		Does Vessel Engage in Charter Fishing
OTHER_FISHING_FLAG
NUMBER 		Does Vessel Engage in Other Fishing
FUEL
NUMBER 		Fuel Costs
FISHING_SUPPLIES
NUMBER 		Cost of Fishing Supplies
BAIT_SUPPLIES
NUMBER 		Costs Of Bait
CREW_PAYMENT
NUMBER 		Salary/Costs from crew
REPAIR_MAINTENANCE
NUMBER 		Boat Repair/Maintenance Costs
INCLUDES_HAULOUT_FLAG
NUMBER 		Indicates whether there is a cost associated with haulout of boat
PURCHASE_OF_CAPITAL
NUMBER 		Interest Costs Due to capital purchases
BOAT_RENT_UTILITY
NUMBER 		Boat Rental Utility
INSURANCE
NUMBER 		Insurance Costs
INCLUDES_HULL_FLAG
NUMBER 		Indicates whether there is a cost associated with the boat hull
INCLUDES_PI_FLAG
NUMBER 		Indicates whether there is a cost associated with the PI
COMMERCIAL_FISHING_LICENSE
NUMBER 		Cost Of Commercial Fishing Licenses
BOAT_LOAN
NUMBER 		Interest Costs From Boat Loan
BUSINESS_TAX
NUMBER 		Business Tax Costs
OFFICE
NUMBER 		Office Expenses
VEHICLE
NUMBER 		Vehicle Expenses That are in an area attributable to the business of fishing
OTHER
NUMBER 		Other Costs
NUMBER_OF_DAYS_FISHED
NUMBER 		Number Of Days Fished
VESSEL_GROSS_REVENUE
NUMBER 		Gross Revenue For The Vessel Over The Agreed upon timeperiod
LU
DATE 		Date Record was last updated
IS_DELETED_FLAG
NUMBER 		FLag to indicate if record has been placed in a staus where it will not be used
NUMBER_OF_DAYS_NONFISHED
NUMBER 		Number of days this vessel was used for non-fishing income activities

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

Data Table Containg Annual Trip Costs
Notes:

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

Physical Location

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

Entity Information

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

Data Table Containg Annual Trip Costs

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ANNUAL_TRIP_COSTS_ID NUMBER Primary Key
100
 YEAR NUMBER (Trip Cost) Year
100
 VESSEL_ID VARCHAR2 All information from sero's db sero_activev table
100
 VESSEL_NAME VARCHAR2 Name of The Vessel
100
 OWNER_NAME VARCHAR2 Name Of The Owner Of The Vessel
100
 SIGNING_PERSON_NAME VARCHAR2 Name of the person completing the form
100
 SIGNING_PERSON_PHONE VARCHAR2 Phone number of the person completing the form
100
 DATA_ENTRY_DATE DATE Date/Time Statmp of when data was enetred into the system
100
 BOTTOM_FISHING_FLAG NUMBER Does Vessel Engage in Bottom Fishing
100
 TROLL_FISHING_FLAG NUMBER Does Vessel Engage in Troll Fishing
100
 CHARTER_FISHING_FLAG NUMBER Does Vessel Engage in Charter Fishing
100
 OTHER_FISHING_FLAG NUMBER Does Vessel Engage in Other Fishing
100
 FUEL NUMBER Fuel Costs
100
 FISHING_SUPPLIES NUMBER Cost of Fishing Supplies
100
 BAIT_SUPPLIES NUMBER Costs Of Bait
100
 CREW_PAYMENT NUMBER Salary/Costs from crew
100
 REPAIR_MAINTENANCE NUMBER Boat Repair/Maintenance Costs
100
 INCLUDES_HAULOUT_FLAG NUMBER Indicates whether there is a cost associated with haulout of boat
100
 PURCHASE_OF_CAPITAL NUMBER Interest Costs Due to capital purchases
100
 BOAT_RENT_UTILITY NUMBER Boat Rental Utility
100
 INSURANCE NUMBER Insurance Costs
100
 INCLUDES_HULL_FLAG NUMBER Indicates whether there is a cost associated with the boat hull
100
 INCLUDES_PI_FLAG NUMBER Indicates whether there is a cost associated with the PI
100
 COMMERCIAL_FISHING_LICENSE NUMBER Cost Of Commercial Fishing Licenses
100
 BOAT_LOAN NUMBER Interest Costs From Boat Loan
100
 BUSINESS_TAX NUMBER Business Tax Costs
100
 OFFICE NUMBER Office Expenses
100
 VEHICLE NUMBER Vehicle Expenses That are in an area attributable to the business of fishing
100
 OTHER NUMBER Other Costs
100
 NUMBER_OF_DAYS_FISHED NUMBER Number Of Days Fished
100
 VESSEL_GROSS_REVENUE NUMBER Gross Revenue For The Vessel Over The Agreed upon timeperiod
100
 LU DATE Date Record was last updated
100
 IS_DELETED_FLAG NUMBER FLag to indicate if record has been placed in a staus where it will not be used
100
 NUMBER_OF_DAYS_NONFISHED NUMBER Number of days this vessel was used for non-fishing income activities

Attribute Details

ANNUAL_TRIP_COSTS_ID

CC ID: 24477
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Primary Key
General Data Type: NUMBER

YEAR

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

(Trip Cost) Year
General Data Type: NUMBER

VESSEL_ID

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

All information from sero's db sero_activev table
General Data Type: VARCHAR2

VESSEL_NAME

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

Name of The Vessel
General Data Type: VARCHAR2

OWNER_NAME

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

Name Of The Owner Of The Vessel
General Data Type: VARCHAR2

SIGNING_PERSON_NAME

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

Name of the person completing the form
General Data Type: VARCHAR2

SIGNING_PERSON_PHONE

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

Phone number of the person completing the form
General Data Type: VARCHAR2

DATA_ENTRY_DATE

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

Date/Time Statmp of when data was enetred into the system
General Data Type: DATE

BOTTOM_FISHING_FLAG

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

Does Vessel Engage in Bottom Fishing
General Data Type: NUMBER

TROLL_FISHING_FLAG

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

Does Vessel Engage in Troll Fishing
General Data Type: NUMBER

CHARTER_FISHING_FLAG

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

Does Vessel Engage in Charter Fishing
General Data Type: NUMBER

OTHER_FISHING_FLAG

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

Does Vessel Engage in Other Fishing
General Data Type: NUMBER

FUEL

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

Fuel Costs
General Data Type: NUMBER

FISHING_SUPPLIES

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

Cost of Fishing Supplies
General Data Type: NUMBER

BAIT_SUPPLIES

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

Costs Of Bait
General Data Type: NUMBER

CREW_PAYMENT

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

Salary/Costs from crew
General Data Type: NUMBER

REPAIR_MAINTENANCE

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

Boat Repair/Maintenance Costs
General Data Type: NUMBER

INCLUDES_HAULOUT_FLAG

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

Indicates whether there is a cost associated with haulout of boat
General Data Type: NUMBER

PURCHASE_OF_CAPITAL

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

Interest Costs Due to capital purchases
General Data Type: NUMBER

BOAT_RENT_UTILITY

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

Boat Rental Utility
General Data Type: NUMBER

INSURANCE

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

Insurance Costs
General Data Type: NUMBER

INCLUDES_HULL_FLAG

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

Indicates whether there is a cost associated with the boat hull
General Data Type: NUMBER

INCLUDES_PI_FLAG

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

Indicates whether there is a cost associated with the PI
General Data Type: NUMBER

COMMERCIAL_FISHING_LICENSE

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

Cost Of Commercial Fishing Licenses
General Data Type: NUMBER

BOAT_LOAN

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

Interest Costs From Boat Loan
General Data Type: NUMBER

BUSINESS_TAX

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

Business Tax Costs
General Data Type: NUMBER

OFFICE

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

Office Expenses
General Data Type: NUMBER

VEHICLE

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

Vehicle Expenses That are in an area attributable to the business of fishing
General Data Type: NUMBER

OTHER

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

Other Costs
General Data Type: NUMBER

NUMBER_OF_DAYS_FISHED

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

Number Of Days Fished
General Data Type: NUMBER

VESSEL_GROSS_REVENUE

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

Gross Revenue For The Vessel Over The Agreed upon timeperiod
General Data Type: NUMBER

LU

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

Date Record was last updated
General Data Type: DATE

IS_DELETED_FLAG

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

FLag to indicate if record has been placed in a staus where it will not be used
General Data Type: NUMBER

NUMBER_OF_DAYS_NONFISHED

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

Number of days this vessel was used for non-fishing income activities
General Data Type: NUMBER

Catalog Details

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