Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Contains cost,vessel,location per set trip record all in the same record

Description

Contains cost,vessel,location per set trip record all in the same record

Entity Information

Entity Type
Data View

Data Attribute / Type Description
LOGBOOK_KEY
NUMBER
Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
BATCH_NUMBER
VARCHAR2
Batch Number
SCHEDULE_NUMBER
VARCHAR2
Schedule Number
VESSEL_ID
VARCHAR2
State Registration Number or Federal Vessel Identiification Number
VESSEL_NAME
VARCHAR2
Vessel Name
TELEPHONE
VARCHAR2
Phone Number To Contact Vessel
DAYS_AWAY
VARCHAR2
Number Of Days Fishing
START_DATE
VARCHAR2
Start Date Of FIshing Trip
NUMBER_OF_CREW
VARCHAR2
Number Of Crew On Boat
UNLOAD_DATE
VARCHAR2
Date Catch Was Unloaded
TRIP_TICKET
VARCHAR2
Trip Ticket Number
OWNER_ABOARD
VARCHAR2
Was the Owner Aboard?
OWNER_SALARY_INCLUDED
VARCHAR2
Was the owner's salary included?
OWNER_SHARE
VARCHAR2
Owner's share of the revenue.
OWNER_SHARE_PERCENT
VARCHAR2
Owner Share Percent
CAPTAIN_SHARE
VARCHAR2
Captain's share of the revenue.
CAPTAIN_SHARE_PERCENT
VARCHAR2
Captain Share Percent
AVG_CREW_SHARE
VARCHAR2
Average share for the revenue for crew members.
AVG_CREW_SHARE_PERCENT
VARCHAR2
Average Crew Share Percent
FUEL
VARCHAR2
Amount of fuel used during the trip.
FUEL_UNIT_PRICE
VARCHAR2
Fuel Unit Price
FUEL_COST
VARCHAR2
Cost of the fuel.
BAIT_UNIT_PRICE
VARCHAR2
Bait Unit Price
BAIT_MSU
VARCHAR2
Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons
BAIT_WEIGHT
VARCHAR2
Weight of the bait.
BAIT_COUNT
VARCHAR2
How many units of bait were used
BAIT_COST
VARCHAR2
Cost of bait purchased.
BAIT2_UNIT_PRICE
VARCHAR2
Secondary /Second Bait Unit Price
BAIT2_MSU
VARCHAR2
Measured Standard Units For Seconday/second Bait
BAIT2_WEIGHT
VARCHAR2
Weight Of Secondary/Second Bait
BAIT2_COUNT
VARCHAR2
How Many Units Of second/secondary bait were used
BAIT2_COST
VARCHAR2
Secondary/Second Bait Cost
ICE_WEIGHT
VARCHAR2
Weight of ice purchased.
ICE_UNIT_PRICE
VARCHAR2
Ice Unit Price
ICE_COUNT
VARCHAR2
Quantity of Ice Used
ICE_COST
VARCHAR2
Cost of ice
ICE_MSU
VARCHAR2
Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
ICE_TIME_FRAME
VARCHAR2
Time Frame For Ice To Last
LIGHT_STICK_NUMBER
VARCHAR2
Number of light sticks used.
COST_PER_LIGHT_STICK
VARCHAR2
Cost of each light stick.
GROCERIES_EXPENSES
VARCHAR2
Total cost of groceries used during the trip.
OTHER_EXPENSES
VARCHAR2
Other Expenses
TOTAL_SHARE_COST
VARCHAR2
Total Share Cost
TOTAL_TRIP_COST
VARCHAR2
Total expenses for the trip.
FREIGHT_COST
VARCHAR2
Cost of freight.
DOCKING_UNLOADING_FEE
VARCHAR2
Docking Unloading Fee.
TACKLE_GEAR_EXPENSES
VARCHAR2
Tackle Gear Expenses
TRIP_GROCERY_EXPENSE
VARCHAR2
Grocery Expenses Per Trip
MISC_EXPENSE
VARCHAR2
Miscellaneous Expenses Per Trip
TOTAL_TRIP_REVENUE
VARCHAR2
Total Trip Revenue
PERSON_ID
NUMBER
Person ID. By Cassio on 6/2/2006 - For EDC
CHANGE_REASON_ID
NUMBER
Key to why reason was changed. By Cassio on 6/2/2006 - For EDC
LU
DATE
When Records was last updated By Cassio on 6/2/2006 - For EDC
TABLE_NAME
VARCHAR2
Oracle Table which serves as a source for this record

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: View: EDC_TRIP_COST_DATA_VW
Short Name: EDC_TRIP_COST_DATA_VW
Status: Completed
Abstract:

