Slide Menu
Jump to Section...
Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
Metadata Rubric
80%
4.79 / 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_spc_vfp

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

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