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

g_sbs_spc_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63473  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Description

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPC_PK
varchar 		UID created for this record
EXP_FK
varchar 		Key link each species record back to it parent record (c_sbs_exp_vfp, EXP_KEY2)
SPECIES_FK
int 		Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
SPECIES_NAME
varchar 		Species name
PERCENT_COMP
decimal 		This species composition
EXP_KGS
decimal 		Expanded kgs of this species
KGS
decimal 		Fish weight in kilograms.
NUM_KEPT
int 		Number of pieces of fish caught.
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: g_sbs_spc_vfp
Status: Completed
Abstract:

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: guam_dawr_wh
Description:

Contains shore-based creel survey expanded catch data based on monthly, quarterly, or yearly periods.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SPC_PK varchar UID created for this record
100
 EXP_FK varchar Key link each species record back to it parent record (c_sbs_exp_vfp, EXP_KEY2)
100
 SPECIES_FK int Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
100
 SPECIES_NAME varchar Species name
100
 PERCENT_COMP decimal This species composition
100
 EXP_KGS decimal Expanded kgs of this species
100
 KGS decimal Fish weight in kilograms.
100
 NUM_KEPT int Number of pieces of fish caught.
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: 1008306
Seq. Order: 1
Data Storage Type: varchar
Max Length: 15
Required: Yes
Primary Key: Yes
Status: Active
Description:

UID created for this record

EXP_FK

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

Key link each species record back to it parent record (c_sbs_exp_vfp, EXP_KEY2)

SPECIES_FK

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

Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF

SPECIES_NAME

CC ID: 1008309
Seq. Order: 4
Data Storage Type: varchar
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

Species name

PERCENT_COMP

CC ID: 1008310
Seq. Order: 5
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 6
Scale: 3
Status: Active
Description:

This species composition

EXP_KGS

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

Expanded kgs of this species

KGS

CC ID: 1008312
Seq. Order: 7
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Fish weight in kilograms.

NUM_KEPT

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

Number of pieces of fish caught.

LOAD_TABLE

CC ID: 1008314
Seq. Order: 9
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: 1008315
Seq. Order: 10
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: 1008316
Seq. Order: 11
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: 63473
GUID: gov.noaa.nmfs.inport:63473
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:10+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