Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC ESD Socioeconomics Program (SP) Metadata... > PIFSC Socioeconomics Program: Economics Researc... > Hawaii Longline Fishery Trip Expenditure (2004... >

HAWAII_LL_TRIP_EXPENDITURE_DATA

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:18751  |  Updated: March 4, 2026  |  Published / External 
Summary
Item Identification
Keywords
Physical Location
Entity Info
Data Attributes
Support Roles
Access Info
Catalog Details

Summary

Abstract

This table contains the results of the Hawaii Longline Fishery Trip Expenditure Survey

Description

The entity table shows the variable names, data storage types, and maximum length of the variables contain in the data file

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
E_TRIPTYPE
Text 		Type of fishing trip (e.g. Tuna or Swordfish)
E_CODE
Long Integer 		Filing reference number
E_TRIPNUM
Text 		Trip Number (primary key)
E_VESSELNAME
Text 		Name of vessel
E_DEPARTDATE
Date 		Departure date of vessel for this trip
E_RETURNDATE
Date 		Return date of vessel for this trip
E_FUELPRICE
Currency 		Price of fuel for this trip ($ per gallon)
E_FUELUSED
Long Integer 		Total amount of fuel used (in gallons) for this trip
E_FUELCOST
Currency 		Total cost of fuel purchased for this trip
E_OILPRICE
Currency 		Price of oil for this trip ($ per gallon)
E_OILUSED
Long Integer 		Number of gallons of oil used for this trip
E_OILCOST
Currency 		Total cost of oil purchased for this trip
E_BAIT1
Text 		Type of Bait Type 1 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
E_BAIT1PRICE
Currency 		Price Per Box for bait type 1
E_BAIT1USED
Long Integer 		Number of boxes used for bait type 1
E_BAIT1COST
Currency 		Total cost of bait type 1
E_BAIT2
Text 		Type of Bait Type 2 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
E_BAIT2PRICE
Currency 		Price per box for bait type 2
E_BAIT2USED
Long Integer 		Number of boxes used for bait type 2
E_BAIT2COST
Currency 		Total cost of bait type 2
E_ICEMAKER
Logical 		Does the vessel have an icemaker?
E_ICEUNIT
Text 		Unit of ice (e.g., Block, Ton, Pound)
E_ICEPRICE
Currency 		Ice Price Per Unit
E_ICEUSED
Long Integer 		Number of units used
E_ICECOST
Currency 		Total cost of ice purchased
E_GEARCOST
Currency 		Fishing gear cost
E_PROVCOST
Currency 		Cost of provisions (e.g. bottled water, food, etc.)
E_COMMCOST
Currency 		Cost of satellite phone calls, e-mail, etc.
E_SFCERT
Text 		If swordfish fishing certificate used, indicate if purchased or not purchased
E_FREESOURCE
Text 		If swordfish fishing certificate used and not purchased, indicate how obtained, Own, Other (given by other fishermen), Both (Own and Other used during this trip)
E_CERTPURCH
Long Integer 		If swordfish fishing certificates were purchased, indicate the number of certificates purchased
E_CERTPRICE
Currency 		Price per certificate
E_CERTCOST
Currency 		Total cost for certificates
E_LIGHTSTICKPRICE
Currency 		Lightstick Price Per Case (500 per case)
E_LIGHTSTICKUSED
Long Integer 		Number of lightstick cases used
E_LIGHTSTICKCOST
Currency 		Total cost of lightsticks
E_ESTCOSTS
Currency 		Estimated total trip cost (by captain or owner)
E_CALCTRIPCOSTS
Currency 		Summation of itemized fields in form, which include E_FuelCost, E_OilCost, E_Bait1Cost, E_Bait2Cost, E_FreezerCosts, E_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_FreightCost, E_MiscCost
E_OPERATOR
Text 		Operator for this trip (e.g., Owner operated, Hired captain, Not indicated)
E_NUMCREWOLD
Long Integer 		Number of crew including captain (old form before 2011)
E_NUMCREW
Long Integer 		Number of crew not including captain (2011 form)
E_NUMFOREIGNCREW
Long Integer 		Number of total foreign crew (e.g., Kiribati, Marshall Is, Christmas Is, Philippines)
E_STATUSCOLLECTION
Text 		Indicate if data collected by observer
E_OBSNOTE
Text 		If E_STATUSCOLLECTION is "Other", include note from observer
E_DATATYPE
Text 		Choose the specific designation for data type (e.g. Data from captain, Observed data at sea, In office)
E_OBSNUMBER
Text 		Observer i.d. number
E_CAPTAINPHONE
Text 		Trip operator phone number

Child Items

No Child Items for this record.

Contact Information

Point of Contact
Minling Pan
ORCID: 0009-0000-3822-2651
minling.pan@noaa.gov
(808)725-5349

Item Identification

Title: HAWAII_LL_TRIP_EXPENDITURE_DATA
Status: In Work
Abstract:

This table contains the results of the Hawaii Longline Fishery Trip Expenditure Survey

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None ECONOMICS
None Hawaii longline fishery
None PIFSC
None SOCIOECONOMICS
None Trip expenditure

Physical Location

Organization: Pacific Islands Fisheries Science Center
City: Honolulu
State/Province: HI
Country: USA

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

The entity table shows the variable names, data storage types, and maximum length of the variables contain in the data file

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 E_TRIPTYPE Text Type of fishing trip (e.g. Tuna or Swordfish)
100
 E_CODE Long Integer Filing reference number
100
 E_TRIPNUM Text Trip Number (primary key)
100
 E_VESSELNAME Text Name of vessel
100
 E_DEPARTDATE Date Departure date of vessel for this trip
100
 E_RETURNDATE Date Return date of vessel for this trip
100
 E_FUELPRICE Currency Price of fuel for this trip ($ per gallon)
100
 E_FUELUSED Long Integer Total amount of fuel used (in gallons) for this trip
100
 E_FUELCOST Currency Total cost of fuel purchased for this trip
100
 E_OILPRICE Currency Price of oil for this trip ($ per gallon)
100
 E_OILUSED Long Integer Number of gallons of oil used for this trip
100
 E_OILCOST Currency Total cost of oil purchased for this trip
100
 E_BAIT1 Text Type of Bait Type 1 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
100
 E_BAIT1PRICE Currency Price Per Box for bait type 1
100
 E_BAIT1USED Long Integer Number of boxes used for bait type 1
100
 E_BAIT1COST Currency Total cost of bait type 1
100
 E_BAIT2 Text Type of Bait Type 2 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
100
 E_BAIT2PRICE Currency Price per box for bait type 2
100
 E_BAIT2USED Long Integer Number of boxes used for bait type 2
100
 E_BAIT2COST Currency Total cost of bait type 2
100
 E_ICEMAKER Logical Does the vessel have an icemaker?
100
 E_ICEUNIT Text Unit of ice (e.g., Block, Ton, Pound)
100
 E_ICEPRICE Currency Ice Price Per Unit
100
 E_ICEUSED Long Integer Number of units used
100
 E_ICECOST Currency Total cost of ice purchased
100
 E_GEARCOST Currency Fishing gear cost
100
 E_PROVCOST Currency Cost of provisions (e.g. bottled water, food, etc.)
100
 E_COMMCOST Currency Cost of satellite phone calls, e-mail, etc.
100
 E_SFCERT Text If swordfish fishing certificate used, indicate if purchased or not purchased
100
 E_FREESOURCE Text If swordfish fishing certificate used and not purchased, indicate how obtained, Own, Other (given by other fishermen), Both (Own and Other used during this trip)
100
 E_CERTPURCH Long Integer If swordfish fishing certificates were purchased, indicate the number of certificates purchased
100
 E_CERTPRICE Currency Price per certificate
100
 E_CERTCOST Currency Total cost for certificates
100
 E_LIGHTSTICKPRICE Currency Lightstick Price Per Case (500 per case)
100
 E_LIGHTSTICKUSED Long Integer Number of lightstick cases used
100
 E_LIGHTSTICKCOST Currency Total cost of lightsticks
100
 E_ESTCOSTS Currency Estimated total trip cost (by captain or owner)
100
 E_CALCTRIPCOSTS Currency Summation of itemized fields in form, which include E_FuelCost, E_OilCost, E_Bait1Cost, E_Bait2Cost, E_FreezerCosts, E_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_FreightCost, E_MiscCost
100
 E_OPERATOR Text Operator for this trip (e.g., Owner operated, Hired captain, Not indicated)
100
 E_NUMCREWOLD Long Integer Number of crew including captain (old form before 2011)
100
 E_NUMCREW Long Integer Number of crew not including captain (2011 form)
100
 E_NUMFOREIGNCREW Long Integer Number of total foreign crew (e.g., Kiribati, Marshall Is, Christmas Is, Philippines)
100
 E_STATUSCOLLECTION Text Indicate if data collected by observer
100
 E_OBSNOTE Text If E_STATUSCOLLECTION is "Other", include note from observer
100
 E_DATATYPE Text Choose the specific designation for data type (e.g. Data from captain, Observed data at sea, In office)
100
 E_OBSNUMBER Text Observer i.d. number
100
 E_CAPTAINPHONE Text Trip operator phone number

Attribute Details

E_TRIPTYPE

CC ID: 104282
Seq. Order: 1
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of fishing trip (e.g. Tuna or Swordfish)
Display Example: Tuna, Swordfish

E_CODE

CC ID: 104283
Seq. Order: 2
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Filing reference number

E_TRIPNUM

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

Trip Number (primary key)

E_VESSELNAME

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

Name of vessel

E_DEPARTDATE

CC ID: 104286
Seq. Order: 5
Data Storage Type: Date
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Departure date of vessel for this trip
Format Mask: MM/DD/YYYY

E_RETURNDATE

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

Return date of vessel for this trip
Format Mask: MM/DD/YYYY

E_FUELPRICE

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

Price of fuel for this trip ($ per gallon)

E_FUELUSED

CC ID: 104289
Seq. Order: 8
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Total amount of fuel used (in gallons) for this trip

E_FUELCOST

CC ID: 104290
Seq. Order: 9
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total cost of fuel purchased for this trip

E_OILPRICE

CC ID: 104291
Seq. Order: 10
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Price of oil for this trip ($ per gallon)

E_OILUSED

CC ID: 104292
Seq. Order: 11
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of gallons of oil used for this trip

E_OILCOST

CC ID: 104293
Seq. Order: 12
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total cost of oil purchased for this trip

E_BAIT1

CC ID: 104294
Seq. Order: 13
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of Bait Type 1 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
Display Example: Squid, Sardine, Sanma, Mackerel, Anchovy,and Other

E_BAIT1PRICE

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

Price Per Box for bait type 1

E_BAIT1USED

CC ID: 104296
Seq. Order: 15
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of boxes used for bait type 1

E_BAIT1COST

CC ID: 104297
Seq. Order: 16
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total cost of bait type 1

E_BAIT2

CC ID: 104298
Seq. Order: 17
Data Storage Type: Text
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Type of Bait Type 2 (e.g., Squid, Sardine, Sanma, Mackerel, Anchovy, Other)
Display Example: Squid, Sardine, Sanma, Mackerel, Anchovy,and Other

E_BAIT2PRICE

CC ID: 104299
Seq. Order: 18
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Price per box for bait type 2

E_BAIT2USED

CC ID: 104300
Seq. Order: 19
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of boxes used for bait type 2

E_BAIT2COST

CC ID: 104301
Seq. Order: 20
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total cost of bait type 2

E_ICEMAKER

CC ID: 104302
Seq. Order: 21
Data Storage Type: Logical
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Does the vessel have an icemaker?

E_ICEUNIT

CC ID: 104303
Seq. Order: 22
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Unit of ice (e.g., Block, Ton, Pound)
Display Example: Block, Ton, Pound

E_ICEPRICE

CC ID: 104304
Seq. Order: 23
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Ice Price Per Unit

E_ICEUSED

CC ID: 104305
Seq. Order: 24
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of units used

E_ICECOST

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

Total cost of ice purchased

E_GEARCOST

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

Fishing gear cost

E_PROVCOST

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

Cost of provisions (e.g. bottled water, food, etc.)

E_COMMCOST

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

Cost of satellite phone calls, e-mail, etc.

E_SFCERT

CC ID: 104310
Seq. Order: 29
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

If swordfish fishing certificate used, indicate if purchased or not purchased
Display Example: Purchased, Not purchased

E_FREESOURCE

CC ID: 104311
Seq. Order: 30
Data Storage Type: Text
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

If swordfish fishing certificate used and not purchased, indicate how obtained, Own, Other (given by other fishermen), Both (Own and Other used during this trip)
Display Example: Own, Other, Both

E_CERTPURCH

CC ID: 104312
Seq. Order: 31
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

If swordfish fishing certificates were purchased, indicate the number of certificates purchased

E_CERTPRICE

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

Price per certificate

E_CERTCOST

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

Total cost for certificates

E_LIGHTSTICKPRICE

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

Lightstick Price Per Case (500 per case)

E_LIGHTSTICKUSED

CC ID: 104316
Seq. Order: 35
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of lightstick cases used

E_LIGHTSTICKCOST

CC ID: 104317
Seq. Order: 36
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Total cost of lightsticks

E_ESTCOSTS

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

Estimated total trip cost (by captain or owner)

E_CALCTRIPCOSTS

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

Summation of itemized fields in form, which include E_FuelCost, E_OilCost, E_Bait1Cost, E_Bait2Cost, E_FreezerCosts, E_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_FreightCost, E_MiscCost

E_OPERATOR

CC ID: 104320
Seq. Order: 39
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Operator for this trip (e.g., Owner operated, Hired captain, Not indicated)
Display Example: Owner operated, Hired captain, Not indicated

E_NUMCREWOLD

CC ID: 104321
Seq. Order: 40
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Inactive
Description:

Number of crew including captain (old form before 2011)

E_NUMCREW

CC ID: 104322
Seq. Order: 41
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of crew not including captain (2011 form)

E_NUMFOREIGNCREW

CC ID: 104323
Seq. Order: 42
Data Storage Type: Long Integer
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Number of total foreign crew (e.g., Kiribati, Marshall Is, Christmas Is, Philippines)

E_STATUSCOLLECTION

CC ID: 104324
Seq. Order: 43
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Indicate if data collected by observer
Display Example: Yes, No, Other

E_OBSNOTE

CC ID: 104325
Seq. Order: 44
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

If E_STATUSCOLLECTION is "Other", include note from observer

E_DATATYPE

CC ID: 104326
Seq. Order: 45
Data Storage Type: Text
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Choose the specific designation for data type (e.g. Data from captain, Observed data at sea, In office)
Display Example: Data from captain, Observed data at sea, In office

E_OBSNUMBER

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

Observer i.d. number

E_CAPTAINPHONE

CC ID: 104328
Seq. Order: 47
Data Storage Type: Text
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip operator phone number

Support Roles

Point of Contact

CC ID: 104281
Date Effective From: 2007-08-22
Date Effective To:
Contact (Person): Pan, Minling
Address: 1845 Wasp Blvd.
Honolulu, HI 96818
USA
ORCID: https://orcid.org/0009-0000-3822-2651
Email Address: minling.pan@noaa.gov
Phone: (808)725-5349
Business Hours: 8:30 a.m. - 5:00 p.m. HST M-F

Access Information

Security Class: Confidential

Catalog Details

Catalog Item ID: 18751
GUID: gov.noaa.nmfs.inport:18751
Metadata Record Created By: Hing Ling Chan
Metadata Record Created: 2013-04-25 21:03+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2026-03-04 19:17+0000
Metadata Record Published: 2015-12-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2015-12-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2016-12-29