Metadata Rubric

83%

5 / 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_exp_vfp

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

Item Identification

Title:	c_sbs_exp_vfp
Status:	Completed

Entity Information

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

Data Attributes

Attribute Summary

	Name	Type	Description
100	EXP_PK	varchar	Primary key created for each expansion record.
100	EXP_KEY2	varchar	Primary key created to link the records found in the c_sbs_spc_r records. NOTE:Each EXP_KEY2 value records contain two Exp_PK records; thus, becareful when you link data from c_sbs_spc_r into the c_sbs_exp_r table, you will get two EXP records per each SPC record.
100	YEAR	int	Year of the survey date
100	TYPE_OF_DAY	varchar	Type of day on which the interview was conducted (1 = weekday, 2 = weekend/holiday).
100	AM_PM	varchar	Day (D) or night (N) expanded data stratum.
100	METHOD_FK	int	Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.
100	SHIFT	int	shift of the stratum
100	SUB_SHIFT	int	No used
100	POOL_FLAG	varchar	CPUE calculated with pooled data, if flagged
100	NUM_PAR	int	The number of participation log entries for the current stratum
100	NUM_RUNS	int	Number of participation runs
100	NUM_INTERVIEW	int	Total interview, including pooled interviews.
100	NUM_INTERVIEW_NOPOOL	int	Total interview, without pooled interviews.
100	NUM_CALENDAR_DAYS	int	Number of days that expansion was done
100	SUM_GEAR_PAR	int	The total number of gears recorded during participation runs for the current stratum.
100	SUM_GEAR2_PAR	int	The total number of gears recorded during participation runs for the current stratum squared.
100	SUM_FISHER_PAR	int	The total number of fishers recorded during participation runs for the current stratum.
100	SUM_TOT_KGS	decimal	Total species weight per this stratum
100	SUM_TOT_KGS2	decimal	Total species weight per this stratum squared
100	SUM_GEAR_HOUR	decimal	The number of gear hours represented by interviews collected for the current stratum.
100	SUM_GEAR_HOUR2	decimal	The number of gear hours represented by interviews collected for the current stratum squared.
100	SUM_KG_GEAR_HOUR	decimal	The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.
100	SUM_HOUR_INT	decimal	The number of fishing hours represented by interviews collected for the current stratum.
100	SUM_GEAR_INT	decimal	The total number of gears represented by interviews collected for the current stratum
100	SUM_FISHER_INT	int	The number of fishers represented by interviews collected for the current stratum
100	SUM_FISHER_HOUR_INT	decimal	The number of fisher-hours represented by interviews collected for the current stratum.
100	CPUE_GEAR_HOUR	decimal	CPUE (catch per gear-hours)
100	AVG_GEAR_PAR	decimal	Average number of gears
100	AVG_FISHER_PAR	decimal	Average number of fishers
100	EXP_HOUR	int	Expanded hours
100	EXP_GEAR_HOUR	decimal	Expanded Gear_Hour per stratum = AV_GR * EX_HR.
100	EXP_FISHER_HOUR	decimal	expanded fisher hours
100	EXP_TOT_KGS	decimal	Expanded kgs of the expansion stratum
100	VAR_EXP_TOT_KGS	decimal	Varian of expanded fish weight
100	VAR_AVG_GEAR	decimal	Varian of average gears
100	VAR_GEAR_HOUR	decimal	Varian of gear-hours CPUE
100	VAR_CPUE_GEAR_HOUR	decimal	Varian of gear-hours CPUE
100	STD_GEAR_HOUR	decimal	Standard deviation of gear-hours
100	STD_CPUE_GEAR_HOUR	decimal	Standard deviation of gear-hours CPUE
100	STD_EXP_TOT_KGS	decimal	Standard deviation of expanded weight
100	P2	decimal	P2 adjustment percent
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.

Name

Type

Description

100

EXP_PK

varchar

Primary key created for each expansion record.

100

EXP_KEY2

varchar

Primary key created to link the records found in the c_sbs_spc_r records. NOTE:Each EXP_KEY2 value records contain two Exp_PK records; thus, becareful when you link data from c_sbs_spc_r into the c_sbs_exp_r table, you will get two EXP records per each SPC record.

100

YEAR

int

Year of the survey date

100

TYPE_OF_DAY

varchar

Type of day on which the interview was conducted (1 = weekday, 2 = weekend/holiday).

100

AM_PM

varchar

Day (D) or night (N) expanded data stratum.

100

METHOD_FK

int

Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.

100

SHIFT

int

shift of the stratum

100

SUB_SHIFT

int

No used

100

POOL_FLAG

varchar

