Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Fisheries Research and Monitoring Divisio... > Fisheries Monitoring > Western Pacific Fisheries Information Network (... > CNMI Boat-based Creel Survey >

c_bbs_exp_vfp

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

Summary

Abstract

Contains shore-based expanded species composition data.

Description

Contains shore-based expanded species composition data.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
EXPANSION_PK
int 		System-generated artificial 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.
SM_TR
decimal 		The number of trips represented by interviews collected for the current stratum.
AVG_EST_TRIP
decimal 		Average trip per day from boat log.
DAYS_Q
int 		Days in the quarter for current stratum.
EXP_TRIP
decimal 		Expanded trips for the current stratum.
EXP_HOUR
decimal 		Expanded hours for the current stratum.
EXP_FISHER
decimal 		Expanded fishers for the current stratum.
EXP_FISHER_HOUR
decimal 		Expanded fisher-hours for the current stratum.
EXP_GEAR_HOUR
decimal 		Expanded gear-hours for the current stratum.
CPUE_TRIP
decimal 		The average catch-per-trip.
EXP_CATCH
decimal 		Expanded total catch for the current stratum.
VAR_EST_TRIP
decimal 		The variance of the estimated number of trips across sampling days for the current stratum.
VAR_EXP_TRIP
decimal 		The variance of the expanded number of trips for the current stratum.
VAR_CPUE_TRIP
decimal 		The variance of the catch-per-trip from interviews for the current stratum.
VAR_EXP_CATCH
decimal 		The variance of the estimated number of expanded catch across sampling days for the current stratum.
STD_EXP_TRIP
decimal 		The coefficient of variation of the expanded number of trips for the current stratum.
STD_CPUE_TRIP
decimal 		The coefficient of variation of the catch-per-trip from interviews for the current stratum.
STD_EXP_CATCH
decimal 		The coefficient of variation of the average number of trips per sampling day for the current stratum.
NUM_SAMPLE_DAY
int 		Number of sampled days.
P1
decimal 		Place holder, not used.
P2
decimal 		Place holder, not used.
AD_FISH
decimal 		Place holder, not used.
AD_SM_TR
decimal 		Place holder, not used.
AD_SM_TR2
decimal 		Place holder, not used.
SM_KG
decimal 		The number of kgs represented by interviews collected for the current stratum.
SM_KG2
decimal 		The number of kgs represented by interviews collected for the current stratum squared.
NUM_INT0
int 		The number of interviews counted for this stratum.
NUM_INT
int 		The number of interviews counted for this stratum.
SM_HOUR
decimal 		The number of hours represented by interviews collected for the current stratum.
SM_HOUR2
decimal 		The number of hours represented by interviews collected for the current stratum squared.
SM_PRSN
int 		The number of persons represented by interviews collected for the current stratum.
SM_PR2
int 		The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
SM_PR_HR
decimal 		The number of person-hours represented by interviews collected for the current stratum.
SM_PR_HR2
decimal 		The number of person-hours represented by interviews collected for the current stratum squared.
SM_GEAR_HOUR
decimal 		The number of gear hours represented by interviews collected for the current stratum.
SM_GEAR_HOUR2
decimal 		The number of gear hours represented by interviews collected for the current stratum squared.
EX_FACTOR
decimal 		A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
POOL_FLAG
varchar 		Type of pooling was excecuted.
WCT_TR
int 		Total trips from WCT data.
WCT_TR2
int 		Total trips from WCT data, squared.
VAR_WCT_TR
decimal 		The variance of the number of trips for the current stratum from WCT data.
CHT_TR91
int 		Total trolling charted trips.
CHT_TR91_2
int 		Total trolling charted trips, squared.
V_CHT_TR91
decimal 		temporary place holder to calculate the the variance of CHT_TR92.
CHT_TR92
int 		Total bottomfishing charted trips.
CHT_TR92_2
int 		Total bottomfishing charted trips, squared.
V_CHT_TR92
decimal 		temporary place holder to calculate the the variance of CHT_TR91.
LATE_TR_AD
decimal 		Trips that were collected in the PM shift.
PC_METH
decimal 		The proportion of all trips that are for the current method, calculated from boat log data.
ALL_DAY
int 		Total all-day trip from interviews
ALL_LATE
int 		Late trips from interviews.
TR_DAY
int 		Total trips observed duringpm shift.
TR_LATE
int 		Total trips observed during am shift.
CHT_CNT
int 		Chartered trip counts
CHT_CNT_AD
int 		Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
ADD_FROM
varchar 		Place holder, not used.
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_exp_vfp
Status: Completed
Abstract:

Contains shore-based expanded species composition data.

Entity Information

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

Contains shore-based expanded species composition data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key EXPANSION_PK int System-generated artificial 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
 SM_TR decimal The number of trips represented by interviews collected for the current stratum.
100
 AVG_EST_TRIP decimal Average trip per day from boat log.
100
 DAYS_Q int Days in the quarter for current stratum.
100
 EXP_TRIP decimal Expanded trips for the current stratum.
100
 EXP_HOUR decimal Expanded hours for the current stratum.
100
 EXP_FISHER decimal Expanded fishers for the current stratum.
100
 EXP_FISHER_HOUR decimal Expanded fisher-hours for the current stratum.
100
 EXP_GEAR_HOUR decimal Expanded gear-hours for the current stratum.
100
 CPUE_TRIP decimal The average catch-per-trip.
100
 EXP_CATCH decimal Expanded total catch for the current stratum.
100
 VAR_EST_TRIP decimal The variance of the estimated number of trips across sampling days for the current stratum.
100
 VAR_EXP_TRIP decimal The variance of the expanded number of trips for the current stratum.
100
 VAR_CPUE_TRIP decimal The variance of the catch-per-trip from interviews for the current stratum.
100
 VAR_EXP_CATCH decimal The variance of the estimated number of expanded catch across sampling days for the current stratum.
100
 STD_EXP_TRIP decimal The coefficient of variation of the expanded number of trips for the current stratum.
100
 STD_CPUE_TRIP decimal The coefficient of variation of the catch-per-trip from interviews for the current stratum.
100
 STD_EXP_CATCH decimal The coefficient of variation of the average number of trips per sampling day for the current stratum.
100
 NUM_SAMPLE_DAY int Number of sampled days.
100
 P1 decimal Place holder, not used.
100
 P2 decimal Place holder, not used.
100
 AD_FISH decimal Place holder, not used.
100
 AD_SM_TR decimal Place holder, not used.
100
 AD_SM_TR2 decimal Place holder, not used.
100
 SM_KG decimal The number of kgs represented by interviews collected for the current stratum.
100
 SM_KG2 decimal The number of kgs represented by interviews collected for the current stratum squared.
100
 NUM_INT0 int The number of interviews counted for this stratum.
100
 NUM_INT int The number of interviews counted for this stratum.
100
 SM_HOUR decimal The number of hours represented by interviews collected for the current stratum.
100
 SM_HOUR2 decimal The number of hours represented by interviews collected for the current stratum squared.
100
 SM_PRSN int The number of persons represented by interviews collected for the current stratum.
100
 SM_PR2 int The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
100
 SM_PR_HR decimal The number of person-hours represented by interviews collected for the current stratum.
100
 SM_PR_HR2 decimal The number of person-hours represented by interviews collected for the current stratum squared.
100
 SM_GEAR_HOUR decimal The number of gear hours represented by interviews collected for the current stratum.
100
 SM_GEAR_HOUR2 decimal The number of gear hours represented by interviews collected for the current stratum squared.
100
 EX_FACTOR decimal A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
100
 POOL_FLAG varchar Type of pooling was excecuted.
100
 WCT_TR int Total trips from WCT data.
100
 WCT_TR2 int Total trips from WCT data, squared.
100
 VAR_WCT_TR decimal The variance of the number of trips for the current stratum from WCT data.
100
 CHT_TR91 int Total trolling charted trips.
100
 CHT_TR91_2 int Total trolling charted trips, squared.
100
 V_CHT_TR91 decimal temporary place holder to calculate the the variance of CHT_TR92.
100
 CHT_TR92 int Total bottomfishing charted trips.
100
 CHT_TR92_2 int Total bottomfishing charted trips, squared.
100
 V_CHT_TR92 decimal temporary place holder to calculate the the variance of CHT_TR91.
100
 LATE_TR_AD decimal Trips that were collected in the PM shift.
100
 PC_METH decimal The proportion of all trips that are for the current method, calculated from boat log data.
100
 ALL_DAY int Total all-day trip from interviews
100
 ALL_LATE int Late trips from interviews.
100
 TR_DAY int Total trips observed duringpm shift.
100
 TR_LATE int Total trips observed during am shift.
100
 CHT_CNT int Chartered trip counts
100
 CHT_CNT_AD int Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
100
 ADD_FROM varchar Place holder, not used.
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

EXPANSION_PK

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

System-generated artificial primary key.

YEAR_QUARTER

CC ID: 1007568
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: 1007569
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: 1007570
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: 1007571
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: 1007572
Seq. Order: 6
Data Storage Type: int
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Fishing method.
Default Value: 0

SM_TR

CC ID: 1007573
Seq. Order: 7
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 6
Status: Active
Description:

The number of trips represented by interviews collected for the current stratum.
Default Value: 0.000000

AVG_EST_TRIP

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

Average trip per day from boat log.
Default Value: 0.000

DAYS_Q

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

Days in the quarter for current stratum.
Default Value: 0

EXP_TRIP

CC ID: 1007576
Seq. Order: 10
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 13
Scale: 4
Status: Active
Description:

Expanded trips for the current stratum.
Default Value: 0.0000

EXP_HOUR

CC ID: 1007577
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

EXP_FISHER

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

Expanded fishers for the current stratum.
Default Value: 0.00

EXP_FISHER_HOUR

CC ID: 1007579
Seq. Order: 13
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

Expanded fisher-hours for the current stratum.
Default Value: 0.00

EXP_GEAR_HOUR

CC ID: 1007580
Seq. Order: 14
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

Expanded gear-hours for the current stratum.
Default Value: 0.00

CPUE_TRIP

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

The average catch-per-trip.
Default Value: 0.00

EXP_CATCH

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

Expanded total catch for the current stratum.
Default Value: 0.00

VAR_EST_TRIP

CC ID: 1007583
Seq. Order: 17
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 12
Scale: 4
Status: Active
Description:

The variance of the estimated number of trips across sampling days for the current stratum.
Default Value: 0.0000

VAR_EXP_TRIP

CC ID: 1007584
Seq. Order: 18
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

The variance of the expanded number of trips for the current stratum.
Default Value: 0.00

VAR_CPUE_TRIP

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

The variance of the catch-per-trip from interviews for the current stratum.
Default Value: 0.00

VAR_EXP_CATCH

CC ID: 1007586
Seq. Order: 20
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 18
Scale: 2
Status: Active
Description:

The variance of the estimated number of expanded catch across sampling days for the current stratum.
Default Value: 0.00

STD_EXP_TRIP

CC ID: 1007587
Seq. Order: 21
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the expanded number of trips for the current stratum.
Default Value: 0.0

STD_CPUE_TRIP

CC ID: 1007588
Seq. Order: 22
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the catch-per-trip from interviews for the current stratum.
Default Value: 0.0

STD_EXP_CATCH

CC ID: 1007589
Seq. Order: 23
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 7
Scale: 1
Status: Active
Description:

The coefficient of variation of the average number of trips per sampling day for the current stratum.
Default Value: 0.0

NUM_SAMPLE_DAY

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

Number of sampled days.
Default Value: 0

P1

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

Place holder, not used.
Default Value: 0.000

P2

CC ID: 1007592
Seq. Order: 26
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Place holder, not used.
Default Value: 0.0000

AD_FISH

CC ID: 1007593
Seq. Order: 27
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 4
Status: Active
Description:

Place holder, not used.
Default Value: 0.0000

AD_SM_TR

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

Place holder, not used.
Default Value: 0.00

AD_SM_TR2

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

Place holder, not used.
Default Value: 0.00

SM_KG

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

The number of kgs represented by interviews collected for the current stratum.
Default Value: 0.0

SM_KG2

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

The number of kgs represented by interviews collected for the current stratum squared.
Default Value: 0.0

NUM_INT0

CC ID: 1007598
Seq. Order: 32
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_INT

CC ID: 1007599
Seq. Order: 33
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

SM_HOUR

CC ID: 1007600
Seq. Order: 34
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 8
Scale: 1
Status: Active
Description:

The number of hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_HOUR2

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

The number of hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

SM_PRSN

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

The number of persons represented by interviews collected for the current stratum.
Default Value: 0

SM_PR2

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

The number of persons represented by interviews collected for the current stratum for the nao-sampled ports.
Default Value: 0

SM_PR_HR

CC ID: 1007604
Seq. Order: 38
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 17
Scale: 1
Status: Active
Description:

The number of person-hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_PR_HR2

CC ID: 1007605
Seq. Order: 39
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

The number of person-hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

SM_GEAR_HOUR

CC ID: 1007606
Seq. Order: 40
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 17
Scale: 1
Status: Active
Description:

The number of gear hours represented by interviews collected for the current stratum.
Default Value: 0.0

SM_GEAR_HOUR2

CC ID: 1007607
Seq. Order: 41
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 22
Scale: 2
Status: Active
Description:

The number of gear hours represented by interviews collected for the current stratum squared.
Default Value: 0.00

EX_FACTOR

CC ID: 1007608
Seq. Order: 42
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 11
Scale: 4
Status: Active
Description:

A ratio of (expanded trips)/(trips from interviews data). This factor is used to create the expanded effort data (e.g. Exp_Gears, Exp_fisher, Exp_fisher_hours, etc…)
Default Value: 0.0000

POOL_FLAG

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

Type of pooling was excecuted.

WCT_TR

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

Total trips from WCT data.
Default Value: 0

WCT_TR2

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

Total trips from WCT data, squared.
Default Value: 0

VAR_WCT_TR

CC ID: 1007612
Seq. Order: 46
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

The variance of the number of trips for the current stratum from WCT data.
Default Value: 0.00

CHT_TR91

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

Total trolling charted trips.
Default Value: 0

CHT_TR91_2

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

Total trolling charted trips, squared.
Default Value: 0

V_CHT_TR91

CC ID: 1007615
Seq. Order: 49
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

temporary place holder to calculate the the variance of CHT_TR92.
Default Value: 0.00

CHT_TR92

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

Total bottomfishing charted trips.
Default Value: 0

CHT_TR92_2

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

Total bottomfishing charted trips, squared.
Default Value: 0

V_CHT_TR92

CC ID: 1007618
Seq. Order: 52
Data Storage Type: decimal
Required: No
Primary Key: No
Precision: 14
Scale: 2
Status: Active
Description:

temporary place holder to calculate the the variance of CHT_TR91.
Default Value: 0.00

LATE_TR_AD

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

Trips that were collected in the PM shift.
Default Value: 0.00000

PC_METH

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

The proportion of all trips that are for the current method, calculated from boat log data.
Default Value: 0.00000

ALL_DAY

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

Total all-day trip from interviews
Default Value: 0

ALL_LATE

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

Late trips from interviews.
Default Value: 0

TR_DAY

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

Total trips observed duringpm shift.
Default Value: 0

TR_LATE

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

Total trips observed during am shift.
Default Value: 0

CHT_CNT

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

Chartered trip counts
Default Value: 0

CHT_CNT_AD

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

Chartered trips added. Aditional chartered trips that was made after returned from the morning trips.
Default Value: 0

ADD_FROM

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

Place holder, not used.

SYS_CREATE_TIME

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

Date the record was created

SYS_MODIFY_TIME

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

Date the record was last modified

LOAD_TABLE

CC ID: 1007630
Seq. Order: 64
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: 1007631
Seq. Order: 65
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: 1007632
Seq. Order: 66
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: 63460
GUID: gov.noaa.nmfs.inport:63460
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2021-01-21 00:25+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