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 (... > CNMI Boat-based Creel Survey >

c_bbs_spc_vfp

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:63462  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
SPECCOMP_PK
int 		UID, primary key.
YEAR_QUARTER
int 		Start year and quarter and end year and quarter of expansion data. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
TYPE_OF_DAY
int 		Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
PORT
int 		Port code for this expansion.
CHARTER_F
char 		If true (T), indicates chartered trip.
METHOD
int 		Fishing method.
SPECIES
int 		Species code.
SPECIES_NAME
varchar 		Common English name for the species.
PC_SPCOMP
decimal 		species composition of this species per this stratum.
EXP_KGS
decimal 		Expanded catch of this species for the current stratum.
EXP_HOUR
decimal 		Expanded hours for the current stratum.
CAT_KGS
decimal 		Catch of this species from interviews.
NUM_INT
int 		The number of interviews counted for this stratum.
NUM_INT0
int 		The number of interviews counted for this stratum.
NUM_CAT
int 		Total number of pieces of this species for this stratum from interview data.
POOL_FLAG
varchar 		Type of pooling was excecuted.
SYS_CREATE_TIME
datetime 		Date the record was created
SYS_MODIFY_TIME
datetime 		Date the record was last modified
LOAD_TABLE
varchar 		Name of the FoxPro table that was loaded into MySQL.
LOAD_DATETIME
datetime 		The date and time the data was loaded in to the table
LOAD_USER
varchar 		User who loaded the data to the MySQL 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: c_bbs_spc_vfp
Status: Completed

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: cnmi_dfw_wh

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key SPECCOMP_PK int UID, primary key.
100
 YEAR_QUARTER int Start year and quarter and end year and quarter of expansion data. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
100
 TYPE_OF_DAY int Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
100
 PORT int Port code for this expansion.
100
 CHARTER_F char If true (T), indicates chartered trip.
100
 METHOD int Fishing method.
100
 SPECIES int Species code.
100
 SPECIES_NAME varchar Common English name for the species.
100
 PC_SPCOMP decimal species composition of this species per this stratum.
100
 EXP_KGS decimal Expanded catch of this species for the current stratum.
100
 EXP_HOUR decimal Expanded hours for the current stratum.
100
 CAT_KGS decimal Catch of this species from interviews.
100
 NUM_INT int The number of interviews counted for this stratum.
100
 NUM_INT0 int The number of interviews counted for this stratum.
100
 NUM_CAT int Total number of pieces of this species for this stratum from interview data.
100
 POOL_FLAG varchar Type of pooling was excecuted.
100
 SYS_CREATE_TIME datetime Date the record was created
100
 SYS_MODIFY_TIME datetime Date the record was last modified
100
 LOAD_TABLE varchar Name of the FoxPro table that was loaded into MySQL.
100
 LOAD_DATETIME datetime The date and time the data was loaded in to the table
100
 LOAD_USER varchar User who loaded the data to the MySQL table.

Attribute Details

SPECCOMP_PK

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

UID, primary key.

YEAR_QUARTER

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

Start year and quarter and end year and quarter of expansion data. Format is yyyyqYYYYQ: 'yyyy' is the start year, 'q' is the start quarter, 'YYYY' is the end year, and 'Q' is the end quarter. Quarters are 1 = 4 calendar year.
Default Value: 0

TYPE_OF_DAY

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

Type of day on which the interview was conducted (1= weekday, 2 = weekend/holiday).
Default Value: 0

PORT

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

Port code for this expansion.
Default Value: 0

CHARTER_F

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

If true (T), indicates chartered trip.

METHOD

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

Fishing method.
Default Value: 0

SPECIES

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

Species code.
Default Value: 0

SPECIES_NAME

CC ID: 1007723
Seq. Order: 8
Data Storage Type: varchar
Max Length: 28
Required: No
Primary Key: No
Status: Active
Description:

Common English name for the species.

PC_SPCOMP

CC ID: 1007724
Seq. Order: 9
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 3
Status: Active
Description:

species composition of this species per this stratum.
Default Value: 0.000

EXP_KGS

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

Expanded catch of this species for the current stratum.
Default Value: 0.00

EXP_HOUR

CC ID: 1007726
Seq. Order: 11
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 9
Scale: 2
Status: Active
Description:

Expanded hours for the current stratum.
Default Value: 0.00

CAT_KGS

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

Catch of this species from interviews.
Default Value: 0.00

NUM_INT

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

The number of interviews counted for this stratum.
Default Value: 0

NUM_INT0

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

The number of interviews counted for this stratum.
Default Value: 0

NUM_CAT

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

Total number of pieces of this species for this stratum from interview data.
Default Value: 0

POOL_FLAG

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

Type of pooling was excecuted.

SYS_CREATE_TIME

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

Date the record was created

SYS_MODIFY_TIME

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

Date the record was last modified

LOAD_TABLE

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

Name of the FoxPro table that was loaded into MySQL.

LOAD_DATETIME

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

The date and time the data was loaded in to the table

LOAD_USER

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

User who loaded the data to the MySQL table.

Catalog Details

Catalog Item ID: 63462
GUID: gov.noaa.nmfs.inport:63462
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 00:31+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