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