Metadata Rubric

83%

5 / 6

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

a_sbs_interview_flat_view

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

Item Identification

Title:	a_sbs_interview_flat_view
Status:	Completed

Entity Information

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

Data Attributes

Attribute Summary

	Name	Type	Description
100	INTERVIEW_PK	varchar	Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.
100	ROUTE_FK	int	Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
100	SAMPLE_DATE	date	Date of the survey.
100	INTERVIEW_TIME	datetime	Date and time the interview started.
100	TYPE_OF_DAY	varchar	Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.
100	GRAMS_F	char	Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.
100	NON_SCHED_F	char	If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.
100	INTERVIEWER1_FK	int	Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	INTERVIEWER2_FK	int	Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	INTERVIEWER3_FK	int	Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
100	HOURS_FISHED	decimal	Number of hours spent fishing before the interview was started.
100	AREA_FK	int	Area code. Detailed information can be found in A_AREA and A_AREA.DBF.
100	HOME_F	char	Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.
100	METHOD_FK	int	Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
100	NUM_GEAR	int	Number of gears used.
100	NUM_PEOPLE	int	Number of people in the group being interviewed whether they are fishing or not.
100	NUM_CHILD_M	int	Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.
100	NUM_CHILD_F	int	Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.
100	NUM_ADULT_F	int	Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.
100	NUM_ADULT_M	int	Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.
100	TOT_EST_WHOLE_LBS	decimal	Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.
100	PORCENT_SOLD	int	Percentage of the interview catch sold commercially.
100	COMPLETED_INT_F	char	If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.
100	START_TIME	datetime	Date and time or time the fishing activity started.
100	STOP_TIME	datetime	time when fishing stopped.
100	INT_REMARKS	varchar	Remarks.
100	INT_CREATE_TIME	datetime	date of interview record created
100	INT_MODIFY_TIME	datetime	When this record was last modified.
100	INT_LOAD_TABLE	varchar	Foxpro files where this record was loaded from.
100	INT_LOAD_DATETIME	datetime	Date when data was loaded
100	INT_LOAD_USER	varchar	User who loaded the a_sbs_int data table from Focpro data
100	CATCH_PK	int	Primary key value found in the a_sbs_cat data table
100	INTERVIEW_FK	varchar	Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .
100	SPECIES_FK	int	species code , detailed information can be found in A_SPECIES.
100	DISPOSITION_FK	int	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
100	LEN_CM	decimal	Length in centimeters of a single fish if measured.
100	ACT_WT	decimal	Actual measured weight.
100	NUM_PIECES	int	Number of pieces of fish caught.
100	EST_WHOLE_LBS_TYPE	varchar	Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.
100	EST_WHOLE_LBS	decimal	Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.
100	CAT_REMARKS	varchar	Remarks.
100	CAT_CREATE_TIME	datetime	When catch data record was created.
100	CAT_MODIFY_TIME	datetime	When this record was last modified.
100	CAT_LOAD_TABLE	varchar	Foxpro files where this record was loaded from.
100	CAT_LOAD_DATETIME	datetime	When the a_sbs_catch data table was loaded ito MySQL.
100	CAT_LOAD_USER	varchar	User who loaded the a_sbs_catch data table from Focpro data.
100	FISHING_METHOD	varchar	gear used code. See description in A_METHOD table
100	FISHING_AREA	varchar	area fished code. See description in the A_AREA table
100	ROUTE_NAME	varchar	The name of the route.
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.
100	DISPOSITION	varchar	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

Name

Type

Description

100

INTERVIEW_PK

varchar

Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.

100

ROUTE_FK

int

Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.

100

SAMPLE_DATE

date

Date of the survey.

100

INTERVIEW_TIME

datetime

Date and time the interview started.

100

TYPE_OF_DAY

varchar

Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.

100

GRAMS_F

char

Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.

100

NON_SCHED_F

char

If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.

100

INTERVIEWER1_FK

int

Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

100

INTERVIEWER2_FK

int

Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

100

INTERVIEWER3_FK

int

Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

100

HOURS_FISHED

decimal

Number of hours spent fishing before the interview was started.

100

AREA_FK

int

Area code. Detailed information can be found in A_AREA and A_AREA.DBF.

100

HOME_F

char

Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.

100

METHOD_FK

int

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

100

NUM_GEAR

int

Number of gears used.

100

NUM_PEOPLE

int

Number of people in the group being interviewed whether they are fishing or not.

100

NUM_CHILD_M

int

Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.

100

NUM_CHILD_F

int

Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.

100

NUM_ADULT_F

int

Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.

100

NUM_ADULT_M

int

Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.

100

TOT_EST_WHOLE_LBS

decimal

Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.

100

PORCENT_SOLD

int

Percentage of the interview catch sold commercially.

100

COMPLETED_INT_F

char

If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.

100

START_TIME

datetime

Date and time or time the fishing activity started.

