Search Help Show/Hide Menu
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