6870 FLS_INT_SCANNED_COSTS Entity Published / External 6802 SSRG Socioeconomic Panel Data Set Completed 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. Loaded by batch 2043, 12-20-2007 08:10 Southeast Fisheries Science Center Miami FL USA Data Table Yes FLS 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. 1 LOGBOOK_KEY NUMBER 22 No No 10 0 Active Foreign key to the FLS_TRIPS table, thus identifying the trip which costs are being described. NUMBER 2 SCHEDULE_NUMBER VARCHAR2 10 No No Active Sequence Number On Paper Form VARCHAR2 3 VESSEL_ID VARCHAR2 12 No No Active Vessel Identifier (either state or federal) VARCHAR2 4 BATCH_NUMBER VARCHAR2 10 No No Active Batch Number VARCHAR2 5 OWNER_ABOARD VARCHAR2 1 No No Active Was the Owner Aboard? VARCHAR2 6 OWNER_SALARY_INCLUDED VARCHAR2 1 No No Active Was the owner's salary included? VARCHAR2 7 OWNER_SHARE VARCHAR2 8 No No Active Owner's share of the revenue. VARCHAR2 8 OWNER_SHARE_PERCENT VARCHAR2 8 No No Active Owner Share Percent VARCHAR2 9 CAPTAIN_SHARE VARCHAR2 8 No No Active Captain's share of the revenue. VARCHAR2 10 CAPTAIN_SHARE_PERCENT VARCHAR2 8 No No Active Captain Share Percent VARCHAR2 11 AVG_CREW_SHARE VARCHAR2 8 No No Active Average share for the revenue for crew members. VARCHAR2 12 AVG_CREW_SHARE_PERCENT VARCHAR2 8 No No Active Average Crew Share Percent VARCHAR2 13 FUEL_USED VARCHAR2 5 No No Active Amount Of Fuel Used VARCHAR2 14 FUEL_UNIT_PRICE VARCHAR2 8 No No Active Fuel Unit Price VARCHAR2 15 FUEL_MSU VARCHAR2 5 No No Active Units used to represent the amount of fuel. VARCHAR2 16 FUEL_COST VARCHAR2 8 No No Active Cost of the fuel. VARCHAR2 17 BAIT_WEIGHT VARCHAR2 5 No No Active Weight of the bait. VARCHAR2 18 BAIT_UNIT_PRICE VARCHAR2 8 No No Active Bait Unit Price VARCHAR2 19 BAIT_MSU VARCHAR2 5 No No Active Measurement uint in which the bait was weighed.Domain: G - Grams OZ - Ounces LB - Pounds KG - Kilograms T - Tons VARCHAR2 20 BAIT_COUNT VARCHAR2 5 No No Active How many units of bait were used VARCHAR2 21 BAIT_COST VARCHAR2 8 No No Active Cost of bait purchased. VARCHAR2 22 BAIT2_WEIGHT VARCHAR2 5 No No Active Weight Of Secondary/Second Bait VARCHAR2 23 BAIT2_UNIT_PRICE VARCHAR2 8 No No Active Secondary /Second Bait Unit Price VARCHAR2 24 BAIT2_MSU VARCHAR2 5 No No Active Measured Standard Units For Seconday/second Bait VARCHAR2 25 BAIT2_COUNT VARCHAR2 5 No No Active How Many Units Of second/secondary bait were used VARCHAR2 26 BAIT2_COST VARCHAR2 8 No No Active Secondary/Second Bait Cost VARCHAR2 27 ICE_WEIGHT VARCHAR2 5 No No Active Weight of ice purchased. VARCHAR2 28 ICE_UNIT_PRICE VARCHAR2 8 No No Active Ice Unit Price VARCHAR2 29 ICE_MSU VARCHAR2 5 No No Active Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) VARCHAR2 30 ICE_COUNT VARCHAR2 5 No No Active Quantity of Ice Used VARCHAR2 31 ICE_COST VARCHAR2 8 No No Active Cost of ice VARCHAR2 32 ICE_TIME_FRAME VARCHAR2 8 No No Active Time Frame For Ice To Last VARCHAR2 33 LIGHT_STICK_NUMBER VARCHAR2 4 No No Active Number of light sticks used. VARCHAR2 34 COST_PER_LIGHT_STICK VARCHAR2 8 No No Active Cost of each light stick. VARCHAR2 35 FREIGHT_COST VARCHAR2 8 No No Active Cost of freight. VARCHAR2 36 DOCKING_UNLOADING_FEE VARCHAR2 8 No No Active Docking Unloading Fee. VARCHAR2 37 TACKLE_GEAR_EXPENSES VARCHAR2 8 No No Active Tackle Gear Expenses VARCHAR2 38 GROCERIES_EXPENSES VARCHAR2 8 No No Active Total cost of groceries used during the trip. VARCHAR2 39 OTHER_EXPENSES VARCHAR2 8 No No Active Other Expenses VARCHAR2 40 TOTAL_SHARE_COST VARCHAR2 8 No No Active Total Share Cost VARCHAR2 41 TOTAL_TRIP_COST VARCHAR2 8 No No Active Total expenses for the trip. VARCHAR2 42 FORMTYPE VARCHAR2 9 No No Active Indicates version of data entry form VARCHAR2 43 SOURCE_FILE VARCHAR2 50 No No Active Name Of File that loaded this data VARCHAR2 44 PERSON_ID NUMBER 22 No No 38 Active Person ID. By Cassio on 6/2/2006 - For EDC NUMBER 45 CHANGE_REASON_ID NUMBER 22 No No 38 Active Key to why reason was changed. By Cassio on 6/2/2006 - For EDC NUMBER 46 LU DATE 7 No No Active When Records was last updated By Cassio on 6/2/2006 - For EDC DATE 47 TRIP_GROCERY_EXPENSE NUMBER 22 No No 4 0 Active Grocery Expenses Per Trip NUMBER 48 MISC_EXPENSE NUMBER 22 No No 4 0 Active Miscellaneous Expenses Per Trip NUMBER 49 TOTAL_TRIP_REVENUE NUMBER 22 No No 6 0 Active Total Trip Revenue NUMBER gov.noaa.nmfs.inport:6870 Lee Weinberger 2007-12-20T08:10:55 SysAdmin InPortAdmin 2022-08-09T17:10:58 2021-05-07 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No 2021-05-07 1 Year 2022-05-07