Metadata Rubric

83%

5 / 6

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

g_sbs_interview_flat_view

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

Item Identification

Title:	g_sbs_interview_flat_view
Status:	Completed

Entity Information

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	guam_dawr_wh

Data Attributes

Attribute Summary

	Name	Type	Description
100	INTERVIEW_PK	varchar	UID assigned to this record
100	SAMPLE_DATE	date	Date of the survey.
100	TYPE_OF_DAY	varchar	Type of day when the interview was conducted (1 = weekday, 2 = weekend/holiday).
100	NUM_FISHER	int	Number of fishermen fishing.
100	INTERVIEW_ORDER	int	Squential number assigned to each line on the interview form.
100	INTERVIEWER_FK	varchar	Code for the interviewer.
100	INTERVIEW_TIME	int	Time the interview.
100	START_TIME	int	Fishing start time.
100	END_TIME	int	Fishing stop time.
100	DAY_BEFORE	int	If fisher started the fishing on the day before today.
100	DAY_AFTER	int	If fisher plan to stop fishing on the day after today.
100	BREAK_HOURS	decimal	Break time taken during fishing trip, measured in hours.
100	ACTUAL_HOURS	decimal	Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME.
100	EST_HOURS	decimal	Estimated of trip time. Calculated field: STOP_TIME - START_TIME.
100	METHOD_FK	int	Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.
100	AREA_FK	int	Area fished code
100	NUM_GEAR	int	Number of gears used.
100	REEF_ZONE	int	Code of the reef zone
100	PERCENT_SOLD	decimal	Percentage of catch sold.
100	PERCENT_UNSOLD	decimal	Percentage of catch not sold.
100	BUYER_FK	int	Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF.
100	TOT_NUM_KEPT	int	Total pieces of species caught.
100	TOT_EST_KGS	decimal	Total fish weight of this interview
100	TOT_SPECIES	int	Total number of species caught.
100	TOT_NUM_TYPE	int	How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
100	TOT_EST_KGS_TYPE	int	How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).
100	TOT_SPECIES_TYPE	int	How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).
100	BAIT_FK	int	bait code
100	WEATHER_FK	int	Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
100	CLOUD_FK	int	Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF.
100	SURF	int	Surf high in feet.
100	TIDE	varchar	Tide level
100	NON_SCHED_F	char	If true, the interview was not scheduled (opportunistic).
100	INCOMPLETE_F	char	This interview was not able to record all the catch of the trip.
100	BYCATCH_F	varchar	If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.)
100	LUNAR_DAY	int	Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date
100	INT_REMARKS	varchar	Remarks
100	INT_CREATE_TIME	datetime	When this record was created
100	INT_MODIFY_TIME	datetime	When was the last date this record was editted
100	INT_CREATE_USER	varchar	Staff code who enter this data
100	INT_MODIFY_USER	varchar	Staff code who last editted this record
100	INT_LOAD_TABLE	varchar	Which VFP table where this data was loaded from
100	INT_LOAD_DATETIME	datetime	When this record was loade into MySQL VFP
100	INT_LOAD_USER	varchar	User load the data into MySQL
100	CATCH_PK	varchar	Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.
100	INTERVIEW_FK	varchar	Key value that link this record to the related record found in the g_sbs_int
100	SPECIES_FK	int	Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
100	NUM_KEPT_TYPE	int	How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
100	NUM_KEPT	int	Number of pieces of fish caught.
100	EST_KGS_TYPE	int	How weight was collected, 1=actual, 2=calculated and 3=estimated)
100	EST_KGS	decimal	total catch weight of this species.
100	SIZE_GROUP	int	fish size goup.
100	BYCATCH_TYPE	varchar	Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).
100	CAT_CREATE_TIME	datetime	When this record was created
100	CAT_MODIFY_TIME	datetime	When was the last date this record was editted
100	CAT_LOAD_TABLE	varchar	Which VFP table where this data was loaded from
100	CAT_LOAD_DATETIME	datetime	When this record was loade into MySQL VFP
100	CAT_LOAD_USER	varchar	User load the data into MySQL
100	SIZE_PK	int	UID created for this record
100	CATCH_FK	varchar	Link key to link this record to it parent record in c_bbs_catch
100	LEN_MM_TYPE	int	How length was measured (1 = actual, 2 = calculated, 3 = estimated).
100	LEN_MM	int	Fork length of fish, from snout tip to tail fork, in millimeters.
100	KGS_TYPE	int	How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100	KGS	decimal	Fish weight in kilograms.
100	SIZ_CREATE_TIME	datetime	This record created date
100	SIZ_MODIFY_TIME	datetime	When was last update to this record
100	SIZ_LOAD_TABLE	varchar	Which table where data was loaded from VFP database
100	SIZ_LOAD_DATETIME	datetime	this record loaded date-time form VFP table
100	SIZ_LOAD_USER	varchar	User migrated this data from FVP
100	FISHING_METHOD	varchar	fishing method code
100	FISHING_AREA	varchar	fishing area code
100	BUYER_NAME	varchar	Buyer name
100	BAIT_NAME	varchar	type of bait description
100	WEATHER	varchar	Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
100	SCIENTIFIC_NAME	varchar	Scientific name of the species (Genus name + Species name).
100	COMMON_NAME	varchar	Common English name for the species.

