6858 EDC_SET_COST_DATA_EXT_VW Entity Published / External 6802 SSRG Socioeconomic Panel Data Set Completed View Used That Enables The Download Of Trip Cost Data In one file/table Loaded by batch 2043, 12-20-2007 08:10 Data View Yes FLS View Used That Enables The Download Of Trip Cost Data In one file/table 1 LOGBOOK_KEY NUMBER 22 Yes No 10 0 Active Automatic sequence that links all the tables that hold information related to trips. NUMBER 2 BATCH_NUMBER VARCHAR2 10 No No Active The batch number is the number of the batch where the trip was processed. VARCHAR2 3 SCHEDULE_NUMBER VARCHAR2 10 Yes No Active A number stamped on each logbook form. VARCHAR2 4 VESSEL_ID VARCHAR2 10 Yes No Active Vessel Identifier VARCHAR2 5 VESSEL_NAME VARCHAR2 30 No No Active Name of the vessel that matches the vessel id. VARCHAR2 6 TELEPHONE VARCHAR2 15 No No Active Phone number that appears on the logbook. VARCHAR2 7 DAYS_AWAY VARCHAR2 40 No No Active Number of days from, departure to landing, the vessel was away from port. VARCHAR2 8 START_DATE VARCHAR2 8 No No Active Start Date Of Fishing Trip VARCHAR2 9 NUMBER_OF_CREW VARCHAR2 40 No No Active Number of personnel engaged in fishing during the trip. VARCHAR2 10 UNLOAD_DATE VARCHAR2 8 No No Active Unload Date VARCHAR2 11 TRIP_TICKET VARCHAR2 12 No No Active Trip Ticket Number VARCHAR2 12 ICE_MSU VARCHAR2 5 No No Active Measurement unit for the amount of ice used.Domain: TONS, BLOCK, POUND, UNKN (Unknown) VARCHAR2 13 OWNER_SHARE_PERCENT VARCHAR2 40 No No Active Owner Share Percent VARCHAR2 14 CAPTAIN_SHARE_PERCENT VARCHAR2 40 No No Active Captain Share Percent VARCHAR2 15 AVG_CREW_SHARE_PERCENT VARCHAR2 40 No No Active Average Crew Share Percent VARCHAR2 16 FUEL VARCHAR2 40 No No Active Amount Of Fuel Used VARCHAR2 17 FUEL_UNIT_PRICE VARCHAR2 40 No No Active Fuel Unit Price VARCHAR2 18 BAIT_WEIGHT VARCHAR2 40 No No Active Bait Weight VARCHAR2 19 BAIT_COUNT VARCHAR2 40 No No Active How many units of bait were used VARCHAR2 20 BAIT_COST VARCHAR2 40 No No Active Bait Cost Per Weight VARCHAR2 21 ICE_UNIT_PRICE VARCHAR2 40 No No Active Ice Unit Price VARCHAR2 22 ICE_COUNT VARCHAR2 40 No No Active Quantity of Ice Used VARCHAR2 23 ICE_COST VARCHAR2 40 No No Active Cost of ice VARCHAR2 24 LIGHT_STICK_NUMBER VARCHAR2 40 No No Active Number of light sticks used. VARCHAR2 25 COST_PER_LIGHT_STICK VARCHAR2 40 No No Active Cost of each light stick. VARCHAR2 26 GROCERIES_EXPENSES VARCHAR2 40 No No Active Total cost of groceries used during the trip. VARCHAR2 27 OTHER_EXPENSES VARCHAR2 40 No No Active Other Expenses VARCHAR2 28 TOTAL_SHARE_COST VARCHAR2 40 No No Active Total Share Cost VARCHAR2 29 TOTAL_TRIP_COST VARCHAR2 40 No No Active Total expenses for the trip. VARCHAR2 30 BROKER_PERCENT VARCHAR2 40 No No Active Broker Percent VARCHAR2 31 PERSON_ID NUMBER 22 No No 38 Active Person ID. By Cassio on 6/2/2006 - For EDC NUMBER 32 CHANGE_REASON_ID NUMBER 22 No No 38 Active Key to why reason was changed. By Cassio on 6/2/2006 - For EDC NUMBER 33 LU DATE 7 No No Active When Records was last updated By Cassio on 6/2/2006 - For EDC DATE 34 TABLE_NAME CHAR 9 No No Active Which Table Serves As a Source For This Record CHAR 35 GEAR_CODE_NMFS VARCHAR2 5 Yes No Active NMFS Gear Code VARCHAR2 36 STATE_CODE_NMFS VARCHAR2 2 Yes No Active NMFS State Code VARCHAR2 37 COUNTY_CODE_NMFS VARCHAR2 3 Yes No Active NMFS County Code VARCHAR2 gov.noaa.nmfs.inport:6858 Lee Weinberger 2007-12-20T08:10:54 SysAdmin InPortAdmin 2022-08-09T17:10:59 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