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 on which 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
int
Code for the interviewer. Detailed information can be found in C_SBS_INTERVIEWER or C_INTERV.DBF.
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
Total fished time for catch recorded on this interview. Calculated field: INT_TIME minus START_TIME.
EST_HOURS
decimal
Estimated of trip time. Calculated field: STOP_TIME - START_TIME.
METHOD_FK
int
Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.
AREA_FK
int
Code for the area fished. Detailed information can be found in C_SBS_AREA or C_AREA.DBF.
NUM_GEAR
int
Number of gears used.
REEF_ZONE_FK
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_KEPT_TYP
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).
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 conditions (1: 0-1 ft. calm, 2: 1-3 ft. light surf, 6: 3-6 ft. medium surf, 9: 6-9 ft high surf).
TIDE
decimal
Tide level
ETHNICITY_FK
int
Code for the ethnicity of fisherman. Detailed information can be found in C_ETHNICITY or C_ETHNIC.DBF.
NON_SCHED_F
char
Indicates whether an interview is opportunistic or not. If true (T), it is an opportunistic interview (non-scheduled).
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. 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).
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
int
Staff code who enter this data
INT_MODIFY_USER
int
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
UID assigned to this record
INTERVIEW_FK
varchar
Identifier each record in C_SBS_INT.
SPECIES_FK
int
Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.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 len was collected (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
WEATHER
varchar
Weather conditions code description.
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_sbs_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 assigned to this record
100
SAMPLE_DATE date Date of the survey.
100
TYPE_OF_DAY varchar Type of day on which 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 int Code for the interviewer. Detailed information can be found in C_SBS_INTERVIEWER or C_INTERV.DBF.
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 Total fished time for catch recorded on this interview. Calculated field: INT_TIME minus 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. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.
100
AREA_FK int Code for the area fished. Detailed information can be found in C_SBS_AREA or C_AREA.DBF.
100
NUM_GEAR int Number of gears used.
100
REEF_ZONE_FK 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_KEPT_TYP 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
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 conditions (1: 0-1 ft. calm, 2: 1-3 ft. light surf, 6: 3-6 ft. medium surf, 9: 6-9 ft high surf).
100
TIDE decimal Tide level
100
ETHNICITY_FK int Code for the ethnicity of fisherman. Detailed information can be found in C_ETHNICITY or C_ETHNIC.DBF.
100
NON_SCHED_F char Indicates whether an interview is opportunistic or not. If true (T), it is an opportunistic interview (non-scheduled).
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. 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
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 int Staff code who enter this data
100
INT_MODIFY_USER int 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 UID assigned to this record
100
INTERVIEW_FK varchar Identifier each record in C_SBS_INT.
100
SPECIES_FK int Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.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 len was collected (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
WEATHER varchar Weather conditions code description.
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: 1007903
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: 1007904
Seq. Order: 2
Data Storage Type: date
Required: No
Primary Key: No
Status: Active
Description:

Date of the survey.

TYPE_OF_DAY

CC ID: 1007905
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 (1 = weekday, 2 = weekend/holiday).

NUM_FISHER

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

Code for the interviewer. Detailed information can be found in C_SBS_INTERVIEWER or C_INTERV.DBF.

INTERVIEW_TIME

CC ID: 1007909
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: 1007910
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: 1007911
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: 1007912
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: 1007913
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: 1007914
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: 1007915
Seq. Order: 13
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 5
Scale: 2
Status: Active
Description:

Total fished time for catch recorded on this interview. Calculated field: INT_TIME minus START_TIME.

EST_HOURS

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

Code for the fishing method. Detailed information can be found in C_SBS_METHOD or in C_METHOD.DBF.

AREA_FK

CC ID: 1007918
Seq. Order: 16
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_SBS_AREA or C_AREA.DBF.

NUM_GEAR

CC ID: 1007919
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_FK

CC ID: 1007920
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: 1007921
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: 1007922
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: 1007923
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: 1007924
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: 1007925
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: 1007926
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_KEPT_TYP

CC ID: 1007927
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: 1007928
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: 1007929
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).

WEATHER_FK

CC ID: 1007930
Seq. Order: 28
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: 1007931
Seq. Order: 29
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: 1007932
Seq. Order: 30
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Surf conditions (1: 0-1 ft. calm, 2: 1-3 ft. light surf, 6: 3-6 ft. medium surf, 9: 6-9 ft high surf).

TIDE

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

Tide level

ETHNICITY_FK

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

Code for the ethnicity of fisherman. Detailed information can be found in C_ETHNICITY or C_ETHNIC.DBF.

NON_SCHED_F

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

Indicates whether an interview is opportunistic or not. If true (T), it is an opportunistic interview (non-scheduled).

BYCATCH_F

CC ID: 1007936
Seq. Order: 34
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: 1007937
Seq. Order: 35
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).

INT_CREATE_TIME

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

When this record was created

INT_MODIFY_TIME

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

Staff code who enter this data

INT_MODIFY_USER

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

Staff code who last editted this record

INT_LOAD_TABLE

CC ID: 1007942
Seq. Order: 40
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: 1007943
Seq. Order: 41
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: 1007944
Seq. Order: 42
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: 1007945
Seq. Order: 43
Data Storage Type: varchar
Max Length: 23
Required: No
Primary Key: No
Status: Active
Description:

UID assigned to this record

INTERVIEW_FK

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

Identifier each record in C_SBS_INT.

SPECIES_FK

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

Species code. Detailed information can be found in C_SBS_SPECIES or C_SPECIES.DBF.

NUM_KEPT_TYPE

CC ID: 1007948
Seq. Order: 46
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: 1007949
Seq. Order: 47
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: 1007950
Seq. Order: 48
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: 1007951
Seq. Order: 49
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: 1007952
Seq. Order: 50
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

fish size goup.

BYCATCH_TYPE

CC ID: 1007953
Seq. Order: 51
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: 1007954
Seq. Order: 52
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

When this record was created

CAT_MODIFY_TIME

CC ID: 1007955
Seq. Order: 53
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: 1007956
Seq. Order: 54
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: 1007957
Seq. Order: 55
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: 1007958
Seq. Order: 56
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: 1007959
Seq. Order: 57
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: 1007960
Seq. Order: 58
Data Storage Type: varchar
Max Length: 23
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: 1007961
Seq. Order: 59
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).

LEN_MM

CC ID: 1007962
Seq. Order: 60
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: 1007963
Seq. Order: 61
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: 1007964
Seq. Order: 62
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: 1007965
Seq. Order: 63
Data Storage Type: datetime
Required: No
Primary Key: No
Status: Active
Description:

This record created date

SIZ_MODIFY_TIME

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

When was last update to this record

SIZ_LOAD_TABLE

CC ID: 1007967
Seq. Order: 65
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: 1007968
Seq. Order: 66
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: 1007969
Seq. Order: 67
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: 1007970
Seq. Order: 68
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

fishing method code

FISHING_AREA

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

fishing area code

BUYER_NAME

CC ID: 1007972
Seq. Order: 70
Data Storage Type: varchar
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Buyer name

WEATHER

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

Weather conditions code description.

SCIENTIFIC_NAME

CC ID: 1007974
Seq. Order: 72
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: 1007975
Seq. Order: 73
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: 1007976
Seq. Order: 74
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: 63465
GUID: gov.noaa.nmfs.inport:63465
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 00:50+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