Metadata Rubric

100%

6 / 6

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

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Contains expanded species composition data by method.

Description

Contains expanded species composition data by method.

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

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

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

SPECIES_NAME
varchar

Species name

EXP_KGS
decimal

Expanded kgs of this species

EXP_TOT_KGS
decimal

Expanded kgs of the expansion stratum

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)

TOT_KGS
decimal

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

PERCENT_COMP
decimal

This species composition

KGS
decimal

Fish weight in kilograms.

NUM_KEPT
int

Number of pieces of fish caught.

POOL_FLAG
varchar

CPUE calculated with pooled data, if flagged

LOAD_TABLE
varchar

Name of the FoxPro table that was loaded into MySQL.

P2
varchar

P2 adjustment percent

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.

YEAR
int

Year of the survey date

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (PIFSC) for inquiries on this record.

Title:	c_sbs_spc_vfp
Status:	Completed
Abstract:	Contains expanded species composition data by method.

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	cnmi_dfw_wh
Description:	Contains expanded species composition data by method.

Attribute Summary

	Name	Type	Description
100	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

Name

Type

Description

100

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

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

c_sbs_spc_vfp

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

SPC_PK

EXP_FK

SPECIES_FK

SPECIES_NAME

EXP_KGS

EXP_TOT_KGS

TOT_KGS_INT

TOT_KGS

PERCENT_COMP

KGS

NUM_KEPT

POOL_FLAG

LOAD_TABLE

P2

LOAD_DATETIME

LOAD_USER

YEAR

Catalog Details