Table: FLS_INT_SCANNED_COSTS
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:6870 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | Table: FLS_INT_SCANNED_COSTS |
|---|---|
| Short Name: | FLS_INT_SCANNED_COSTS |
| Status: | Completed |
| Abstract: |
Intermediate table that holds cost data as received by the scanning/data entry company as it is being validated and eventually added to the master table. As records are valid they are put in the master table and removed from this one. |
| Notes: |
Loaded by batch 2043, 12-20-2007 08:10 |
Physical Location
| Organization: | Southeast Fisheries Science Center |
|---|---|
| City: | Miami |
| State/Province: | FL |
| Country: | USA |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Schema Name: | FLS |
| Description: |
Intermediate table that holds cost data as received by the scanning/data entry company as it is being validated and eventually added to the master table. As records are valid they are put in the master table and removed from this one. |
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
|
SCHEDULE_NUMBER | VARCHAR2 | Sequence Number On Paper Form | |
|
100
|
VESSEL_ID | VARCHAR2 | Vessel Identifier (either state or federal) | |
|
100
|
BATCH_NUMBER | VARCHAR2 | Batch 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_USED | VARCHAR2 | Amount Of Fuel Used | |
|
100
|
FUEL_UNIT_PRICE | VARCHAR2 | Fuel Unit Price | |
|
100
|
FUEL_MSU | VARCHAR2 | Units used to represent the amount of fuel. | |
|
100
|
FUEL_COST | VARCHAR2 | Cost of the fuel. | |
|
100
|
BAIT_WEIGHT | VARCHAR2 | Weight of the bait. | |
|
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_COUNT | VARCHAR2 | How many units of bait were used | |
|
100
|
BAIT_COST | VARCHAR2 | Cost of bait purchased. | |
|
100
|
BAIT2_WEIGHT | VARCHAR2 | Weight Of Secondary/Second Bait | |
|
100
|
BAIT2_UNIT_PRICE | VARCHAR2 | Secondary /Second Bait Unit Price | |
|
100
|
BAIT2_MSU | VARCHAR2 | Measured Standard Units For Seconday/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_MSU | VARCHAR2 | Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) | |
|
100
|
ICE_COUNT | VARCHAR2 | Quantity of Ice Used | |
|
100
|
ICE_COST | VARCHAR2 | Cost of ice | |
|
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
|
FREIGHT_COST | VARCHAR2 | Cost of freight. | |
|
100
|
DOCKING_UNLOADING_FEE | VARCHAR2 | Docking Unloading Fee. | |
|
100
|
TACKLE_GEAR_EXPENSES | VARCHAR2 | Tackle Gear Expenses | |
|
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
|
FORMTYPE | VARCHAR2 | Indicates version of data entry form | |
|
100
|
SOURCE_FILE | VARCHAR2 | Name Of File that loaded this data | |
|
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
|
TRIP_GROCERY_EXPENSE | NUMBER | Grocery Expenses Per Trip | |
|
100
|
MISC_EXPENSE | NUMBER | Miscellaneous Expenses Per Trip | |
|
100
|
TOTAL_TRIP_REVENUE | NUMBER | Total Trip Revenue |
Attribute Details
LOGBOOK_KEY
CC ID: 24862
| 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 |
SCHEDULE_NUMBER
CC ID: 24863
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sequence Number On Paper Form |
| General Data Type: | VARCHAR2 |
VESSEL_ID
CC ID: 24864
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel Identifier (either state or federal) |
| General Data Type: | VARCHAR2 |
BATCH_NUMBER
CC ID: 24865
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 10 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Batch Number |
| General Data Type: | VARCHAR2 |
OWNER_ABOARD
CC ID: 24866
| Seq. Order: | 5 |
|---|---|
| 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: 24867
| Seq. Order: | 6 |
|---|---|
| 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: 24868
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Owner's share of the revenue. |
| General Data Type: | VARCHAR2 |
OWNER_SHARE_PERCENT
CC ID: 24869
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Owner Share Percent |
| General Data Type: | VARCHAR2 |
CAPTAIN_SHARE
CC ID: 24870
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captain's share of the revenue. |
| General Data Type: | VARCHAR2 |
CAPTAIN_SHARE_PERCENT
CC ID: 24871
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Captain Share Percent |
| General Data Type: | VARCHAR2 |
AVG_CREW_SHARE
CC ID: 24872
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| 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: 24873
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Average Crew Share Percent |
| General Data Type: | VARCHAR2 |
FUEL_USED
CC ID: 24874
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Amount Of Fuel Used |
| General Data Type: | VARCHAR2 |
FUEL_UNIT_PRICE
CC ID: 24875
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fuel Unit Price |
| General Data Type: | VARCHAR2 |
FUEL_MSU
CC ID: 24876
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Units used to represent the amount of fuel. |
| General Data Type: | VARCHAR2 |
FUEL_COST
CC ID: 24877
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cost of the fuel. |
| General Data Type: | VARCHAR2 |
BAIT_WEIGHT
CC ID: 24878
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight of the bait. |
| General Data Type: | VARCHAR2 |
BAIT_UNIT_PRICE
CC ID: 24879
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Bait Unit Price |
| General Data Type: | VARCHAR2 |
BAIT_MSU
CC ID: 24880
| Seq. Order: | 19 |
|---|---|
| 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_COUNT
CC ID: 24881
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
How many units of bait were used |
| General Data Type: | VARCHAR2 |
BAIT_COST
CC ID: 24882
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cost of bait purchased. |
| General Data Type: | VARCHAR2 |
BAIT2_WEIGHT
CC ID: 24883
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight Of Secondary/Second Bait |
| General Data Type: | VARCHAR2 |
BAIT2_UNIT_PRICE
CC ID: 24884
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Secondary /Second Bait Unit Price |
| General Data Type: | VARCHAR2 |
BAIT2_MSU
CC ID: 24885
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Measured Standard Units For Seconday/second Bait |
| General Data Type: | VARCHAR2 |
BAIT2_COUNT
CC ID: 24886
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| 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: 24887
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Secondary/Second Bait Cost |
| General Data Type: | VARCHAR2 |
ICE_WEIGHT
CC ID: 24888
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Weight of ice purchased. |
| General Data Type: | VARCHAR2 |
ICE_UNIT_PRICE
CC ID: 24889
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Ice Unit Price |
| General Data Type: | VARCHAR2 |
ICE_MSU
CC ID: 24890
| Seq. Order: | 29 |
|---|---|
| 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_COUNT
CC ID: 24891
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Quantity of Ice Used |
| General Data Type: | VARCHAR2 |
ICE_COST
CC ID: 24892
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cost of ice |
| General Data Type: | VARCHAR2 |
ICE_TIME_FRAME
CC ID: 24893
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Time Frame For Ice To Last |
| General Data Type: | VARCHAR2 |
LIGHT_STICK_NUMBER
CC ID: 24894
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of light sticks used. |
| General Data Type: | VARCHAR2 |
COST_PER_LIGHT_STICK
CC ID: 24895
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cost of each light stick. |
| General Data Type: | VARCHAR2 |
FREIGHT_COST
CC ID: 24896
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Cost of freight. |
| General Data Type: | VARCHAR2 |
DOCKING_UNLOADING_FEE
CC ID: 24897
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Docking Unloading Fee. |
| General Data Type: | VARCHAR2 |
TACKLE_GEAR_EXPENSES
CC ID: 24898
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Tackle Gear Expenses |
| General Data Type: | VARCHAR2 |
GROCERIES_EXPENSES
CC ID: 24899
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total cost of groceries used during the trip. |
| General Data Type: | VARCHAR2 |
OTHER_EXPENSES
CC ID: 24900
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Other Expenses |
| General Data Type: | VARCHAR2 |
TOTAL_SHARE_COST
CC ID: 24901
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total Share Cost |
| General Data Type: | VARCHAR2 |
TOTAL_TRIP_COST
CC ID: 24902
| Seq. Order: | 41 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 8 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total expenses for the trip. |
| General Data Type: | VARCHAR2 |
FORMTYPE
CC ID: 24903
| Seq. Order: | 42 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 9 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicates version of data entry form |
| General Data Type: | VARCHAR2 |
SOURCE_FILE
CC ID: 24904
| Seq. Order: | 43 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 50 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Name Of File that loaded this data |
| General Data Type: | VARCHAR2 |
PERSON_ID
CC ID: 24905
| Seq. Order: | 44 |
|---|---|
| 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: 24906
| Seq. Order: | 45 |
|---|---|
| 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: 24907
| Seq. Order: | 46 |
|---|---|
| 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 |
TRIP_GROCERY_EXPENSE
CC ID: 24908
| Seq. Order: | 47 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Grocery Expenses Per Trip |
| General Data Type: | NUMBER |
MISC_EXPENSE
CC ID: 24909
| Seq. Order: | 48 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 4 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Miscellaneous Expenses Per Trip |
| General Data Type: | NUMBER |
TOTAL_TRIP_REVENUE
CC ID: 24910
| Seq. Order: | 49 |
|---|---|
| Data Storage Type: | NUMBER |
| Max Length: | 22 |
| Required: | No |
| Primary Key: | No |
| Precision: | 6 |
| Scale: | 0 |
| Status: | Active |
| Description: |
Total Trip Revenue |
| General Data Type: | NUMBER |
Catalog Details
| Catalog Item ID: | 6870 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:6870 |
| 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 |