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 (... > 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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

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

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_sbs_interview_flat_view
Status: Completed

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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