View: EDC_TRIP_COST_DATA_VW
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6862 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |