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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-11-17 23:42+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2021-01-21 20:03+0000
Metadata Record Published: 2021-01-21
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2022-01-22