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
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2020-06-18 15:53+0000
Metadata Record Last Modified By: Brent M Miyamoto
Metadata Record Last Modified: 2021-01-21 19:58+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