6 Apportionment
6.1 Description
Federal landing data come from multiples sources including federal dealers and Vessel Trip Reports (VTR). Landings data from dealers are considered the most accurate measurements of sold catch in the greater Atlantic region but they do not have location, gear, or effort information. Landings from VTR are generally less precise, on-vessel estimates but include information about fishing location, gear, mesh, and effort. The objective of the dealer apportionment process is to split each trip-level dealer record across the associated subtrips (AREA-GEAR-MESH).
CAMS trip apportionment integrates Vessel Trip Report (VTR) catch and dealer reported landings from the Commercial Fisheries Dealer Electronic Reports System (CFDERS). It uses the CAMS matching tables 3 to define the relationship between VTR trips and CFDERS transactions. For records that match at the trip and species group levels (CAMSID-ITIS_GROUP1; STATUS = ‘MATCH’), the dealer-reported landed pounds, live pounds, and dollar values are apportioned into individual VTR subtrips proportional to landings reported on the VTR (VTR kept converted to VTR live pounds). Dealer transactions and VTR trips without a corresponding match between one another are considered orphans. Additionally, within matched trips, individual species records can be orphaned if the species is not reported in both dealer and VTR sources. VTR species orphans are assigned to the subtrip they were reported. Dealer species orphans (STATUS = ’DLR_ORPHAN_SPECIES) are apportioned to VTR subtrips according to the NTRIPS method, which is proportional to the days fished (DF) effort reported on the VTR (including imputations of DF for VTR subtrips when missing).
The apportioned landings and values (LNDLB, LIVLB, and VALUE) that round down to zero for a record are rounded up to one. This happens for thousands of records resulting in an increase in total pounds and totals on those subtrips. To minimized this, the subtrip with the highest live pounds for any species that rounded up from zero are rounded down by an equal amount. This is done for all records unless the rounding down results in less than one pound or dollar. True zeros are left as zero, e.g., those coming from No Catch (status = ‘VTR_NO_CATCH’) and discard-only (status = ‘VTR_DISCARD’).
6.3 Example of dealer apportionment
Figure 6.1: An example of apportioning dealer discards across VTR subtrips and the results when species occur only in the dealer record (status = DLR_ORPHAN_SPECIES) and only in the VTR report (status = VTR_ORPHAN_SPECIES).
6.4 Mixed Hake Apportionment
After subtrip apportionment, any landings reported as mixed hake are apportioned into the individual species. This is currently done for mixed red/white hake (ITIS = 164729; genus = Urophycis) into Atlantic red hake (164730; Urophycis chuss) and Atlantic white hake (164732; Urophycis tenuis). This mix is not split into spotted hake or southern hake, despite being in the same genus, because the proportions on any mixed trip would result in estimates near zero and spotted hake tend to be identifiable when mixed with red and white hake. Additionally, the VTR data entry specifies the mix as red/white rather than red/white/spotted/southern.
Similarly, mixed silver/offshore hake (ITIS_TSN = 164790; genus = Merluccius) records are split into offshore hake (164793; Merluccius albidus) and silver hake (164791; Merluccius bilinearis), also commonly known as whiting.
Although done independently, both mixed hake apportionments use the same stratification process. The proportion landings of each of the individual species is calculated by year, hake stock region, and mesh category. Those proportions are applied to all matching subtrips with reported mixed take to split the mixed hake into the individual species. This doubles the rows from the original mixed species record but totals the same pounds just split by full, individual species. The intent is to have no mixed hake records in the final CAMS end user tables.
6.5 Additional trip attributes
CAMS adds additional trip-level attributes after the apportionment process. These value-added attributes are intended to support discard estimation and end users. These attributes are primary from declarations, pretrip hails, and similar sources to indicate exceptions from particular gear or area regulations that can lead to differences in fishing and discard behavior.
For example, the 71-30 exception is a late 2022 addition to these exemptions as part of groundfish Amendment 23. Groundfish vessels can declare a 71-30 exemption as part of their start hail. This excludes sector trips fished in their entirety west of \(71^o30'\) W Longitude from the at-sea monitoring (ASM) requirement. CAMS assumes trips fished west of \(71^o30'\) W are exempt even if the start-hail exception is missing (e.g. data mismatch, not yet received, etc.). In CAMS, this rule applies to all trips landing on or after 2022-12-15.
The additional trip attribute tables carried through are:
| COLUMN_NAME | DESCRIPTION |
|---|---|
| ACCESSAREA | Scallop Access Area, only relevant for scallop trips |
| ACTIVITY_CODE_1 | VMS declaration |
| ACTIVITY_CODE_2 | VMS declaration, if more than one/trip |
| ACTIVITY_CODE_3 | VMS declaration, if more than one/trip |
| CLOSED_AREA_EXEMPTION | Groundfish specific stratification |
| EM | EM program, groundfish trips only |
| EXEMPT_7130 | Logical 0/1 whether a groundfish trip was granted the exception for fishing west of 71 degrees 30 minutes. |
| REDFISH_EXEMPTION | Exemption fishing under |
| SECTID | Groundfish Sector ID number |
| SNE_SMALLMESH_EXEMPTION | Exemption fishing under |
| TRIPCATEGORY | Scallop fleet designation, if applicable |
| XLRG_GILLNET_EXEMPTION | Exemption fishing under |
6.6 End user landings tables
End user tables are produced after all the landings data are processed, joined, and apportioned.The primary landings table is CAMS_LAND. Subtrip information associated with these records are found in CAMS_SUBTRIP. This table has one row per subtrip and can be joined to CAMS_LAND by CAMSID and SUBTRIP. Additionally, primary and other fishery target groups can be found in CAMS_FISHERY_GROUP which has one row per subtrip. Recreational data indicated on the VTR (recreational/party/charter) that are not sold to a dealer are separated into their own table CAMS_VTR_REC. Sometimes tuna and other species are sold from recreational trips, making those records then commercial. The format of this table is identical to CAMS_LAND and can be unioned as needed. Similarly, VTR trip-level mismatches (status = ‘VTR_ORPHAN_TRIPS’) are considered either preliminary until dealer reports are entered or bad data that might be duplication of dealer trip orphans (status = ‘DLR_ORPHAN_TRIPS’) and are therefore not included in the official record of landings in CAMS_LAND. These VTR trip orphans are separated into their own identical table, CAMS_VTR_ORPHANS and the associated subtrips in CAMS_VTR_ORPHANS_SUBTRIP. All landings tables run from 1996 - present. Information about the updating of years of landings data can be found in CAMS_LANDINGS_METADATA. More information about these tables can be found below:
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMS_LAND_ID | CHAR | |
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| DOCID | VARCHAR2 | Document ID from VTR. One per trip regardless of number of subtrips. |
| VTRSERNO | VARCHAR2 | A unique serial number used to identify a vessel trip report. NULL = Unknown |
| DATE_TRIP | DATE | Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer |
| DLR_DATE | DATE | Date of the dealer transaction. |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| MONTH | NUMBER | The numeric month (1-12) of the vessel landing or negative dealer report. |
| WEEK | NUMBER | Week of the year. |
| DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 0=Unknown. NULL = Not applicable for VTR records not sold to dealer (e.g. Bait-Home-Consumption). Indicated with STATUS = VTR_NOT_SOLD. |
| DLR_STID | VARCHAR2 | State Dealer License Number |
| PERMIT | VARCHAR2 | Vessel permit number assigned by the Northeast Regional Offices Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. 490998=Unknown |
| DLR_CFLIC | VARCHAR2 | Commercial fisherman license issued by a State reported by the dealer in CFDERS. |
| PERMIT_STATE_FED | VARCHAR2 | Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000) |
| STATE | VARCHAR2 | Two character US state abbreviation based on PORT as related in the CFG_PORT table. The first two digits from the port code are used for assignment when the PORT is missing in the CFG_PORT table. The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. |
| PORT | VARCHAR2 | A combined code for state, port and county. Taken with priority from CFDERS -> VTR PORT1 -> PRINC_PORT (permit data). Unknown = 990999. Named ports in VTR are converted to port numbers using the trip_reports.vlporttbl table. |
| BHC | VARCHAR2 | Logical indicator column of whether the VTR indicated the catch was for either bait or home consumption. 0 = FALSE, 1 = TRUE. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| DLR_RPTID | VARCHAR2 | Confirmation number that identifies the record and is given to the dealer. |
| DLR_DOCN | VARCHAR2 | Number assigned to each weighout form, or negative dealer report; Unique within a month. |
| DLR_UTILCD | VARCHAR2 | The utilization code: 0=food fish or unknown; 2=aquaculture; 3=canned pet food (1984+); 4=Biomedical (2002+); 5=animal food (1984+); 7=bait; 8=industrial, other (2002+); 9=industrial, reduction. |
| DLR_SOURCE | VARCHAR2 | Source of the data: 0=Weighout, only (Non-Mandatory); 1=Weighout + Interview; 2=Weighout + Captains Log; 3=Weighout + Sea Sample Data; 4=Weighout + Foreign JV; 5=NEMFIS State Data (IWP); 6=Weighout + Domestic JV (IWP); 7=Mandatory Reporting; 8=Clam Logbook; 9=Tuna Logbook; 10=Estimated General Landings; 11=Estimated Mandatory Landings; 12=Vessel Trip Report, no Weighout; 13=Canadian Transhipment (OTS); 14=NMFS Enforcement; 15=State Enforcement |
| HULLID | VARCHAR2 | |
| DLR_TONCL | VARCHAR2 | The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. |
| FZONE | VARCHAR2 | The fishing zone in which sample was taken as determined from the VTR trip point location. 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown. |
| VTR_CATCHID | VARCHAR2 | Internal primary key. Oracle generated sequence for noaa.catch. |
| VTR_DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000 = Unknown. NULL = Not matched to a dealer record. Exceptions and special codes when not sold to a dealer: 00001 - Seized for Violations; 00002 - Sold to another vessel for bait or retained as bait; 00004 - Retained for future sale; 00005- Sold to a non-Federal dealer (non-Federally regulated species only); 00006 - Sub legal catch landed for research; 00007 - Legal catch landed for research (EFP trips only); 00008 - Landed, unmarketable catch (LUMF); 99998 - Used for home consumption |
| ITIS_TSN | VARCHAR2 | Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records. |
| ITIS_GROUP1 | VARCHAR2 | Actual grouping of ITIS TSN for apportionment |
| VTR_LBS_DISCARD | NUMBER | |
| VTR_COUNT_KEPT | NUMBER | |
| VTR_COUNT_DISCARD | NUMBER | |
| DLR_CATCH_SOURCE | VARCHAR2 | |
| DLR_MKT | VARCHAR2 | Market Code. As reported in CFDERS. |
| DLR_GRADE | VARCHAR2 | Dealer Grade. As reported in CFDERS. |
| DLR_DISP | VARCHAR2 | A code indicating the disposition of the catch. See CFDBS. SFDISP for the code descriptions. Rename of CFDERS column DISPOSITION_CODE |
| LNDLB | NUMBER | The pounds landed. |
| LIVLB | NUMBER | The live weight in pounds. |
| VALUE | NUMBER | The value of landed catch to the nearest dollar (U.S.) associated with the record. |
| LANDING_SOURCE | VARCHAR2 | Character ID for the source of the landing, live weight, and value: DLR or VTR when kept pounds are greater than zero, or DIS when landed pounds are zero but discarded pounds are greater than zero |
| STATUS | VARCHAR2 | Status of the matching record between CFDERS and VTR: MATCH = records fully match at the CAMSID-ITIS_GROUP1 level; DLR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 in CFDERS does not appear on the VTR; DLR_ORPHAN_TRIP = dealer trip with no matching VTR trip; VTR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 on the VTR does not appear on the CFDERS trip (these records were previously excluded from AA tables); VTR_ORPHAN_TRIP = VTR trip with no matching trip in CFDERS (these records were previously excluded from AA tables); VTR_NOT_SOLD = VTR records kept for bait-home-consumption and therefore not sold to the dealer and not in CFDERS (these records were previously excluded from AA tables); VTR_NO_CATCH = VTR records that do not match to dealer records with no landed pounds and no discards; VTR_DISCARD = VTR records that do not match to dealer records and have no landed pounds but discarded pounds are greater than zero; PZERO = Records where PERMIT = 000000. These are not included in the apportionment or imputation processes. |
| REC | VARCHAR2 | Indicator of recreational landings. 1 = recreational, 0 = commercial |
| AREA_HERR | VARCHAR2 | Herring management area. |
| NEMAREA | VARCHAR2 | The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. Unknown = 000. |
| AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = 000. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. |
| NEGEAR | VARCHAR2 | Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables. |
| VTR_MESH | NUMBER | The mesh size of gear used and reported on the VTR. |
| MESH_CAT | VARCHAR2 | The category of mesh size of gear for trawls and gillnets. Mesh categorized as LM >= 4.00 inches and 4.00 > SM >= 0.00 inches. Additionally, for gillnets (NEGEAR: 100, 105, 115, 117, 116) mesh greater than or equal to 8.0 inches receive an XL classification. Mesh is imputed for gill nets and otter trawls, otherwise NULL if MESH not reported on the VTR. |
| AREA_SOURCE | VARCHAR2 | Source of the area data: CAREA = calculated area from the VTR location data; AREA = area reported on the VTR; DLR = area reported by the dealer (SOURCE = 08); WHSE = area assigned by the ACCSP warehouse for SOURCE = 11; PORT = assigned the statistical area adjacent to the port of record using CFG_PORT_AREA; IMPUTE = imputed from VTR records. |
| AREA_IMP_METHOD | VARCHAR2 | Method or level of area imputation: YEAR-PERMIT-QUARTER-MAIN_SPP_GRP = B; YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2 = C; YEAR-PORT_GRP = D; YEAR-STATE = E. |
| AREA_PROP | NUMBER | If area imputed by stratification group (B, C, D, E), the proportion of subtrips fished in the imputed area across subtrips at that stratification level from VTR reporting area. |
| GEAR_SOURCE | VARCHAR2 | Source of the NEGEAR code: VTR = taken from the VTR gearcode and converted to NEGEAR using the CFG_VLGEAR table; WHSE = Taken from CFDERS for SOURCE = 11 as generated by the ACCSP warehouse; DLR = Taken from the dealer report; IMPUTE = imputed from VTR records; IMPUTE_STATE = imputed from dealer-reported NEGEAR for permit 000000 (state permits). |
| GEAR_IMP_METHOD | VARCHAR2 | Method or level of negear imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP. |
| NEGEAR_PROP | NUMBER | If NEGEAR imputed by stratification group (B, C, D, E), the proportion of subtrips fished with the imputed gear across subtrips at that stratification level. |
| MESH_SOURCE | VARCHAR2 | Source of the MESH_CAT: VTR = taken from the VTR MESH and converted to mesh category. IMPUTE = imputed from VTR-converted MESH_CAT; NULL if missing on the VTR or no matching VTR record. |
| MESH_IMP_METHOD | VARCHAR2 | Method or level of mesh category (MESH_CAT) imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP; F = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA-NEGEAR; G = YEAR-AREA-NEGEAR; H = YEAR-NEGEAR. |
| MESH_PROP | NUMBER | If MESH_CAT is imputed by stratification group (B, C, D, E, F, G, H), the proportion of subtrips fished with the imputed MESH_CAT across subtrips at that stratification level. |
| SECTID | VARCHAR2 | Groundfish Sector ID number |
| REGION | VARCHAR2 | Northern (N: area < 600), Southern (S: area >= 600), Other (area = 000) |
| DATE_RUN | DATE | Date the CAMS program was run to create the record |
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMS_SUBTRIP_ID | CHAR | |
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| PERMIT | VARCHAR2 | Vessel permit number assigned by the Northeast Regional Offices Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. 490998=Unknown |
| PERMIT_STATE_FED | VARCHAR2 | Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000) |
| DOCID | VARCHAR2 | Document ID from VTR. One per trip regardless of number of subtrips. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| VTRSERNO | VARCHAR2 | A unique serial number used to identify a vessel trip report. NULL = Unknown |
| AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = 000. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. |
| AREA_INSHORE | VARCHAR2 | State inshore areas as calculated from TRIP_REPORTS using the latitude and longitude of the VTR for that subtrip. |
| AREA_LOBSTER | VARCHAR2 | |
| NEGEAR | VARCHAR2 | Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables. |
| VTR_MESH | NUMBER | The mesh size of gear used and reported on the VTR. |
| MESH_CAT | VARCHAR2 | The category of mesh size of gear for trawls and gillnets. Mesh categorized as LM >= 4.00 inches and 4.00 > SM >= 0.00 inches. Additionally, for gillnets (NEGEAR: 100, 105, 115, 117, 116) mesh greater than or equal to 8.0 inches receive an XL classification. Mesh is imputed for gill nets and otter trawls, otherwise NULL if MESH not reported on the VTR. |
| N_SUBTRIP | NUMBER | Number of subtrips during the trip. A subtrip is defined as any change in area, gear, or mesh. Calculated after imputations. |
| RECORD_SAIL | DATE | Official sail date for the trip. |
| RECORD_LAND | DATE | Official landing date for the trip. Assigned with priority order of VTR, VMS, then DLR based on available data for the trip. |
| DATE_TRIP | DATE | Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| GF | VARCHAR2 | Indicator of whether the trip was classified as groundfish or not. 1 = groundfish trip. 0 = non-groundfish trip. |
| PERMIT_CLASS | VARCHAR2 | Based on VPS_PLAN for the permit: NOL = No Lobster Permit; LOP = Lobster permit and other federal permitted species; LOO = Lobster-only permit; NOP = no federal permitted species during the trip. |
| MAIN_SPP_GRP | VARCHAR2 | The main species group caught in a fishing trip: species group with the largest percentage of the total catch (live weight) on the subtrip. |
| MAIN_PORT_GRP | VARCHAR2 | The main port group on a fishing trip based on total pounds landed. |
| VTR_TRIPCATG | VARCHAR2 | Type of trip: Commercial (1), Party (2), Charter (3), Research Set-Aside (RSA)/ Experimental Fishing Permit (EFP) - deprecated (4), Letters of Acknowledgement Research (deprecated), Private Recreational or Headboat in some Apps (6). |
| VTR_CREW | NUMBER | The number of crew (including captain) as reported on the VTR. |
| VTR_DEPTH | NUMBER | The average depth to bottom, in fathoms, over the trip as reported on the VTR. |
| VTR_IMGID | NUMBER | VTR (noaa.images) Primary key. FVTR image identification number. Link to CATCH table. |
| VTR_ACTIVITY | VARCHAR2 | Numerica activity type from the VTR Document: 0 = Fishing trip with effort, 1 = Set Only Trip, 2 = Mechanical Breakdown, 3 = Turned around due to weather, 4 = Transiting Trip, 5 = Herring Carrier Vessel, 6 = Illness or Injury, 7 = Other (Entanglement, Good Samaritan, etc) 8 = Transit with product on board (as of 7/15/2015) |
| VTR_ACTIVITY_DESC | VARCHAR2 | VTR activity description associated with the numeric code: 0 = Fishing trip with effort, 1 = Set Only Trip, 2 = Mechanical Breakdown, 3 = Turned around due to weather, 4 = Transiting Trip, 5 = Herring Carrier Vessel, 6 = Illness or Injury, 7 = Other (Entanglement, Good Samaritan, etc) 8 = Transit with product on board (as of 7/15/2015) |
| VTR_GEAR_SIZE | NUMBER | Size of gear fished. If several gear sizes fished, enter average gear size used per haul. |
| VTR_GEAR_QTY | NUMBER | Quantity of gear being fished per haul. |
| LAT_DD | NUMBER | Latitude decimal degrees |
| LON_DD | NUMBER | Longitude decimal degrees |
| VES_LEN | NUMBER | Length of the vessel in feet from the permit system. |
| VES_GTONS | NUMBER | The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. |
| FMCODE | VARCHAR2 | Code to indicate mobile gear (M), Fixed gear (F), or other gear (O). Refer to CFG_NEGEAR for specific gear FMCODES. |
| EFFORT_IMP | VARCHAR2 | Indicator of effort imputation (0 = not imputed, 1 = imputed, NULL for permit 000000). Effort imputation done by lognormal Bayesian hierarchical modeling so no level indicated. |
| TRIP_DURATION | NUMBER | Length of trip calculated by RECORD_LAND - RECORD_SAIL. |
| TRIP_DURATION_Q25 | NUMBER | |
| TRIP_DURATION_Q75 | NUMBER | |
| DF | NUMBER | The total number of days gear is actually fished during fishing trip, in days (rounded to four decimal places). Does not include steam time. Prorated for subtrips. Estimated when missing indicated by the EFFORT_IMP column. Not estimated for Permit = 000000. NULL = unknown. |
| DF_Q25 | NUMBER | 25% of posterior for estimated DF. |
| DF_Q75 | NUMBER | 75% of posterior for estimated DF. |
| DA | NUMBER | For a trip, the total number of days absent from port in days as defined by TRUNC(date_land) - TRUNC(date_sail) + 1 (rounded to four decimal places). The value is estimated when missing (indicated by EFFORT_IMP column). For trips with multiple subtrips, DA is split proportional to the days fished (DF) for each subtrip. In the AA tables, for trips with catch sold to multiple dealers (multiple DOCN), DA for the subtrip is divided equally among transactions. |
| DA_Q25 | NUMBER | 25% of posterior probability for estimated DA. |
| DA_Q75 | NUMBER | 75% of posterior probability for estimated DA. |
| SECTID | VARCHAR2 | Groundfish Sector ID number |
| ACTIVITY_CODE_1 | VARCHAR2 | VMS declaration |
| ACTIVITY_CODE_2 | VARCHAR2 | VMS declaration, if more than one/trip |
| EM | VARCHAR2 | EM program, groundfish trips only |
| REDFISH_EXEMPTION | VARCHAR2 | Exemption fishing under |
| CLOSED_AREA_EXEMPTION | VARCHAR2 | Groundfish specific stratification |
| SNE_SMALLMESH_EXEMPTION | VARCHAR2 | Exemption fishing under |
| XLRG_GILLNET_EXEMPTION | VARCHAR2 | Exemption fishing under |
| EXEMPT_7130 | VARCHAR2 | Logical 0/1 whether a groundfish trip was granted the exception for fishing west of 71 degrees 30 minutes. |
| TRIPCATEGORY | VARCHAR2 | Scallop fleet designation, if applicable |
| ACCESSAREA | VARCHAR2 | Scallop Access Area, only relevant for scallop trips |
| GEARTYPE | VARCHAR2 | Gear description |
| SCALLOP_AREA | VARCHAR2 | Scallop Access ARea fished, scallop trips only |
| DATE_RUN | DATE | Date the CAMS program was run to create the record |
| STATE_WATERS | VARCHAR2 |
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| FISHERY_GROUP | VARCHAR2 | Primary targeted fishery group |
| DLR_RESEARCH | NUMBER | Research trip as indicated by dealer code starting with 8888 |
| RESEARCH | NUMBER | Research trip |
| NAFO | NUMBER | NAFO trip |
| GROUNDFISH | NUMBER | Groundfish trip |
| GROUND_ASSUMED | NUMBER | Assumed groundfish trip |
| SCALLOP | NUMBER | Subtrip targeting scallops |
| HERRING | NUMBER | Subtrip targeting herring |
| MONKFISH | NUMBER | Subtrip targeting monkfish |
| REDCRAB | NUMBER | Subtrip targeting redcrab |
| SURFCLAM | NUMBER | Subtrip targeting surf clams |
| TILEFISH | NUMBER | Subtrip targeting tilefish |
| MACKEREL | NUMBER | Subtrip targeting mackerel |
| LOLIGO | NUMBER | Subtrip targeting longfin squid |
| SQUID | NUMBER | Subtrip targeting squid |
| MISDECLARED | NUMBER | Groundfish trip potentially misdeclared on VMS |
| DOF | NUMBER | Subtrip declared out of fishery |
| PCHARTER_MULT | NUMBER | Subtrip by party or charter vessel catching multispecies |
| RECREATIONAL | NUMBER | Subtrip for recreational purposes |
| CARRIER | NUMBER | Herring carrier subtrip |
| SHRIMP | NUMBER | Subtrip targeting shrimp |
| LOBSTERCRAB | NUMBER | Subtrip targeting lobster or crab |
| WHELKCONCH | NUMBER | Subtrip targeting whelk or conch |
| HAGFISH | NUMBER | Subtrip targeting hagfish |
| MENHADEN | NUMBER | Subtrip targeting menhaden |
| FLUKE | NUMBER | Subtrip targeting fluke |
| SCUP | NUMBER | Subtrip targeting scup |
| WHITING | NUMBER | Subtrip targeting whiting |
| OUTSIDE | NUMBER | Subtrip outside of region |
| STATE_SUBTRIP | NUMBER | Subtrip by vessel in state waters operating under a state permit |
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMS_VTR_REC_ID | CHAR | |
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| DOCID | VARCHAR2 | Document ID from VTR. One per trip regardless of number of subtrips. |
| VTRSERNO | VARCHAR2 | A unique serial number used to identify a vessel trip report. NULL = Unknown |
| DATE_TRIP | DATE | Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer |
| DLR_DATE | DATE | Date of the dealer transaction. |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| MONTH | NUMBER | The numeric month (1-12) of the vessel landing or negative dealer report. |
| WEEK | NUMBER | Week of the year. |
| DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 0=Unknown. NULL = Not applicable for VTR records not sold to dealer (e.g. Bait-Home-Consumption). Indicated with STATUS = VTR_NOT_SOLD. |
| DLR_STID | VARCHAR2 | State Dealer License Number |
| PERMIT | VARCHAR2 | Vessel permit number assigned by the Northeast Regional Offices Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. 490998=Unknown |
| DLR_CFLIC | VARCHAR2 | Commercial fisherman license issued by a State reported by the dealer in CFDERS. |
| PERMIT_STATE_FED | VARCHAR2 | Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000) |
| STATE | VARCHAR2 | Two character US state abbreviation based on PORT as related in the CFG_PORT table. The first two digits from the port code are used for assignment when the PORT is missing in the CFG_PORT table. The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. |
| PORT | VARCHAR2 | A combined code for state, port and county. Taken with priority from CFDERS -> VTR PORT1 -> PRINC_PORT (permit data). Unknown = 990999. Named ports in VTR are converted to port numbers using the trip_reports.vlporttbl table. |
| BHC | VARCHAR2 | Logical indicator column of whether the VTR indicated the catch was for either bait or home consumption. 0 = FALSE, 1 = TRUE. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| DLR_RPTID | VARCHAR2 | Confirmation number that identifies the record and is given to the dealer. |
| DLR_DOCN | VARCHAR2 | Number assigned to each weighout form, or negative dealer report; Unique within a month. |
| DLR_UTILCD | VARCHAR2 | The utilization code: 0=food fish or unknown; 2=aquaculture; 3=canned pet food (1984+); 4=Biomedical (2002+); 5=animal food (1984+); 7=bait; 8=industrial, other (2002+); 9=industrial, reduction. |
| DLR_SOURCE | VARCHAR2 | Source of the data: 0=Weighout, only (Non-Mandatory); 1=Weighout + Interview; 2=Weighout + Captains Log; 3=Weighout + Sea Sample Data; 4=Weighout + Foreign JV; 5=NEMFIS State Data (IWP); 6=Weighout + Domestic JV (IWP); 7=Mandatory Reporting; 8=Clam Logbook; 9=Tuna Logbook; 10=Estimated General Landings; 11=Estimated Mandatory Landings; 12=Vessel Trip Report, no Weighout; 13=Canadian Transhipment (OTS); 14=NMFS Enforcement; 15=State Enforcement |
| HULLID | VARCHAR2 | |
| DLR_TONCL | VARCHAR2 | The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. |
| FZONE | VARCHAR2 | The fishing zone in which sample was taken as determined from the VTR trip point location. 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown. |
| VTR_CATCHID | VARCHAR2 | Internal primary key. Oracle generated sequence for noaa.catch. |
| VTR_DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000 = Unknown. NULL = Not matched to a dealer record. Exceptions and special codes when not sold to a dealer: 00001 - Seized for Violations; 00002 - Sold to another vessel for bait or retained as bait; 00004 - Retained for future sale; 00005- Sold to a non-Federal dealer (non-Federally regulated species only); 00006 - Sub legal catch landed for research; 00007 - Legal catch landed for research (EFP trips only); 00008 - Landed, unmarketable catch (LUMF); 99998 - Used for home consumption |
| ITIS_TSN | VARCHAR2 | Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records. |
| ITIS_GROUP1 | VARCHAR2 | Actual grouping of ITIS TSN for apportionment |
| VTR_LBS_DISCARD | NUMBER | |
| VTR_COUNT_KEPT | NUMBER | |
| VTR_COUNT_DISCARD | NUMBER | |
| DLR_CATCH_SOURCE | VARCHAR2 | |
| DLR_MKT | VARCHAR2 | Market Code. As reported in CFDERS. |
| DLR_GRADE | VARCHAR2 | Dealer Grade. As reported in CFDERS. |
| DLR_DISP | VARCHAR2 | A code indicating the disposition of the catch. See CFDBS. SFDISP for the code descriptions. Rename of CFDERS column DISPOSITION_CODE |
| LNDLB | NUMBER | The pounds landed. |
| LIVLB | NUMBER | The live weight in pounds. |
| VALUE | NUMBER | The value of landed catch to the nearest dollar (U.S.) associated with the record. |
| LANDING_SOURCE | VARCHAR2 | Character ID for the source of the landing, live weight, and value: DLR or VTR when kept pounds are greater than zero, or DIS when landed pounds are zero but discarded pounds are greater than zero |
| STATUS | VARCHAR2 | Status of the matching record between CFDERS and VTR: MATCH = records fully match at the CAMSID-ITIS_GROUP1 level; DLR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 in CFDERS does not appear on the VTR; DLR_ORPHAN_TRIP = dealer trip with no matching VTR trip; VTR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 on the VTR does not appear on the CFDERS trip (these records were previously excluded from AA tables); VTR_ORPHAN_TRIP = VTR trip with no matching trip in CFDERS (these records were previously excluded from AA tables); VTR_NOT_SOLD = VTR records kept for bait-home-consumption and therefore not sold to the dealer and not in CFDERS (these records were previously excluded from AA tables); VTR_NO_CATCH = VTR records that do not match to dealer records with no landed pounds and no discards; VTR_DISCARD = VTR records that do not match to dealer records and have no landed pounds but discarded pounds are greater than zero; PZERO = Records where PERMIT = 000000. These are not included in the apportionment or imputation processes. |
| REC | VARCHAR2 | Indicator of recreational landings. 1 = recreational, 0 = commercial |
| AREA_HERR | VARCHAR2 | Herring management area. |
| NEMAREA | VARCHAR2 | The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. Unknown = 000. |
| AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = 000. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. |
| NEGEAR | VARCHAR2 | Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables. |
| VTR_MESH | NUMBER | The mesh size of gear used and reported on the VTR. |
| MESH_CAT | VARCHAR2 | The category of mesh size of gear for trawls and gillnets. Mesh categorized as LM >= 4.00 inches and 4.00 > SM >= 0.00 inches. Additionally, for gillnets (NEGEAR: 100, 105, 115, 117, 116) mesh greater than or equal to 8.0 inches receive an XL classification. Mesh is imputed for gill nets and otter trawls, otherwise NULL if MESH not reported on the VTR. |
| AREA_SOURCE | VARCHAR2 | Source of the area data: CAREA = calculated area from the VTR location data; AREA = area reported on the VTR; DLR = area reported by the dealer (SOURCE = 08); WHSE = area assigned by the ACCSP warehouse for SOURCE = 11; PORT = assigned the statistical area adjacent to the port of record using CFG_PORT_AREA; IMPUTE = imputed from VTR records. |
| AREA_IMP_METHOD | VARCHAR2 | Method or level of area imputation: YEAR-PERMIT-QUARTER-MAIN_SPP_GRP = B; YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2 = C; YEAR-PORT_GRP = D; YEAR-STATE = E. |
| AREA_PROP | NUMBER | If area imputed by stratification group (B, C, D, E), the proportion of subtrips fished in the imputed area across subtrips at that stratification level from VTR reporting area. |
| GEAR_SOURCE | VARCHAR2 | Source of the NEGEAR code: VTR = taken from the VTR gearcode and converted to NEGEAR using the CFG_VLGEAR table; WHSE = Taken from CFDERS for SOURCE = 11 as generated by the ACCSP warehouse; DLR = Taken from the dealer report; IMPUTE = imputed from VTR records; IMPUTE_STATE = imputed from dealer-reported NEGEAR for permit 000000 (state permits). |
| GEAR_IMP_METHOD | VARCHAR2 | Method or level of negear imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP. |
| NEGEAR_PROP | NUMBER | If NEGEAR imputed by stratification group (B, C, D, E), the proportion of subtrips fished with the imputed gear across subtrips at that stratification level. |
| MESH_SOURCE | VARCHAR2 | Source of the MESH_CAT: VTR = taken from the VTR MESH and converted to mesh category. IMPUTE = imputed from VTR-converted MESH_CAT; NULL if missing on the VTR or no matching VTR record. |
| MESH_IMP_METHOD | VARCHAR2 | Method or level of mesh category (MESH_CAT) imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP; F = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA-NEGEAR; G = YEAR-AREA-NEGEAR; H = YEAR-NEGEAR. |
| MESH_PROP | NUMBER | If MESH_CAT is imputed by stratification group (B, C, D, E, F, G, H), the proportion of subtrips fished with the imputed MESH_CAT across subtrips at that stratification level. |
| SECTID | VARCHAR2 | Groundfish Sector ID number |
| REGION | VARCHAR2 | Northern (N: area < 600), Southern (S: area >= 600), Other (area = 000) |
| DATE_RUN | DATE | Date the CAMS program was run to create the record |
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMS_VTR_ORPHANS_ID | CHAR | |
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| DOCID | VARCHAR2 | Document ID from VTR. One per trip regardless of number of subtrips. |
| VTRSERNO | VARCHAR2 | A unique serial number used to identify a vessel trip report. NULL = Unknown |
| DATE_TRIP | DATE | Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer |
| DLR_DATE | DATE | Date of the dealer transaction. |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| MONTH | NUMBER | The numeric month (1-12) of the vessel landing or negative dealer report. |
| WEEK | NUMBER | Week of the year. |
| DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 0=Unknown. NULL = Not applicable for VTR records not sold to dealer (e.g. Bait-Home-Consumption). Indicated with STATUS = VTR_NOT_SOLD. |
| DLR_STID | VARCHAR2 | State Dealer License Number |
| PERMIT | VARCHAR2 | Vessel permit number assigned by the Northeast Regional Offices Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. 490998=Unknown |
| DLR_CFLIC | VARCHAR2 | Commercial fisherman license issued by a State reported by the dealer in CFDERS. |
| PERMIT_STATE_FED | VARCHAR2 | Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000) |
| STATE | VARCHAR2 | Two character US state abbreviation based on PORT as related in the CFG_PORT table. The first two digits from the port code are used for assignment when the PORT is missing in the CFG_PORT table. The 2 digit numeric state code for the port of landing: 07=CT; 08=DE; 22=ME; 23=MD; 24=MA; 32=NH; 33=NJ; 35=NY; 36=NC; 42=RI; 49=VA. |
| PORT | VARCHAR2 | A combined code for state, port and county. Taken with priority from CFDERS -> VTR PORT1 -> PRINC_PORT (permit data). Unknown = 990999. Named ports in VTR are converted to port numbers using the trip_reports.vlporttbl table. |
| BHC | VARCHAR2 | Logical indicator column of whether the VTR indicated the catch was for either bait or home consumption. 0 = FALSE, 1 = TRUE. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| DLR_RPTID | VARCHAR2 | Confirmation number that identifies the record and is given to the dealer. |
| DLR_DOCN | VARCHAR2 | Number assigned to each weighout form, or negative dealer report; Unique within a month. |
| DLR_UTILCD | VARCHAR2 | The utilization code: 0=food fish or unknown; 2=aquaculture; 3=canned pet food (1984+); 4=Biomedical (2002+); 5=animal food (1984+); 7=bait; 8=industrial, other (2002+); 9=industrial, reduction. |
| DLR_SOURCE | VARCHAR2 | Source of the data: 0=Weighout, only (Non-Mandatory); 1=Weighout + Interview; 2=Weighout + Captains Log; 3=Weighout + Sea Sample Data; 4=Weighout + Foreign JV; 5=NEMFIS State Data (IWP); 6=Weighout + Domestic JV (IWP); 7=Mandatory Reporting; 8=Clam Logbook; 9=Tuna Logbook; 10=Estimated General Landings; 11=Estimated Mandatory Landings; 12=Vessel Trip Report, no Weighout; 13=Canadian Transhipment (OTS); 14=NMFS Enforcement; 15=State Enforcement |
| HULLID | VARCHAR2 | |
| DLR_TONCL | VARCHAR2 | The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. |
| FZONE | VARCHAR2 | The fishing zone in which sample was taken as determined from the VTR trip point location. 0 = inside coastal boundary (NEMFIS only); 1 = within 3 miles of continental U.S.; 2 = between 3 and 12 miles off the continental U.S.; 3 = more than 12 miles off continental U.S.; 4 = off foreign shores or in international waters. blank/null=Unknown. |
| VTR_CATCHID | VARCHAR2 | Internal primary key. Oracle generated sequence for noaa.catch. |
| VTR_DLRID | VARCHAR2 | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000 = Unknown. NULL = Not matched to a dealer record. Exceptions and special codes when not sold to a dealer: 00001 - Seized for Violations; 00002 - Sold to another vessel for bait or retained as bait; 00004 - Retained for future sale; 00005- Sold to a non-Federal dealer (non-Federally regulated species only); 00006 - Sub legal catch landed for research; 00007 - Legal catch landed for research (EFP trips only); 00008 - Landed, unmarketable catch (LUMF); 99998 - Used for home consumption |
| ITIS_TSN | VARCHAR2 | Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records. |
| ITIS_GROUP1 | VARCHAR2 | Actual grouping of ITIS TSN for apportionment |
| VTR_LBS_DISCARD | NUMBER | |
| VTR_COUNT_KEPT | NUMBER | |
| VTR_COUNT_DISCARD | NUMBER | |
| DLR_CATCH_SOURCE | VARCHAR2 | |
| DLR_MKT | VARCHAR2 | Market Code. As reported in CFDERS. |
| DLR_GRADE | VARCHAR2 | Dealer Grade. As reported in CFDERS. |
| DLR_DISP | VARCHAR2 | A code indicating the disposition of the catch. See CFDBS. SFDISP for the code descriptions. Rename of CFDERS column DISPOSITION_CODE |
| LNDLB | NUMBER | The pounds landed. |
| LIVLB | NUMBER | The live weight in pounds. |
| VALUE | NUMBER | The value of landed catch to the nearest dollar (U.S.) associated with the record. |
| LANDING_SOURCE | VARCHAR2 | Character ID for the source of the landing, live weight, and value: DLR or VTR when kept pounds are greater than zero, or DIS when landed pounds are zero but discarded pounds are greater than zero |
| STATUS | VARCHAR2 | Status of the matching record between CFDERS and VTR: MATCH = records fully match at the CAMSID-ITIS_GROUP1 level; DLR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 in CFDERS does not appear on the VTR; DLR_ORPHAN_TRIP = dealer trip with no matching VTR trip; VTR_ORPHAN_SPECIES = matching CAMSID (trip) but the ITIS_GROUP1 on the VTR does not appear on the CFDERS trip (these records were previously excluded from AA tables); VTR_ORPHAN_TRIP = VTR trip with no matching trip in CFDERS (these records were previously excluded from AA tables); VTR_NOT_SOLD = VTR records kept for bait-home-consumption and therefore not sold to the dealer and not in CFDERS (these records were previously excluded from AA tables); VTR_NO_CATCH = VTR records that do not match to dealer records with no landed pounds and no discards; VTR_DISCARD = VTR records that do not match to dealer records and have no landed pounds but discarded pounds are greater than zero; PZERO = Records where PERMIT = 000000. These are not included in the apportionment or imputation processes. |
| REC | VARCHAR2 | Indicator of recreational landings. 1 = recreational, 0 = commercial |
| AREA_HERR | VARCHAR2 | Herring management area. |
| NEMAREA | VARCHAR2 | The NEMFIS Area, coded as the NAFO Statistical Area for federally collected data; a three digit code for internal state waters for state collected data. Unknown = 000. |
| AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = 000. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. |
| NEGEAR | VARCHAR2 | Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables. |
| VTR_MESH | NUMBER | The mesh size of gear used and reported on the VTR. |
| MESH_CAT | VARCHAR2 | The category of mesh size of gear for trawls and gillnets. Mesh categorized as LM >= 4.00 inches and 4.00 > SM >= 0.00 inches. Additionally, for gillnets (NEGEAR: 100, 105, 115, 117, 116) mesh greater than or equal to 8.0 inches receive an XL classification. Mesh is imputed for gill nets and otter trawls, otherwise NULL if MESH not reported on the VTR. |
| AREA_SOURCE | VARCHAR2 | Source of the area data: CAREA = calculated area from the VTR location data; AREA = area reported on the VTR; DLR = area reported by the dealer (SOURCE = 08); WHSE = area assigned by the ACCSP warehouse for SOURCE = 11; PORT = assigned the statistical area adjacent to the port of record using CFG_PORT_AREA; IMPUTE = imputed from VTR records. |
| AREA_IMP_METHOD | VARCHAR2 | Method or level of area imputation: YEAR-PERMIT-QUARTER-MAIN_SPP_GRP = B; YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2 = C; YEAR-PORT_GRP = D; YEAR-STATE = E. |
| AREA_PROP | NUMBER | If area imputed by stratification group (B, C, D, E), the proportion of subtrips fished in the imputed area across subtrips at that stratification level from VTR reporting area. |
| GEAR_SOURCE | VARCHAR2 | Source of the NEGEAR code: VTR = taken from the VTR gearcode and converted to NEGEAR using the CFG_VLGEAR table; WHSE = Taken from CFDERS for SOURCE = 11 as generated by the ACCSP warehouse; DLR = Taken from the dealer report; IMPUTE = imputed from VTR records; IMPUTE_STATE = imputed from dealer-reported NEGEAR for permit 000000 (state permits). |
| GEAR_IMP_METHOD | VARCHAR2 | Method or level of negear imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP. |
| NEGEAR_PROP | NUMBER | If NEGEAR imputed by stratification group (B, C, D, E), the proportion of subtrips fished with the imputed gear across subtrips at that stratification level. |
| MESH_SOURCE | VARCHAR2 | Source of the MESH_CAT: VTR = taken from the VTR MESH and converted to mesh category. IMPUTE = imputed from VTR-converted MESH_CAT; NULL if missing on the VTR or no matching VTR record. |
| MESH_IMP_METHOD | VARCHAR2 | Method or level of mesh category (MESH_CAT) imputation: B = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA; C = YEAR-QUARTER-PORT_GRP-MAIN_SPP_GRP-TONCL2-AREA; D = YEAR-MAIN_SPP_GRP-AREA; E = YEAR-MAIN_SPP_GRP; F = YEAR-PERMIT-QUARTER-MAIN_SPP_GRP-AREA-NEGEAR; G = YEAR-AREA-NEGEAR; H = YEAR-NEGEAR. |
| MESH_PROP | NUMBER | If MESH_CAT is imputed by stratification group (B, C, D, E, F, G, H), the proportion of subtrips fished with the imputed MESH_CAT across subtrips at that stratification level. |
| SECTID | VARCHAR2 | Groundfish Sector ID number |
| REGION | VARCHAR2 | Northern (N: area < 600), Southern (S: area >= 600), Other (area = 000) |
| DATE_RUN | DATE | Date the CAMS program was run to create the record |
| COLUMN_NAME | DATA_TYPE | COMMENTS |
|---|---|---|
| CAMS_VTR_ORPHANS_SUBTRIP_ID | CHAR | |
| CAMSID | VARCHAR2 | Unique trip identification code within CAMS. For federally-permitted vessels, CAMSID is a concatenated field built as permit number, official trip date (see RECORD_LAND), then the VTR document identifier (DOCID) if it exists else “000000”. The resulting format is PERMIT_YYYYMMDDhhmmss_DOCID. DOCID will be replaced with the universal trip identifier (UTID) when available. For dealer records with no federal permit number (permit = 000000), the CAMSID is built as PERMIT, HULLID, dealer partner id, dealer link, and dealer date with the format PERMIT_HULLID_PARTNER_LINK_YYMMDD000000. |
| PERMIT | VARCHAR2 | Vessel permit number assigned by the Northeast Regional Offices Vessel Permit System (VPS). 000000=no permit or no vessel, check hull number; 190998=Unknown undertonnage vessel; 390998=Unknown tonnage vessel. 490998=Unknown |
| PERMIT_STATE_FED | VARCHAR2 | Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000) |
| DOCID | VARCHAR2 | Document ID from VTR. One per trip regardless of number of subtrips. |
| SUBTRIP | VARCHAR2 | The subtrip number. The subtrip number is 1 for non-split trips (whole trip fished one area, gear, mesh). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. |
| VTRSERNO | VARCHAR2 | A unique serial number used to identify a vessel trip report. NULL = Unknown |
| AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. Unknown = 000. For CAMS data, refer to AREA_SOURCE and AREA_IMP_METHOD for metadata about AREA. |
| AREA_INSHORE | VARCHAR2 | State inshore areas as calculated from TRIP_REPORTS using the latitude and longitude of the VTR for that subtrip. |
| AREA_LOBSTER | VARCHAR2 | |
| NEGEAR | VARCHAR2 | Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables. |
| VTR_MESH | NUMBER | The mesh size of gear used and reported on the VTR. |
| MESH_CAT | VARCHAR2 | The category of mesh size of gear for trawls and gillnets. Mesh categorized as LM >= 4.00 inches and 4.00 > SM >= 0.00 inches. Additionally, for gillnets (NEGEAR: 100, 105, 115, 117, 116) mesh greater than or equal to 8.0 inches receive an XL classification. Mesh is imputed for gill nets and otter trawls, otherwise NULL if MESH not reported on the VTR. |
| N_SUBTRIP | NUMBER | Number of subtrips during the trip. A subtrip is defined as any change in area, gear, or mesh. Calculated after imputations. |
| RECORD_SAIL | DATE | Official sail date for the trip. |
| RECORD_LAND | DATE | Official landing date for the trip. Assigned with priority order of VTR, VMS, then DLR based on available data for the trip. |
| DATE_TRIP | DATE | Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer |
| YEAR | NUMBER | The year in which the landings or negative report occurred. Based on DATE_TRIP which is a function of VTR_LAND, AMS_LAND, then DLR_DATE. |
| GF | VARCHAR2 | Indicator of whether the trip was classified as groundfish or not. 1 = groundfish trip. 0 = non-groundfish trip. |
| PERMIT_CLASS | VARCHAR2 | Based on VPS_PLAN for the permit: NOL = No Lobster Permit; LOP = Lobster permit and other federal permitted species; LOO = Lobster-only permit; NOP = no federal permitted species during the trip. |
| MAIN_SPP_GRP | VARCHAR2 | The main species group caught in a fishing trip: species group with the largest percentage of the total catch (live weight) on the subtrip. |
| MAIN_PORT_GRP | VARCHAR2 | The main port group on a fishing trip based on total pounds landed. |
| VTR_TRIPCATG | VARCHAR2 | Type of trip: Commercial (1), Party (2), Charter (3), Research Set-Aside (RSA)/ Experimental Fishing Permit (EFP) - deprecated (4), Letters of Acknowledgement Research (deprecated), Private Recreational or Headboat in some Apps (6). |
| VTR_CREW | NUMBER | The number of crew (including captain) as reported on the VTR. |
| VTR_DEPTH | NUMBER | The average depth to bottom, in fathoms, over the trip as reported on the VTR. |
| VTR_IMGID | NUMBER | VTR (noaa.images) Primary key. FVTR image identification number. Link to CATCH table. |
| VTR_ACTIVITY | VARCHAR2 | Numerica activity type from the VTR Document: 0 = Fishing trip with effort, 1 = Set Only Trip, 2 = Mechanical Breakdown, 3 = Turned around due to weather, 4 = Transiting Trip, 5 = Herring Carrier Vessel, 6 = Illness or Injury, 7 = Other (Entanglement, Good Samaritan, etc) 8 = Transit with product on board (as of 7/15/2015) |
| VTR_ACTIVITY_DESC | VARCHAR2 | VTR activity description associated with the numeric code: 0 = Fishing trip with effort, 1 = Set Only Trip, 2 = Mechanical Breakdown, 3 = Turned around due to weather, 4 = Transiting Trip, 5 = Herring Carrier Vessel, 6 = Illness or Injury, 7 = Other (Entanglement, Good Samaritan, etc) 8 = Transit with product on board (as of 7/15/2015) |
| VTR_GEAR_SIZE | NUMBER | Size of gear fished. If several gear sizes fished, enter average gear size used per haul. |
| VTR_GEAR_QTY | NUMBER | Quantity of gear being fished per haul. |
| LAT_DD | NUMBER | Latitude decimal degrees |
| LON_DD | NUMBER | Longitude decimal degrees |
| VES_LEN | NUMBER | Length of the vessel in feet from the permit system. |
| VES_GTONS | NUMBER | The tonnage class code which defines the range of gross registered tons (GRT) for the vessel indicated. If last 2 digits = 00, the exact GRT and the sub-range of GRT is unknown. |
| FMCODE | VARCHAR2 | Code to indicate mobile gear (M), Fixed gear (F), or other gear (O). Refer to CFG_NEGEAR for specific gear FMCODES. |
| EFFORT_IMP | VARCHAR2 | Indicator of effort imputation (0 = not imputed, 1 = imputed, NULL for permit 000000). Effort imputation done by lognormal Bayesian hierarchical modeling so no level indicated. |
| TRIP_DURATION | NUMBER | Length of trip calculated by RECORD_LAND - RECORD_SAIL. |
| TRIP_DURATION_Q25 | NUMBER | |
| TRIP_DURATION_Q75 | NUMBER | |
| DF | NUMBER | The total number of days gear is actually fished during fishing trip, in days (rounded to four decimal places). Does not include steam time. Prorated for subtrips. Estimated when missing indicated by the EFFORT_IMP column. Not estimated for Permit = 000000. NULL = unknown. |
| DF_Q25 | NUMBER | 25% of posterior for estimated DF. |
| DF_Q75 | NUMBER | 75% of posterior for estimated DF. |
| DA | NUMBER | For a trip, the total number of days absent from port in days as defined by TRUNC(date_land) - TRUNC(date_sail) + 1 (rounded to four decimal places). The value is estimated when missing (indicated by EFFORT_IMP column). For trips with multiple subtrips, DA is split proportional to the days fished (DF) for each subtrip. In the AA tables, for trips with catch sold to multiple dealers (multiple DOCN), DA for the subtrip is divided equally among transactions. |
| DA_Q25 | NUMBER | 25% of posterior probability for estimated DA. |
| DA_Q75 | NUMBER | 75% of posterior probability for estimated DA. |
| SECTID | VARCHAR2 | Groundfish Sector ID number |
| ACTIVITY_CODE_1 | VARCHAR2 | VMS declaration |
| ACTIVITY_CODE_2 | VARCHAR2 | VMS declaration, if more than one/trip |
| EM | VARCHAR2 | EM program, groundfish trips only |
| REDFISH_EXEMPTION | VARCHAR2 | Exemption fishing under |
| CLOSED_AREA_EXEMPTION | VARCHAR2 | Groundfish specific stratification |
| SNE_SMALLMESH_EXEMPTION | VARCHAR2 | Exemption fishing under |
| XLRG_GILLNET_EXEMPTION | VARCHAR2 | Exemption fishing under |
| EXEMPT_7130 | VARCHAR2 | Logical 0/1 whether a groundfish trip was granted the exception for fishing west of 71 degrees 30 minutes. |
| TRIPCATEGORY | VARCHAR2 | Scallop fleet designation, if applicable |
| ACCESSAREA | VARCHAR2 | Scallop Access Area, only relevant for scallop trips |
| GEARTYPE | VARCHAR2 | Gear description |
| SCALLOP_AREA | VARCHAR2 | Scallop Access ARea fished, scallop trips only |
| DATE_RUN | DATE | Date the CAMS program was run to create the record |
| STATE_WATERS | VARCHAR2 |
Last modified: 2025-12-16