Slide Menu
Jump to Section...
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 (... > CNMI Shore-based Creel Survey >

c_sbs_spc_vfp

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

Item Identification

Title: c_sbs_spc_vfp
Status: Completed
Abstract:

Contains expanded species composition data by method.

Entity Information

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

Contains expanded species composition data by method.

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 Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.DBF.
100
 SPECIES_NAME varchar Species name
100
 EXP_KGS decimal Expanded kgs of this species
100
 EXP_TOT_KGS decimal Expanded kgs of the expansion stratum
100
 TOT_KGS_INT decimal Total weight of all species of this stratum if no pooling were made (same as TOT_KGS); otherwise, it is NULL (999.99). However, the value is seemmed to be double (as compared to the TOT_KGS)
100
 TOT_KGS decimal Total weight of all species found in interviews (pooling included) of this stratum
100
 PERCENT_COMP decimal This species composition
100
 KGS decimal Fish weight in kilograms.
100
 NUM_KEPT int Number of pieces of fish caught.
100
 POOL_FLAG varchar CPUE calculated with pooled data, if flagged
100
 LOAD_TABLE varchar Name of the FoxPro table that was loaded into MySQL.
100
 P2 varchar P2 adjustment percent
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.
100
 YEAR int Year of the survey date

Attribute Details

SPC_PK

CC ID: 1007977
Seq. Order: 1
Data Storage Type: varchar
Max Length: 14
Required: Yes
Primary Key: Yes
Status: Active
Description:

UID created for this record

EXP_FK

CC ID: 1007978
Seq. Order: 2
Data Storage Type: varchar
Max Length: 9
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: 1007979
Seq. Order: 3
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.DBF.

SPECIES_NAME

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

Species name

EXP_KGS

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

Expanded kgs of this species

EXP_TOT_KGS

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

Expanded kgs of the expansion stratum

TOT_KGS_INT

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

Total weight of all species of this stratum if no pooling were made (same as TOT_KGS); otherwise, it is NULL (999.99). However, the value is seemmed to be double (as compared to the TOT_KGS)

TOT_KGS

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

Total weight of all species found in interviews (pooling included) of this stratum

PERCENT_COMP

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

This species composition

KGS

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

Fish weight in kilograms.

NUM_KEPT

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

Number of pieces of fish caught.

POOL_FLAG

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

CPUE calculated with pooled data, if flagged

LOAD_TABLE

CC ID: 1007989
Seq. Order: 13
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.

P2

CC ID: 1007990
Seq. Order: 14
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

P2 adjustment percent

LOAD_DATETIME

CC ID: 1007991
Seq. Order: 15
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: 1007992
Seq. Order: 16
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

User who loaded the data to the MySQL table.

YEAR

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

Year of the survey date

Catalog Details

Catalog Item ID: 63466
GUID: gov.noaa.nmfs.inport:63466
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 00:51+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