Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > American Samoa Shore-based Creel Survey >

a_sbs_exp_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63477  |  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
DATA_YEAR
int 		Data year
KEYFLD
varchar 		key value created to link data records between this and the a_sbs_spc_vfp table
EXP_PERIOD
varchar 		Expansion period
ROUTE_FK
int 		Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
METHOD_FK
int 		Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
TYPE_OF_DAY
varchar 		Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
DAY_NIGHT
varchar 		Expansion domain of Day or Night
POOLING_TYPE
varchar 		How interview data were borrowed and used in the expansion.
NUM_INT
int 		Total number of interviews used in the expansion.
INT_LBS
decimal 		total pounds per this demain before expanded.
GEAR_HRS
decimal 		Gear-hr of this domain.
EXP_GEARS
decimal 		expanded number of gears
EXP_PP
decimal 		expanded number of people
GEAR_HR_CPUE
decimal 		Catch per Gear-hr of this domain.
EXP_LBS
decimal 		expanded pounds caught
ROUTE_NAME
varchar 		The name of the route.
METHOD_NAME
varchar 		gear used.
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_sbs_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
 DATA_YEAR int Data year
100
 KEYFLD varchar key value created to link data records between this and the a_sbs_spc_vfp table
100
 EXP_PERIOD varchar Expansion period
100
 ROUTE_FK int Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
100
 METHOD_FK int Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
100
 TYPE_OF_DAY varchar Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
100
 DAY_NIGHT varchar Expansion domain of Day or Night
100
 POOLING_TYPE varchar How interview data were borrowed and used in the expansion.
100
 NUM_INT int Total number of interviews used in the expansion.
100
 INT_LBS decimal total pounds per this demain before expanded.
100
 GEAR_HRS decimal Gear-hr of this domain.
100
 EXP_GEARS decimal expanded number of gears
100
 EXP_PP decimal expanded number of people
100
 GEAR_HR_CPUE decimal Catch per Gear-hr of this domain.
100
 EXP_LBS decimal expanded pounds caught
100
 ROUTE_NAME varchar The name of the route.
100
 METHOD_NAME varchar gear used.
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

DATA_YEAR

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

Data year

KEYFLD

CC ID: 1008488
Seq. Order: 2
Data Storage Type: varchar
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

key value created to link data records between this and the a_sbs_spc_vfp table

EXP_PERIOD

CC ID: 1008489
Seq. Order: 3
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Expansion period

ROUTE_FK

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

Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.

METHOD_FK

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

Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.

TYPE_OF_DAY

CC ID: 1008492
Seq. Order: 6
Data Storage Type: varchar
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.

DAY_NIGHT

CC ID: 1008493
Seq. Order: 7
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Expansion domain of Day or Night

POOLING_TYPE

CC ID: 1008494
Seq. Order: 8
Data Storage Type: varchar
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

How interview data were borrowed and used in the expansion.

NUM_INT

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

Total number of interviews used in the expansion.

INT_LBS

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

total pounds per this demain before expanded.

GEAR_HRS

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

Gear-hr of this domain.

EXP_GEARS

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

expanded number of gears

EXP_PP

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

expanded number of people

GEAR_HR_CPUE

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

Catch per Gear-hr of this domain.

EXP_LBS

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

expanded pounds caught

ROUTE_NAME

CC ID: 1008502
Seq. Order: 16
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The name of the route.

METHOD_NAME

CC ID: 1008503
Seq. Order: 17
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

gear used.

LOAD_TABLE

CC ID: 1008504
Seq. Order: 18
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: 1008505
Seq. Order: 19
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: 1008506
Seq. Order: 20
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: 63477
GUID: gov.noaa.nmfs.inport:63477
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:29+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