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
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
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
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
Seq. Order: | 2 |
---|---|
Data Storage Type: | date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of the survey. |
TYPE_OF_DAY
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
Seq. Order: | 4 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time of the Interview. |
INTERVIEWER1_FK
Seq. Order: | 5 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Interviewer 1 code. |
INTERVIEWER2_FK
Seq. Order: | 6 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Interviewer 2 code. |
INTERVIEW_ORDER
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
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
Seq. Order: | 9 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Fishing Area code |
METHOD_FK
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
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
Seq. Order: | 12 |
---|---|
Data Storage Type: | date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fishing trip start date. |
TRIP_BEG_TIME
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
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
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
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
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
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
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
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
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
Seq. Order: | 22 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Vessel code. |
VESSEL_HISTORY_FK
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 72 |
---|---|
Data Storage Type: | varchar |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fishing method code. |
FISHING_AREA
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
Seq. Order: | 74 |
---|---|
Data Storage Type: | varchar |
Max Length: | 11 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Vessel's registaton number.. |
PORT_NAME
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
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
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
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
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
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
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
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 |