HAWAII_LL_TRIP_EXPENDITURE_DATA
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:18751 | Updated: August 9, 2022 | Published / External
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
![]() |
![]() |
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
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
Seq. Order: | 2 |
---|---|
Data Storage Type: | Long Integer |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Filing reference number |
E_TRIPNUM
Seq. Order: | 3 |
---|---|
Data Storage Type: | Text |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Trip Number (primary key) |
E_VESSELNAME
Seq. Order: | 4 |
---|---|
Data Storage Type: | Text |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Name of vessel |
E_DEPARTDATE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 23 |
---|---|
Data Storage Type: | Currency |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ice Price Per Unit |
E_ICEUSED
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
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
Seq. Order: | 26 |
---|---|
Data Storage Type: | Currency |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fishing gear cost |
E_PROVCOST
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
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
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
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
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
Seq. Order: | 32 |
---|---|
Data Storage Type: | Currency |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Price per certificate |
E_CERTCOST
Seq. Order: | 33 |
---|---|
Data Storage Type: | Currency |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total cost for certificates |
E_LIGHTSTICKPRICE
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
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
Seq. Order: | 36 |
---|---|
Data Storage Type: | Currency |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total cost of lightsticks |
E_ESTCOSTS
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
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
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
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
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
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
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
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
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
Seq. Order: | 46 |
---|---|
Data Storage Type: | Text |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Observer i.d. number |
E_CAPTAINPHONE
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
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 |
---|---|
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: | 2022-08-09 17:11+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 |