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 Boat-based Creel Survey >

g_bbs_interview_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63468  |  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 		Primary key, a unique identifier for each record in this table.
SAMPLE_DATE
date 		Date of the survey.
TYPE_OF_DAY
varchar 		Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).
INTERVIEW_TIME
int 		Time the interview was conducted.
INTERVIEWER1_FK
int 		Interviewer1 code.
INTERVIEWER2_FK
int 		Interviewer2 code.
INTERVIEW_ORDER
int 		Order of the survey was taken.
BOATLOG_DT_FK
int 		Filler, not in used.
AREA_FK
int 		Code for the area fished. Detailed information can be found in G_BBS_AREA.
METHOD_FK
int 		Fishing method code.
DEPTH
varchar 		If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed).
WEATHER_FK
int 		Weather conditions. Detailed information can be found in G_WEATHER.
CLOUD_FK
int 		Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF.
WIND_DIRECTION
varchar 		Wind direction (e.g. E=east, NE=northeast).
WIND_SPEED
int 		Wind speed in knots.
HOURS_FISHED
decimal 		Number of hours spent fishing.
NUM_FISHER
int 		Number of fishermen fishing.
NUM_GUEST
int 		Number of guests on vessel.
NUM_DAYS_FISHED
int 		Number of days fished.
NUM_GEAR
int 		Number of gears used.
VESSEL_NAME
varchar 		Name of the fishing vessel.
PORT_FK
int 		Port code.
CAR_LICENSE
varchar 		Vehicle/trailer license number.
TOT_NUM_KEPT_TYPE
int 		How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated).
TOT_NUM_KEPT
int 		Total pieces of fish caught.
TOT_EST_KGS_TYPE
int 		How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated).
TOT_EST_KGS
decimal 		Total fish caught in kgs for this trip.
TOT_SPECIES_TYPE
int 		How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated).
TOT_SPECIES
int 		Number of species caught on this trip.
PERCENT_UNSOLD
decimal 		Percent of unsold catch.
PERCENT_SOLD
decimal 		Percent of catch sold (to the hundredths).
BUYER_FK
int 		Filler, not in used.
BYCATCH_F
varchar 		If true, this was a bycatch.
CHARTER_F
char 		If true, it is a charter trip.
BERTHED_F
char 		If true, the vessel is berthed.
SMALLCRAFT_F
char 		If true (T), small craft advisory was in effect.
HIGHSURF_F
char 		If true, high surf warning was in effect.
NON_SCHED_F
char 		If true (T), the interview was non-scheduled (opportunistic).
LUNAR_DAY
int 		Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011.
INCOMPLETE_F
char 		This interview is not complete (all catch from this trip was not captured on this interview).
REMARKS
varchar 		Comment field.
INT_CREATE_TIME
datetime 		Date and time that the record was created or date the record was created.
INT_MODIFY_TIME
datetime 		When was the last date this record was editted
INT_CREATE_USER
varchar 		Name of the user who created the record.
INT_MODIFY_USER
varchar 		Name of the user who last modified the 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, a unique identifier for each record in this table.
INTERVIEW_FK
varchar 		Key that link this record back to its related record found in the c_bbs_int.
SPECIES_FK
int 		Species code.
NUM_KEPT
int 		Number of fish (pieces) kept.
NUM_KEPT_TYPE
int 		Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated).
EST_KGS
decimal 		Total catch of this species.
EST_KGS_TYPE
int 		How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
DISPOSITION
int 		Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion.
PRICE_LB
decimal 		Place holder, not used.
PRICE_LB_TYPE
int 		Place holder, not used.
SIZE_GROUP
int 		fish size goup.
BYCATCH_TYPE
varchar 		Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other).
CAT_REMARKS
varchar 		Comment field.
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 		System-generated artificial primary key.
CATCH_FK
varchar 		Key link this record to its related record in C_BBS_CATCH.
LEN_MM
int 		Fork length of fish in mm.
LEN_MM_TYPE
int 		How len was collected (1 = actual, 2 = calculated, 3 = estimated).
KGS
decimal 		Fish weight in kilograms.
KGS_TYPE
int 		How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
SEX
varchar 		Place holder, not in used.
SIZ_CREATE_TIME
datetime 		Date the record was created
SIZ_MODIFY_TIME
datetime 		Date the record was last modified
SIZ_LOAD_TABLE
varchar 		varchar(32)
SIZ_LOAD_DATETIME
datetime 		datetime
SIZ_LOAD_USER
varchar 		varchar(32)
FISHING_METHOD
varchar 		Fishing method.
FISHING_AREA
varchar 		Fishing area code.
PORT_NAME
varchar 		Port name.
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_bbs_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 Primary key, a unique identifier for each record in this table.
100
 SAMPLE_DATE date Date of the survey.
