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
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
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
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: 2019-06-04 13:14+0000
Metadata Record Published: 2015-12-29
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2016-12-29