Contains cost,vessel,location per set trip record all in the same record

Notes:

Loaded by batch 2043, 12-20-2007 08:10

Entity Information

Entity Type: Data View
Active Version?: Yes
Schema Name: FLS
Description:

Contains cost,vessel,location per set trip record all in the same record

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
LOGBOOK_KEY NUMBER Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
100
BATCH_NUMBER VARCHAR2 Batch Number
100
SCHEDULE_NUMBER VARCHAR2 Schedule Number
100
VESSEL_ID VARCHAR2 State Registration Number or Federal Vessel Identiification Number
100
VESSEL_NAME VARCHAR2 Vessel Name
100
TELEPHONE VARCHAR2 Phone Number To Contact Vessel
100
DAYS_AWAY VARCHAR2 Number Of Days Fishing
100
START_DATE VARCHAR2 Start Date Of FIshing Trip
100
NUMBER_OF_CREW VARCHAR2 Number Of Crew On Boat
100
UNLOAD_DATE VARCHAR2 Date Catch Was Unloaded
100
TRIP_TICKET VARCHAR2 Trip Ticket Number
100
OWNER_ABOARD VARCHAR2 Was the Owner Aboard?
100
OWNER_SALARY_INCLUDED VARCHAR2 Was the owner's salary included?
100
OWNER_SHARE VARCHAR2 Owner's share of the revenue.
100
OWNER_SHARE_PERCENT VARCHAR2 Owner Share Percent
100
CAPTAIN_SHARE VARCHAR2 Captain's share of the revenue.
100
CAPTAIN_SHARE_PERCENT VARCHAR2 Captain Share Percent
100
AVG_CREW_SHARE VARCHAR2 Average share for the revenue for crew members.
100
AVG_CREW_SHARE_PERCENT VARCHAR2 Average Crew Share Percent
100
FUEL VARCHAR2 Amount of fuel used during the trip.
100
FUEL_UNIT_PRICE VARCHAR2 Fuel Unit Price
100
FUEL_COST VARCHAR2 Cost of the fuel.
100
BAIT_UNIT_PRICE VARCHAR2 Bait Unit Price
100
BAIT_MSU VARCHAR2 Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons
100
BAIT_WEIGHT VARCHAR2 Weight of the bait.
100
BAIT_COUNT VARCHAR2 How many units of bait were used
100
BAIT_COST VARCHAR2 Cost of bait purchased.
100
BAIT2_UNIT_PRICE VARCHAR2 Secondary /Second Bait Unit Price
100
BAIT2_MSU VARCHAR2 Measured Standard Units For Seconday/second Bait
100
BAIT2_WEIGHT VARCHAR2 Weight Of Secondary/Second Bait
100
BAIT2_COUNT VARCHAR2 How Many Units Of second/secondary bait were used
100
BAIT2_COST VARCHAR2 Secondary/Second Bait Cost
100
ICE_WEIGHT VARCHAR2 Weight of ice purchased.
100
ICE_UNIT_PRICE VARCHAR2 Ice Unit Price
100
ICE_COUNT VARCHAR2 Quantity of Ice Used
100
ICE_COST VARCHAR2 Cost of ice
100
ICE_MSU VARCHAR2 Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
100
ICE_TIME_FRAME VARCHAR2 Time Frame For Ice To Last
100
LIGHT_STICK_NUMBER VARCHAR2 Number of light sticks used.
100
COST_PER_LIGHT_STICK VARCHAR2 Cost of each light stick.
100
GROCERIES_EXPENSES VARCHAR2 Total cost of groceries used during the trip.
100
OTHER_EXPENSES VARCHAR2 Other Expenses
100
TOTAL_SHARE_COST VARCHAR2 Total Share Cost
100
TOTAL_TRIP_COST VARCHAR2 Total expenses for the trip.
100
FREIGHT_COST VARCHAR2 Cost of freight.
100
DOCKING_UNLOADING_FEE VARCHAR2 Docking Unloading Fee.
100
TACKLE_GEAR_EXPENSES VARCHAR2 Tackle Gear Expenses
100
TRIP_GROCERY_EXPENSE VARCHAR2 Grocery Expenses Per Trip
100
MISC_EXPENSE VARCHAR2 Miscellaneous Expenses Per Trip
100
TOTAL_TRIP_REVENUE VARCHAR2 Total Trip Revenue
100
PERSON_ID NUMBER Person ID. By Cassio on 6/2/2006 - For EDC
100
CHANGE_REASON_ID NUMBER Key to why reason was changed. By Cassio on 6/2/2006 - For EDC
100
LU DATE When Records was last updated By Cassio on 6/2/2006 - For EDC
100
TABLE_NAME VARCHAR2 Oracle Table which serves as a source for this record

