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 Boat-based Creel Survey >

a_bbs_interview_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:60075  |  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 or UID for each interview header data record.
SAMPLE_DATE
date 		Date of the survey.
TYPE_OF_DAY
varchar 		Type of day (WD – weekday, WE weekend/holiday).
INTERVIEW_TIME
datetime 		Date and time of the Interview.
INTERVIEWER1_FK
int 		Interviewer 1 code.
INTERVIEWER2_FK
int 		Interviewer 2 code.
INTERVIEW_ORDER
int 		Place holder for future usage. Current value is NULL.
BLDT_FK
int 		Place holder for future usage. Current value is NULL.
AREA_FK
int 		Fishing Area code
METHOD_FK
int 		Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
DEPTH
varchar 		The approximate depth range in fathoms of hook dropped.
TRIP_BEG_DATE
date 		Fishing trip start date.
TRIP_BEG_TIME
int 		Fishing trip start time.
HOURS_FISHED
decimal 		Number of hours spent fishing.
NUM_FISHER
int 		Number of fishermen fishing.
NUM_GUEST
int 		Number of guests on trip that are not fishing.
NUM_SETS
int 		For longline fishing method only. Number of sets covered by the interview. The value is usually 1, but it can be 2 or 3 for longline boats that set their gear two or three times during a trip.
HOURS_PER_SET
decimal 		Longline: hours of line in water. Other method: hours of fishing time.
HOOKS_PER_SET
int 		For longline method: Number of hooks per line. For others: number of gears used.
NUM_DAYS_FISHED
int 		Number of days fished.
NUM_GEAR
int 		For longline method: Number of hooks used. For others: number of gears used.
VESSEL_FK
int 		Vessel code.
VESSEL_HISTORY_FK
int 		Vessel’s history code (e.g. ownership, permit type or type of used). Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF.
PORT_FK
int 		Port code interview is conducted. Detailed information can be found in A_PORT or A_PORT.DBF
TOT_EST_LBS
decimal 		Estimated total pounds of catch for the trip.
BYCATCH_F
char 		If true, there was bycatch on this trip.
CHARTER_F
char 		If true, it is a charter trip.
BERTHED_F
char 		If true, the vessel is berthed at a specific designated place.
NON_SCHED_F
char 		If true, this interview was from a nonscheduled survey day (opportunist interview).
LUNAR_DAY
int 		Place holder for future usage to store the Lunar day of the month. Current value is NULL.
ISLAND_FK
varchar 		Island where the interview was conducted. (TTL:Tutuila and MNA:Manu`a).
REFUSED_F
char 		If true, the fisherman refused to be interviewed.
INCOMPLETE_F
char 		If true, all catch from this trip were not fully captured in this interview.
INT_REMARKS
varchar 		Comments related to the trip (interview header record).
INT_CREATE_TIME
datetime 		Date and time the record was created (interview header records).
INT_MODIFY_TIME
datetime 		Date and time the record was last modified (interview header record).
INT_LOAD_TABLE
varchar 		Name of the FoxPro table (contain this data) that was loaded into MySQL (interview header record).
INT_LOAD_DATETIME
datetime 		The date and time the data was loaded in to the table (interview header record).
INT_LOAD_USER
varchar 		User who loaded the data to the MySQL table (interview header record).
CATCH_PK
varchar 		Primary key, a unique identifier for each catch record. The value is the sample date, interview time, and fishing method (MMDDYYHHMMFF).
INTERVIEW_FK
varchar 		Key (foreign) links the related of catch records (in A_BBS_CAT table) to its interview trip header data (table A_BBS_INT).
SPECIES_FK
int 		Species code. Detailed information can be found in A_SPECIES.
FISH_CONDITION_FK
varchar 		Fish condition code when interview took place. (i.e., whole, gilled-gutted, etc.) Code description is found in the A_FISH_CONDITION.
NUM_KEPT
int 		Number of fish kept (pieces).
NUM_KEPT_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
CAT_LBS
decimal 		Actual fish weight during sampling. When weight was not able to obtain during the interview, the value for this field is zero.
CAT_LBS_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
EST_LBS
decimal 		Estimated fish weight calculated by one of the following cases. 1. It is CAT_LBS, if CAT_LBS >0; 2. Calculated whole fish weight (CAT_LBS and FISH_CONDITION_FK fields both have values); 3. Calculated from measured fish length (length-weight regression based estimation), when CAT_LBS =0 and LEN_MM=1; or 4. NUM_PIECES *AVG_WT when CAT_LBS =0 and NUM_PIECES = >1. AVG_WT is the average fish weight calculated from the measured fish; when there is no measured data (LEN_MM), default mean weight is used (a_species).
EST_LBS_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
DISPOSITION_FK
int 		Fish disposition code. Detailed information can be found in A_DISPOSITION.
BYCATCH_TYPE
char 		Type of bycatch (N-none, A-alive, U-unknown, I-injured or D-dead).
PRICE_LB
decimal 		Estimated price per pound of fish will be selling, provided by fisher.
PRICE_LB_TYPE_FK
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
CAT_REMARKS
varchar 		Comment field (interview catch record).
CAT_CREATE_TIME
datetime 		Date and time the record was created (interview catch record).
CAT_MODIFY_TIME
datetime 		Date and time or date the record was last modified (interview catch record).
CAT_LOAD_TABLE
varchar 		Name of the FoxPro table that was loaded into MySQL (interview catch record).
CAT_LOAD_DATETIME
datetime 		The date and time the data was loaded into MySQL table (interview catch record).
CAT_LOAD_USER
varchar 		User who loaded the data to the MySQL table (interview catch record).
SIZE_PK
int 		Primary key, a unique identifier for each record of the interview’s size data. Value is auto-generated
CATCH_FK
varchar 		Key (foreign) links the related size measurement records (in this table) to its catch record (A_BBS_CAT).
LEN_MM
decimal 		Fork-length of fish in centimeters. Column name should be LEN_CM.
LEN_MM_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
SIZ_LBS
decimal 		Calculated fish weight.
SIZ_LBS_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.
SIZ_REMARKS
varchar 		Comment field for collected individual fish (interview size record).
SIZ_CREATE_TIME
datetime 		Date and time the record was created (interview size record).
SIZ_MODIFY_TIME
datetime 		Date and time or date the record was last modified (interview size record).
SIZ_LOAD_TABLE
varchar 		Name of the FoxPro table that was loaded into MySQL (interview size record).
SIZ_LOAD_DATETIME
datetime 		The date and time the data was loaded in to the table (interview size record).
SIZ_LOAD_USER
varchar 		User who loaded the data to the MySQL table (interview size record).
FISHING_METHOD
varchar 		Fishing method code.
FISHING_AREA
varchar 		Code of fishing area.
VESSEL_REGIST_NO
varchar 		Vessel's registaton number..
PORT_NAME
varchar 		Description for PORT_FK code.
ISLAND_NAME
varchar 		Description for ISLAND_FK code.
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.
FISH_CONDITION
varchar 		Description for FISH_CONDITION_FK code.
DISPOSITION
varchar 		Description for DISPOSITION_FK code.
PRICE_LB_TYPE
varchar 		Place holder to store the source of PRICE_LB value. Currently NULL value.

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_bbs_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 or UID for each interview header data record.
100
 SAMPLE_DATE date Date of the survey.
100
 TYPE_OF_DAY varchar Type of day (WD – weekday, WE weekend/holiday).
100
 INTERVIEW_TIME datetime Date and time of the Interview.
100
 INTERVIEWER1_FK int Interviewer 1 code.
100
 INTERVIEWER2_FK int Interviewer 2 code.
100
 INTERVIEW_ORDER int Place holder for future usage. Current value is NULL.
100
 BLDT_FK int Place holder for future usage. Current value is NULL.
100
 AREA_FK int Fishing Area code
100
 METHOD_FK int Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.
100
 DEPTH varchar The approximate depth range in fathoms of hook dropped.
100
 TRIP_BEG_DATE date Fishing trip start date.
100
 TRIP_BEG_TIME int Fishing trip start time.
100
 HOURS_FISHED decimal Number of hours spent fishing.
100
 NUM_FISHER int Number of fishermen fishing.
100
 NUM_GUEST int Number of guests on trip that are not fishing.
100
 NUM_SETS int For longline fishing method only. Number of sets covered by the interview. The value is usually 1, but it can be 2 or 3 for longline boats that set their gear two or three times during a trip.
100
 HOURS_PER_SET decimal Longline: hours of line in water. Other method: hours of fishing time.
100
 HOOKS_PER_SET int For longline method: Number of hooks per line. For others: number of gears used.
100
 NUM_DAYS_FISHED int Number of days fished.
100
 NUM_GEAR int For longline method: Number of hooks used. For others: number of gears used.
100
 VESSEL_FK int Vessel code.
100
 VESSEL_HISTORY_FK int Vessel’s history code (e.g. ownership, permit type or type of used). Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF.
100
 PORT_FK int Port code interview is conducted. Detailed information can be found in A_PORT or A_PORT.DBF
100
 TOT_EST_LBS decimal Estimated total pounds of catch for the trip.
100
 BYCATCH_F char If true, there was bycatch on this trip.
100
 CHARTER_F char If true, it is a charter trip.
100
 BERTHED_F char If true, the vessel is berthed at a specific designated place.
100
 NON_SCHED_F char If true, this interview was from a nonscheduled survey day (opportunist interview).
100
 LUNAR_DAY int Place holder for future usage to store the Lunar day of the month. Current value is NULL.
100
 ISLAND_FK varchar Island where the interview was conducted. (TTL:Tutuila and MNA:Manu`a).
