Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
79%
4.74 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > American Samoa Boat-based Creel Survey >

a_bbs_exp_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63474  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: a_bbs_exp_vfp
Status: Completed

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: amsam_dmwr_wh

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key EXP_PK int Primary key created for each expansion record.
67
 DATA_YEAR int
67
 KEY_FLD varchar
100
 METHOD_FK int Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
100
 NUM_SAMPLE_DAYS int Number of sample days in the expansion period.
100
 NUM_EXP_DAYS int Number of calendar days used for the expansion.
67
 NUM_INT int
67
 NUM_INT_WITH_FISHER int
67
 NUM_INT_WITH_GEAR int
67
 NUM_INT_WITH_HOUR int
67
 NUM_INT_WITH_FISHR_HR int
100
 NUM_BOATDAY_TRIPS decimal boat-day trips calculated from interview data.
100
 AVG_BOATDAY_TRIPS decimal Average boat day trips per this stratum.
100
 AVG_BOATHOURS_PER_TRIP decimal Average boat-hours per trip per this stratum.
100
 AVG_FISHERS_PER_TRIP decimal Average fisher per trip per this stratum.
100
 AVG_GEARS_PER_TRIP decimal Average gear per trip per this stratum.
100
 AVG_FISHER_HOUR_PER_TRIP decimal Average fisher-hours per trip per this stratum.
67
 TRIP_CPUE decimal
100
 HOUR_CPUE decimal CPUE of hours fished.
100
 FISHER_HOUR_CPUE decimal CPUE of fisher-hours
100
 GEAR_CPUE decimal Gear CPUE
100
 EXP_TRIPS decimal Expanded number of trips.
100
 EXP_FISHERS decimal Expanded number of fishers.
100
 EXP_HOURS decimal Expanded number of hours fished.
100
 EXP_FISHER_HOURS decimal Expanded number of fisher-hours.
100
 EXP_GEARS decimal Expanded number of fishing gears for the current stratum. (for longlining, 1 gear = 1000 hooks).
100
 EXP_LBS decimal Expanded pounds caught.
100
 METHOD_NAME varchar Fishing method.
100
 LOAD_TABLE varchar Name of the FoxPro table that was loaded into MySQL.
100
 LOAD_DATETIME datetime The date and time the data was loaded in to the table
100
 LOAD_USER varchar User who loaded the data to the MySQL table.

Attribute Details

EXP_PK

CC ID: 1008317
Seq. Order: 1
Data Storage Type: int
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

Primary key created for each expansion record.

DATA_YEAR

CC ID: 1008318
Seq. Order: 2
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

KEY_FLD

CC ID: 1008319
Seq. Order: 3
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active

METHOD_FK

CC ID: 1008320
Seq. Order: 4
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.

NUM_SAMPLE_DAYS

CC ID: 1008321
Seq. Order: 5
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of sample days in the expansion period.

NUM_EXP_DAYS

CC ID: 1008322
Seq. Order: 6
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of calendar days used for the expansion.

NUM_INT

CC ID: 1008323
Seq. Order: 7
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

NUM_INT_WITH_FISHER

CC ID: 1008324
Seq. Order: 8
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

NUM_INT_WITH_GEAR

CC ID: 1008325
Seq. Order: 9
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

NUM_INT_WITH_HOUR

CC ID: 1008326
Seq. Order: 10
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

NUM_INT_WITH_FISHR_HR

CC ID: 1008327
Seq. Order: 11
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active

NUM_BOATDAY_TRIPS

CC ID: 1008328
Seq. Order: 12
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

boat-day trips calculated from interview data.

AVG_BOATDAY_TRIPS

CC ID: 1008329
Seq. Order: 13
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Average boat day trips per this stratum.

AVG_BOATHOURS_PER_TRIP

CC ID: 1008330
Seq. Order: 14
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Average boat-hours per trip per this stratum.

AVG_FISHERS_PER_TRIP

CC ID: 1008331
Seq. Order: 15
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Average fisher per trip per this stratum.

AVG_GEARS_PER_TRIP

CC ID: 1008332
Seq. Order: 16
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Average gear per trip per this stratum.

AVG_FISHER_HOUR_PER_TRIP

CC ID: 1008333
Seq. Order: 17
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Average fisher-hours per trip per this stratum.

TRIP_CPUE

CC ID: 1008334
Seq. Order: 18
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active

HOUR_CPUE

CC ID: 1008335
Seq. Order: 19
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

CPUE of hours fished.

FISHER_HOUR_CPUE

CC ID: 1008336
Seq. Order: 20
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

CPUE of fisher-hours

GEAR_CPUE

CC ID: 1008337
Seq. Order: 21
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Gear CPUE

EXP_TRIPS

CC ID: 1008338
Seq. Order: 22
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded number of trips.

EXP_FISHERS

CC ID: 1008339
Seq. Order: 23
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded number of fishers.

EXP_HOURS

CC ID: 1008340
Seq. Order: 24
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded number of hours fished.

EXP_FISHER_HOURS

CC ID: 1008341
Seq. Order: 25
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded number of fisher-hours.

EXP_GEARS

CC ID: 1008342
Seq. Order: 26
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 10
Scale: 2
Status: Active
Description:

Expanded number of fishing gears for the current stratum. (for longlining, 1 gear = 1000 hooks).

EXP_LBS

CC ID: 1008343
Seq. Order: 27
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 15
Scale: 2
Status: Active
Description:

Expanded pounds caught.

METHOD_NAME

CC ID: 1008344
Seq. Order: 28
Data Storage Type: varchar
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

Fishing method.

LOAD_TABLE

CC ID: 1008345
Seq. Order: 29
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Name of the FoxPro table that was loaded into MySQL.

LOAD_DATETIME

CC ID: 1008346
Seq. Order: 30
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

The date and time the data was loaded in to the table

LOAD_USER

CC ID: 1008347
Seq. Order: 31
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

User who loaded the data to the MySQL table.

Catalog Details

Catalog Item ID: 63474
GUID: gov.noaa.nmfs.inport:63474
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:25+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-01-21
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-01-21
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-01-21