Attribute Details

LOGBOOK_KEY

CC ID: 24710
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 0
Status: Active
Description:

Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.

General Data Type: NUMBER

BATCH_NUMBER

CC ID: 24728
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Batch Number

General Data Type: VARCHAR2

SCHEDULE_NUMBER

CC ID: 24729
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

Schedule Number

General Data Type: VARCHAR2

VESSEL_ID

CC ID: 24689
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 10
Required: No
Primary Key: No
Status: Active
Description:

State Registration Number or Federal Vessel Identiification Number

General Data Type: VARCHAR2

VESSEL_NAME

CC ID: 24708
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

Vessel Name

General Data Type: VARCHAR2

TELEPHONE

CC ID: 24701
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 15
Required: No
Primary Key: No
Status: Active
Description:

Phone Number To Contact Vessel

General Data Type: VARCHAR2

DAYS_AWAY

CC ID: 24694
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number Of Days Fishing

General Data Type: VARCHAR2

START_DATE

CC ID: 24721
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Start Date Of FIshing Trip

General Data Type: VARCHAR2

NUMBER_OF_CREW

CC ID: 24705
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number Of Crew On Boat

General Data Type: VARCHAR2

UNLOAD_DATE

CC ID: 24738
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Date Catch Was Unloaded

General Data Type: VARCHAR2

TRIP_TICKET

CC ID: 24723
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Trip Ticket Number

General Data Type: VARCHAR2

OWNER_ABOARD

CC ID: 24699
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the Owner Aboard?

General Data Type: VARCHAR2

OWNER_SALARY_INCLUDED

CC ID: 24730
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Was the owner's salary included?

General Data Type: VARCHAR2

OWNER_SHARE

CC ID: 24709
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Owner's share of the revenue.

General Data Type: VARCHAR2

OWNER_SHARE_PERCENT

CC ID: 24692
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Owner Share Percent

General Data Type: VARCHAR2

CAPTAIN_SHARE

CC ID: 24715
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Captain's share of the revenue.

General Data Type: VARCHAR2

CAPTAIN_SHARE_PERCENT

CC ID: 24720
Seq. Order: 17
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Captain Share Percent

General Data Type: VARCHAR2

AVG_CREW_SHARE

CC ID: 24697
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Average share for the revenue for crew members.

General Data Type: VARCHAR2

AVG_CREW_SHARE_PERCENT

CC ID: 24724
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Average Crew Share Percent

General Data Type: VARCHAR2

FUEL

CC ID: 24740
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Amount of fuel used during the trip.

General Data Type: VARCHAR2

FUEL_UNIT_PRICE

CC ID: 24722
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Fuel Unit Price

General Data Type: VARCHAR2

FUEL_COST

CC ID: 24713
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of the fuel.

General Data Type: VARCHAR2

BAIT_UNIT_PRICE

CC ID: 24714
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Bait Unit Price

General Data Type: VARCHAR2

BAIT_MSU

CC ID: 24712
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons

General Data Type: VARCHAR2

BAIT_WEIGHT