100
 TYPE_OF_DAY varchar Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).
100
 INTERVIEW_TIME int Time the interview was conducted.
100
 INTERVIEWER1_FK int Interviewer1 code.
100
 INTERVIEWER2_FK int Interviewer2 code.
100
 INTERVIEW_ORDER int Order of the survey was taken.
100
 BOATLOG_DT_FK int Filler, not in used.
100
 AREA_FK int Code for the area fished. Detailed information can be found in G_BBS_AREA.
100
 METHOD_FK int Fishing method code.
100
 DEPTH varchar If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed).
100
 WEATHER_FK int Weather conditions. Detailed information can be found in G_WEATHER.
100
 CLOUD_FK int Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF.
100
 WIND_DIRECTION varchar Wind direction (e.g. E=east, NE=northeast).
100
 WIND_SPEED int Wind speed in knots.
100
 HOURS_FISHED decimal Number of hours spent fishing.
100
 NUM_FISHER int Number of fishermen fishing.
100
 NUM_GUEST int Number of guests on vessel.
100
 NUM_DAYS_FISHED int Number of days fished.
100
 NUM_GEAR int Number of gears used.
100
 VESSEL_NAME varchar Name of the fishing vessel.
100
 PORT_FK int Port code.
100
 CAR_LICENSE varchar Vehicle/trailer license number.
100
 TOT_NUM_KEPT_TYPE int How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_NUM_KEPT int Total pieces of fish caught.
100
 TOT_EST_KGS_TYPE int How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_EST_KGS decimal Total fish caught in kgs for this trip.
100
 TOT_SPECIES_TYPE int How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_SPECIES int Number of species caught on this trip.
100
 PERCENT_UNSOLD decimal Percent of unsold catch.
100
 PERCENT_SOLD decimal Percent of catch sold (to the hundredths).
100
 BUYER_FK int Filler, not in used.
100
 BYCATCH_F varchar If true, this was a bycatch.
100
 CHARTER_F char If true, it is a charter trip.
100
 BERTHED_F char If true, the vessel is berthed.
100
 SMALLCRAFT_F char If true (T), small craft advisory was in effect.
100
 HIGHSURF_F char If true, high surf warning was in effect.
100
 NON_SCHED_F char If true (T), the interview was non-scheduled (opportunistic).
100
 LUNAR_DAY int Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011.
100
 INCOMPLETE_F char This interview is not complete (all catch from this trip was not captured on this interview).
100
 REMARKS varchar Comment field.
100
 INT_CREATE_TIME datetime Date and time that the record was created or date the record was created.
100
 INT_MODIFY_TIME datetime When was the last date this record was editted
100
 INT_CREATE_USER varchar Name of the user who created the record.
100
 INT_MODIFY_USER varchar Name of the user who last modified the 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, a unique identifier for each record in this table.
100
 INTERVIEW_FK varchar Key that link this record back to its related record found in the c_bbs_int.
100
 SPECIES_FK int Species code.
100
 NUM_KEPT int Number of fish (pieces) kept.
100
 NUM_KEPT_TYPE int Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated).
100
 EST_KGS decimal Total catch of this species.
100
 EST_KGS_TYPE int How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 DISPOSITION int Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion.
100
 PRICE_LB decimal Place holder, not used.
100
 PRICE_LB_TYPE int Place holder, not used.
100
 SIZE_GROUP int fish size goup.
100
 BYCATCH_TYPE varchar Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other).
100
 CAT_REMARKS varchar Comment field.
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 System-generated artificial primary key.
100
 CATCH_FK varchar Key link this record to its related record in C_BBS_CATCH.
100
 LEN_MM int Fork length of fish in mm.
100
 LEN_MM_TYPE int How len was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 KGS decimal Fish weight in kilograms.
100
 KGS_TYPE int How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 SEX varchar Place holder, not in used.
100
 SIZ_CREATE_TIME datetime Date the record was created
100
 SIZ_MODIFY_TIME datetime Date the record was last modified
100
 SIZ_LOAD_TABLE varchar varchar(32)
