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
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