{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["updated list 2026.01.21"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"updated list 2026.01.21","index":0,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["FVT Field Headers"]
["*Requirements may differ based on agency and/or species"]
["Report Section","File Upload Heading","Definition","Required?","Example Data","TYPE"]
["REPORT","DEALER_TICKET_NO","The unique ticket number from the dealer's system","Y","\"Capt Ryan2026/01/31\", \"20251225DOE,JOHN\"","CORE"]
["REPORT","DATE_OF_PUR","Date that the product was purchased","Y","\"1/31/2026\"","CORE"]
["REPORT","DATE_LANDED","Date that the product was landed",null,"\"1/31/2026\"","CORE"]
["REPORT","VESSEL","Dealer's code used to identify the vessel","Y*","\"Bill's Boat\", \"SEAWOLF\"","CORE"]
["REPORT","VESSEL_REGISTRATION","Vessel US Coast Guard doc or state-registration number","Y*","\"1234567\", \"FL123456\"","CORE"]
["REPORT","PORTLANDED","Dealer's code used to identify port code of landing","Y","\"POINT JUDITH\", \"Yarmouth\"","CORE"]
["REPORT","DEALER_CF_CODE","Dealer's code used to identify the fisherman","Y","\"Capt Ryan\", \"SMITH, JOHN 1234\"","CORE"]
["REPORT","VTRSERNO","VTR number",null,"\"12345626013109\"","CORE"]
["REPORT","TIMELAND","Time of day that product was landed",null,"\"0900\", \"1630\"","ATTRIBUTE"]
["REPORT","REPORT_TYPE","Finfish, Shellfish, Other",null,"\"FIN\", \"SHE\", \"NOR\"","ATTRIBUTE"]
["REPORT","OBSERVER_LOG_ID","Number from observer log",null,"\"XY123\"","ATTRIBUTE"]
["REPORT","TRIP_START_DATE","The date the fishing trip started",null,"\"1/31/2026\"","ATTRIBUTE"]
["REPORT","TRIP_START_TIME","The time the fishing trip started",null,"\"0900\", \"1630\"","ATTRIBUTE"]
["LANDING","SPECIES","Dealer's code used to describe a species, unit of measure, grade, and market combination","Y*","\"Softshell Jumbo\", \"SQUID L\",  \"LG FLUKE\"","CORE"]
["LANDING","SPECIES_ITIS","Code that serves as taxonomic classification of animal","Y*","\"123456\"","CORE"]
["LANDING","UNIT_MEASURE","Measurement code (LB, BU, etc.)","Y*","\"LB\", \"BU\", \"MP\"","CORE"]
["LANDING","MARKET_CODE","Abbreviated code for market (jumbo, large, small, etc - size)","Y*","\"LG\", \"MX\", \"S2\", \"UN\"","CORE"]
["LANDING","GRADE_CODE","Code for grade (round, head, tails, etc)","Y*","\"01\",  \"04\", \"09\", \"00\"","CORE"]
["LANDING","REPORTED_QUANTITY","Quantity reported based on the reported unit of measurement","Y","\"100\"","CORE"]
["LANDING","DOLLARS","Total value in dollars","Y*","\"650\", \"57.33\"","CORE"]
["LANDING","PRICE","Price in dollars per unit reported ","Y*","\"1.23\", \"0.90\"","CORE"]
["LANDING","DISPOSITION_CODE","Abbreviated disposition code (Food, Personal Use, No Market)","Y","\"001\", \"002\", \"101\"","CORE"]
["LANDING","DEALER_CATCH_SOURCE","Dealer's code used to identify source of the landing (Standard, For Hire, Carred, Aquaculture, Research Set Aside)",null,"\"S\", \"H\", \"C\", \"A\", \"R\"","CORE"]
["LANDING","DEALER_AREA_CODE","Dealer's code used to identify the NOAA Statistical fishing area combination",null,"\"SC55\", \"N4\", \"10613\"","ATTRIBUTE"]
["LANDING","AREA_FISHED","NOAA Statistical fishing area code",null,"\"621\", \"000\"","ATTRIBUTE"]
["LANDING","SUB_AREA_FISHED","SubArea Code for where animals were caught",null,"\"0108\", \"0000\"","ATTRIBUTE"]
["LANDING","LOCAL_AREA","Local area code where animals were caught supplied by state, usually shellfish areas",null,"\"N4\", \"00\"","ATTRIBUTE"]
["LANDING","NBR_FISH","Number of animals landed",null,"\"12\"","ATTRIBUTE"]
["LANDING","TEMP_AT_RECEIVING","Temperature of shellfish at receiving - Dept of Public Health",null,"\"33.9\", \"36\"","ATTRIBUTE"]
["LANDING","TEMP_UNIT","Celsius or Farenheit - Dept of Public Health",null,"\"F\", \"C\"","ATTRIBUTE"]
["LANDING","TIME_OF_HARVEST","Time of shellfish harvest - Dept Public Health",null,"\"08:30\"","ATTRIBUTE"]
["LANDING","TIME_OF_ICING","Time of shellfish icing - Dept of Public Health",null,"\"09:15\"","ATTRIBUTE"]
["LANDING","DEALER_GEAR_CODE","Dealer's code used to describe a gear",null,"\"ROD AND REEL\", \"TRAWL\", \"LBST PTS\"","ATTRIBUTE"]
["LANDING","GEAR_CODE","ACCSP gear code",null,"\"300\", \"090\", \"160\"","ATTRIBUTE"]
["LANDING","FISHING_HOURS","Total amount of time the gear was in the water. Do not include time spent traveling to fishing grounds.",null,"\"4\"","ATTRIBUTE"]
["LANDING","HOURS_DAYS_FLAG","Units of Hours or Days for Fishing Time",null,"\"H\", \"D\"","ATTRIBUTE"]
["LANDING","LEASE_NUM","Shellfish lease number",null,"\"12345\"","ATTRIBUTE"]
["LANDING","BFT_AREA_CODE","HMS area where animal was caught (ex. Cape Hatteras to Key West, Eastham to Aquinnah)",null,"\"8\", \"5\", \"3\"","ATTRIBUTE"]
["LANDING","DESTINATION_CODE","Export or US Domestic",null,"\"X\", \"U\"","ATTRIBUTE"]
["LANDING","SPECIES_LENGTH","Length in inches",null,"\"123\"","ATTRIBUTE"]
["LANDING","MEASURE_TYPE","Fin or Snout",null,"\"1\", \"7\"","ATTRIBUTE"]
["LANDING","TAG_PREFIX","Bluefin Tuna Tag prefix",null,"\"BT05\", \"BT80\", \"BT90\"","ATTRIBUTE"]
["LANDING","TAG_NBR","Individual tag number",null,"\"0012345\"","ATTRIBUTE"]
["LANDING","COLOR","A, B, or C",null,"\"A, \"B\", \"C\"","ATTRIBUTE"]
["LANDING","FAT","A, B, or C",null,"\"A, \"B\", \"C\"","ATTRIBUTE"]
["LANDING","FRESHNESS","A, B, or C",null,"\"A, \"B\", \"C\"","ATTRIBUTE"]
["LANDING","SHAPE","A, B, or C",null,"\"A, \"B\", \"C\"","ATTRIBUTE"]
["LANDING","PECAT_ID","Permit Category",null,"\"INLL, \"GENRR\", \"HARPN\"","ATTRIBUTE"]
["LANDING","PECAT_ORIGIN","PeCat origin",null,"\"1\", \"0\"","ATTRIBUTE"]
["LANDING","SALE_NATURE_CODE","Consignment or Dockside",null,"\"C\", \"D\"","ATTRIBUTE"]
["LANDING","DEALER_HMS_CATCH_AREA","HMS Area Code for where animals were caught",null,"\"BF51\", \"BF60\"","ATTRIBUTE"]
["LANDING","HOW_FINS_ATTACHED","Are the fins attached to the shark? (Y/N)",null,"\"Y\", \"N\"","ATTRIBUTE"]
["LANDING","WHY_FINS_NOT_ATTACHED","If fins are not attached naturally, then why?",null,"\"Removed at packout\", \"Weighed Separately\"","ATTRIBUTE"]
["LANDING","SALE_PRICE","HMS Sale Price",null,"\"123.45\", \"650\"","ATTRIBUTE"]
["LANDING","LATE_REPORT_EXPLANATION","Reason the VTR is late",null,"\"Holiday\", \"Please forgive me\"","ATTRIBUTE"]
["LANDING","MODIFIED_DATA_EXPLANATION","Reason the VTR is modified",null,"\"Price update\", \"duplicate report\"","ATTRIBUTE"]