Slide Menu
Search Help Show/Hide Menu

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