Slide Menu
Jump to Section...
Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring Program > Western Pacific Fisheries Information Network (... > Guam Boat-based Creel Survey >

g_bbs_interview_flat_view

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63468  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: g_bbs_interview_flat_view
Status: Completed

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: guam_dawr_wh

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 INTERVIEW_PK varchar Primary key, a unique identifier for each record in this table.
100
 SAMPLE_DATE date Date of the survey.
100
 TYPE_OF_DAY varchar Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).
100
 INTERVIEW_TIME int Time the interview was conducted.
100
 INTERVIEWER1_FK int Interviewer1 code.
100
 INTERVIEWER2_FK int Interviewer2 code.
100
 INTERVIEW_ORDER int Order of the survey was taken.
100
 BOATLOG_DT_FK int Filler, not in used.
100
 AREA_FK int Code for the area fished. Detailed information can be found in G_BBS_AREA.
100
 METHOD_FK int Fishing method code.
100
 DEPTH varchar If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed).
100
 WEATHER_FK int Weather conditions. Detailed information can be found in G_WEATHER.
100
 CLOUD_FK int Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF.
100
 WIND_DIRECTION varchar Wind direction (e.g. E=east, NE=northeast).
100
 WIND_SPEED int Wind speed in knots.
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 vessel.
100
 NUM_DAYS_FISHED int Number of days fished.
100
 NUM_GEAR int Number of gears used.
100
 VESSEL_NAME varchar Name of the fishing vessel.
100
 PORT_FK int Port code.
100
 CAR_LICENSE varchar Vehicle/trailer license number.
100
 TOT_NUM_KEPT_TYPE int How NUM_KEPT was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_NUM_KEPT int Total pieces of fish caught.
100
 TOT_EST_KGS_TYPE int How TOT_EST_KGS was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_EST_KGS decimal Total fish caught in kgs for this trip.
100
 TOT_SPECIES_TYPE int How TOT_SPECIES was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 TOT_SPECIES int Number of species caught on this trip.
100
 PERCENT_UNSOLD decimal Percent of unsold catch.
100
 PERCENT_SOLD decimal Percent of catch sold (to the hundredths).
100
 BUYER_FK int Filler, not in used.
100
 BYCATCH_F varchar If true, this was a bycatch.
100
 CHARTER_F char If true, it is a charter trip.
100
 BERTHED_F char If true, the vessel is berthed.
100
 SMALLCRAFT_F char If true (T), small craft advisory was in effect.
100
 HIGHSURF_F char If true, high surf warning was in effect.
100
 NON_SCHED_F char If true (T), the interview was non-scheduled (opportunistic).
100
 LUNAR_DAY int Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011.
100
 INCOMPLETE_F char This interview is not complete (all catch from this trip was not captured on this interview).
100
 REMARKS varchar Comment field.
100
 INT_CREATE_TIME datetime Date and time that the record was created or date the record was created.
100
 INT_MODIFY_TIME datetime When was the last date this record was editted
100
 INT_CREATE_USER varchar Name of the user who created the record.
100
 INT_MODIFY_USER varchar Name of the user who last modified the 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, a unique identifier for each record in this table.
100
 INTERVIEW_FK varchar Key that link this record back to its related record found in the c_bbs_int.
100
 SPECIES_FK int Species code.
100
 NUM_KEPT int Number of fish (pieces) kept.
100
 NUM_KEPT_TYPE int Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated).
100
 EST_KGS decimal Total catch of this species.
100
 EST_KGS_TYPE int How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 DISPOSITION int Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion.
100
 PRICE_LB decimal Place holder, not used.
100
 PRICE_LB_TYPE int Place holder, not used.
100
 SIZE_GROUP int fish size goup.
100
 BYCATCH_TYPE varchar Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other).
100
 CAT_REMARKS varchar Comment field.
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 System-generated artificial primary key.
100
 CATCH_FK varchar Key link this record to its related record in C_BBS_CATCH.
100
 LEN_MM int Fork length of fish in mm.
100
 LEN_MM_TYPE int How len was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 KGS decimal Fish weight in kilograms.
100
 KGS_TYPE int How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100
 SEX varchar Place holder, not in used.
100
 SIZ_CREATE_TIME datetime Date the record was created
100
 SIZ_MODIFY_TIME datetime Date the record was last modified
100
 SIZ_LOAD_TABLE varchar varchar(32)
100
 SIZ_LOAD_DATETIME datetime datetime
100
 SIZ_LOAD_USER varchar varchar(32)
100
 FISHING_METHOD varchar Fishing method.
100
 FISHING_AREA varchar Fishing area code.
100
 PORT_NAME varchar Port name.
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

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

Primary key, a unique identifier for each record in this table.

SAMPLE_DATE

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

Date of the survey.

TYPE_OF_DAY

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

Type of day on which the interview was conducted (WD= weekday, WE = weekend/holiday).

INTERVIEW_TIME

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

Time the interview was conducted.

INTERVIEWER1_FK

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

Interviewer1 code.

INTERVIEWER2_FK

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

Interviewer2 code.

INTERVIEW_ORDER

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

Order of the survey was taken.

BOATLOG_DT_FK

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

Filler, not in used.

AREA_FK

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

Code for the area fished. Detailed information can be found in G_BBS_AREA.

METHOD_FK

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

Fishing method code.

DEPTH

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

If bottomfishing, indicates the type of set used (D = deep, S = shallow, M = mixed).

WEATHER_FK

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

Weather conditions. Detailed information can be found in G_WEATHER.

CLOUD_FK

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

Cloud conditions. Detailed information can be found in G_CLOUD or G_CLOUD.DBF.