100
 REFUSED_F char If true, the fisherman refused to be interviewed.
100
 INCOMPLETE_F char If true, all catch from this trip were not fully captured in this interview.
100
 INT_REMARKS varchar Comments related to the trip (interview header record).
100
 INT_CREATE_TIME datetime Date and time the record was created (interview header records).
100
 INT_MODIFY_TIME datetime Date and time the record was last modified (interview header record).
100
 INT_LOAD_TABLE varchar Name of the FoxPro table (contain this data) that was loaded into MySQL (interview header record).
100
 INT_LOAD_DATETIME datetime The date and time the data was loaded in to the table (interview header record).
100
 INT_LOAD_USER varchar User who loaded the data to the MySQL table (interview header record).
100
 CATCH_PK varchar Primary key, a unique identifier for each catch record. The value is the sample date, interview time, and fishing method (MMDDYYHHMMFF).
100
 INTERVIEW_FK varchar Key (foreign) links the related of catch records (in A_BBS_CAT table) to its interview trip header data (table A_BBS_INT).
100
 SPECIES_FK int Species code. Detailed information can be found in A_SPECIES.
100
 FISH_CONDITION_FK varchar Fish condition code when interview took place. (i.e., whole, gilled-gutted, etc.) Code description is found in the A_FISH_CONDITION.
