Search Help Show/Hide Menu
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