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

c_bbs_interview_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63461  |  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, Primary key .
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 C_BBS_AREA or C_AREA.DBF.
METHOD_FK
int 		Fishing method code.
DEPTH
varchar 		Bottomfishing set depth (D = deep, S = shallow, M = mixed).
WEATHER_FK
int 		Code for weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
CLOUD_FK
int 		Cloud condition code.
WIND_DIRECTION
varchar 		Place holder, not used.
WIND_SPEED
int 		Place holder, not used.
HOURS_FISHED
decimal 		Number of hours fished.
NUM_FISHER
int 		Number of fishermen fishing.
NUM_GUEST
int 		Number of guests onboard during trip.
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_SOLD_DOCK
decimal 		Percent of catch sold at dock (to the hundredths).
PERCENT_SOLD
decimal 		Percent of catch sold (to the hundredths).
PERCENT_UNSOLD
decimal 		Percent of unsold catch.
BUYER_FK
int 		Filler, not in used.
BYCATCH_F
varchar 		If true, this was a bycatch.
CHARTER_F
char 		If true (T), indicates chartered trip.
BERTHED_F
char 		If true (T), the boat was 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 		Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon).
INCOMPLETE_F
char 		This interview is not complete (all catch from this trip was not captured on this interview).
INT_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
int 		Name of the user who created the record.
INT_MODIFY_USER
int 		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 (MySQL only) which is a unique identifier for each record in this table. Specify value.
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 		Pieces of fish caught.
NUM_KEPT_TYPE
int 		How NUM_KEPT was collected (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).
PRICE_LB
decimal 		Place holder, not used.
PRICE_LB_TYPE_FK
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.
LOCAL_NAME
varchar 		Local name of 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: c_bbs_interview_flat_view
Status: Completed

Entity Information

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

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 INTERVIEW_PK varchar UID, Primary key .
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 C_BBS_AREA or C_AREA.DBF.
100
 METHOD_FK int Fishing method code.
100
 DEPTH varchar Bottomfishing set depth (D = deep, S = shallow, M = mixed).
100
 WEATHER_FK int Code for weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
100
 CLOUD_FK int Cloud condition code.
100
 WIND_DIRECTION varchar Place holder, not used.
100
 WIND_SPEED int Place holder, not used.
100
 HOURS_FISHED decimal Number of hours fished.
100
 NUM_FISHER int Number of fishermen fishing.
100
 NUM_GUEST int Number of guests onboard during trip.
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_SOLD_DOCK decimal Percent of catch sold at dock (to the hundredths).
100
 PERCENT_SOLD decimal Percent of catch sold (to the hundredths).
100
 PERCENT_UNSOLD decimal Percent of unsold catch.
100
 BUYER_FK int Filler, not in used.
100
 BYCATCH_F varchar If true, this was a bycatch.
100
 CHARTER_F char If true (T), indicates chartered trip.
100
 BERTHED_F char If true (T), the boat was 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 Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon).
100
 INCOMPLETE_F char This interview is not complete (all catch from this trip was not captured on this interview).
100
 INT_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 int Name of the user who created the record.
100
 INT_MODIFY_USER int 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 (MySQL only) which is a unique identifier for each record in this table. Specify value.
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 Pieces of fish caught.
100
 NUM_KEPT_TYPE int How NUM_KEPT was collected (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
 PRICE_LB decimal Place holder, not used.
100
 PRICE_LB_TYPE_FK 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.
100
 LOCAL_NAME varchar Local name of the species.

Attribute Details

INTERVIEW_PK

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

UID, Primary key .

SAMPLE_DATE

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

Date of the survey.

TYPE_OF_DAY

CC ID: 1007739
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: 1007740
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: 1007741
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: 1007742
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: 1007743
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: 1007744
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: 1007745
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 C_BBS_AREA or C_AREA.DBF.

METHOD_FK

CC ID: 1007746
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: 1007747
Seq. Order: 11
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Bottomfishing set depth (D = deep, S = shallow, M = mixed).

WEATHER_FK

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

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

CLOUD_FK

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

Cloud condition code.

WIND_DIRECTION

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

Place holder, not used.

WIND_SPEED

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

Place holder, not used.

HOURS_FISHED

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

Number of hours fished.

NUM_FISHER

CC ID: 1007753
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: 1007754
Seq. Order: 18
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of guests onboard during trip.

NUM_GEAR

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

Number of gears used.

VESSEL_NAME

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

Name of the fishing vessel.

PORT_FK

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

Port code.

CAR_LICENSE

CC ID: 1007758
Seq. Order: 22
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: 1007759
Seq. Order: 23
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: 1007760
Seq. Order: 24
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: 1007761
Seq. Order: 25
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: 1007762
Seq. Order: 26
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 3
Status: Active
Description:

Total fish caught in kgs for this trip.

TOT_SPECIES_TYPE

CC ID: 1007763
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).