Name

Type

Description

100

INTERVIEW_PK

varchar

UID assigned to this record

100

SAMPLE_DATE

date

Date of the survey.

100

TYPE_OF_DAY

varchar

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

100

NUM_FISHER

int

Number of fishermen fishing.

100

INTERVIEW_ORDER

int

Squential number assigned to each line on the interview form.

100

INTERVIEWER_FK

varchar

Code for the interviewer.

100

INTERVIEW_TIME

int

Time the interview.

100

START_TIME

int

Fishing start time.

100

END_TIME

int

Fishing stop time.

100

DAY_BEFORE

int

If fisher started the fishing on the day before today.

100

DAY_AFTER

int

If fisher plan to stop fishing on the day after today.

100

BREAK_HOURS

decimal

Break time taken during fishing trip, measured in hours.

100

ACTUAL_HOURS

decimal

Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME.

100

EST_HOURS

decimal

Estimated of trip time. Calculated field: STOP_TIME - START_TIME.

100

METHOD_FK

int

Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.

100

AREA_FK

int

Area fished code

100

NUM_GEAR

int

Number of gears used.

100

REEF_ZONE

int

Code of the reef zone

100

PERCENT_SOLD

decimal

Percentage of catch sold.

100

PERCENT_UNSOLD

decimal

Percentage of catch not sold.

100

BUYER_FK

int

Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF.

100

TOT_NUM_KEPT

int

Total pieces of species caught.

100

TOT_EST_KGS

decimal

Total fish weight of this interview

100

TOT_SPECIES

int

Total number of species caught.

100

TOT_NUM_TYPE

int

How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).

100

TOT_EST_KGS_TYPE

int

How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).

100

TOT_SPECIES_TYPE

int

How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).

100

BAIT_FK

int

bait code

100

WEATHER_FK

int

Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.

100

CLOUD_FK

int

Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF.

100

SURF

int

Surf high in feet.

100

TIDE

varchar

Tide level

100

NON_SCHED_F

char

If true, the interview was not scheduled (opportunistic).

100

INCOMPLETE_F

char

This interview was not able to record all the catch of the trip.

100

BYCATCH_F

varchar

If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.)

100

LUNAR_DAY

int

Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date

100

INT_REMARKS

varchar

Remarks

100

INT_CREATE_TIME

datetime

When this record was created

100

INT_MODIFY_TIME

datetime

When was the last date this record was editted

100

INT_CREATE_USER

varchar

Staff code who enter this data

100

INT_MODIFY_USER