WIND_DIRECTION

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

Wind direction (e.g. E=east, NE=northeast).

WIND_SPEED

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

Wind speed in knots.

HOURS_FISHED

CC ID: 1008057
Seq. Order: 16
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: 1008058
Seq. Order: 17
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Number of fishermen fishing.

NUM_GUEST

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

Number of guests on vessel.

NUM_DAYS_FISHED

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

Number of days fished.

NUM_GEAR

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

Number of gears used.

VESSEL_NAME

CC ID: 1008062
Seq. Order: 21
Data Storage Type: varchar
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Name of the fishing vessel.

PORT_FK

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

Port code.

CAR_LICENSE

CC ID: 1008064
Seq. Order: 23
Data Storage Type: varchar
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Vehicle/trailer license number.

TOT_NUM_KEPT_TYPE

CC ID: 1008065
Seq. Order: 24
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).

TOT_NUM_KEPT

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

Total pieces of fish caught.

TOT_EST_KGS_TYPE

CC ID: 1008067
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_EST_KGS

CC ID: 1008068
Seq. Order: 27
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 2
Status: Active
Description:

Total fish caught in kgs for this trip.

TOT_SPECIES_TYPE

CC ID: 1008069
Seq. Order: 28
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).

TOT_SPECIES

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

Number of species caught on this trip.

PERCENT_UNSOLD

CC ID: 1008071
Seq. Order: 30
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Percent of unsold catch.

PERCENT_SOLD

CC ID: 1008072
Seq. Order: 31
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 5
Scale: 1
Status: Active
Description:

Percent of catch sold (to the hundredths).

BUYER_FK

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

Filler, not in used.

BYCATCH_F

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

If true, this was a bycatch.

CHARTER_F

CC ID: 1008075
Seq. Order: 34
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: 1008076
Seq. Order: 35
Data Storage Type: char
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

If true, the vessel is berthed.

SMALLCRAFT_F

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

If true (T), small craft advisory was in effect.

HIGHSURF_F

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

If true, high surf warning was in effect.

NON_SCHED_F

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

If true (T), the interview was non-scheduled (opportunistic).

LUNAR_DAY

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

Calculated using G_BBS_LUNAR (15 = full moon, 1 or 29/30 = new moon). This field was not used after 2011.

INCOMPLETE_F

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

This interview is not complete (all catch from this trip was not captured on this interview).

REMARKS

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

Comment field.

INT_CREATE_TIME

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

Date and time that the record was created or date the record was created.

INT_MODIFY_TIME

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

When was the last date this record was editted

INT_CREATE_USER

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

Name of the user who created the record.

INT_MODIFY_USER

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

Name of the user who last modified the record.

INT_LOAD_TABLE

CC ID: 1008087
Seq. Order: 46
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

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

When this record was loade into MySQL VFP

INT_LOAD_USER

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

User load the data into MySQL

CATCH_PK

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

Primary key, a unique identifier for each record in this table.

INTERVIEW_FK

CC ID: 1008091
Seq. Order: 50
Data Storage Type: varchar
Max Length: 14
Required: No
Primary Key: No
Status: Active
Description:

Key that link this record back to its related record found in the c_bbs_int.

SPECIES_FK

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

Species code.

NUM_KEPT

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

Number of fish (pieces) kept.

NUM_KEPT_TYPE

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

Method used to determine pieces of species caught (1 = actual, 2 = calculated, 3 = estimated).

EST_KGS

CC ID: 1008095
Seq. Order: 54
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 2
Status: Active
Description:

Total catch of this species.

EST_KGS_TYPE

CC ID: 1008096
Seq. Order: 55
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).

DISPOSITION

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

Disposition of the fish. Detailed information can be found in G_BBS_DISPOSITION. Old field for archived data conversion.

PRICE_LB

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

Place holder, not used.

PRICE_LB_TYPE

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

Place holder, not used.

SIZE_GROUP

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

fish size goup.

BYCATCH_TYPE

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

Condition of bycatch if caught (1= live, 2 = damaged/injured, 3 = other).

CAT_REMARKS

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

Comment field.

CAT_CREATE_TIME

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

When this record was created

CAT_MODIFY_TIME

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

When was the last date this record was editted

CAT_LOAD_TABLE

CC ID: 1008105
Seq. Order: 64
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

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

When this record was loade into MySQL VFP

CAT_LOAD_USER

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

User load the data into MySQL

SIZE_PK

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

System-generated artificial primary key.

CATCH_FK

CC ID: 1008109
Seq. Order: 68
Data Storage Type: varchar
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Key link this record to its related record in C_BBS_CATCH.

LEN_MM

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

Fork length of fish in mm.

LEN_MM_TYPE

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

How len was collected (1 = actual, 2 = calculated, 3 = estimated).

KGS

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

Fish weight in kilograms.

KGS_TYPE

CC ID: 1008113
Seq. Order: 72
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).

SEX

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

Place holder, not in used.

SIZ_CREATE_TIME

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

Date the record was created

SIZ_MODIFY_TIME

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

Date the record was last modified

SIZ_LOAD_TABLE

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

varchar(32)

SIZ_LOAD_DATETIME

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

datetime

SIZ_LOAD_USER

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

varchar(32)

FISHING_METHOD

CC ID: 1008120
Seq. Order: 79
Data Storage Type: varchar
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Fishing method.

FISHING_AREA

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

Fishing area code.

PORT_NAME

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

Port name.

SCIENTIFIC_NAME

CC ID: 1008123
Seq. Order: 82
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

CC ID: 1008124
Seq. Order: 83
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: 63468
GUID: gov.noaa.nmfs.inport:63468
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 01:05+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