TOT_SPECIES

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

Number of species caught on this trip.

PERCENT_SOLD_DOCK

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

Percent of catch sold at dock (to the hundredths).

PERCENT_SOLD

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

Percent of catch sold (to the hundredths).

PERCENT_UNSOLD

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

Percent of unsold catch.

BUYER_FK

CC ID: 1007768
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: 1007769
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: 1007770
Seq. Order: 34
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true (T), indicates chartered trip.

BERTHED_F

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

If true (T), the boat was berthed.

SMALLCRAFT_F

CC ID: 1007772
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: 1007773
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: 1007774
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: 1007775
Seq. Order: 39
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Lunar day. Data obtained from C_LUNAR.DBF (foxpro table), based on the value of the survey date (15 = full moon, 1 or 29/30 = new moon).

INCOMPLETE_F

CC ID: 1007776
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).

INT_REMARKS

CC ID: 1007777
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: 1007778
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: 1007779
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: 1007780
Seq. Order: 44
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Name of the user who created the record.

INT_MODIFY_USER

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

Name of the user who last modified the record.

INT_LOAD_TABLE

CC ID: 1007782
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: 1007783
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: 1007784
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: 1007785
Seq. Order: 49
Data Storage Type: varchar
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Primary key (MySQL only) which is a unique identifier for each record in this table. Specify value.

INTERVIEW_FK

CC ID: 1007786
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: 1007787
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: 1007788
Seq. Order: 52
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Pieces of fish caught.

NUM_KEPT_TYPE

CC ID: 1007789
Seq. Order: 53
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).

EST_KGS

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

Total catch of this species.

EST_KGS_TYPE

CC ID: 1007791
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).

PRICE_LB

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

Place holder, not used.

PRICE_LB_TYPE_FK

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

Place holder, not used.

SIZE_GROUP

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

fish size goup.

BYCATCH_TYPE

CC ID: 1007795
Seq. Order: 59
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: 1007796
Seq. Order: 60
Data Storage Type: varchar
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Comment field.

CAT_CREATE_TIME

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

When this record was created

CAT_MODIFY_TIME

CC ID: 1007798
Seq. Order: 62
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: 1007799
Seq. Order: 63
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: 1007800
Seq. Order: 64
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: 1007801
Seq. Order: 65
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: 1007802
Seq. Order: 66
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: 1007803
Seq. Order: 67
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: 1007804
Seq. Order: 68
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: 1007805
Seq. Order: 69
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: 1007806
Seq. Order: 70
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 3
Status: Active
Description:

Fish weight in kilograms.

KGS_TYPE

CC ID: 1007807
Seq. Order: 71
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: 1007808
Seq. Order: 72
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: 1007809
Seq. Order: 73
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

Date the record was created

SIZ_MODIFY_TIME

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

Date the record was last modified

SIZ_LOAD_TABLE

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

varchar(32)

SIZ_LOAD_DATETIME

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

datetime

SIZ_LOAD_USER

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

varchar(32)

FISHING_METHOD

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

Fishing method.

FISHING_AREA

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

Fishing area code.

PORT_NAME

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

Port name.

SCIENTIFIC_NAME

CC ID: 1007817
Seq. Order: 81
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: 1007818
Seq. Order: 82
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Common English name for the species.

LOCAL_NAME

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

Local name of the species.

Catalog Details

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