g_sbs_interview_flat_view

Pacific Islands Fisheries Science Center
Entity (ENT) | ID: 63472 | Published / External
Created: 2021-01-21   |   Last Modified: 2022-08-09

Parent: Guam Shore-based Creel Survey
Data Set (DS) | ID: 5621

ID: 63472
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title g_sbs_interview_flat_view
Short Name  
* Status Completed
Creation Date  
Revision Date  
• Publication Date  
* » Abstract
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)  
DOI Registration Authority  
DOI Issue Date  

Keywords

Theme Keywords

Thesaurus Keyword
   
   
   

Temporal Keywords

Thesaurus Keyword
   
   
   

* Spatial Keywords

Thesaurus Keyword
   
   
   

Stratum Keywords

Thesaurus Keyword
   
   
   

Instrument Keywords

Thesaurus Keyword
   
   
   

Platform Keywords

Thesaurus Keyword
   
   
   

Physical Location

• » Organization  
• » City  
• » State/Province  
• Country  
• » Location Description

Entity Information

Entity Type Data View
Active Version? Y
Alias  
Schema Name guam_dawr_wh
» Description
Change Summary

Data Attributes

Attribute Summary

Score Req'd? PKey? » Name Data Storage Type Description
100 No No INTERVIEW_PK varchar UID assigned to this record
100 No No SAMPLE_DATE date Date of the survey.
100 No No TYPE_OF_DAY varchar Type of day when the interview was conducted (1 = weekday, 2 = weekend/holiday).
100 No No NUM_FISHER int Number of fishermen fishing.
100 No No INTERVIEW_ORDER int Squential number assigned to each line on the interview form.
100 No No INTERVIEWER_FK varchar Code for the interviewer.
100 No No INTERVIEW_TIME int Time the interview.
100 No No START_TIME int Fishing start time.
100 No No END_TIME int Fishing stop time.
100 No No DAY_BEFORE int If fisher started the fishing on the day before today.
100 No No DAY_AFTER int If fisher plan to stop fishing on the day after today.
100 No No BREAK_HOURS decimal Break time taken during fishing trip, measured in hours.
100 No No ACTUAL_HOURS decimal Actual time spent on the fishing trip. Calculated field: INT_TIME - START_TIME.
100 No No EST_HOURS decimal Estimated of trip time. Calculated field: STOP_TIME - START_TIME.
100 No No 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 No No AREA_FK int Area fished code
100 No No NUM_GEAR int Number of gears used.
100 No No REEF_ZONE int Code of the reef zone
100 No No PERCENT_SOLD decimal Percentage of catch sold.
100 No No PERCENT_UNSOLD decimal Percentage of catch not sold.
100 No No BUYER_FK int Code for the buyer. Detailed information can be found in C_SBS_BUYER or in C_BUYER.DBF.
100 No No TOT_NUM_KEPT int Total pieces of species caught.
100 No No TOT_EST_KGS decimal Total fish weight of this interview
100 No No TOT_SPECIES int Total number of species caught.
100 No No TOT_NUM_TYPE int How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
100 No No TOT_EST_KGS_TYPE int How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).
100 No No TOT_SPECIES_TYPE int How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).
100 No No BAIT_FK int bait code
100 No No WEATHER_FK int Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
100 No No CLOUD_FK int Code for the cloud conditions. Detailed information can be found in C_CLOUD or C_CLOUD.DBF.
100 No No SURF int Surf high in feet.
100 No No TIDE varchar Tide level
100 No No NON_SCHED_F char If true, the interview was not scheduled (opportunistic).
100 No No INCOMPLETE_F char This interview was not able to record all the catch of the trip.
100 No No 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 No No LUNAR_DAY int Lunar day. 15 = full moon, 1 or 29/30 = new moon based on the value of the survey date
100 No No INT_REMARKS varchar Remarks
100 No No INT_CREATE_TIME datetime When this record was created
100 No No INT_MODIFY_TIME datetime When was the last date this record was editted
100 No No INT_CREATE_USER varchar Staff code who enter this data
100 No No INT_MODIFY_USER varchar Staff code who last editted this record
100 No No INT_LOAD_TABLE varchar Which VFP table where this data was loaded from
100 No No INT_LOAD_DATETIME datetime When this record was loade into MySQL VFP
100 No No INT_LOAD_USER varchar User load the data into MySQL
100 No No CATCH_PK varchar Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.
100 No No INTERVIEW_FK varchar Key value that link this record to the related record found in the g_sbs_int
100 No No SPECIES_FK int Code for the species. Detailed information can be found in G_SBS_SPECIES or G_SPEC.DBF
100 No No NUM_KEPT_TYPE int How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
100 No No NUM_KEPT int Number of pieces of fish caught.
100 No No EST_KGS_TYPE int How weight was collected, 1=actual, 2=calculated and 3=estimated)
100 No No EST_KGS decimal total catch weight of this species.
100 No No SIZE_GROUP int fish size goup.
100 No No BYCATCH_TYPE varchar Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).
100 No No CAT_CREATE_TIME datetime When this record was created
100 No No CAT_MODIFY_TIME datetime When was the last date this record was editted
100 No No CAT_LOAD_TABLE varchar Which VFP table where this data was loaded from
100 No No CAT_LOAD_DATETIME datetime When this record was loade into MySQL VFP
100 No No CAT_LOAD_USER varchar User load the data into MySQL
100 No No SIZE_PK int UID created for this record
100 No No CATCH_FK varchar Link key to link this record to it parent record in c_bbs_catch
100 No No LEN_MM_TYPE int How length was measured (1 = actual, 2 = calculated, 3 = estimated).
100 No No LEN_MM int Fork length of fish, from snout tip to tail fork, in millimeters.
100 No No KGS_TYPE int How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
100 No No KGS decimal Fish weight in kilograms.
100 No No SIZ_CREATE_TIME datetime This record created date
100 No No SIZ_MODIFY_TIME datetime When was last update to this record
100 No No SIZ_LOAD_TABLE varchar Which table where data was loaded from VFP database
100 No No SIZ_LOAD_DATETIME datetime this record loaded date-time form VFP table
100 No No SIZ_LOAD_USER varchar User migrated this data from FVP
100 No No FISHING_METHOD varchar fishing method code
100 No No FISHING_AREA varchar fishing area code
100 No No BUYER_NAME varchar Buyer name
100 No No BAIT_NAME varchar type of bait description
100 No No WEATHER varchar Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
100 No No SCIENTIFIC_NAME varchar Scientific name of the species (Genus name + Species name).
100 No No COMMON_NAME varchar Common English name for the species.