CC ID: 24693
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight of the bait.

General Data Type: VARCHAR2

BAIT_COUNT

CC ID: 24700
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

How many units of bait were used

General Data Type: VARCHAR2

BAIT_COST

CC ID: 24691
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of bait purchased.

General Data Type: VARCHAR2

BAIT2_UNIT_PRICE

CC ID: 24717
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Secondary /Second Bait Unit Price

General Data Type: VARCHAR2

BAIT2_MSU

CC ID: 24726
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Measured Standard Units For Seconday/second Bait

General Data Type: VARCHAR2

BAIT2_WEIGHT

CC ID: 24737
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight Of Secondary/Second Bait

General Data Type: VARCHAR2

BAIT2_COUNT

CC ID: 24707
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

How Many Units Of second/secondary bait were used

General Data Type: VARCHAR2

BAIT2_COST

CC ID: 24702
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Secondary/Second Bait Cost

General Data Type: VARCHAR2

ICE_WEIGHT

CC ID: 24727
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Weight of ice purchased.

General Data Type: VARCHAR2

ICE_UNIT_PRICE

CC ID: 24718
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Ice Unit Price

General Data Type: VARCHAR2

ICE_COUNT

CC ID: 24736
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Quantity of Ice Used

General Data Type: VARCHAR2

ICE_COST

CC ID: 24711
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of ice

General Data Type: VARCHAR2

ICE_MSU

CC ID: 24734
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)

General Data Type: VARCHAR2

ICE_TIME_FRAME

CC ID: 24695
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Time Frame For Ice To Last

General Data Type: VARCHAR2

LIGHT_STICK_NUMBER

CC ID: 24696
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Number of light sticks used.

General Data Type: VARCHAR2

COST_PER_LIGHT_STICK

CC ID: 24735
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of each light stick.

General Data Type: VARCHAR2

GROCERIES_EXPENSES

CC ID: 24703
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total cost of groceries used during the trip.

General Data Type: VARCHAR2

OTHER_EXPENSES

CC ID: 24716
Seq. Order: 42
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Other Expenses

General Data Type: VARCHAR2

TOTAL_SHARE_COST

CC ID: 24690
Seq. Order: 43
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total Share Cost

General Data Type: VARCHAR2

TOTAL_TRIP_COST

CC ID: 24739
Seq. Order: 44
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total expenses for the trip.

General Data Type: VARCHAR2

FREIGHT_COST

CC ID: 24719
Seq. Order: 45
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Cost of freight.

General Data Type: VARCHAR2

DOCKING_UNLOADING_FEE

CC ID: 24698
Seq. Order: 46
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Docking Unloading Fee.

General Data Type: VARCHAR2

TACKLE_GEAR_EXPENSES

CC ID: 24688
Seq. Order: 47
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Tackle Gear Expenses

General Data Type: VARCHAR2

TRIP_GROCERY_EXPENSE

CC ID: 24687
Seq. Order: 48
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Grocery Expenses Per Trip

General Data Type: VARCHAR2

MISC_EXPENSE

CC ID: 24733
Seq. Order: 49
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Miscellaneous Expenses Per Trip

General Data Type: VARCHAR2

TOTAL_TRIP_REVENUE

CC ID: 24704
Seq. Order: 50
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Total Trip Revenue

General Data Type: VARCHAR2

PERSON_ID

CC ID: 24706
Seq. Order: 51
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Person ID. By Cassio on 6/2/2006 - For EDC

General Data Type: NUMBER

CHANGE_REASON_ID

CC ID: 24732
Seq. Order: 52
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Key to why reason was changed. By Cassio on 6/2/2006 - For EDC

General Data Type: NUMBER

LU

CC ID: 24731
Seq. Order: 53
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

When Records was last updated By Cassio on 6/2/2006 - For EDC

General Data Type: DATE

TABLE_NAME

CC ID: 24725
Seq. Order: 54
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

Oracle Table which serves as a source for this record

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 6862
GUID: gov.noaa.nmfs.inport:6862
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2007-12-20 08:10+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:10+0000
Metadata Record Published: 2021-05-07
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-05-07
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-05-07