100

STOP_TIME

datetime

time when fishing stopped.

100

INT_REMARKS

varchar

Remarks.

100

INT_CREATE_TIME

datetime

date of interview record created

100

INT_MODIFY_TIME

datetime

When this record was last modified.

100

INT_LOAD_TABLE

varchar

Foxpro files where this record was loaded from.

100

INT_LOAD_DATETIME

datetime

Date when data was loaded

100

INT_LOAD_USER

varchar

User who loaded the a_sbs_int data table from Focpro data

100

CATCH_PK

int

Primary key value found in the a_sbs_cat data table

100

INTERVIEW_FK

varchar

Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .

100

SPECIES_FK

int

species code , detailed information can be found in A_SPECIES.

100

DISPOSITION_FK

int

Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

100

LEN_CM

decimal

Length in centimeters of a single fish if measured.

100

ACT_WT

decimal

Actual measured weight.

100

NUM_PIECES

int

Number of pieces of fish caught.

100

EST_WHOLE_LBS_TYPE

varchar

Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.

100

EST_WHOLE_LBS

decimal

Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.

100

CAT_REMARKS

varchar

Remarks.

100

CAT_CREATE_TIME

datetime

When catch data record was created.

100

CAT_MODIFY_TIME

datetime

When this record was last modified.

100

CAT_LOAD_TABLE

varchar

Foxpro files where this record was loaded from.

100

CAT_LOAD_DATETIME

datetime

When the a_sbs_catch data table was loaded ito MySQL.

100

CAT_LOAD_USER

varchar

User who loaded the a_sbs_catch data table from Focpro data.

100

FISHING_METHOD

varchar

gear used code. See description in A_METHOD table

100

FISHING_AREA

varchar

area fished code. See description in the A_AREA table

100

ROUTE_NAME

varchar

The name of the route.

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.

100

DISPOSITION

varchar

Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

Attribute Details

INTERVIEW_PK

CC ID: 1008529

Seq. Order:	1
Data Storage Type:	varchar
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created.

ROUTE_FK

CC ID: 1008530

Seq. Order:	2
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.

SAMPLE_DATE

CC ID: 1008531

Seq. Order:	3
Data Storage Type:	date
Required:	No
Primary Key:	No
Status:	Active
Description:	Date of the survey.

INTERVIEW_TIME

CC ID: 1008532

Seq. Order:	4
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time the interview started.

TYPE_OF_DAY

CC ID: 1008533

Seq. Order:	5
Data Storage Type:	varchar
Max Length:	2
Required:	No
Primary Key:	No
Status:	Active
Description:	Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF.

GRAMS_F

CC ID: 1008534

Seq. Order:	6
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field.

NON_SCHED_F

CC ID: 1008535

Seq. Order:	7
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route.

INTERVIEWER1_FK

CC ID: 1008536

Seq. Order:	8
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

INTERVIEWER2_FK

CC ID: 1008537

Seq. Order:	9
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

INTERVIEWER3_FK

CC ID: 1008538

Seq. Order:	10
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.

HOURS_FISHED

CC ID: 1008539

Seq. Order:	11
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	7
Scale:	2
Status:	Active
Description:	Number of hours spent fishing before the interview was started.

AREA_FK

CC ID: 1008540

Seq. Order:	12
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Area code. Detailed information can be found in A_AREA and A_AREA.DBF.

HOME_F

CC ID: 1008541

Seq. Order:	13
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home.

METHOD_FK

CC ID: 1008542

Seq. Order:	14
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 A_METHOD or A_METHOD.DBF.

NUM_GEAR

CC ID: 1008543

Seq. Order:	15
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of gears used.

NUM_PEOPLE

CC ID: 1008544

Seq. Order:	16
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of people in the group being interviewed whether they are fishing or not.

NUM_CHILD_M

CC ID: 1008545

Seq. Order:	17
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not.

NUM_CHILD_F

CC ID: 1008546

Seq. Order:	18
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not.

NUM_ADULT_F

CC ID: 1008547

Seq. Order:	19
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.

NUM_ADULT_M

CC ID: 1008548

Seq. Order:	20
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.

TOT_EST_WHOLE_LBS

CC ID: 1008549

Seq. Order:	21
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	10
Scale:	3
Status:	Active
Description:	Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip.

PORCENT_SOLD

CC ID: 1008550

Seq. Order:	22
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Percentage of the interview catch sold commercially.

COMPLETED_INT_F

CC ID: 1008551

Seq. Order:	23
Data Storage Type:	char
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion.

START_TIME

CC ID: 1008552

Seq. Order:	24
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	Date and time or time the fishing activity started.

STOP_TIME

CC ID: 1008553

Seq. Order:	25
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	time when fishing stopped.

INT_REMARKS

CC ID: 1008554