Attribute Details

Attribute Name INTERVIEW_PK
Seq. Order 1
Data Storage Type varchar
Max Length 14
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

UID assigned to this record
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SAMPLE_DATE
Seq. Order 2
Data Storage Type date
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Date of the survey.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TYPE_OF_DAY
Seq. Order 3
Data Storage Type varchar
Max Length 2
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Type of day when the interview was conducted (1 = weekday, 2 = weekend/holiday).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUM_FISHER
Seq. Order 4
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Number of fishermen fishing.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INTERVIEW_ORDER
Seq. Order 5
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Squential number assigned to each line on the interview form.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INTERVIEWER_FK
Seq. Order 6
Data Storage Type varchar
Max Length 3
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for the interviewer.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INTERVIEW_TIME
Seq. Order 7
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Time the interview.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name START_TIME
Seq. Order 8
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Fishing start time.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name END_TIME
Seq. Order 9
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Fishing stop time.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_BEFORE
Seq. Order 10
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

If fisher started the fishing on the day before today.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name DAY_AFTER
Seq. Order 11
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

If fisher plan to stop fishing on the day after today.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BREAK_HOURS
Seq. Order 12
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 5
Scale 2
Status Active
Description

Break time taken during fishing trip, measured in hours.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name ACTUAL_HOURS
Seq. Order 13
Data Storage Type decimal
Max Length  
Min Length  
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.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name EST_HOURS
Seq. Order 14
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 5
Scale 2
Status Active
Description

