Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 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_exp_vfp

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

Summary

Entity Information

Entity Type
Data Table

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

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key 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.

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