100
 NUM_KEPT int Number of fish kept (pieces).
100
 NUM_KEPT_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 CAT_LBS decimal Actual fish weight during sampling. When weight was not able to obtain during the interview, the value for this field is zero.
100
 CAT_LBS_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 EST_LBS decimal Estimated fish weight calculated by one of the following cases. 1. It is CAT_LBS, if CAT_LBS >0; 2. Calculated whole fish weight (CAT_LBS and FISH_CONDITION_FK fields both have values); 3. Calculated from measured fish length (length-weight regression based estimation), when CAT_LBS =0 and LEN_MM=1; or 4. NUM_PIECES *AVG_WT when CAT_LBS =0 and NUM_PIECES = >1. AVG_WT is the average fish weight calculated from the measured fish; when there is no measured data (LEN_MM), default mean weight is used (a_species).
100
 EST_LBS_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 DISPOSITION_FK int Fish disposition code. Detailed information can be found in A_DISPOSITION.
100
 BYCATCH_TYPE char Type of bycatch (N-none, A-alive, U-unknown, I-injured or D-dead).
100
 PRICE_LB decimal Estimated price per pound of fish will be selling, provided by fisher.
100
 PRICE_LB_TYPE_FK varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 CAT_REMARKS varchar Comment field (interview catch record).
100
 CAT_CREATE_TIME datetime Date and time the record was created (interview catch record).
100
 CAT_MODIFY_TIME datetime Date and time or date the record was last modified (interview catch record).