varchar

Staff code who last editted this record

100

INT_LOAD_TABLE

varchar

Which VFP table where this data was loaded from

100

INT_LOAD_DATETIME

datetime

When this record was loade into MySQL VFP

100

INT_LOAD_USER

varchar

User load the data into MySQL

100

CATCH_PK

varchar

Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.

100

INTERVIEW_FK

varchar

Key value that link this record to the related record found in the g_sbs_int

100

SPECIES_FK

int

Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF

100

NUM_KEPT_TYPE

int

How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).

100

NUM_KEPT

int

Number of pieces of fish caught.

100

EST_KGS_TYPE

int

How weight was collected, 1=actual, 2=calculated and 3=estimated)

100

EST_KGS

decimal

total catch weight of this species.

100

SIZE_GROUP

int

fish size goup.

100

BYCATCH_TYPE

varchar

Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).

100

CAT_CREATE_TIME

datetime

When this record was created

100

CAT_MODIFY_TIME

datetime

When was the last date this record was editted

100

CAT_LOAD_TABLE

varchar

Which VFP table where this data was loaded from

100

CAT_LOAD_DATETIME

datetime

When this record was loade into MySQL VFP

100

CAT_LOAD_USER

varchar

User load the data into MySQL

100

SIZE_PK

int

UID created for this record

100

CATCH_FK

varchar

Link key to link this record to it parent record in c_bbs_catch

100

LEN_MM_TYPE

int

How length was measured (1 = actual, 2 = calculated, 3 = estimated).

100

LEN_MM

int

Fork length of fish, from snout tip to tail fork, in millimeters.

100

KGS_TYPE

int

How weight was collected (1 = actual, 2 = calculated, 3 = estimated).

100

KGS

decimal

Fish weight in kilograms.

100

SIZ_CREATE_TIME

datetime

This record created date

100

SIZ_MODIFY_TIME

datetime

When was last update to this record

100

SIZ_LOAD_TABLE

varchar

Which table where data was loaded from VFP database

100

SIZ_LOAD_DATETIME

datetime

this record loaded date-time form VFP table

100

SIZ_LOAD_USER

varchar

User migrated this data from FVP

100

FISHING_METHOD

varchar

fishing method code

100

FISHING_AREA

varchar

fishing area code

100

BUYER_NAME

varchar

Buyer name

100

BAIT_NAME

varchar

type of bait description

100

WEATHER

varchar

Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.

100

SCIENTIFIC_NAME

varchar

Scientific name of the species (Genus name + Species name).

100

COMMON_NAME

varchar

Common English name for the species.

Attribute Details

INTERVIEW_PK

CC ID: 1008230

Seq. Order:	1
Data Storage Type:	varchar
Max Length:	14
Required:	No
Primary Key:	No
Status:	Active
Description:	UID assigned to this record

SAMPLE_DATE

CC ID: 1008231

Seq. Order:	2
Data Storage Type:	date
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of the survey.

TYPE_OF_DAY

CC ID: 1008232

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

NUM_FISHER

CC ID: 1008233

Seq. Order:	4
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of fishermen fishing.

INTERVIEW_ORDER

CC ID: 1008234

Seq. Order:	5
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Squential number assigned to each line on the interview form.

INTERVIEWER_FK

CC ID: 1008235

Seq. Order:	6
Data Storage Type:	varchar
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the interviewer.

INTERVIEW_TIME

CC ID: 1008236

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

START_TIME

CC ID: 1008237

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

END_TIME

CC ID: 1008238

Seq. Order:	9
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Fishing stop time.

DAY_BEFORE

CC ID: 1008239

Seq. Order:	10
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	If fisher started the fishing on the day before today.

DAY_AFTER

CC ID: 1008240

Seq. Order:	11
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	If fisher plan to stop fishing on the day after today.

BREAK_HOURS

CC ID: 1008241

Seq. Order:	12
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Break time taken during fishing trip, measured in hours.

