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_spc_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63478  |  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_exp_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
SPECIES_FK
int 		species code , detailed information can be found in A_SPECIES.
NUM_INT
int 		Total number of interviews used in the expansion.
INT_SPEC_LBS
decimal 		Total lbs of this species from interview data.
INT_SPEC_SOLD_LBS
decimal 		Total sold lbs of this species from interview data.
INT_SPEC_SOLD_REV
decimal 		Total sold value of this species from interview data.
POOLED_INT
int 		Total number of interviews used in the expansion.
EXP_LBS
decimal 		expanded pounds caught
EXP_LBS_SOLD
decimal 		expanded pounds sold.
EXP_REVENUE
decimal 		expanded Total catch revenue
ROUTE_NAME
varchar 		The name of the route.
METHOD_NAME
varchar 		gear used.
SPECIES_NAME
varchar 		common species name
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_spc_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_exp_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
 SPECIES_FK int species code , detailed information can be found in A_SPECIES.
100
 NUM_INT int Total number of interviews used in the expansion.
100
 INT_SPEC_LBS decimal Total lbs of this species from interview data.
100
 INT_SPEC_SOLD_LBS decimal Total sold lbs of this species from interview data.
100
 INT_SPEC_SOLD_REV decimal Total sold value of this species from interview data.
100
 POOLED_INT int Total number of interviews used in the expansion.
100
 EXP_LBS decimal expanded pounds caught
100
 EXP_LBS_SOLD decimal expanded pounds sold.
100
 EXP_REVENUE decimal expanded Total catch revenue
100
 ROUTE_NAME varchar The name of the route.
100
 METHOD_NAME varchar gear used.
100
 SPECIES_NAME varchar common species name
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: 1008507
Seq. Order: 1
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Data year

KEYFLD

CC ID: 1008508
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_exp_vfp table

EXP_PERIOD

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

Expansion period

ROUTE_FK

CC ID: 1008510
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: 1008511
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: 1008512
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: 1008513
Seq. Order: 7
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Expansion domain of Day or Night

SPECIES_FK

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

species code , detailed information can be found in A_SPECIES.

NUM_INT

CC ID: 1008515
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_SPEC_LBS

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

Total lbs of this species from interview data.

INT_SPEC_SOLD_LBS

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

Total sold lbs of this species from interview data.

INT_SPEC_SOLD_REV

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

Total sold value of this species from interview data.

POOLED_INT

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

Total number of interviews used in the expansion.

EXP_LBS

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

expanded pounds caught

EXP_LBS_SOLD

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

expanded pounds sold.

EXP_REVENUE

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

expanded Total catch revenue

ROUTE_NAME

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

The name of the route.

METHOD_NAME

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

gear used.

SPECIES_NAME

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

common species name

LOAD_TABLE

CC ID: 1008526
Seq. Order: 20
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: 1008527
Seq. Order: 21
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: 1008528
Seq. Order: 22
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: 63478
GUID: gov.noaa.nmfs.inport:63478
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:30+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