g_sbs_interview_flat_view
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:63472 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | g_sbs_interview_flat_view |
---|---|
Status: | Completed |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | guam_dawr_wh |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
INTERVIEW_PK | varchar | UID assigned to this record | |
100
|
SAMPLE_DATE | date | Date of the survey. | |
100
|
TYPE_OF_DAY | varchar | Type of day when the interview was conducted (1 = weekday, 2 = weekend/holiday). | |
100
|
NUM_FISHER | int | Number of fishermen fishing. | |
100
|
INTERVIEW_ORDER | int | Squential number assigned to each line on the interview form. | |
100
|
INTERVIEWER_FK | varchar | Code for the interviewer. | |
100
|
INTERVIEW_TIME | int | Time the interview. | |
100
|
START_TIME | int | Fishing start time. | |
100
|
END_TIME | int | Fishing stop time. | |
100
|
DAY_BEFORE | int | If fisher started the fishing on the day before today. | |
100
|
DAY_AFTER | int | If fisher plan to stop fishing on the day after today. | |
100
|
BREAK_HOURS | decimal | Break time taken during fishing trip, measured in hours. | |
100
|
ACTUAL_HOURS | decimal | Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME. | |
100
|
EST_HOURS | decimal | Estimated of trip time. Calculated field: STOP_TIME - START_TIME. | |
100
|
METHOD_FK | int | Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF. | |
100
|
AREA_FK | int | Area fished code | |
100
|
NUM_GEAR | int | Number of gears used. | |
100
|
REEF_ZONE | int | Code of the reef zone | |
100
|
PERCENT_SOLD | decimal | Percentage of catch sold. | |
100
|
PERCENT_UNSOLD | decimal | Percentage of catch not sold. | |
100
|
BUYER_FK | int | Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF. | |
100
|
TOT_NUM_KEPT | int | Total pieces of species caught. | |
100
|
TOT_EST_KGS | decimal | Total fish weight of this interview | |
100
|
TOT_SPECIES | int | Total number of species caught. | |
100
|
TOT_NUM_TYPE | int | How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
TOT_EST_KGS_TYPE | int | How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
TOT_SPECIES_TYPE | int | How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
BAIT_FK | int | bait code | |
100
|
WEATHER_FK | int | Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. | |
100
|
CLOUD_FK | int | Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF. | |
100
|
SURF | int | Surf high in feet. | |
100
|
TIDE | varchar | Tide level | |
100
|
NON_SCHED_F | char | If true, the interview was not scheduled (opportunistic). | |
100
|
INCOMPLETE_F | char | This interview was not able to record all the catch of the trip. | |
100
|
BYCATCH_F | varchar | If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.) | |
100
|
LUNAR_DAY | int | Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date | |
100
|
INT_REMARKS | varchar | Remarks | |
100
|
INT_CREATE_TIME | datetime | When this record was created | |
100
|
INT_MODIFY_TIME | datetime | When was the last date this record was editted | |
100
|
INT_CREATE_USER | varchar | Staff code who enter this data | |
100
|
INT_MODIFY_USER | varchar | Staff code who last editted this record | |
100
|
INT_LOAD_TABLE | varchar | Which VFP table where this data was loaded from | |
100
|
INT_LOAD_DATETIME | datetime | When this record was loade into MySQL VFP | |
100
|
INT_LOAD_USER | varchar | User load the data into MySQL | |
100
|
CATCH_PK | varchar | Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated. | |
100
|
INTERVIEW_FK | varchar | Key value that link this record to the related record found in the g_sbs_int | |
100
|
SPECIES_FK | int | Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF | |
100
|
NUM_KEPT_TYPE | int | How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
NUM_KEPT | int | Number of pieces of fish caught. | |
100
|
EST_KGS_TYPE | int | How weight was collected, 1=actual, 2=calculated and 3=estimated) | |
100
|
EST_KGS | decimal | total catch weight of this species. | |
100
|
SIZE_GROUP | int | fish size goup. | |
100
|
BYCATCH_TYPE | varchar | Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other). | |
100
|
CAT_CREATE_TIME | datetime | When this record was created | |
100
|
CAT_MODIFY_TIME | datetime | When was the last date this record was editted | |
100
|
CAT_LOAD_TABLE | varchar | Which VFP table where this data was loaded from | |
100
|
CAT_LOAD_DATETIME | datetime | When this record was loade into MySQL VFP | |
100
|
CAT_LOAD_USER | varchar | User load the data into MySQL | |
100
|
SIZE_PK | int | UID created for this record | |
100
|
CATCH_FK | varchar | Link key to link this record to it parent record in c_bbs_catch | |
100
|
LEN_MM_TYPE | int | How length was measured (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
LEN_MM | int | Fork length of fish, from snout tip to tail fork, in millimeters. | |
100
|
KGS_TYPE | int | How weight was collected (1 = actual, 2 = calculated, 3 = estimated). | |
100
|
KGS | decimal | Fish weight in kilograms. | |
100
|
SIZ_CREATE_TIME | datetime | This record created date | |
100
|
SIZ_MODIFY_TIME | datetime | When was last update to this record | |
100
|
SIZ_LOAD_TABLE | varchar | Which table where data was loaded from VFP database | |
100
|
SIZ_LOAD_DATETIME | datetime | this record loaded date-time form VFP table | |
100
|
SIZ_LOAD_USER | varchar | User migrated this data from FVP | |
100
|
FISHING_METHOD | varchar | fishing method code | |
100
|
FISHING_AREA | varchar | fishing area code | |
100
|
BUYER_NAME | varchar | Buyer name | |
100
|
BAIT_NAME | varchar | type of bait description | |
100
|
WEATHER | varchar | Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. | |
100
|
SCIENTIFIC_NAME | varchar | Scientific name of the species (Genus name + Species name). | |
100
|
COMMON_NAME | varchar | Common English name for the species. |
Attribute Details
INTERVIEW_PK
Seq. Order: | 1 |
---|---|
Data Storage Type: | varchar |
Max Length: | 14 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
UID assigned to this 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 when the interview was conducted (1 = weekday, 2 = weekend/holiday). |
NUM_FISHER
Seq. Order: | 4 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Number of fishermen fishing. |
INTERVIEW_ORDER
Seq. Order: | 5 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Squential number assigned to each line on the interview form. |
INTERVIEWER_FK
Seq. Order: | 6 |
---|---|
Data Storage Type: | varchar |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the interviewer. |
INTERVIEW_TIME
Seq. Order: | 7 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Time the interview. |
START_TIME
Seq. Order: | 8 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Fishing start time. |
END_TIME
Seq. Order: | 9 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Fishing stop time. |
DAY_BEFORE
Seq. Order: | 10 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
If fisher started the fishing on the day before today. |
DAY_AFTER
Seq. Order: | 11 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
If fisher plan to stop fishing on the day after today. |
BREAK_HOURS
Seq. Order: | 12 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Break time taken during fishing trip, measured in hours. |
ACTUAL_HOURS
Seq. Order: | 13 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME. |
EST_HOURS
Seq. Order: | 14 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 2 |
Status: | Active |
Description: |
Estimated of trip time. Calculated field: STOP_TIME - START_TIME. |
METHOD_FK
Seq. Order: | 15 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code for the fishing method used. Detailed information about method codes can be found in G_SBS_METHOD or G_METHOD.DBF. |
AREA_FK
Seq. Order: | 16 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Area fished code |
NUM_GEAR
Seq. Order: | 17 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Number of gears used. |
REEF_ZONE
Seq. Order: | 18 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code of the reef zone |
PERCENT_SOLD
Seq. Order: | 19 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 1 |
Status: | Active |
Description: |
Percentage of catch sold. |
PERCENT_UNSOLD
Seq. Order: | 20 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 1 |
Status: | Active |
Description: |
Percentage of catch not sold. |
BUYER_FK
Seq. Order: | 21 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF. |
TOT_NUM_KEPT
Seq. Order: | 22 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Total pieces of species caught. |
TOT_EST_KGS
Seq. Order: | 23 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 13 |
Scale: | 4 |
Status: | Active |
Description: |
Total fish weight of this interview |
TOT_SPECIES
Seq. Order: | 24 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of species caught. |
TOT_NUM_TYPE
Seq. Order: | 25 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). |
TOT_EST_KGS_TYPE
Seq. Order: | 26 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated). |
TOT_SPECIES_TYPE
Seq. Order: | 27 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated). |
BAIT_FK
Seq. Order: | 28 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
bait code |
WEATHER_FK
Seq. Order: | 29 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. |
CLOUD_FK
Seq. Order: | 30 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF. |
SURF
Seq. Order: | 31 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Surf high in feet. |
TIDE
Seq. Order: | 32 |
---|---|
Data Storage Type: | varchar |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tide level |
NON_SCHED_F
Seq. Order: | 33 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If true, the interview was not scheduled (opportunistic). |
INCOMPLETE_F
Seq. Order: | 34 |
---|---|
Data Storage Type: | char |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This interview was not able to record all the catch of the trip. |
BYCATCH_F
Seq. Order: | 35 |
---|---|
Data Storage Type: | varchar |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
If true (T), indicates there was bycatch. For VFP, values can be (Y = bycatch, N = no bycatch, U = not known if there was bycatch.) |
LUNAR_DAY
Seq. Order: | 36 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date |
INT_REMARKS
Seq. Order: | 37 |
---|---|
Data Storage Type: | varchar |
Max Length: | 255 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Remarks |
INT_CREATE_TIME
Seq. Order: | 38 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was created |
INT_MODIFY_TIME
Seq. Order: | 39 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When was the last date this record was editted |
INT_CREATE_USER
Seq. Order: | 40 |
---|---|
Data Storage Type: | varchar |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Staff code who enter this data |
INT_MODIFY_USER
Seq. Order: | 41 |
---|---|
Data Storage Type: | varchar |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Staff code who last editted this record |
INT_LOAD_TABLE
Seq. Order: | 42 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Which VFP table where this data was loaded from |
INT_LOAD_DATETIME
Seq. Order: | 43 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was loade into MySQL VFP |
INT_LOAD_USER
Seq. Order: | 44 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User load the data into MySQL |
CATCH_PK
Seq. Order: | 45 |
---|---|
Data Storage Type: | varchar |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated. |
INTERVIEW_FK
Seq. Order: | 46 |
---|---|
Data Storage Type: | varchar |
Max Length: | 14 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Key value that link this record to the related record found in the g_sbs_int |
SPECIES_FK
Seq. Order: | 47 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF |
NUM_KEPT_TYPE
Seq. Order: | 48 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated). |
NUM_KEPT
Seq. Order: | 49 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Number of pieces of fish caught. |
EST_KGS_TYPE
Seq. Order: | 50 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How weight was collected, 1=actual, 2=calculated and 3=estimated) |
EST_KGS
Seq. Order: | 51 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 4 |
Status: | Active |
Description: |
total catch weight of this species. |
SIZE_GROUP
Seq. Order: | 52 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
fish size goup. |
BYCATCH_TYPE
Seq. Order: | 53 |
---|---|
Data Storage Type: | varchar |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other). |
CAT_CREATE_TIME
Seq. Order: | 54 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was created |
CAT_MODIFY_TIME
Seq. Order: | 55 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When was the last date this record was editted |
CAT_LOAD_TABLE
Seq. Order: | 56 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Which VFP table where this data was loaded from |
CAT_LOAD_DATETIME
Seq. Order: | 57 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When this record was loade into MySQL VFP |
CAT_LOAD_USER
Seq. Order: | 58 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User load the data into MySQL |
SIZE_PK
Seq. Order: | 59 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
UID created for this record |
CATCH_FK
Seq. Order: | 60 |
---|---|
Data Storage Type: | varchar |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Link key to link this record to it parent record in c_bbs_catch |
LEN_MM_TYPE
Seq. Order: | 61 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How length was measured (1 = actual, 2 = calculated, 3 = estimated). |
LEN_MM
Seq. Order: | 62 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
Fork length of fish, from snout tip to tail fork, in millimeters. |
KGS_TYPE
Seq. Order: | 63 |
---|---|
Data Storage Type: | int |
Required: | No |
Primary Key: | No |
Precision: | 10 |
Scale: | 0 |
Status: | Active |
Description: |
How weight was collected (1 = actual, 2 = calculated, 3 = estimated). |
KGS
Seq. Order: | 64 |
---|---|
Data Storage Type: | decimal |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 4 |
Status: | Active |
Description: |
Fish weight in kilograms. |
SIZ_CREATE_TIME
Seq. Order: | 65 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
This record created date |
SIZ_MODIFY_TIME
Seq. Order: | 66 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
When was last update to this record |
SIZ_LOAD_TABLE
Seq. Order: | 67 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Which table where data was loaded from VFP database |
SIZ_LOAD_DATETIME
Seq. Order: | 68 |
---|---|
Data Storage Type: | datetime |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
this record loaded date-time form VFP table |
SIZ_LOAD_USER
Seq. Order: | 69 |
---|---|
Data Storage Type: | varchar |
Max Length: | 32 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
User migrated this data from FVP |
FISHING_METHOD
Seq. Order: | 70 |
---|---|
Data Storage Type: | varchar |
Max Length: | 25 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
fishing method code |
FISHING_AREA
Seq. Order: | 71 |
---|---|
Data Storage Type: | varchar |
Max Length: | 35 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
fishing area code |
BUYER_NAME
Seq. Order: | 72 |
---|---|
Data Storage Type: | varchar |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Buyer name |
BAIT_NAME
Seq. Order: | 73 |
---|---|
Data Storage Type: | varchar |
Max Length: | 16 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
type of bait description |
WEATHER
Seq. Order: | 74 |
---|---|
Data Storage Type: | varchar |
Max Length: | 20 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF. |
SCIENTIFIC_NAME
Seq. Order: | 75 |
---|---|
Data Storage Type: | varchar |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Scientific name of the species (Genus name + Species name). |
COMMON_NAME
Seq. Order: | 76 |
---|---|
Data Storage Type: | varchar |
Max Length: | 45 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Common English name for the species. |
Catalog Details
Catalog Item ID: | 63472 |
---|---|
GUID: | gov.noaa.nmfs.inport:63472 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-01-21 01:10+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 |