Estimated of trip time. Calculated field: STOP_TIME - START_TIME.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name METHOD_FK
Seq. Order 15
Data Storage Type int
Max Length  
Min Length  
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.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name AREA_FK
Seq. Order 16
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Area fished code
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUM_GEAR
Seq. Order 17
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Number of gears used.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name REEF_ZONE
Seq. Order 18
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Code of the reef zone
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCENT_SOLD
Seq. Order 19
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 5
Scale 1
Status Active
Description

Percentage of catch sold.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name PERCENT_UNSOLD
Seq. Order 20
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 5
Scale 1
Status Active
Description

Percentage of catch not sold.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BUYER_FK
Seq. Order 21
Data Storage Type int
Max Length  
Min Length  
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.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_NUM_KEPT
Seq. Order 22
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Total pieces of species caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_EST_KGS
Seq. Order 23
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 13
Scale 4
Status Active
Description

Total fish weight of this interview
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_SPECIES
Seq. Order 24
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Total number of species caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_NUM_TYPE
Seq. Order 25
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How tot_num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_EST_KGS_TYPE
Seq. Order 26
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How tot_est_kgs was collected (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TOT_SPECIES_TYPE
Seq. Order 27
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How tot_species was collected (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAIT_FK
Seq. Order 28
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

bait code
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name WEATHER_FK
Seq. Order 29
Data Storage Type int
Max Length  
Min Length  
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.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CLOUD_FK
Seq. Order 30
Data Storage Type int
Max Length  
Min Length  
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.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SURF
Seq. Order 31
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Surf high in feet.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name TIDE
Seq. Order 32
Data Storage Type varchar
Max Length 4
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Tide level
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NON_SCHED_F
Seq. Order 33
Data Storage Type char
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

If true, the interview was not scheduled (opportunistic).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INCOMPLETE_F
Seq. Order 34
Data Storage Type char
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

This interview was not able to record all the catch of the trip.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BYCATCH_F
Seq. Order 35
Data Storage Type varchar
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
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.)
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LUNAR_DAY
Seq. Order 36
Data Storage Type int
Max Length  
Min Length  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_REMARKS
Seq. Order 37
Data Storage Type varchar
Max Length 255
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Remarks
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_CREATE_TIME
Seq. Order 38
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When this record was created
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_MODIFY_TIME
Seq. Order 39
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When was the last date this record was editted
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_CREATE_USER
Seq. Order 40
Data Storage Type varchar
Max Length 35
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Staff code who enter this data
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_MODIFY_USER
Seq. Order 41
Data Storage Type varchar
Max Length 35
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Staff code who last editted this record
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_LOAD_TABLE
Seq. Order 42
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Which VFP table where this data was loaded from
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_LOAD_DATETIME
Seq. Order 43
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When this record was loade into MySQL VFP
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INT_LOAD_USER
Seq. Order 44
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

User load the data into MySQL
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CATCH_PK
Seq. Order 45
Data Storage Type varchar
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Primary key (only in MySQL) which is a unique identifier for each record in this table. Auto-generated.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name INTERVIEW_FK
Seq. Order 46
Data Storage Type varchar
Max Length 14
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Key value that link this record to the related record found in the g_sbs_int
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SPECIES_FK
Seq. Order 47
Data Storage Type int
Max Length  
Min Length  
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
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUM_KEPT_TYPE
Seq. Order 48
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How num_kept was collected (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name NUM_KEPT
Seq. Order 49
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Number of pieces of fish caught.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name EST_KGS_TYPE
Seq. Order 50
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How weight was collected, 1=actual, 2=calculated and 3=estimated)
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name EST_KGS
Seq. Order 51
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 4
Status Active
Description

total catch weight of this species.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_GROUP
Seq. Order 52
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

fish size goup.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BYCATCH_TYPE
Seq. Order 53
Data Storage Type varchar
Max Length 1
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Condition of the fish when release (1 = live, 2 = damaged/injured, 3 = other).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAT_CREATE_TIME
Seq. Order 54
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When this record was created
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAT_MODIFY_TIME
Seq. Order 55
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When was the last date this record was editted
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAT_LOAD_TABLE
Seq. Order 56
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Which VFP table where this data was loaded from
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAT_LOAD_DATETIME
Seq. Order 57
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When this record was loade into MySQL VFP
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CAT_LOAD_USER
Seq. Order 58
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

User load the data into MySQL
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZE_PK
Seq. Order 59
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

UID created for this record
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name CATCH_FK
Seq. Order 60
Data Storage Type varchar
Max Length 22
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Link key to link this record to it parent record in c_bbs_catch
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LEN_MM_TYPE
Seq. Order 61
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How length was measured (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name LEN_MM
Seq. Order 62
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

Fork length of fish, from snout tip to tail fork, in millimeters.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name KGS_TYPE
Seq. Order 63
Data Storage Type int
Max Length  
Min Length  
Required No
Primary Key No
Precision 10
Scale 0
Status Active
Description

How weight was collected (1 = actual, 2 = calculated, 3 = estimated).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name KGS
Seq. Order 64
Data Storage Type decimal
Max Length  
Min Length  
Required No
Primary Key No
Precision 9
Scale 4
Status Active
Description

Fish weight in kilograms.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZ_CREATE_TIME
Seq. Order 65
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

This record created date
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZ_MODIFY_TIME
Seq. Order 66
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

When was last update to this record
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZ_LOAD_TABLE
Seq. Order 67
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Which table where data was loaded from VFP database
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZ_LOAD_DATETIME
Seq. Order 68
Data Storage Type datetime
Max Length  
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

this record loaded date-time form VFP table
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SIZ_LOAD_USER
Seq. Order 69
Data Storage Type varchar
Max Length 32
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

User migrated this data from FVP
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHING_METHOD
Seq. Order 70
Data Storage Type varchar
Max Length 25
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

fishing method code
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name FISHING_AREA
Seq. Order 71
Data Storage Type varchar
Max Length 35
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

fishing area code
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BUYER_NAME
Seq. Order 72
Data Storage Type varchar
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Buyer name
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name BAIT_NAME
Seq. Order 73
Data Storage Type varchar
Max Length 16
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

type of bait description
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name WEATHER
Seq. Order 74
Data Storage Type varchar
Max Length 20
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Code for the weather conditions. Detailed information can be found in C_WEATHER or C_WEATHE.DBF.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name SCIENTIFIC_NAME
Seq. Order 75
Data Storage Type varchar
Max Length 40
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Scientific name of the species (Genus name + Species name).
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name COMMON_NAME
Seq. Order 76
Data Storage Type varchar
Max Length 45
Min Length  
Required No
Primary Key No
Precision  
Scale  
Status Active
Description

Common English name for the species.
General Data Type  
Unit of Measure  
Case Restriction  
Display Example  
Format Mask  
Null Value  
Null Value Meaning
Allowed Values  
Default Value  
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules
Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions
* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference  

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class  
* Security Classification System  
 
Security Handling Description  
 
• Data Access Policy  
 
» Data Access Procedure  
 
• » Data Access Constraints  
 
• Data Use Constraints  
 
Metadata Access Constraints  
 
Metadata Use Constraints  
 

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status
Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description
Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue
Issue Date
Author
Issue
Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score Type Title
     
     
     

Related Items

Item Type Relationship Type Title
     
     
     

Catalog Details

Catalog Item ID 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 Workflow State Published / External
Metadata Last Review Date 2021-01-21
Metadata Review Frequency 1 Year
Metadata Next Review Date 2022-01-21
Tags