Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > 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 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
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.
ROUTE_FK
int 		Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF.
SAMPLE_DATE
date 		Date of the survey.
INTERVIEW_TIME
datetime 		Date and time the interview started.
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.
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.
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.
INTERVIEWER1_FK
int 		Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
INTERVIEWER2_FK
int 		Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
INTERVIEWER3_FK
int 		Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF.
HOURS_FISHED
decimal 		Number of hours spent fishing before the interview was started.
AREA_FK
int 		Area code. Detailed information can be found in A_AREA and A_AREA.DBF.
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.
METHOD_FK
int 		Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF.
NUM_GEAR
int 		Number of gears used.
NUM_PEOPLE
int 		Number of people in the group being interviewed whether they are fishing or not.
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.
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.
NUM_ADULT_F
int 		Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not.
NUM_ADULT_M
int 		Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not.
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.
PORCENT_SOLD
int 		Percentage of the interview catch sold commercially.
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.
START_TIME
datetime 		Date and time or time the fishing activity started.
STOP_TIME
datetime 		time when fishing stopped.
INT_REMARKS
varchar 		Remarks.
INT_CREATE_TIME
datetime 		date of interview record created
INT_MODIFY_TIME
datetime 		When this record was last modified.
INT_LOAD_TABLE
varchar 		Foxpro files where this record was loaded from.
INT_LOAD_DATETIME
datetime 		Date when data was loaded
INT_LOAD_USER
varchar 		User who loaded the a_sbs_int data table from Focpro data
CATCH_PK
int 		Primary key value found in the a_sbs_cat data table
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 .
SPECIES_FK
int 		species code , detailed information can be found in A_SPECIES.
DISPOSITION_FK
int 		Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.
LEN_CM
decimal 		Length in centimeters of a single fish if measured.
ACT_WT
decimal 		Actual measured weight.
NUM_PIECES
int 		Number of pieces of fish caught.
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.
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.
CAT_REMARKS
varchar 		Remarks.
CAT_CREATE_TIME
datetime 		When catch data record was created.
CAT_MODIFY_TIME
datetime 		When this record was last modified.
CAT_LOAD_TABLE
varchar 		Foxpro files where this record was loaded from.
CAT_LOAD_DATETIME
datetime 		When the a_sbs_catch data table was loaded ito MySQL.
CAT_LOAD_USER
varchar 		User who loaded the a_sbs_catch data table from Focpro data.
FISHING_METHOD
varchar 		gear used code. See description in A_METHOD table
FISHING_AREA
varchar 		area fished code. See description in the A_AREA table
ROUTE_NAME
varchar 		The name of the route.
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.
DISPOSITION
varchar 		Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table.

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: 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

Rubric Score Primary Key? 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