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_SET_COSTS

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

Summary

Abstract

Data Table containing Annual Set Costs

Description

Data Table containing Annual Set Costs

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ANNUAL_SET_COSTS_ID
NUMBER 		Primary Key for This table
YEAR
NUMBER 		Year the data is collected for
VESSEL_ID
VARCHAR2 		The boat license number. It may be either the state registration number or the Coast Guard Number
SIGNING_PERSON_NAME
VARCHAR2 		Name that signed the form
SIGNING_PERSON_PHONE
VARCHAR2 		Phone Number Of Person who signed the form
DATA_ENTRY_DATE
DATE 		Date form was enetred
REPAIR_MAINTENANCE
NUMBER 		Costs Of Regular Equioment Maintenance/Repair
FISHING_SUPPLIES
NUMBER 		Cost Of FIshing Supplies
DRYDOCK_HAULOUT
NUMBER 		Cost Of Hauling Boat In and Out of drydock
PURCHASE_OF_CAPITAL
NUMBER 		Costs For Other capital supplies
INSURANCE_HULL
NUMBER 		Insurance Costs For The Boat Hull
INSURANCE_PI
NUMBER 		Other Insurcane Costs
BOAT_RENT_UTILITY
NUMBER 		Boat Rental Costs
COMMERCIAL_FISHING_LICENSE
NUMBER 		Cost Of FIshing Licenses/Permits
BOAT_LOAN
NUMBER 		(Interest) Costs Associated With Loan On The Boat
RELOCATION
NUMBER 		Relocation Costs Involved WIth Fishing
BUSINESS_TAX
NUMBER 		Business Tax Fees Payed
OFFICE
NUMBER 		Office Expenses
OTHER
NUMBER 		Other Expenses
PERSON_ID
NUMBER 		Person Id
SEQUENCE_NUMBER
NUMBER 		Sequence Number
IS_DELETED_FLAG
NUMBER 		To indicated whether record has been deleted
LU
DATE 		Date/Time stamp of when record was last updated
OWNER_NAME
VARCHAR2 		Owner Name
VESSEL_NAME
VARCHAR2 		Vessel Name

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

Data Table containing Annual Set Costs
Notes:

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

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None economic data

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 containing Annual Set Costs

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ANNUAL_SET_COSTS_ID NUMBER Primary Key for This table
100
 YEAR NUMBER Year the data is collected for
100
 VESSEL_ID VARCHAR2 The boat license number. It may be either the state registration number or the Coast Guard Number
100
 SIGNING_PERSON_NAME VARCHAR2 Name that signed the form
100
 SIGNING_PERSON_PHONE VARCHAR2 Phone Number Of Person who signed the form
100
 DATA_ENTRY_DATE DATE Date form was enetred
100
 REPAIR_MAINTENANCE NUMBER Costs Of Regular Equioment Maintenance/Repair
100
 FISHING_SUPPLIES NUMBER Cost Of FIshing Supplies
100
 DRYDOCK_HAULOUT NUMBER Cost Of Hauling Boat In and Out of drydock
100
 PURCHASE_OF_CAPITAL NUMBER Costs For Other capital supplies
100
 INSURANCE_HULL NUMBER Insurance Costs For The Boat Hull
100
 INSURANCE_PI NUMBER Other Insurcane Costs
100
 BOAT_RENT_UTILITY NUMBER Boat Rental Costs
100
 COMMERCIAL_FISHING_LICENSE NUMBER Cost Of FIshing Licenses/Permits
100
 BOAT_LOAN NUMBER (Interest) Costs Associated With Loan On The Boat
100
 RELOCATION NUMBER Relocation Costs Involved WIth Fishing
100
 BUSINESS_TAX NUMBER Business Tax Fees Payed
100
 OFFICE NUMBER Office Expenses
100
 OTHER NUMBER Other Expenses
100
 PERSON_ID NUMBER Person Id
100
 SEQUENCE_NUMBER NUMBER Sequence Number
100
 IS_DELETED_FLAG NUMBER To indicated whether record has been deleted
100
 LU DATE Date/Time stamp of when record was last updated
100
 OWNER_NAME VARCHAR2 Owner Name
100
 VESSEL_NAME VARCHAR2 Vessel Name

Attribute Details

ANNUAL_SET_COSTS_ID

CC ID: 24452
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

YEAR

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

Year the data is collected for
General Data Type: NUMBER

VESSEL_ID

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

The boat license number. It may be either the state registration number or the Coast Guard Number
General Data Type: VARCHAR2

SIGNING_PERSON_NAME

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

Name that signed the form
General Data Type: VARCHAR2

SIGNING_PERSON_PHONE

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

Phone Number Of Person who signed the form
General Data Type: VARCHAR2

DATA_ENTRY_DATE

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

Date form was enetred
General Data Type: DATE

REPAIR_MAINTENANCE

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

Costs Of Regular Equioment Maintenance/Repair
General Data Type: NUMBER

FISHING_SUPPLIES

CC ID: 24459
Seq. Order: 8
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

DRYDOCK_HAULOUT

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

Cost Of Hauling Boat In and Out of drydock
General Data Type: NUMBER

PURCHASE_OF_CAPITAL

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

Costs For Other capital supplies
General Data Type: NUMBER

INSURANCE_HULL

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

Insurance Costs For The Boat Hull
General Data Type: NUMBER

INSURANCE_PI

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

Other Insurcane Costs
General Data Type: NUMBER

BOAT_RENT_UTILITY

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

Boat Rental Costs
General Data Type: NUMBER

COMMERCIAL_FISHING_LICENSE

CC ID: 24465
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 Licenses/Permits
General Data Type: NUMBER

BOAT_LOAN

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

(Interest) Costs Associated With Loan On The Boat
General Data Type: NUMBER

RELOCATION

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

Relocation Costs Involved WIth Fishing
General Data Type: NUMBER

BUSINESS_TAX

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

Business Tax Fees Payed
General Data Type: NUMBER

OFFICE

CC ID: 24469
Seq. Order: 18
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

OTHER

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

Other Expenses
General Data Type: NUMBER

PERSON_ID

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

Person Id
General Data Type: NUMBER

SEQUENCE_NUMBER

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

Sequence Number
General Data Type: NUMBER

IS_DELETED_FLAG

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

To indicated whether record has been deleted
General Data Type: NUMBER

LU

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

Date/Time stamp of when record was last updated
General Data Type: DATE

OWNER_NAME

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

Owner Name
General Data Type: VARCHAR2

VESSEL_NAME

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

Vessel Name
General Data Type: VARCHAR2

Catalog Details

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