Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
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