Metadata Rubric

100%

6 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > Guam Boat-based Creel Survey >

g_bbs_exp_vfp

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

Item Identification

Title:	g_bbs_exp_vfp
Status:	Completed
Abstract:	Contains expanded catch data based on monthly, quarterly, and yearly time periods from Manu`a and Tutuila and the weekend and weekday expansions for all species combined.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	guam_dawr_wh
Description:	Contains expanded catch data based on monthly, quarterly, and yearly time periods from Manu`a and Tutuila and the weekend and weekday expansions for all species combined.

Data Attributes

Attribute Summary

	Name	Type	Description
100	EXPANSION_PK	int	System-generated artificial primary key.
100	YEAR_QUARTER	int	Start year and quarter and end year and quarter of expansion data.
100	TYPE_OF_DAY	int	Type of day on which the interview was conducted. Values are '1' for a weekday and '2' for a weekend/holiday). Calculated field.
100	PORT	int	Port code.
100	CHARTER_F	char	If true, it is a charter trip.
100	METHOD	int	Fishing method code.
100	SM_TR	decimal	Sum of the fishing trips from G_BBS_BLHD or GOfyyBLD.DBF.
100	SM_TR2	decimal	Sum of the number of trips squared (Trip: number of trips per DAY-PORT-CHARTER-METHOD in GOFyyBLD.DBF). For CV calculation.
100	NUM_SV	int	Number of surveys in G_BBS_BLDT or GOFyyBLD.DBF.
100	AVG_EST_TRIP	decimal	Average trip per day from boat log.
100	DAYS_Q	int	Number of actual calendar days in the expansion period.
100	EXP_TRIP	decimal	Expanded trips per stratum = AV_ES_TR * DAYS_Q.
100	EXP_HOUR	decimal	Expanded hours fished per stratum = EX_FACTOR * SM_HR.
100	EXP_FISHER	decimal	Expanded number of fishers per stratum = EX_FACTOR * SM_PRSN
100	EXP_FISHER_HOUR	decimal	Expanded FISHERMAN_HOUR per stratum = EX_FACTOR * SM_PR_HR.
100	EXP_GEAR_HOUR	decimal	Expanded Gear_Hour per stratum = EX_FACTOR * SM_GR_HR.
100	CPUE_TRIP	decimal	Caught in kilograms per trip in stratum = SM_KG / NUM_INT.
100	EXP_CATCH	decimal	Expanded total kilograms caught in stratum = EX_TR * TR_CPUE.
100	VAR_EST_TRIP	decimal	Variance of ES_TR = (AD_SM_TR2 - AD_SM_TR^2 / DAY_SAMP) / (DAY_SAMP-1) / DAY_SAMP.
100	VAR_EXP_TRIP	decimal	Variance of EX_TR = V_ES_TR * DAYS_Q^2.
100	VAR_CPUE_TRIP	decimal	Variance of TR_CPUE = (SM_KG2 - Sm_Kg^2 / NUM_INT) / (NUM_INT-1) / NUM_INT.
100	VAR_EXP_CATCH	decimal	Variance of EX_CAT = (V_TR_CPUE * (EX_TR^2)) + (V_EX_TR * (TR_CPUE^2)) + (V_EX_TR * V_TR_CPUE).
100	STD_EXP_TRIP	decimal	CV of EX_TR = 100 * SQRT ( ABS (V_EX_TR) ) / EX_TR.
100	STD_CPUE_TRIP	decimal	CV of TR_CPUE = 100 * SQRT (ABS (V_TR_CPUE)) / TR_CPUE.
100	STD_EXP_CATCH	decimal	CV of EX_CAT =100 * SQRT ( ABS (V_EX_CAT)) / EX_CAT.
100	NUM_SAMPLE_DAY	int	Number of sampled days.
100	P1	decimal	A temporal adjustment factor for expansion from MYSQL NAME or GOFyyP1.DBF.
100	P2	decimal	A spatial adjustment factor for expansion: the boat or trailer count ratio between non-surveyed ports and surveyed ports from GOFyyIWC.DBF.
100	AD_FISH	decimal	Reflects the adjustment for a better trip estimate. For example, in GOFyyBLD.DBF, FISHED could = U (unknown) or = Y, and METHOD could = 0.
100	AD_SM_TR	decimal	Adjusted sum of the fishing trips = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
100	AD_SM_TR2	decimal	Adjusted sum of the fishing trips squared = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
100	SM_KG	decimal	Sum of the TOT_KGS in the stratum from GOFyyINT.DBF.
100	SM_KG2	decimal	Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
100	NUM_INT0	int	The number of interviews counted for this stratum.
100	NUM_INT	int	The number of interviews counted for this stratum.
100	SM_HOUR	decimal	Sum of HRS_FISH in the stratum from GOFyyINT.DBF.
100	SM_HOUR2	decimal	Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
100	SM_PRSN	int	Sum of NUM_FISHER in the stratum from GOFyyINT.DBF.
100	SM_PR2	int	Sum of NUM_FISHER^2 in the stratum from GOFyyINT.DBF.
100	SM_PR_HR	decimal	Sum of (NUM_FISHER * HRS_FISH) in the stratum from GOFyyINT.DBF.
100	SM_PR_HR2	decimal	Sum of (NUM_FISHER^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
100	SM_GEAR_HOUR	decimal	Sum of (NUM_GEAR * HRS_FISH) in the stratum from GOFyyINT.DBF.
100	SM_GEAR_HOUR2	decimal	Sum of (NUM_GEAR^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
100	EX_FACTOR	decimal	Expansion factor (EXP_TRIP/interviews trip) uses to create the expaned efforts data (e.g. EXP_FISHER, EXP_HOURS, etc.)
100	POOL_FLAG	varchar	Shows the quality of expanded data in the stratum (Nothing: standard stratum, D: combined TYP_DAY, M: combined METHOD 4-6 to 4, P: combined Port 1, 2, p: combined Port 1-3 for METHOD =1 or 3).
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

EXPANSION_PK

int

System-generated artificial primary key.

100

YEAR_QUARTER

int

Start year and quarter and end year and quarter of expansion data.

100

TYPE_OF_DAY

int

Type of day on which the interview was conducted. Values are '1' for a weekday and '2' for a weekend/holiday). Calculated field.

100

PORT

int

Port code.

100

CHARTER_F

char

If true, it is a charter trip.

100

METHOD

int

Fishing method code.

100

SM_TR

decimal

Sum of the fishing trips from G_BBS_BLHD or GOfyyBLD.DBF.

100

SM_TR2

decimal

Sum of the number of trips squared (Trip: number of trips per DAY-PORT-CHARTER-METHOD in GOFyyBLD.DBF). For CV calculation.

100

NUM_SV

int

Number of surveys in G_BBS_BLDT or GOFyyBLD.DBF.

100

AVG_EST_TRIP

decimal

Average trip per day from boat log.

100

DAYS_Q

int

Number of actual calendar days in the expansion period.

100

EXP_TRIP

decimal

Expanded trips per stratum = AV_ES_TR * DAYS_Q.

100

EXP_HOUR

decimal

Expanded hours fished per stratum = EX_FACTOR * SM_HR.

100

EXP_FISHER

decimal

Expanded number of fishers per stratum = EX_FACTOR * SM_PRSN

100

EXP_FISHER_HOUR

decimal

Expanded FISHERMAN_HOUR per stratum = EX_FACTOR * SM_PR_HR.

100

EXP_GEAR_HOUR

decimal

Expanded Gear_Hour per stratum = EX_FACTOR * SM_GR_HR.

100

CPUE_TRIP

decimal

Caught in kilograms per trip in stratum = SM_KG / NUM_INT.

100

EXP_CATCH

decimal

Expanded total kilograms caught in stratum = EX_TR * TR_CPUE.

100

VAR_EST_TRIP

decimal

Variance of ES_TR = (AD_SM_TR2 - AD_SM_TR^2 / DAY_SAMP) / (DAY_SAMP-1) / DAY_SAMP.

100

VAR_EXP_TRIP

decimal

Variance of EX_TR = V_ES_TR * DAYS_Q^2.

100

VAR_CPUE_TRIP

decimal

Variance of TR_CPUE = (SM_KG2 - Sm_Kg^2 / NUM_INT) / (NUM_INT-1) / NUM_INT.

100

VAR_EXP_CATCH

decimal

Variance of EX_CAT = (V_TR_CPUE * (EX_TR^2)) + (V_EX_TR * (TR_CPUE^2)) + (V_EX_TR * V_TR_CPUE).

100

STD_EXP_TRIP

decimal

CV of EX_TR = 100 * SQRT ( ABS (V_EX_TR) ) / EX_TR.

100

STD_CPUE_TRIP

decimal

CV of TR_CPUE = 100 * SQRT (ABS (V_TR_CPUE)) / TR_CPUE.

100

STD_EXP_CATCH

decimal

CV of EX_CAT =100 * SQRT ( ABS (V_EX_CAT)) / EX_CAT.

100

NUM_SAMPLE_DAY

int

Number of sampled days.

100

decimal

A temporal adjustment factor for expansion from MYSQL NAME or GOFyyP1.DBF.

100

decimal

A spatial adjustment factor for expansion: the boat or trailer count ratio between non-surveyed ports and surveyed ports from GOFyyIWC.DBF.

100

AD_FISH

decimal

Reflects the adjustment for a better trip estimate. For example, in GOFyyBLD.DBF, FISHED could = U (unknown) or = Y, and METHOD could = 0.

100

AD_SM_TR

decimal

Adjusted sum of the fishing trips = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.

100

AD_SM_TR2

decimal

Adjusted sum of the fishing trips squared = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.

100

SM_KG

decimal

Sum of the TOT_KGS in the stratum from GOFyyINT.DBF.

100

SM_KG2

decimal

Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.

100

NUM_INT0

int

The number of interviews counted for this stratum.

100

NUM_INT

int

The number of interviews counted for this stratum.

100

SM_HOUR

decimal

Sum of HRS_FISH in the stratum from GOFyyINT.DBF.

100

SM_HOUR2

decimal

Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.

100

SM_PRSN

int

Sum of NUM_FISHER in the stratum from GOFyyINT.DBF.

100

SM_PR2

int

Sum of NUM_FISHER^2 in the stratum from GOFyyINT.DBF.

100

SM_PR_HR

decimal

Sum of (NUM_FISHER * HRS_FISH) in the stratum from GOFyyINT.DBF.

100

SM_PR_HR2

decimal

Sum of (NUM_FISHER^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.

100

SM_GEAR_HOUR

decimal

Sum of (NUM_GEAR * HRS_FISH) in the stratum from GOFyyINT.DBF.

100

SM_GEAR_HOUR2

decimal

Sum of (NUM_GEAR^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.

100

EX_FACTOR

decimal

Expansion factor (EXP_TRIP/interviews trip) uses to create the expaned efforts data (e.g. EXP_FISHER, EXP_HOURS, etc.)

100

POOL_FLAG

varchar

Shows the quality of expanded data in the stratum (Nothing: standard stratum, D: combined TYP_DAY, M: combined METHOD 4-6 to 4, P: combined Port 1, 2, p: combined Port 1-3 for METHOD =1 or 3).

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

EXPANSION_PK

CC ID: 1007994

Seq. Order:	1
Data Storage Type:	int
Required:	Yes
Primary Key:	Yes
Precision:	10
Scale:	0
Status:	Active
Description:	System-generated artificial primary key.

YEAR_QUARTER

CC ID: 1007995

Seq. Order:	2
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Start year and quarter and end year and quarter of expansion data.

TYPE_OF_DAY

CC ID: 1007996

Seq. Order:	3
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Type of day on which the interview was conducted. Values are '1' for a weekday and '2' for a weekend/holiday). Calculated field.

PORT

CC ID: 1007997

Seq. Order:	4
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Port code.

CHARTER_F

CC ID: 1007998

Seq. Order:	5
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true, it is a charter trip.

METHOD

CC ID: 1007999

Seq. Order:	6
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Fishing method code.

SM_TR

CC ID: 1008000

Seq. Order:	7
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Sum of the fishing trips from G_BBS_BLHD or GOfyyBLD.DBF.

SM_TR2

CC ID: 1008001

Seq. Order:	8
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Sum of the number of trips squared (Trip: number of trips per DAY-PORT-CHARTER-METHOD in GOFyyBLD.DBF). For CV calculation.

NUM_SV

CC ID: 1008002

Seq. Order:	9
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of surveys in G_BBS_BLDT or GOFyyBLD.DBF.

AVG_EST_TRIP

CC ID: 1008003

Seq. Order:	10
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	3
Status:	Active
Description:	Average trip per day from boat log.

DAYS_Q

CC ID: 1008004

Seq. Order:	11
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of actual calendar days in the expansion period.

EXP_TRIP

CC ID: 1008005

Seq. Order:	12
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Expanded trips per stratum = AV_ES_TR * DAYS_Q.

EXP_HOUR

CC ID: 1008006

Seq. Order:	13
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Expanded hours fished per stratum = EX_FACTOR * SM_HR.

EXP_FISHER

CC ID: 1008007

Seq. Order:	14
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	Expanded number of fishers per stratum = EX_FACTOR * SM_PRSN

EXP_FISHER_HOUR

CC ID: 1008008

Seq. Order:	15
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	22
Scale:	2
Status:	Active
Description:	Expanded FISHERMAN_HOUR per stratum = EX_FACTOR * SM_PR_HR.

EXP_GEAR_HOUR

CC ID: 1008009

Seq. Order:	16
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	22
Scale:	2
Status:	Active
Description:	Expanded Gear_Hour per stratum = EX_FACTOR * SM_GR_HR.

CPUE_TRIP

CC ID: 1008010

Seq. Order:	17
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	Caught in kilograms per trip in stratum = SM_KG / NUM_INT.

EXP_CATCH

CC ID: 1008011

Seq. Order:	18
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	2
Status:	Active
Description:	Expanded total kilograms caught in stratum = EX_TR * TR_CPUE.

VAR_EST_TRIP

CC ID: 1008012

Seq. Order:	19
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	12
Scale:	4
Status:	Active
Description:	Variance of ES_TR = (AD_SM_TR2 - AD_SM_TR^2 / DAY_SAMP) / (DAY_SAMP-1) / DAY_SAMP.

VAR_EXP_TRIP

CC ID: 1008013

Seq. Order:	20
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	2
Status:	Active
Description:	Variance of EX_TR = V_ES_TR * DAYS_Q^2.

VAR_CPUE_TRIP

CC ID: 1008014

Seq. Order:	21
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	18
Scale:	2
Status:	Active
Description:	Variance of TR_CPUE = (SM_KG2 - Sm_Kg^2 / NUM_INT) / (NUM_INT-1) / NUM_INT.

VAR_EXP_CATCH

CC ID: 1008015

Seq. Order:	22
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	22
Scale:	2
Status:	Active
Description:	Variance of EX_CAT = (V_TR_CPUE * (EX_TR^2)) + (V_EX_TR * (TR_CPUE^2)) + (V_EX_TR * V_TR_CPUE).

STD_EXP_TRIP

CC ID: 1008016

Seq. Order:	23
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	1
Status:	Active
Description:	CV of EX_TR = 100 * SQRT ( ABS (V_EX_TR) ) / EX_TR.

STD_CPUE_TRIP

CC ID: 1008017

Seq. Order:	24
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	1
Status:	Active
Description:	CV of TR_CPUE = 100 * SQRT (ABS (V_TR_CPUE)) / TR_CPUE.

STD_EXP_CATCH

CC ID: 1008018

Seq. Order:	25
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	1
Status:	Active
Description:	CV of EX_CAT =100 * SQRT ( ABS (V_EX_CAT)) / EX_CAT.

NUM_SAMPLE_DAY

CC ID: 1008019

Seq. Order:	26
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of sampled days.

P1

CC ID: 1008020

Seq. Order:	27
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	3
Status:	Active
Description:	A temporal adjustment factor for expansion from MYSQL NAME or GOFyyP1.DBF.

P2

CC ID: 1008021

Seq. Order:	28
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	4
Status:	Active
Description:	A spatial adjustment factor for expansion: the boat or trailer count ratio between non-surveyed ports and surveyed ports from GOFyyIWC.DBF.

AD_FISH

CC ID: 1008022

Seq. Order:	29
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	4
Status:	Active
Description:	Reflects the adjustment for a better trip estimate. For example, in GOFyyBLD.DBF, FISHED could = U (unknown) or = Y, and METHOD could = 0.

AD_SM_TR

CC ID: 1008023

Seq. Order:	30
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	2
Status:	Active
Description:	Adjusted sum of the fishing trips = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.

AD_SM_TR2

CC ID: 1008024

Seq. Order:	31
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	2
Status:	Active
Description:	Adjusted sum of the fishing trips squared = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.

SM_KG

CC ID: 1008025

Seq. Order:	32
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	Sum of the TOT_KGS in the stratum from GOFyyINT.DBF.

SM_KG2

CC ID: 1008026

Seq. Order:	33
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	14
Scale:	1
Status:	Active
Description:	Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.

NUM_INT0

CC ID: 1008027

Seq. Order:	34
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of interviews counted for this stratum.

NUM_INT

CC ID: 1008028

Seq. Order:	35
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	The number of interviews counted for this stratum.

SM_HOUR

CC ID: 1008029

Seq. Order:	36
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	1
Status:	Active
Description:	Sum of HRS_FISH in the stratum from GOFyyINT.DBF.

SM_HOUR2

CC ID: 1008030

Seq. Order:	37
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	2
Status:	Active
Description:	Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.

SM_PRSN

CC ID: 1008031

Seq. Order:	38
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Sum of NUM_FISHER in the stratum from GOFyyINT.DBF.

SM_PR2

CC ID: 1008032

Seq. Order:	39
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Sum of NUM_FISHER^2 in the stratum from GOFyyINT.DBF.

SM_PR_HR

CC ID: 1008033

Seq. Order:	40
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	17
Scale:	1
Status:	Active
Description:	Sum of (NUM_FISHER * HRS_FISH) in the stratum from GOFyyINT.DBF.

SM_PR_HR2

CC ID: 1008034

Seq. Order:	41
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	22
Scale:	2
Status:	Active
Description:	Sum of (NUM_FISHER^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.

SM_GEAR_HOUR

CC ID: 1008035

Seq. Order:	42
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	17
Scale:	1
Status:	Active
Description:	Sum of (NUM_GEAR * HRS_FISH) in the stratum from GOFyyINT.DBF.

SM_GEAR_HOUR2

CC ID: 1008036

Seq. Order:	43
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	22
Scale:	2
Status:	Active
Description:	Sum of (NUM_GEAR^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.

EX_FACTOR

CC ID: 1008037

Seq. Order:	44
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	11
Scale:	4
Status:	Active
Description:	Expansion factor (EXP_TRIP/interviews trip) uses to create the expaned efforts data (e.g. EXP_FISHER, EXP_HOURS, etc.)

POOL_FLAG

CC ID: 1008038

Seq. Order:	45
Data Storage Type:	varchar
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Shows the quality of expanded data in the stratum (Nothing: standard stratum, D: combined TYP_DAY, M: combined METHOD 4-6 to 4, P: combined Port 1, 2, p: combined Port 1-3 for METHOD =1 or 3).

LOAD_TABLE

CC ID: 1008039

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

LOAD_DATETIME

CC ID: 1008040

Seq. Order:	47
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: 1008041

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

Catalog Details

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