Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
79%
4.74 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > 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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data Table

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

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

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