Item Identification

Title: AMERICAN_SAMOA_LL_TRIP_EXPENDITURE_DATA
Status: In Work
Abstract:

This table contains the results of the American Samoa Longline Fishery Trip Expenditure Survey

Keywords

Theme Keywords

Thesaurus Keyword
None American Samoa longline fishery
None ECONOMICS
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

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_DAYSFISHED Long Integer Number of days fished
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_FREEZERCOSTS Currency Cost to operate refrigeration system onboard the vessel for this trip
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_FREIGHTCOST Currency Cost of transporting fish to another market; fish that cannot be used in the A.S. cannery
100
E_MISCCOST Currency Total cost of miscellaneous items purchased for this trip
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_ESTCOST 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_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_CertCost , E_ LightstickCost
100
E_OPERATOR Text Operator for this trip (e.g., Owner operated, Hired captain, Not indicated)
100
E_NUMCREW Long Integer Number of crew including captain (old form before 2011)
100
E_NUMFLATRATE Long Integer Number of crew paid by flat rate (include captain)
100
E_NUMSHARE Long Integer Number of crew paid by share (include captain)
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_FOREIGNCREW Long Integer Number of total foreign crew (e.g., Kiribati, Marshall Is, Christmas Is, Philippines)
100
E_NEWCREW Long Integer Number of crew not including captain (2011 form)
100
E_OBSNUMBER Double The observer's number
100
E_CAPTPHONE Double The phone number of the captain
100
E_DEBRIEFER Text Debriefer's initials

Attribute Details

E_TRIPTYPE

CC ID: 104398
Seq. Order: 1
Data Storage Type: Text
Max Length: 50
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: 104399
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: 104400
Seq. Order: 3
Data Storage Type: Text
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Trip Number (primary key)

E_VESSELNAME

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

Name of vessel

E_DEPARTDATE

CC ID: 104402
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: 104403
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_DAYSFISHED

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

Number of days fished

E_FUELPRICE

CC ID: 104405
Seq. Order: 8
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: 104406
Seq. Order: 9
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: 104407
Seq. Order: 10
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: 104408
Seq. Order: 11
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: 104409
Seq. Order: 12
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: 104410
Seq. Order: 13
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: 104411
Seq. Order: 14
Data Storage Type: Text
Max Length: 50
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: 104412
Seq. Order: 15
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: 104413
Seq. Order: 16
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: 104414
Seq. Order: 17
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: 104415
Seq. Order: 18
Data Storage Type: Text
Max Length: 50
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: 104416
Seq. Order: 19
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: 104417
Seq. Order: 20
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: 104418
Seq. Order: 21
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: 104419
Seq. Order: 22
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: 104420
Seq. Order: 23
Data Storage Type: Text
Max Length: 50
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: 104421
Seq. Order: 24
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Ice Price Per Unit

E_FREEZERCOSTS

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

Cost to operate refrigeration system onboard the vessel for this trip

E_ICEUSED

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

Number of units used

E_ICECOST

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

Total cost of ice purchased

E_GEARCOST

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

Fishing gear cost

E_PROVCOST

CC ID: 104426
Seq. Order: 29
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: 104427
Seq. Order: 30
Data Storage Type: Currency
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

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

E_FREIGHTCOST

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

Cost of transporting fish to another market; fish that cannot be used in the A.S. cannery

E_MISCCOST

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

Total cost of miscellaneous items purchased for this trip

E_SFCERT

CC ID: 104430
Seq. Order: 33
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

If swordfish fishing certificate used, indicate if purchased or not purchased

Display Example: Purchasaed, Not purchased

E_FREESOURCE

CC ID: 104431
Seq. Order: 34
Data Storage Type: Text
Max Length: 50
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_ESTCOST

CC ID: 104432
Seq. Order: 35
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: 104433
Seq. Order: 36
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_IceCost, E_GearCost , E_ProvCost , E_CommCost , E_CertCost , E_ LightstickCost

E_OPERATOR

CC ID: 104434
Seq. Order: 37
Data Storage Type: Text
Max Length: 50
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_NUMCREW

CC ID: 104435
Seq. Order: 38
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_NUMFLATRATE

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

Number of crew paid by flat rate (include captain)

E_NUMSHARE

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

Number of crew paid by share (include captain)

E_STATUSCOLLECTION

CC ID: 104438
Seq. Order: 41
Data Storage Type: Text
Max Length: 50
Required: No
Primary Key: No
Status: Active
Description:

Indicate if data collected by observer

Display Example: Yes, No, Other

E_OBSNOTE

CC ID: 104439
Seq. Order: 42
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: 104440
Seq. Order: 43
Data Storage Type: Text
Max Length: 50
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_FOREIGNCREW

CC ID: 104441
Seq. Order: 44
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_NEWCREW

CC ID: 104442
Seq. Order: 45
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_OBSNUMBER

CC ID: 104443
Seq. Order: 46
Data Storage Type: Double
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

The observer's number

E_CAPTPHONE

CC ID: 104444
Seq. Order: 47
Data Storage Type: Double
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

The phone number of the captain

E_DEBRIEFER

CC ID: 104445
Seq. Order: 48
Data Storage Type: Text
Max Length: 255
Required: No
Primary Key: No
Status: Inactive
Description:

Debriefer's initials

Support Roles

Point of Contact

CC ID: 104329
Date Effective From: 2010-05-27
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: 18752
Metadata Record Created By: Hing Ling Chan
Metadata Record Created: 2013-04-25 22:03+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2018-03-01
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2019-03-02