100
 CAT_LOAD_TABLE varchar Name of the FoxPro table that was loaded into MySQL (interview catch record).
100
 CAT_LOAD_DATETIME datetime The date and time the data was loaded into MySQL table (interview catch record).
100
 CAT_LOAD_USER varchar User who loaded the data to the MySQL table (interview catch record).
100
 SIZE_PK int Primary key, a unique identifier for each record of the interview’s size data. Value is auto-generated
100
 CATCH_FK varchar Key (foreign) links the related size measurement records (in this table) to its catch record (A_BBS_CAT).
100
 LEN_MM decimal Fork-length of fish in centimeters. Column name should be LEN_CM.
100
 LEN_MM_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 SIZ_LBS decimal Calculated fish weight.
100
 SIZ_LBS_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.
100
 SIZ_REMARKS varchar Comment field for collected individual fish (interview size record).
100
 SIZ_CREATE_TIME datetime Date and time the record was created (interview size record).
100
 SIZ_MODIFY_TIME datetime Date and time or date the record was last modified (interview size record).
100
 SIZ_LOAD_TABLE varchar Name of the FoxPro table that was loaded into MySQL (interview size record).
100
 SIZ_LOAD_DATETIME datetime The date and time the data was loaded in to the table (interview size record).
100
 SIZ_LOAD_USER varchar User who loaded the data to the MySQL table (interview size record).
100
 FISHING_METHOD varchar Fishing method code.
100
 FISHING_AREA varchar Code of fishing area.
100
 VESSEL_REGIST_NO varchar Vessel's registaton number..
100
 PORT_NAME varchar Description for PORT_FK code.
100
 ISLAND_NAME varchar Description for ISLAND_FK code.
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
 FISH_CONDITION varchar Description for FISH_CONDITION_FK code.
100
 DISPOSITION varchar Description for DISPOSITION_FK code.
100
 PRICE_LB_TYPE varchar Place holder to store the source of PRICE_LB value. Currently NULL value.

Attribute Details

INTERVIEW_PK

CC ID: 1012872
Seq. Order: 1
Data Storage Type: varchar
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Primary key or UID for each interview header data record.

SAMPLE_DATE

CC ID: 1012873
Seq. Order: 2
Data Storage Type: date
Required: No
Primary Key: No
Status: Active
Description:

Date of the survey.

TYPE_OF_DAY

CC ID: 1012874
Seq. Order: 3
Data Storage Type: varchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Type of day (WD – weekday, WE weekend/holiday).

INTERVIEW_TIME

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

Date and time of the Interview.

INTERVIEWER1_FK

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

Interviewer 1 code.

INTERVIEWER2_FK

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

Interviewer 2 code.

INTERVIEW_ORDER

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

Place holder for future usage. Current value is NULL.

BLDT_FK

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

Place holder for future usage. Current value is NULL.

AREA_FK

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

Fishing Area code

METHOD_FK

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

Fishing method used. Detailed information can be found in A_METHOD. Fishing method to which the data in this record applies.

DEPTH

CC ID: 1012882
Seq. Order: 11
Data Storage Type: varchar
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The approximate depth range in fathoms of hook dropped.

TRIP_BEG_DATE

CC ID: 1012883
Seq. Order: 12
Data Storage Type: date
Required: No
Primary Key: No
Status: Active
Description:

Fishing trip start date.

TRIP_BEG_TIME

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

Fishing trip start time.

HOURS_FISHED

CC ID: 1012885
Seq. Order: 14
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Number of hours spent fishing.

NUM_FISHER

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

Number of fishermen fishing.

NUM_GUEST

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

Number of guests on trip that are not fishing.

NUM_SETS

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

For longline fishing method only. Number of sets covered by the interview. The value is usually 1, but it can be 2 or 3 for longline boats that set their gear two or three times during a trip.

HOURS_PER_SET

CC ID: 1012889
Seq. Order: 18
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Longline: hours of line in water. Other method: hours of fishing time.

HOOKS_PER_SET

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

For longline method: Number of hooks per line. For others: number of gears used.

NUM_DAYS_FISHED

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

Number of days fished.

NUM_GEAR

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

For longline method: Number of hooks used. For others: number of gears used.

VESSEL_FK

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