ACTUAL_HOURS

CC ID: 1008242

Seq. Order:	13
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME.

EST_HOURS

CC ID: 1008243

Seq. Order:	14
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	2
Status:	Active
Description:	Estimated of trip time. Calculated field: STOP_TIME - START_TIME.

METHOD_FK

CC ID: 1008244

Seq. Order:	15
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF.

AREA_FK

CC ID: 1008245

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

NUM_GEAR

CC ID: 1008246

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

REEF_ZONE

CC ID: 1008247

Seq. Order:	18
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code of the reef zone

PERCENT_SOLD

CC ID: 1008248

Seq. Order:	19
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Percentage of catch sold.

PERCENT_UNSOLD

CC ID: 1008249

Seq. Order:	20
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	5
Scale:	1
Status:	Active
Description:	Percentage of catch not sold.

BUYER_FK

CC ID: 1008250

Seq. Order:	21
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF.

TOT_NUM_KEPT

CC ID: 1008251

Seq. Order:	22
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Total pieces of species caught.

TOT_EST_KGS

CC ID: 1008252

Seq. Order:	23
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	13
Scale:	4
Status:	Active
Description:	Total fish weight of this interview

TOT_SPECIES

CC ID: 1008253

Seq. Order:	24
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Total number of species caught.

TOT_NUM_TYPE

CC ID: 1008254

Seq. Order:	25
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).

TOT_EST_KGS_TYPE

CC ID: 1008255

Seq. Order:	26
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).

TOT_SPECIES_TYPE

CC ID: 1008256

Seq. Order:	27
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).

BAIT_FK

CC ID: 1008257

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

WEATHER_FK

CC ID: 1008258

Seq. Order:	29
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.

CLOUD_FK

CC ID: 1008259

Seq. Order:	30
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF.

SURF

CC ID: 1008260

Seq. Order:	31
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Surf high in feet.

TIDE

CC ID: 1008261

Seq. Order:	32
Data Storage Type:	varchar
Max Length:	4
Required:	No
Primary Key:	No
Status:	Active
Description:	Tide level

NON_SCHED_F

CC ID: 1008262

Seq. Order:	33
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true, the interview was not scheduled (opportunistic).

INCOMPLETE_F

CC ID: 1008263

Seq. Order:	34
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	This interview was not able to record all the catch of the trip.

BYCATCH_F

CC ID: 1008264

Seq. Order:	35
Data Storage Type:	varchar
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.)

LUNAR_DAY

CC ID: 1008265

Seq. Order:	36
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date

INT_REMARKS

CC ID: 1008266

Seq. Order:	37
Data Storage Type:	varchar
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	Remarks

INT_CREATE_TIME

CC ID: 1008267

Seq. Order:	38
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was created

INT_MODIFY_TIME

CC ID: 1008268

Seq. Order:	39
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When was the last date this record was editted

INT_CREATE_USER

CC ID: 1008269

Seq. Order:	40
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Staff code who enter this data

INT_MODIFY_USER

CC ID: 1008270

Seq. Order:	41
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	Staff code who last editted this record

INT_LOAD_TABLE

CC ID: 1008271

Seq. Order:	42
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Which VFP table where this data was loaded from

INT_LOAD_DATETIME

CC ID: 1008272

Seq. Order:	43
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was loade into MySQL VFP

INT_LOAD_USER

CC ID: 1008273

Seq. Order:	44
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User load the data into MySQL

CATCH_PK

CC ID: 1008274

Seq. Order:	45
Data Storage Type:	varchar
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.

INTERVIEW_FK

CC ID: 1008275

Seq. Order:	46
Data Storage Type:	varchar
Max Length:	14
Required:	No
Primary Key:	No
Status:	Active
Description:	Key value that link this record to the related record found in the g_sbs_int

SPECIES_FK

CC ID: 1008276

Seq. Order:	47
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF

