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
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This table contains the results of the Hawaii Longline Fishery Trip Expenditure Survey
DescriptionThe 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
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
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 |