CPUE calculated with pooled data, if flagged

100

NUM_PAR

int

The number of participation log entries for the current stratum

100

NUM_RUNS

int

Number of participation runs

100

NUM_INTERVIEW

int

Total interview, including pooled interviews.

100

NUM_INTERVIEW_NOPOOL

int

Total interview, without pooled interviews.

100

NUM_CALENDAR_DAYS

int

Number of days that expansion was done

100

SUM_GEAR_PAR

int

The total number of gears recorded during participation runs for the current stratum.

100

SUM_GEAR2_PAR

int

The total number of gears recorded during participation runs for the current stratum squared.

100

SUM_FISHER_PAR

int

The total number of fishers recorded during participation runs for the current stratum.

100

SUM_TOT_KGS

decimal

Total species weight per this stratum

100

SUM_TOT_KGS2

decimal

Total species weight per this stratum squared

100

SUM_GEAR_HOUR

decimal

The number of gear hours represented by interviews collected for the current stratum.

100

SUM_GEAR_HOUR2

decimal

The number of gear hours represented by interviews collected for the current stratum squared.

100

SUM_KG_GEAR_HOUR

decimal

The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.

100

SUM_HOUR_INT

decimal

The number of fishing hours represented by interviews collected for the current stratum.

100

SUM_GEAR_INT

decimal

The total number of gears represented by interviews collected for the current stratum

100

SUM_FISHER_INT

int

The number of fishers represented by interviews collected for the current stratum

100

SUM_FISHER_HOUR_INT

decimal

The number of fisher-hours represented by interviews collected for the current stratum.

100

CPUE_GEAR_HOUR

decimal

CPUE (catch per gear-hours)

100

AVG_GEAR_PAR

decimal

Average number of gears

100

AVG_FISHER_PAR

decimal

Average number of fishers

100

EXP_HOUR

int

Expanded hours

100

EXP_GEAR_HOUR

decimal

Expanded Gear_Hour per stratum = AV_GR * EX_HR.

100

EXP_FISHER_HOUR

decimal

expanded fisher hours

100

EXP_TOT_KGS

decimal

Expanded kgs of the expansion stratum

100

VAR_EXP_TOT_KGS

decimal

Varian of expanded fish weight

100

VAR_AVG_GEAR

decimal

Varian of average gears

100

VAR_GEAR_HOUR

decimal

Varian of gear-hours CPUE

100

VAR_CPUE_GEAR_HOUR

decimal

Varian of gear-hours CPUE

100

STD_GEAR_HOUR

decimal

Standard deviation of gear-hours

100

STD_CPUE_GEAR_HOUR

decimal

Standard deviation of gear-hours CPUE

100

STD_EXP_TOT_KGS

decimal

Standard deviation of expanded weight

100

decimal

P2 adjustment percent

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

EXP_PK

CC ID: 1007859

Seq. Order:	1
Data Storage Type:	varchar
Max Length:	10
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Primary key created for each expansion record.

EXP_KEY2

CC ID: 1007860

Seq. Order:	2
Data Storage Type:	varchar
Max Length:	9
Required:	No
Primary Key:	No
Status:	Active
Description:	Primary key created to link the records found in the c_sbs_spc_r records. NOTE:Each EXP_KEY2 value records contain two Exp_PK records; thus, becareful when you link data from c_sbs_spc_r into the c_sbs_exp_r table, you will get two EXP records per each SPC record.

YEAR

CC ID: 1007861

Seq. Order:	3
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Year of the survey date

TYPE_OF_DAY

CC ID: 1007862

Seq. Order:	4
Data Storage Type:	varchar
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of day on which the interview was conducted (1 = weekday, 2 = weekend/holiday).

AM_PM

CC ID: 1007863

Seq. Order:	5
Data Storage Type:	varchar
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Day (D) or night (N) expanded data stratum.

METHOD_FK

CC ID: 1007864

Seq. Order:	6
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.

SHIFT

CC ID: 1007865

Seq. Order:	7
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	shift of the stratum

SUB_SHIFT

CC ID: 1007866

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

POOL_FLAG

CC ID: 1007867

Seq. Order:	9
Data Storage Type:	varchar
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	CPUE calculated with pooled data, if flagged

NUM_PAR

CC ID: 1007868

Seq. Order:	10
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of participation log entries for the current stratum

NUM_RUNS

CC ID: 1007869

Seq. Order:	11
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of participation runs

NUM_INTERVIEW

CC ID: 1007870

Seq. Order:	12
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Total interview, including pooled interviews.

NUM_INTERVIEW_NOPOOL

CC ID: 1007871

Seq. Order:	13
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Total interview, without pooled interviews.