Seq. Order:	26
Data Storage Type:	varchar
Max Length:	256
Required:	No
Primary Key:	No
Status:	Active
Description:	Remarks.

INT_CREATE_TIME

CC ID: 1008555

Seq. Order:	27
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	date of interview record created

INT_MODIFY_TIME

CC ID: 1008556

Seq. Order:	28
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was last modified.

INT_LOAD_TABLE

CC ID: 1008557

Seq. Order:	29
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Foxpro files where this record was loaded from.

INT_LOAD_DATETIME

CC ID: 1008558

Seq. Order:	30
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	Date when data was loaded

INT_LOAD_USER

CC ID: 1008559

Seq. Order:	31
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User who loaded the a_sbs_int data table from Focpro data

CATCH_PK

CC ID: 1008560

Seq. Order:	32
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Primary key value found in the a_sbs_cat data table

INTERVIEW_FK

CC ID: 1008561

Seq. Order:	33
Data Storage Type:	varchar
Max Length:	12
Required:	No
Primary Key:	No
Status:	Active
Description:	Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF .

SPECIES_FK

CC ID: 1008562

Seq. Order:	34
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	species code , detailed information can be found in A_SPECIES.

DISPOSITION_FK

CC ID: 1008563

Seq. Order:	35
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

LEN_CM

CC ID: 1008564

Seq. Order:	36
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	2
Status:	Active
Description:	Length in centimeters of a single fish if measured.

ACT_WT

CC ID: 1008565

Seq. Order:	37
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	3
Status:	Active
Description:	Actual measured weight.

NUM_PIECES

CC ID: 1008566

Seq. Order:	38
Data Storage Type:	int
Required:	No
Primary Key:	No
Precision:	10
Scale:	0
Status:	Active
Description:	Number of pieces of fish caught.

EST_WHOLE_LBS_TYPE

CC ID: 1008567

Seq. Order:	39
Data Storage Type:	varchar
Max Length:	3
Required:	No
Primary Key:	No
Status:	Active
Description:	Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens.

EST_WHOLE_LBS

CC ID: 1008568

Seq. Order:	40
Data Storage Type:	decimal
Required:	No
Primary Key:	No
Precision:	8
Scale:	3
Status:	Active
Description:	Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated.

CAT_REMARKS

CC ID: 1008569

Seq. Order:	41
Data Storage Type:	varchar
Max Length:	256
Required:	No
Primary Key:	No
Status:	Active
Description:	Remarks.

CAT_CREATE_TIME

CC ID: 1008570

Seq. Order:	42
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When catch data record was created.

CAT_MODIFY_TIME

CC ID: 1008571

Seq. Order:	43
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When this record was last modified.

CAT_LOAD_TABLE

CC ID: 1008572

Seq. Order:	44
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	Foxpro files where this record was loaded from.

CAT_LOAD_DATETIME

CC ID: 1008573

Seq. Order:	45
Data Storage Type:	datetime
Required:	No
Primary Key:	No
Status:	Active
Description:	When the a_sbs_catch data table was loaded ito MySQL.

CAT_LOAD_USER

CC ID: 1008574

Seq. Order:	46
Data Storage Type:	varchar
Max Length:	32
Required:	No
Primary Key:	No
Status:	Active
Description:	User who loaded the a_sbs_catch data table from Focpro data.

FISHING_METHOD

CC ID: 1008575

Seq. Order:	47
Data Storage Type:	varchar
Max Length:	45
Required:	No
Primary Key:	No
Status:	Active
Description:	gear used code. See description in A_METHOD table

FISHING_AREA

CC ID: 1008576

Seq. Order:	48
Data Storage Type:	varchar
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	area fished code. See description in the A_AREA table

ROUTE_NAME

CC ID: 1008577

Seq. Order:	49
Data Storage Type:	varchar
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the route.

SCIENTIFIC_NAME

CC ID: 1008578

Seq. Order:	50
Data Storage Type:	varchar
Max Length:	73
Required:	No
Primary Key:	No
Status:	Active
Description:	Scientific name of the species (Genus name + Species name).

COMMON_NAME

CC ID: 1008579

Seq. Order:	51
Data Storage Type:	varchar
Max Length:	46
Required:	No
Primary Key:	No
Status:	Active
Description:	Common English name for the species.

LOCAL_NAME

CC ID: 1008580

Seq. Order:	52
Data Storage Type:	varchar
Max Length:	46
Required:	No
Primary Key:	No
Status:	Active
Description:	Local name of the species.

DISPOSITION

CC ID: 1008581

Seq. Order:	53
Data Storage Type:	varchar
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

Catalog Details

Catalog Item ID:	63227
GUID:	gov.noaa.nmfs.inport:63227
Metadata Record Created By:	Brent M Miyamoto
Metadata Record Created:	2020-11-17 23:42+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