100
 SIZ_LOAD_DATETIME datetime datetime
100
 SIZ_LOAD_USER varchar varchar(32)
100
 FISHING_METHOD varchar Fishing method.
100
 FISHING_AREA varchar Fishing area code.
100
 PORT_NAME varchar Port name.
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: 1008042
Seq. Order: 1
Data Storage Type: varchar
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Primary key, a unique identifier for each record in this table.

SAMPLE_DATE

CC ID: 1008043
Seq. Order: 2
Data Storage Type: date
Required: No
Primary Key: No
Status: Active
Description:

Date of the survey.

TYPE_OF_DAY

CC ID: 1008044
Seq. Order: 3
Data Storage Type: varchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).

INTERVIEW_TIME

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

Time the interview was conducted.

INTERVIEWER1_FK

CC ID: 1008046
Seq. Order: 5
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Interviewer1 code.

INTERVIEWER2_FK

CC ID: 1008047
Seq. Order: 6
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Interviewer2 code.

INTERVIEW_ORDER

CC ID: 1008048
Seq. Order: 7
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Order of the survey was taken.

BOATLOG_DT_FK

CC ID: 1008049
Seq. Order: 8
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Filler, not in used.

AREA_FK

CC ID: 1008050
Seq. Order: 9
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Code for the area fished. Detailed information can be found in G_BBS_AREA.

METHOD_FK

CC ID: 1008051
Seq. Order: 10
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Fishing method code.

DEPTH

CC ID: 1008052
Seq. Order: 11
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed).

WEATHER_FK

CC ID: 1008053
Seq. Order: 12
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Weather conditions. Detailed information can be found in G_WEATHER.

CLOUD_FK

CC ID: 1008054
Seq. Order: 13
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF.

WIND_DIRECTION

CC ID: 1008055
Seq. Order: 14
Data Storage Type: varchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Wind direction (e.g. E=east, NE=northeast).

WIND_SPEED

CC ID: 1008056
Seq. Order: 15
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Wind speed in knots.

HOURS_FISHED

CC ID: 1008057
Seq. Order: 16
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Number of hours spent fishing.

NUM_FISHER

CC ID: 1008058
Seq. Order: 17
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of fishermen fishing.

NUM_GUEST

CC ID: 1008059
Seq. Order: 18
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of guests on vessel.

NUM_DAYS_FISHED

CC ID: 1008060
Seq. Order: 19
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of days fished.

NUM_GEAR

CC ID: 1008061
Seq. Order: 20
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of gears used.

VESSEL_NAME

CC ID: 1008062
Seq. Order: 21
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of the fishing vessel.

PORT_FK

CC ID: 1008063
Seq. Order: 22
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Port code.

CAR_LICENSE

CC ID: 1008064
Seq. Order: 23
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Vehicle/trailer license number.

TOT_NUM_KEPT_TYPE

CC ID: 1008065
Seq. Order: 24
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).

TOT_NUM_KEPT

CC ID: 1008066
Seq. Order: 25
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Total pieces of fish caught.

TOT_EST_KGS_TYPE

CC ID: 1008067
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_EST_KGS

CC ID: 1008068
Seq. Order: 27
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 2
Status: Active
Description:

Total fish caught in kgs for this trip.

TOT_SPECIES_TYPE

CC ID: 1008069
Seq. Order: 28
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).

TOT_SPECIES

CC ID: 1008070
Seq. Order: 29
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of species caught on this trip.

PERCENT_UNSOLD

CC ID: 1008071
Seq. Order: 30
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Percent of unsold catch.

PERCENT_SOLD

CC ID: 1008072
Seq. Order: 31
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Percent of catch sold (to the hundredths).

BUYER_FK

CC ID: 1008073
Seq. Order: 32
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Filler, not in used.

BYCATCH_F

CC ID: 1008074
Seq. Order: 33
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true, this was a bycatch.

CHARTER_F

CC ID: 1008075
Seq. Order: 34
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true, it is a charter trip.

BERTHED_F

CC ID: 1008076
Seq. Order: 35
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true, the vessel is berthed.

SMALLCRAFT_F

CC ID: 1008077
Seq. Order: 36
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true (T), small craft advisory was in effect.

HIGHSURF_F

CC ID: 1008078
Seq. Order: 37
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true, high surf warning was in effect.

NON_SCHED_F

CC ID: 1008079
Seq. Order: 38
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true (T), the interview was non-scheduled (opportunistic).