NUM_CALENDAR_DAYS

CC ID: 1007872

Seq. Order:	14
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of days that expansion was done

SUM_GEAR_PAR

CC ID: 1007873

Seq. Order:	15
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of gears recorded during participation runs for the current stratum.

SUM_GEAR2_PAR

CC ID: 1007874

Seq. Order:	16
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of gears recorded during participation runs for the current stratum squared.

SUM_FISHER_PAR

CC ID: 1007875

Seq. Order:	17
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The total number of fishers recorded during participation runs for the current stratum.

SUM_TOT_KGS

CC ID: 1007876

Seq. Order:	18
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	4
Status:	Active
Description:	Total species weight per this stratum

SUM_TOT_KGS2

CC ID: 1007877

Seq. Order:	19
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	4
Status:	Active
Description:	Total species weight per this stratum squared

SUM_GEAR_HOUR

CC ID: 1007878

Seq. Order:	20
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	5
Status:	Active
Description:	The number of gear hours represented by interviews collected for the current stratum.

SUM_GEAR_HOUR2

CC ID: 1007879

Seq. Order:	21
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	5
Status:	Active
Description:	The number of gear hours represented by interviews collected for the current stratum squared.

SUM_KG_GEAR_HOUR

CC ID: 1007880

Seq. Order:	22
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	5
Status:	Active
Description:	The sum of the product of total catch weight and number of gear hours represented by interviews for the current stratum.

SUM_HOUR_INT

CC ID: 1007881

Seq. Order:	23
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	The number of fishing hours represented by interviews collected for the current stratum.

SUM_GEAR_INT

CC ID: 1007882

Seq. Order:	24
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	The total number of gears represented by interviews collected for the current stratum

SUM_FISHER_INT

CC ID: 1007883

Seq. Order:	25
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of fishers represented by interviews collected for the current stratum

SUM_FISHER_HOUR_INT

CC ID: 1007884

Seq. Order:	26
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	The number of fisher-hours represented by interviews collected for the current stratum.

CPUE_GEAR_HOUR

CC ID: 1007885

Seq. Order:	27
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	4
Status:	Active
Description:	CPUE (catch per gear-hours)

AVG_GEAR_PAR

CC ID: 1007886

Seq. Order:	28
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	4
Status:	Active
Description:	Average number of gears

AVG_FISHER_PAR

CC ID: 1007887

Seq. Order:	29
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	4
Status:	Active
Description:	Average number of fishers

EXP_HOUR

CC ID: 1007888

Seq. Order:	30
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Expanded hours

EXP_GEAR_HOUR

CC ID: 1007889

Seq. Order:	31
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Expanded Gear_Hour per stratum = AV_GR * EX_HR.

EXP_FISHER_HOUR

CC ID: 1007890

Seq. Order:	32
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	expanded fisher hours

EXP_TOT_KGS

CC ID: 1007891

Seq. Order:	33
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	2
Status:	Active
Description:	Expanded kgs of the expansion stratum

VAR_EXP_TOT_KGS

CC ID: 1007892

Seq. Order:	34
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	4
Status:	Active
Description:	Varian of expanded fish weight

VAR_AVG_GEAR

CC ID: 1007893

Seq. Order:	35
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	4
Status:	Active
Description:	Varian of average gears

VAR_GEAR_HOUR

CC ID: 1007894

Seq. Order:	36
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	4
Status:	Active
Description:	Varian of gear-hours CPUE

VAR_CPUE_GEAR_HOUR

CC ID: 1007895

Seq. Order:	37
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	15
Scale:	4
Status:	Active
Description:	Varian of gear-hours CPUE

STD_GEAR_HOUR

CC ID: 1007896

Seq. Order:	38
Data Storage Type:	decimal
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Standard deviation of gear-hours

STD_CPUE_GEAR_HOUR

CC ID: 1007897

Seq. Order:	39
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Standard deviation of gear-hours CPUE

STD_EXP_TOT_KGS

CC ID: 1007898

Seq. Order:	40
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	6
Scale:	1
Status:	Active
Description:	Standard deviation of expanded weight

P2

CC ID: 1007899

Seq. Order:	41
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	6
Scale:	4
Status:	Active
Description:	P2 adjustment percent

LOAD_TABLE

CC ID: 1007900

Seq. Order:	42
Data Storage Type:	varchar
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the FoxPro table that was loaded into MySQL.

LOAD_DATETIME

CC ID: 1007901

Seq. Order:	43
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: 1007902

Seq. Order:	44
Data Storage Type:	varchar
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	User who loaded the data to the MySQL table.

Catalog Details

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