NUM_KEPT_TYPE

CC ID: 1008277

Seq. Order:	48
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).

NUM_KEPT

CC ID: 1008278

Seq. Order:	49
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of pieces of fish caught.

EST_KGS_TYPE

CC ID: 1008279

Seq. Order:	50
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How weight was collected, 1=actual, 2=calculated and 3=estimated)

EST_KGS

CC ID: 1008280

Seq. Order:	51
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	4
Status:	Active
Description:	total catch weight of this species.

SIZE_GROUP

CC ID: 1008281

Seq. Order:	52
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	fish size goup.

BYCATCH_TYPE

CC ID: 1008282

Seq. Order:	53
Data Storage Type:	varchar
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).

CAT_CREATE_TIME

CC ID: 1008283

Seq. Order:	54
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was created

CAT_MODIFY_TIME

CC ID: 1008284

Seq. Order:	55
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When was the last date this record was editted

CAT_LOAD_TABLE

CC ID: 1008285

Seq. Order:	56
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Which VFP table where this data was loaded from

CAT_LOAD_DATETIME

CC ID: 1008286

Seq. Order:	57
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was loade into MySQL VFP

CAT_LOAD_USER

CC ID: 1008287

Seq. Order:	58
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User load the data into MySQL

SIZE_PK

CC ID: 1008288

Seq. Order:	59
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	UID created for this record

CATCH_FK

CC ID: 1008289

Seq. Order:	60
Data Storage Type:	varchar
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Link key to link this record to it parent record in c_bbs_catch

LEN_MM_TYPE

CC ID: 1008290

Seq. Order:	61
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How length was measured (1 = actual, 2 = calculated, 3 = estimated).

LEN_MM

CC ID: 1008291

Seq. Order:	62
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Fork length of fish, from snout tip to tail fork, in millimeters.

KGS_TYPE

CC ID: 1008292

Seq. Order:	63
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	How weight was collected (1 = actual, 2 = calculated, 3 = estimated).

KGS

CC ID: 1008293

Seq. Order:	64
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	9
Scale:	4
Status:	Active
Description:	Fish weight in kilograms.

SIZ_CREATE_TIME

CC ID: 1008294

Seq. Order:	65
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	This record created date

SIZ_MODIFY_TIME

CC ID: 1008295

Seq. Order:	66
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When was last update to this record

SIZ_LOAD_TABLE

CC ID: 1008296

Seq. Order:	67
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Which table where data was loaded from VFP database

SIZ_LOAD_DATETIME

CC ID: 1008297

Seq. Order:	68
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	this record loaded date-time form VFP table

SIZ_LOAD_USER

CC ID: 1008298

Seq. Order:	69
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User migrated this data from FVP

FISHING_METHOD

CC ID: 1008299

Seq. Order:	70
Data Storage Type:	varchar
Max Length:	25
Required:	No
Primary Key:	No
Status:	Active
Description:	fishing method code

FISHING_AREA

CC ID: 1008300

Seq. Order:	71
Data Storage Type:	varchar
Max Length:	35
Required:	No
Primary Key:	No
Status:	Active
Description:	fishing area code

BUYER_NAME

CC ID: 1008301

Seq. Order:	72
Data Storage Type:	varchar
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Buyer name

BAIT_NAME

CC ID: 1008302

Seq. Order:	73
Data Storage Type:	varchar
Max Length:	16
Required:	No
Primary Key:	No
Status:	Active
Description:	type of bait description

WEATHER

CC ID: 1008303

Seq. Order:	74
Data Storage Type:	varchar
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
Description:	Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.

SCIENTIFIC_NAME

CC ID: 1008304

Seq. Order:	75
Data Storage Type:	varchar
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	Scientific name of the species (Genus name + Species name).

COMMON_NAME

CC ID: 1008305

Seq. Order:	76
Data Storage Type:	varchar
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	Common English name for the species.

Catalog Details

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