Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > 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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
EXPANSION_PK
int 		System-generated artificial primary key.
YEAR_QUARTER
int 		Start year and quarter and end year and quarter of expansion data.
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.
PORT
int 		Port code.
CHARTER_F
char 		If true, it is a charter trip.
METHOD
int 		Fishing method code.
SM_TR
decimal 		Sum of the fishing trips from G_BBS_BLHD or GOfyyBLD.DBF.
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.
NUM_SV
int 		Number of surveys in G_BBS_BLDT or GOFyyBLD.DBF.
AVG_EST_TRIP
decimal 		Average trip per day from boat log.
DAYS_Q
int 		Number of actual calendar days in the expansion period.
EXP_TRIP
decimal 		Expanded trips per stratum = AV_ES_TR * DAYS_Q.
EXP_HOUR
decimal 		Expanded hours fished per stratum = EX_FACTOR * SM_HR.
EXP_FISHER
decimal 		Expanded number of fishers per stratum = EX_FACTOR * SM_PRSN
EXP_FISHER_HOUR
decimal 		Expanded FISHERMAN_HOUR per stratum = EX_FACTOR * SM_PR_HR.
EXP_GEAR_HOUR
decimal 		Expanded Gear_Hour per stratum = EX_FACTOR * SM_GR_HR.
CPUE_TRIP
decimal 		Caught in kilograms per trip in stratum = SM_KG / NUM_INT.
EXP_CATCH
decimal 		Expanded total kilograms caught in stratum = EX_TR * TR_CPUE.
VAR_EST_TRIP
decimal 		Variance of ES_TR = (AD_SM_TR2 - AD_SM_TR^2 / DAY_SAMP) / (DAY_SAMP-1) / DAY_SAMP.
VAR_EXP_TRIP
decimal 		Variance of EX_TR = V_ES_TR * DAYS_Q^2.
VAR_CPUE_TRIP
decimal 		Variance of TR_CPUE = (SM_KG2 - Sm_Kg^2 / NUM_INT) / (NUM_INT-1) / NUM_INT.
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).
STD_EXP_TRIP
decimal 		CV of EX_TR = 100 * SQRT ( ABS (V_EX_TR) ) / EX_TR.
STD_CPUE_TRIP
decimal 		CV of TR_CPUE = 100 * SQRT (ABS (V_TR_CPUE)) / TR_CPUE.
STD_EXP_CATCH
decimal 		CV of EX_CAT =100 * SQRT ( ABS (V_EX_CAT)) / EX_CAT.
NUM_SAMPLE_DAY
int 		Number of sampled days.
P1
decimal 		A temporal adjustment factor for expansion from MYSQL NAME or GOFyyP1.DBF.
P2
decimal 		A spatial adjustment factor for expansion: the boat or trailer count ratio between non-surveyed ports and surveyed ports from GOFyyIWC.DBF.
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.
AD_SM_TR
decimal 		Adjusted sum of the fishing trips = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
AD_SM_TR2
decimal 		Adjusted sum of the fishing trips squared = SM_TR * AD_FISH / P1 from GOFyyBLD.DBF.
SM_KG
decimal 		Sum of the TOT_KGS in the stratum from GOFyyINT.DBF.
SM_KG2
decimal 		Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
NUM_INT0
int 		The number of interviews counted for this stratum.
NUM_INT
int 		The number of interviews counted for this stratum.
SM_HOUR
decimal 		Sum of HRS_FISH in the stratum from GOFyyINT.DBF.
SM_HOUR2
decimal 		Sum of TOT_KGS ^ 2 in the stratum from GOFyyINT.DBF. For CV calculation.
SM_PRSN
int 		Sum of NUM_FISHER in the stratum from GOFyyINT.DBF.
SM_PR2
int 		Sum of NUM_FISHER^2 in the stratum from GOFyyINT.DBF.
SM_PR_HR
decimal 		Sum of (NUM_FISHER * HRS_FISH) in the stratum from GOFyyINT.DBF.
SM_PR_HR2
decimal 		Sum of (NUM_FISHER^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
SM_GEAR_HOUR
decimal 		Sum of (NUM_GEAR * HRS_FISH) in the stratum from GOFyyINT.DBF.
SM_GEAR_HOUR2
decimal 		Sum of (NUM_GEAR^2 * HRS_FISH^2) in the stratum from GOFyyINT.DBF.
EX_FACTOR
decimal 		Expansion factor (EXP_TRIP/interviews trip) uses to create the expaned efforts data (e.g. EXP_FISHER, EXP_HOURS, etc.)
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).
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: 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

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

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