a_sbs_interview_flat_view
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:63227 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
INTERVIEW_PK
varchar |
Primary key, a unique identifier for each record in this table. Value is YYYYMMDDNNNN where NNNN is a sequential number assigned to interviews as they are created, starting with 0001 each year. Associates the detailed records in AIFyyCAT.DBF with their header record in AIFyyINT.DBF. The value is a unique integer assigned to interviews in increasing numeric order as they are created. |
ROUTE_FK
int |
Code for the route. Detailed information can be found in A_ROUTE and AIFROUTE.DBF. |
SAMPLE_DATE
date |
Date of the survey. |
INTERVIEW_TIME
datetime |
Date and time the interview started. |
TYPE_OF_DAY
varchar |
Type of day when the interview was conducted, e.g., = weekday o= weekend/holiday (WD = weekday or WE = weekend/holiday or 1 = weekday or 2 = weekend/holiday.) Calculated from A_HOLIDAY or AIFHOLDAY.DBF. |
GRAMS_F
char |
Indicates whether the weight of the fish caught is in grams or pounds. If true (T), the value in the ACT_WT field (in A_SBS_CAT or AIFyyCAT.DBF) was recorded in grams and then converted to pounds before being entered in the EST_WHOLE_LBS field or CALC_LBS field. If false (F), the value is in pounds and is copied directly into the EST_WHOLE_LBS or the CALC_LBS field. |
NON_SCHED_F
char |
If true, the interview was non-scheduled (opportunistic), i.e., not held during the scheduled ranges of times and date for the route. |
INTERVIEWER1_FK
int |
Code for the first interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF. |
INTERVIEWER2_FK
int |
Code for the second interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF. |
INTERVIEWER3_FK
int |
Code for the third interviewer. Detailed information can be found in A_INTERVIEWER or A_INT.DBF. |
HOURS_FISHED
decimal |
Number of hours spent fishing before the interview was started. |
AREA_FK
int |
Area code. Detailed information can be found in A_AREA and A_AREA.DBF. |
HOME_F
char |
Indicates whether the area in A_AREA or VILLAGE is the fisher’s home village. If true, the area or village is the fisher’s home. |
METHOD_FK
int |
Code for the fishing method. Detailed information can be found in A_METHOD or A_METHOD.DBF. |
NUM_GEAR
int |
Number of gears used. |
NUM_PEOPLE
int |
Number of people in the group being interviewed whether they are fishing or not. |
NUM_CHILD_M
int |
Number of male children younger than 14 years old present in the group being interviewed whether they are fishing or not. |
NUM_CHILD_F
int |
Number of female children younger than 14 years old present in the group being interviewed whether they are fishing or not. |
NUM_ADULT_F
int |
Number of female adults older than 14 years present in the group being interviewed whether they are fishing or not. |
NUM_ADULT_M
int |
Number of male adults older than 14 years present in the group being interviewed whether they are fishing or not. |
TOT_EST_WHOLE_LBS
decimal |
Calculated, estimated total pounds for the trip; the sum of EST_WHOLE_LBS in A_SBS_CAT for the trip. |
PORCENT_SOLD
int |
Percentage of the interview catch sold commercially. |
COMPLETED_INT_F
char |
If true, all fish the fisher caught were weighed, measured, and included in the interview. If false, only some of the fish that the fisher caught were weighted, measured, and included in the interview. Incomplete interviews are not used in the shore-based creel survey expansion but can be used for size-frequency calculations and determining a/b factors for use in length-to-weight conversion. |
START_TIME
datetime |
Date and time or time the fishing activity started. |
STOP_TIME
datetime |
time when fishing stopped. |
INT_REMARKS
varchar |
Remarks. |
INT_CREATE_TIME
datetime |
date of interview record created |
INT_MODIFY_TIME
datetime |
When this record was last modified. |
INT_LOAD_TABLE
varchar |
Foxpro files where this record was loaded from. |
INT_LOAD_DATETIME
datetime |
Date when data was loaded |
INT_LOAD_USER
varchar |
User who loaded the a_sbs_int data table from Focpro data |
CATCH_PK
int |
Primary key value found in the a_sbs_cat data table |
INTERVIEW_FK
varchar |
Unique identifier for A_SBS_CAT. The value is YYYYMMDDNNN where NNN is a number that groups detailed records to associate them with the header record in A_SBS_INT. A unique identifier for each record in AIFyyINT.DBF . |
SPECIES_FK
int |
species code , detailed information can be found in A_SPECIES. |
DISPOSITION_FK
int |
Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table. |
LEN_CM
decimal |
Length in centimeters of a single fish if measured. |
ACT_WT
decimal |
Actual measured weight. |
NUM_PIECES
int |
Number of pieces of fish caught. |
EST_WHOLE_LBS_TYPE
varchar |
Describes how EST_WHOLE_LBS_TYPE or CALC_LBS was calculated. Values can be W, L, I, or S. W = Calculated from the ACT_WT field. L = Calculated from the LEN_CM field. If no weight data is available, but the fish length has been measured, the weight is calculated using a length-weight regression factor. I = If there is no weight or length data in this record, the whole weight is obtained by multiplying NUM_PIECES by the average of EST_WHOLE_LBS for this species with weight data in this interview. S = If there is no length or weight data for this species in any records in this interview, EST_WHOLE_LBS is obtained by multiplying NUM_PIECES by the average pounds for the species in the species table (A_SPECIES). This rarely happens. |
EST_WHOLE_LBS
decimal |
Whole weight of fish measured in pounds for an interview. If ACT_WT value is in grams, it is converted to pounds by multiplying the ACT_WT value by 2.203. If the ACT_WT value is in pounds it is copied from the ACT_WT field. For other conditions, see EST_WHOLE_LBS_TYPE for how this field is calculated. |
CAT_REMARKS
varchar |
Remarks. |
CAT_CREATE_TIME
datetime |
When catch data record was created. |
CAT_MODIFY_TIME
datetime |
When this record was last modified. |
CAT_LOAD_TABLE
varchar |
Foxpro files where this record was loaded from. |
CAT_LOAD_DATETIME
datetime |
When the a_sbs_catch data table was loaded ito MySQL. |
CAT_LOAD_USER
varchar |
User who loaded the a_sbs_catch data table from Focpro data. |
FISHING_METHOD
varchar |
gear used code. See description in A_METHOD table |
FISHING_AREA
varchar |
area fished code. See description in the A_AREA table |
ROUTE_NAME
varchar |
The name of the route. |
SCIENTIFIC_NAME
varchar |
Scientific name of the species (Genus name + Species name). |
COMMON_NAME
varchar |
Common English name for the species. |
LOCAL_NAME
varchar |
Local name of the species. |
DISPOSITION
varchar |
Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (PIFSC) for inquiries on this record.
Item Identification
Title: | a_sbs_interview_flat_view |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | amsam_dmwr_wh |
Data Attributes
Attribute Summary
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
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
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
Seq. Order: | 3 |
---|---|
Data Storage Type: | date |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of the survey. |
INTERVIEW_TIME
Seq. Order: | 4 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date and time the interview started. |
TYPE_OF_DAY
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Seq. Order: | 25 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
time when fishing stopped. |
INT_REMARKS
Seq. Order: | 26 |
---|---|
Data Storage Type: | varchar |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Remarks. |
INT_CREATE_TIME
Seq. Order: | 27 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
date of interview record created |
INT_MODIFY_TIME
Seq. Order: | 28 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was last modified. |
INT_LOAD_TABLE
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
Seq. Order: | 30 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when data was loaded |
INT_LOAD_USER
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
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
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
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
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
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
Seq. Order: | 37 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 3 |
Status: | Active |
Description: |
Actual measured weight. |
NUM_PIECES
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
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
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
Seq. Order: | 41 |
---|---|
Data Storage Type: | varchar |
Max Length: | 256 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Remarks. |
CAT_CREATE_TIME
Seq. Order: | 42 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When catch data record was created. |
CAT_MODIFY_TIME
Seq. Order: | 43 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was last modified. |
CAT_LOAD_TABLE
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
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
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
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
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
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
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
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
Seq. Order: | 52 |
---|---|
Data Storage Type: | varchar |
Max Length: | 46 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local name of the species. |
DISPOSITION
Seq. Order: | 53 |
---|---|
Data Storage Type: | varchar |
Max Length: | 30 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code identify where fish will be sold. See code descriptions in the A_DISPOSITION table. |
Catalog Details
Catalog Item ID: | 63227 |
---|---|
GUID: | gov.noaa.nmfs.inport:63227 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2020-11-17 23:42+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-01-21 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-01-21 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-01-21 |