Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Social Science Research Group Projects > Trip Cost Data > SSRG Socioeconomic Panel >

Table: FLS_INT_SCANNED_COSTS

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:6870  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Physical Location
Entity Info
Data Attributes
Catalog Details

Summary

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.

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.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
LOGBOOK_KEY
NUMBER 		Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described.
SCHEDULE_NUMBER
VARCHAR2 		Sequence Number On Paper Form
VESSEL_ID
VARCHAR2 		Vessel Identifier (either state or federal)
BATCH_NUMBER
VARCHAR2 		Batch 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_USED
VARCHAR2 		Amount Of Fuel Used
FUEL_UNIT_PRICE
VARCHAR2 		Fuel Unit Price
FUEL_MSU
VARCHAR2 		Units used to represent the amount of fuel.
FUEL_COST
VARCHAR2 		Cost of the fuel.
BAIT_WEIGHT
VARCHAR2 		Weight of the bait.
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_COUNT
VARCHAR2 		How many units of bait were used
BAIT_COST
VARCHAR2 		Cost of bait purchased.
BAIT2_WEIGHT
VARCHAR2 		Weight Of Secondary/Second Bait
BAIT2_UNIT_PRICE
VARCHAR2 		Secondary /Second Bait Unit Price
BAIT2_MSU
VARCHAR2 		Measured Standard Units For Seconday/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_MSU
VARCHAR2 		Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown)
ICE_COUNT
VARCHAR2 		Quantity of Ice Used
ICE_COST
VARCHAR2 		Cost of ice
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.
FREIGHT_COST
VARCHAR2 		Cost of freight.
DOCKING_UNLOADING_FEE
VARCHAR2 		Docking Unloading Fee.
TACKLE_GEAR_EXPENSES
VARCHAR2 		Tackle Gear Expenses
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.
FORMTYPE
VARCHAR2 		Indicates version of data entry form
SOURCE_FILE
VARCHAR2 		Name Of File that loaded this data
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
TRIP_GROCERY_EXPENSE
NUMBER 		Grocery Expenses Per Trip
MISC_EXPENSE
NUMBER 		Miscellaneous Expenses Per Trip
TOTAL_TRIP_REVENUE
NUMBER 		Total Trip Revenue

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: 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

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
 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