Vessel code.

VESSEL_HISTORY_FK

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

Vessel’s history code (e.g. ownership, permit type or type of used). Detailed information can be found in A_VESSEL_HISTORY or A_MASTVSSL.DBF.

PORT_FK

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

Port code interview is conducted. Detailed information can be found in A_PORT or A_PORT.DBF

TOT_EST_LBS

CC ID: 1012896
Seq. Order: 25
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 2
Status: Active
Description:

Estimated total pounds of catch for the trip.

BYCATCH_F

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

If true, there was bycatch on this trip.

CHARTER_F

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

If true, it is a charter trip.

BERTHED_F

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

If true, the vessel is berthed at a specific designated place.

NON_SCHED_F

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

If true, this interview was from a nonscheduled survey day (opportunist interview).

LUNAR_DAY

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

Place holder for future usage to store the Lunar day of the month. Current value is NULL.

ISLAND_FK

CC ID: 1012902
Seq. Order: 31
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Island where the interview was conducted. (TTL:Tutuila and MNA:Manu`a).

REFUSED_F

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

If true, the fisherman refused to be interviewed.

INCOMPLETE_F

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

If true, all catch from this trip were not fully captured in this interview.

INT_REMARKS

CC ID: 1012905
Seq. Order: 34
Data Storage Type: varchar
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Comments related to the trip (interview header record).

INT_CREATE_TIME

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

Date and time the record was created (interview header records).

INT_MODIFY_TIME

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

Date and time the record was last modified (interview header record).

INT_LOAD_TABLE

CC ID: 1012908
Seq. Order: 37
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Name of the FoxPro table (contain this data) that was loaded into MySQL (interview header record).

INT_LOAD_DATETIME

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

The date and time the data was loaded in to the table (interview header record).

INT_LOAD_USER

CC ID: 1012910
Seq. Order: 39
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

User who loaded the data to the MySQL table (interview header record).

CATCH_PK

CC ID: 1012911
Seq. Order: 40
Data Storage Type: varchar
Max Length: 24
Required: No
Primary Key: No
Status: Active
Description:

Primary key, a unique identifier for each catch record. The value is the sample date, interview time, and fishing method (MMDDYYHHMMFF).

INTERVIEW_FK

CC ID: 1012912
Seq. Order: 41
Data Storage Type: varchar
Max Length: 16
Required: No
Primary Key: No
Status: Active
Description:

Key (foreign) links the related of catch records (in A_BBS_CAT table) to its interview trip header data (table A_BBS_INT).

SPECIES_FK

CC ID: 1012913
Seq. Order: 42
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.

FISH_CONDITION_FK

CC ID: 1012914
Seq. Order: 43
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Fish condition code when interview took place. (i.e., whole, gilled-gutted, etc.) Code description is found in the A_FISH_CONDITION.

NUM_KEPT

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

Number of fish kept (pieces).

NUM_KEPT_TYPE

CC ID: 1012916
Seq. Order: 45
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

CAT_LBS

CC ID: 1012917
Seq. Order: 46
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 3
Status: Active
Description:

Actual fish weight during sampling. When weight was not able to obtain during the interview, the value for this field is zero.

CAT_LBS_TYPE

CC ID: 1012918
Seq. Order: 47
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

EST_LBS

CC ID: 1012919
Seq. Order: 48
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 3
Status: Active
Description:

Estimated fish weight calculated by one of the following cases. 1. It is CAT_LBS, if CAT_LBS >0; 2. Calculated whole fish weight (CAT_LBS and FISH_CONDITION_FK fields both have values); 3. Calculated from measured fish length (length-weight regression based estimation), when CAT_LBS =0 and LEN_MM=1; or 4. NUM_PIECES *AVG_WT when CAT_LBS =0 and NUM_PIECES = >1. AVG_WT is the average fish weight calculated from the measured fish; when there is no measured data (LEN_MM), default mean weight is used (a_species).

EST_LBS_TYPE

CC ID: 1012920
Seq. Order: 49
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

DISPOSITION_FK

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

Fish disposition code. Detailed information can be found in A_DISPOSITION.

BYCATCH_TYPE

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

Type of bycatch (N-none, A-alive, U-unknown, I-injured or D-dead).

PRICE_LB

CC ID: 1012923
Seq. Order: 52
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 6
Scale: 2
Status: Active
Description:

Estimated price per pound of fish will be selling, provided by fisher.

PRICE_LB_TYPE_FK

CC ID: 1012924
Seq. Order: 53
Data Storage Type: varchar
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

CAT_REMARKS

CC ID: 1012925
Seq. Order: 54
Data Storage Type: varchar
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Comment field (interview catch record).

CAT_CREATE_TIME

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

Date and time the record was created (interview catch record).

CAT_MODIFY_TIME

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

Date and time or date the record was last modified (interview catch record).

CAT_LOAD_TABLE

CC ID: 1012928
Seq. Order: 57
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

Name of the FoxPro table that was loaded into MySQL (interview catch record).

CAT_LOAD_DATETIME

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

The date and time the data was loaded into MySQL table (interview catch record).

CAT_LOAD_USER

CC ID: 1012930
Seq. Order: 59
Data Storage Type: varchar
Max Length: 32
Required: No
Primary Key: No
Status: Active
Description:

User who loaded the data to the MySQL table (interview catch record).

SIZE_PK

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

Primary key, a unique identifier for each record of the interview’s size data. Value is auto-generated

CATCH_FK

CC ID: 1012932
Seq. Order: 61
Data Storage Type: varchar
Max Length: 24
Required: No
Primary Key: No
Status: Active
Description:

Key (foreign) links the related size measurement records (in this table) to its catch record (A_BBS_CAT).

LEN_MM

CC ID: 1012933
Seq. Order: 62
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Fork-length of fish in centimeters. Column name should be LEN_CM.

LEN_MM_TYPE

CC ID: 1012934
Seq. Order: 63
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

SIZ_LBS

CC ID: 1012935
Seq. Order: 64
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 2
Status: Active
Description:

Calculated fish weight.

SIZ_LBS_TYPE

CC ID: 1012936
Seq. Order: 65
Data Storage Type: varchar
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

SIZ_REMARKS

CC ID: 1012937
Seq. Order: 66
Data Storage Type: varchar
Max Length: 256
Required: No
Primary Key: No
Status: Active
Description:

Comment field for collected individual fish (interview size record).

SIZ_CREATE_TIME

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

Date and time the record was created (interview size record).

SIZ_MODIFY_TIME

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

Date and time or date the record was last modified (interview size record).

SIZ_LOAD_TABLE

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

Name of the FoxPro table that was loaded into MySQL (interview size record).

SIZ_LOAD_DATETIME

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

The date and time the data was loaded in to the table (interview size record).

SIZ_LOAD_USER

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

User who loaded the data to the MySQL table (interview size record).

FISHING_METHOD

CC ID: 1012943
Seq. Order: 72
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Fishing method code.

FISHING_AREA

CC ID: 1012944
Seq. Order: 73
Data Storage Type: varchar
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

Code of fishing area.

VESSEL_REGIST_NO

CC ID: 1012945
Seq. Order: 74
Data Storage Type: varchar
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

Vessel's registaton number..

PORT_NAME

CC ID: 1012946
Seq. Order: 75
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Description for PORT_FK code.

ISLAND_NAME

CC ID: 1012947
Seq. Order: 76
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Description for ISLAND_FK code.

SCIENTIFIC_NAME

CC ID: 1012948
Seq. Order: 77
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: 1012949
Seq. Order: 78
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: 1012950
Seq. Order: 79
Data Storage Type: varchar
Max Length: 46
Required: No
Primary Key: No
Status: Active
Description:

Local name of the species.

FISH_CONDITION

CC ID: 1012951
Seq. Order: 80
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Description for FISH_CONDITION_FK code.

DISPOSITION

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

Description for DISPOSITION_FK code.

PRICE_LB_TYPE

CC ID: 1012953
Seq. Order: 82
Data Storage Type: varchar
Max Length: 45
Required: No
Primary Key: No
Status: Active
Description:

Place holder to store the source of PRICE_LB value. Currently NULL value.

Catalog Details

Catalog Item ID: 60075
GUID: gov.noaa.nmfs.inport:60075
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-06-18 15:53+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