LUNAR_DAY

CC ID: 1008080
Seq. Order: 39
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011.

INCOMPLETE_F

CC ID: 1008081
Seq. Order: 40
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

This interview is not complete (all catch from this trip was not captured on this interview).

REMARKS

CC ID: 1008082
Seq. Order: 41
Data Storage Type: varchar
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Comment field.

INT_CREATE_TIME

CC ID: 1008083
Seq. Order: 42
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date and time that the record was created or date the record was created.

INT_MODIFY_TIME

CC ID: 1008084
Seq. Order: 43
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: 1008085
Seq. Order: 44
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Name of the user who created the record.

INT_MODIFY_USER

CC ID: 1008086
Seq. Order: 45
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Name of the user who last modified the record.

INT_LOAD_TABLE

CC ID: 1008087
Seq. Order: 46
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: 1008088
Seq. Order: 47
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: 1008089
Seq. Order: 48
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: 1008090
Seq. Order: 49
Data Storage Type: varchar
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Primary key, a unique identifier for each record in this table.

INTERVIEW_FK

CC ID: 1008091
Seq. Order: 50
Data Storage Type: varchar
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Key that link this record back to its related record found in the c_bbs_int.

SPECIES_FK

CC ID: 1008092
Seq. Order: 51
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Species code.

NUM_KEPT

CC ID: 1008093
Seq. Order: 52
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of fish (pieces) kept.

NUM_KEPT_TYPE

CC ID: 1008094
Seq. Order: 53
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated).

EST_KGS

CC ID: 1008095
Seq. Order: 54
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Total catch of this species.

EST_KGS_TYPE

CC ID: 1008096
Seq. Order: 55
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).

DISPOSITION

CC ID: 1008097
Seq. Order: 56
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion.

PRICE_LB

CC ID: 1008098
Seq. Order: 57
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Place holder, not used.

PRICE_LB_TYPE

CC ID: 1008099
Seq. Order: 58
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Place holder, not used.

SIZE_GROUP

CC ID: 1008100
Seq. Order: 59
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

fish size goup.

BYCATCH_TYPE

CC ID: 1008101
Seq. Order: 60
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other).

CAT_REMARKS

CC ID: 1008102
Seq. Order: 61
Data Storage Type: varchar
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Comment field.

CAT_CREATE_TIME

CC ID: 1008103
Seq. Order: 62
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

When this record was created

CAT_MODIFY_TIME

CC ID: 1008104
Seq. Order: 63
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: 1008105
Seq. Order: 64
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: 1008106
Seq. Order: 65
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: 1008107
Seq. Order: 66
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: 1008108
Seq. Order: 67
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

System-generated artificial primary key.

CATCH_FK

CC ID: 1008109
Seq. Order: 68
Data Storage Type: varchar
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Key link this record to its related record in C_BBS_CATCH.

LEN_MM

CC ID: 1008110
Seq. Order: 69
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Fork length of fish in mm.

LEN_MM_TYPE

CC ID: 1008111
Seq. Order: 70
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

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

KGS

CC ID: 1008112
Seq. Order: 71
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Fish weight in kilograms.

KGS_TYPE

CC ID: 1008113
Seq. Order: 72
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).

SEX

CC ID: 1008114
Seq. Order: 73
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Place holder, not in used.

SIZ_CREATE_TIME

CC ID: 1008115
Seq. Order: 74
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date the record was created

SIZ_MODIFY_TIME

CC ID: 1008116
Seq. Order: 75
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date the record was last modified

SIZ_LOAD_TABLE

CC ID: 1008117
Seq. Order: 76
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

varchar(32)

SIZ_LOAD_DATETIME

CC ID: 1008118
Seq. Order: 77
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

datetime

SIZ_LOAD_USER

CC ID: 1008119
Seq. Order: 78
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

varchar(32)

FISHING_METHOD

CC ID: 1008120
Seq. Order: 79
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Fishing method.

FISHING_AREA

CC ID: 1008121
Seq. Order: 80
Data Storage Type: varchar
Max Length: 35
Required: No
Primary Key: No
Status: Active
Description:

Fishing area code.

PORT_NAME

CC ID: 1008122
Seq. Order: 81
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Port name.

SCIENTIFIC_NAME

CC ID: 1008123
Seq. Order: 82
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: 1008124
Seq. Order: 83
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: 63468
GUID: gov.noaa.nmfs.inport:63468
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:05+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