63475
a_bbs_spc_vfp
Entity
Published / External
5612
American Samoa Boat-based Creel Survey
Data Set
Completed
Data Table
Yes
amsam_dmwr_wh
1
SPC_PK
int
Yes
Yes
10
0
Active
System-generated artificial primary key.
2
DATA_YEAR
int
No
No
10
0
Active
3
KEY_FLD
varchar
10
No
No
Active
Key that link this record to its related record found in the a_bbs_exp_vfp table.
4
METHOD_FK
int
No
No
10
0
Active
Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
5
SPECIES_FK
int
No
No
10
0
Active
6
EXP_LBS
decimal
No
No
15
2
Active
Expanded pounds caught.
7
EXP_LBS_SOLD
decimal
No
No
15
2
Active
Expanded pounds sold.
8
EXP_REVENUE
decimal
No
No
15
2
Active
9
PRICE_PER_LB
decimal
No
No
6
2
Active
Price per pound
10
SPECIES_NAME
varchar
28
No
No
Active
Name of species
11
METHOD_NAME
varchar
30
No
No
Active
Fishing method.
12
LOAD_TABLE
varchar
32
No
No
Active
Name of the FoxPro table that was loaded into MySQL.
13
LOAD_DATETIME
datetime
No
No
Active
The date and time the data was loaded in to the table
14
LOAD_USER
varchar
32
No
No
Active
User who loaded the data to the MySQL table.
gov.noaa.nmfs.inport:63475
Brent Miyamoto
2021-01-21T01:25:56
SysAdmin InPortAdmin
2022-08-09T17:11:55
2021-01-21
Pacific Islands Fisheries Science Center
PIFSC
1845 Wasp Blvd.
Honolulu
HI
96818
USA
808-725-5300
https://www.pifsc.noaa.gov
8:00 a.m. - 4:30 p.m.
1001
Public
No
2021-01-21
1 Year
2022-01-21