Metadata Rubric

83%

5 / 6

PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > CNMI Shore-based Creel Survey >

c_sbs_interview_flat_view

Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63465 | Updated: August 9, 2022 | Published / External

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

	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.

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