Search Help Show/Hide Menu
Metadata Rubric
80%
4.79 / 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_spc_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63475  |  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
SPC_PK
int 		System-generated artificial primary key.
DATA_YEAR
int
KEY_FLD
varchar 		Key that link this record to its related record found in the a_bbs_exp_vfp table.
METHOD_FK
int 		Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
SPECIES_FK
int
EXP_LBS
decimal 		Expanded pounds caught.
EXP_LBS_SOLD
decimal 		Expanded pounds sold.
EXP_REVENUE
decimal
PRICE_PER_LB
decimal 		Price per pound
SPECIES_NAME
varchar 		Name of species
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_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
 Primary Key SPC_PK int System-generated artificial primary key.
67
 DATA_YEAR int
100
 KEY_FLD varchar Key that link this record to its related record found in the a_bbs_exp_vfp table.
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.
67
 SPECIES_FK int
100
 EXP_LBS decimal Expanded pounds caught.
100
 EXP_LBS_SOLD decimal Expanded pounds sold.
67
 EXP_REVENUE decimal
100
 PRICE_PER_LB decimal Price per pound
100
 SPECIES_NAME varchar Name of species
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

SPC_PK

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

System-generated artificial primary key.

DATA_YEAR

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

KEY_FLD

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

Key that link this record to its related record found in the a_bbs_exp_vfp table.

METHOD_FK

CC ID: 1008351
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.

SPECIES_FK

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

EXP_LBS

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

Expanded pounds caught.

EXP_LBS_SOLD

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

Expanded pounds sold.

EXP_REVENUE

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

PRICE_PER_LB

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

Price per pound

SPECIES_NAME

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

Name of species

METHOD_NAME

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

Fishing method.

LOAD_TABLE

CC ID: 1008359
Seq. Order: 12
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: 1008360
Seq. Order: 13
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: 1008361
Seq. Order: 14
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: 63475
GUID: gov.noaa.nmfs.inport:63475
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