10 Appendix B: Data Dictionary

Table 10.1: CAMS_ALL_PTNS_EM_TRIPS : All PTNS trips for EM assignment

COLUMN_NAME	DATA_TYPE	COMMENTS
PERMIT	NUMBER	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
HULLID	VARCHAR2
DAS_ID	NUMBER
ACTIVITY_CODE	VARCHAR2	VMS declaration
CONFIRMATION_NUM	NUMBER
PTNS_SAIL	DATE
AMS_SAIL	DATE	Date trip departed across VMS demarcation, taken from AMS
AMS_LAND	DATE	Date trip returned across VMS decmarc, taken from AMS
COMBINED_DATE	DATE
TRIP_STATUS	NUMBER
TRIP_STATUS_NAME	VARCHAR2
PTNS_FMP	VARCHAR2	Fishery management plan notified by EM vessel to Pre-Trip Notification System (PTNS)
COLLECTION_NAME	VARCHAR2
INDUSTRY_FUNDED_MONITORING	VARCHAR2
FISHING_EXEMPTION	VARCHAR2
GROUNDFISH_CLOSED_AREA	VARCHAR2
EM_PROGRAM_ID	NUMBER	EM program ID code
EFP_PROGRAM_ID	VARCHAR2
COVERAGE_OUTCOME_REASON	NUMBER
CANCEL_REASON	NUMBER
REALIZED_COVERAGE_TYPE	VARCHAR2
REALIZED_PROVIDER_CODE	VARCHAR2
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
VTR_SAIL	DATE	Date and time vessel left the dock.
VTR_LAND	DATE	VTR landing date
AMSVTR_ACTIVITY_CODE	VARCHAR2
RUN_TIME	DATE
LOAD_ID	NUMBER

Table 6.2:

COLUMN_NAME	DATA_TYPE	COMMENTS
CAMS_AQUACULTURE_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

Table 10.2: CAMS_AQUACULTURE_SUBTRIP : Selection from CAMS_SUBTRIP related to aquaculture activities

COLUMN_NAME	DATA_TYPE	COMMENTS
CAMS_AQUACULTURE_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

Table 10.3: CAMS_CFAGE_AA : Biological sampling age data for all years linked to CAMS subtrips

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.
YEAR	VARCHAR2	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.
LINK	VARCHAR2	A unique identifying column used to join two or more tables.
MONTH	VARCHAR2	The numeric month (1-12) of the vessel landing or negative dealer report.
QTR	VARCHAR2	The quarter of the calendar year in which the vessel landed or the dealer weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month.
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.
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.
PORT2	VARCHAR2	The 3rd and 4th digit of the port code - meaningless without the rest of the port code. Unknown = 09
COUNTY	VARCHAR2	Two digit number of the county. Unknown = 99
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code.
NESPP4	VARCHAR2	Legacy 4-digit Northeast Species code; the fourth digit represents market category. As reported in CFDERS. The standard 2020+ is ITIS_TSN and MKT.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
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.
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.
CATDISP	VARCHAR2	Indicates if the catch from which the sample was taken was: 0=discarded, 1=kept.
SAMPMETH	NUMBER	The method used to sample the vessels catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See Manual for Sampling, Interviewing and Coding for the Northeast Region by R.I. Schultz.
AGESTRCT	NUMBER	The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.
SEX	VARCHAR2	Sex code: 0=unsexed; 1=male; 2=female.
LENGTH	NUMBER	The length of specimen in centimeters.
AGE	NUMBER	The age of specimen in years.
NUMAGE	NUMBER	The number of specimens at a given age.
NPAIRS	NUMBER	The number of length frequency pairs.
ALEVEL	VARCHAR2	Legacy column not currently used in CAMS. See AREA_SOURCE and AREA_IMP_METHOD for area metadata. 1994-2019: The level at which the area was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, gear group, and species group; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter and year; D = Dealer trip matched a group of VTR trips stratified by port group; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation.
ORIG_AREA	VARCHAR2	Original statistical area in the age and length data. The original area may be replaced by the area assigned during the allocation.
ORIG_NEMAREA	VARCHAR2	Original NEMAREA recorded in the AGE data. This NEMAREA may be revised in the NEMAREA column by the allocation.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
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.
ORIG_DOCN	VARCHAR2	Original NEMAREA recorded in the AGE data. This NEMAREA may be revised in the NEMAREA column by the allocation.
NO_LEN_MATCH	VARCHAR2	Flag indicating that there is no matching length record for the age record.
TALLYNO	VARCHAR2	A generated sequence number used to link a tally sheet to its associated samples.
SAMPNO	VARCHAR2	A unique number, within tallyno, generated to identify an individual biological sample.
AREA_SOURCES	VARCHAR2	The area sources contributing to the sample. See AREA_SOURCE for source details.
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.
MATCHED_AREAS	VARCHAR2	List of distinct AREA from CFDETS matched to record. When multiple matches exists, AREA is separated by -. For example a record matched to NEMAREA 514 and ARA 515 is represented as 514-515
NEMAREA_SOURCES	VARCHAR2	Source of the area data: CAREA = calculated nemarea from the VTR location data; AREA = nemarea reported on the VTR; DLR = nemarea reported by the dealer (SOURCE = 08); WHSE = nemarea 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 the VTR records.
NEMAREA_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.
MATCHED_NEMAREAS	VARCHAR2	List of distinct NEMAREA from CFDETS matched to record. When multiple matches exists, NEMAREA is separated by -. For example a record matched to NEMAREA 514 and AREA 515 is represented as 514-515
GEAR_SOURCES	VARCHAR2	The list of sources the gear came from during the trip (e.g. VTR, DLR, IMPUTE).
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.
MATCHED_NEGEARS	VARCHAR2	List of distinct NEGEAR from CFDETS matched to record. When multiple matches exists, NEGEAR is separated by -. For example a record matched to NEGEAR 100 and NEGEAR 020 is represented as 100-020.

Table 10.4: CAMS_CFDETS_AA : Species-level landings formatted following the traditional AA structure

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.
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
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.
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.
PORT2	VARCHAR2	The 3rd and 4th digit of the port code - meaningless without the rest of the port code. Unknown = 09
COUNTY	VARCHAR2	Two digit number of the county. Unknown = 99
YEAR	VARCHAR2	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.
LINK	VARCHAR2	A unique identifying column used to join two or more tables.
DLRTRPID	VARCHAR2	Legacy column in CAMS. Trip now defined by CAMSID. For NEFSC AA tables 1994-2019, a unique identifier assigned to a group of dealer records comprising a trip defined as a unique permit, month, day, year. NULL for 2020 onward.
MONTH	VARCHAR2	The numeric month (1-12) of the vessel landing or negative dealer report.
DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month.
DAY	VARCHAR2	Day of month (1-31)
DEALNUM	NUMBER	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.
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
HULLNUM	VARCHAR2	Official vessel registration number painted on the hull. U.S. Coast Guard, State, or Tribal registration number. Text field–State registrations begin with two character state code. Unknown=blank/null.
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code.
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.
EFFIND	VARCHAR2	0 = Uninterviewed w/minimal effort data: DA, DF, NTRIPS, FZONE… 1 = Interviewed w/detailed effort data; 2 = Mandatory/Dealer report only, i.e., no effort data; 3 = Mandatory/Vessel log only, i.e., effort data; 4 = Mandatory/Dealer & vessel log, i.e., detailed effort data.
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. As reported in CFDERS. NULL for VTR Orphans without matching DLR record.
DEPTHCD	VARCHAR2	The depth to bottom, in fathoms, coded as follows: 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed.
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.
TONCLASS	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.
TONCL1	VARCHAR2	The first digit of the tonnage class code.
TONCL2	VARCHAR2	The first two digits of the tonnage class code.
SAMPAREA	VARCHAR2	The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
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.
MKT	VARCHAR2	Market Code. As reported in CFDERS.
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
UOM	VARCHAR2	Original unit of measurement for the Reported Quantity prior to conversion to landed and live pounds.
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.
NESPP4	VARCHAR2	Legacy 4-digit Northeast Species code; the fourth digit represents market category. As reported in CFDERS. The standard 2020+ is ITIS_TSN and MKT.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
WHSPP	VARCHAR2	The 3 digit commercial species code developed by the Woods Hole lab. No longer used or maintained.
SPPLNDLB	NUMBER	The pounds landed for a given species.
SPPLIVLB	NUMBER	The live weight of species landed in pounds.
SPPVALUE	NUMBER	The value of landed catch to the nearest dollar (U.S.), for a given species.
SPRATIO	NUMBER	The ratio of live pounds of a species to total live pounds of the trip.
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.
VSERIAL	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
VTRIPID	NUMBER	ID number used to link the VTR trip record to its corresponding gear and species records (=DOCID).
VGEARID	NUMBER	ID number used to link the VTR gear record to its corresponding trip and species records (IMGID).
ALEVEL	VARCHAR2	Legacy column not currently used in CAMS. See AREA_SOURCE and AREA_IMP_METHOD for area metadata. 1994-2019: The level at which the area was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, gear group, and species group; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter and year; D = Dealer trip matched a group of VTR trips stratified by port group; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation.
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.
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.
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_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.
ELEVEL	VARCHAR2	Legacy column. 1994-2019. The level at which effort was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, year, gear group, species group and area; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter, year and area; D = Dealer trip matched a group of VTR trips stratified by port group, year and area; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation. In CAMS (2020+), effort imputed using hierarchical Bayesian model.
DOE	DATE	Date of entry from CFDERS or VTR based on landing source.
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.

Table 10.5: CAMS_CFDETT_AA : Trip-Subtrip-DOCN-NEMAREA-level landings data following the traditional AA structure

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.
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
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.
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.
PORT2	VARCHAR2	The 3rd and 4th digit of the port code - meaningless without the rest of the port code. Unknown = 09
COUNTY	VARCHAR2	Two digit number of the county. Unknown = 99
YEAR	VARCHAR2	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.
LINK	VARCHAR2	A unique identifying column used to join two or more tables.
DLRTRPID	VARCHAR2	Legacy column in CAMS. Trip now defined by CAMSID. For NEFSC AA tables 1994-2019, a unique identifier assigned to a group of dealer records comprising a trip defined as a unique permit, month, day, year. NULL for 2020 onward.
MONTH	VARCHAR2	The numeric month (1-12) of the vessel landing or negative dealer report.
DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month.
DAY	VARCHAR2	Day of month (1-31)
DEALNUM	NUMBER	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.
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
HULLNUM	VARCHAR2	Official vessel registration number painted on the hull. U.S. Coast Guard, State, or Tribal registration number. Text field–State registrations begin with two character state code. Unknown=blank/null.
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code.
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.
EFFIND	VARCHAR2	0 = Uninterviewed w/minimal effort data: DA, DF, NTRIPS, FZONE… 1 = Interviewed w/detailed effort data; 2 = Mandatory/Dealer report only, i.e., no effort data; 3 = Mandatory/Vessel log only, i.e., effort data; 4 = Mandatory/Dealer & vessel log, i.e., detailed effort data.
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. As reported in CFDERS. NULL for VTR Orphans without matching DLR record.
DEPTHCD	VARCHAR2	The depth to bottom, in fathoms, coded as follows: 1 = 0-30; 2 = 31-60; 3 = 61-100; 4 = 101-150; 5 = 151-200; 6 = 201-300; 7 = over 300; 8= mixed; 9 = unknown. When the range of fishing depths covers two depth zones, it is the zone in which mid-depth falls. When 3 or more zones are covered, it is mixed.
NSUBTRIP	NUMBER	Number of subtrips during the trip. A subtrip is defined as any change in area, gear, or mesh. Calculated after imputations.
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.
TONCLASS	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.
TONCL1	VARCHAR2	The first digit of the tonnage class code.
TONCL2	VARCHAR2	The first two digits of the tonnage class code.
CREW	NUMBER	The number of crew (including captain) as reported on the VTR. Null for DLR Orphans.
STERN	VARCHAR2	The stern indicator. For 1994-2019: 1 = gear is fished off stern (default); 0 = gear not fished off stern. Used in reporting landings to NAFO. Legacy Column. NULL for 2020+.
QTR	VARCHAR2	The quarter of the calendar year in which the vessel landed or the dealer weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
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.
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.
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.
NTRIPS	NUMBER	The proportional effort (DF) attributed to one row of CFDETT relative to the total trip effort. It starts with the proportional effort on each subtrip relative to the whole trip (DF[subtrip] / DF[trip]). This proportional effort is then divided by the number of rows of CFDETT for that subtrip (e.g. number of dealer weighout transactions, DOCN). NTRIPS sums to one over all rows associated with a trip. Non-federal permits (000000) have no reported VTR effort and NTRIPS is NULL.
TRPLNDLB	NUMBER	The live weight of catch landed of all species combined, in pounds, for the subtrip-transaction associated with 1 row of CFDETT table.
TRPLIVLB	NUMBER	The weight, in pounds, of total landed catch on the subtrip-transaction associated with 1 row of CFDETT table.
TRPVALUE	NUMBER	The total value of all species landed associated with the record (subtrip-transaction) in US dollars.
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.
MAINSPP	VARCHAR2	The main species sought in a fishing trip, found with an algorithm relating the percentage of a given species catch to total catch (live weight). If no species accounts for over 50%, species are grouped until a grouping accounts for over 50% uses NAFO Main Species Code. See CFDBS Main Species Table (MSPP) for actual codes.
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.
GEARQTY	NUMBER	Number of gear fished per haul. Unit determined by gear, i.e. Nets, Pots, Hooks, or Dredges. Taken directly from the VTR and NULL for DLR Orphans and permit 000000.
GEARSIZE	NUMBER	Size of gear fished. If several gear sizes fished, enter average gear size used per haul. Taken directly from the VTR and NULL for DLR Orphans.
MESH	NUMBER	The mesh size of gear used. Taken directly from the VTR and NULL for DLR Orphans.
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.
NTOWS	NUMBER	Number of tows made during fishing trip as reported by the VTR. Unknown/Unreported = NULL.
TOWDUR	NUMBER	The duration of tow in hundredths of hours (two decimal places)as reported by the VTR. Unknown/Unreported = NULL.
DEPTH	NUMBER	The average depth to bottom, in fathoms, over the trip as reported on the VTR. NULL for DLR Orphans.
LAT	VARCHAR2	Latitude DDMM
LATDEG	VARCHAR2	Degrees latitude reported on the VTR. NULL for DLR Orphans.
LATMIN	VARCHAR2	Minutes latitude reported on the VTR. NULL for DLR Orphans.
LON	VARCHAR2	Longitude DDMM
LONGDEG	VARCHAR2	Degrees longitude reported on the VTR. NULL for DLR Orphans.
LONGMIN	VARCHAR2	Minutes longitude reported on the VTR. NULL for DLR Orphans.
TRIPTYPE	VARCHAR2	The trip type, coded as: 0=unknown; 1=whole trip fished within 1 area (i.e., pure trip); 2=split trip, where fishing occurred in 2 or more areas; 3=multiple purpose trip (MPT), where vessel fished for 2 or more species with 1 or more gear in 1 or more areas; 4=joint venture vessel which made more tows on the way to port. Taken directly from CFDERS.
TIMELOST	NUMBER	The total time lost during fishing, in tenths of days (one decimal place). Unknown=blank. Legacy column no longer collected on the VTR
TIMEDAY	VARCHAR2	Legacy data; Set to 0; Not currently used.
GRTONS	NUMBER	The gross registered tonnage of the vessel. From STG_VPS_VESSEL. NULL for permit 000000 and when no valid permit for the trip.
VESSLEN	NUMBER	Registered length of the vessel in feet. From STG_VPS_VESSEL. NULL for permit 000000 and when no valid permit for the trip.
HSPR	NUMBER	The horsepower of the vessel. From STG_VPS_VESSEL. NULL for permit 000000 and when no valid permit for the trip.
YRBLT	NUMBER	Year that the vessel was built, as shown on the builders certificate. From STG_VPS_VESSEL. NULL for permit 000000 and when no valid permit for the trip.
VSERIAL	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
VTRIPID	NUMBER	ID number used to link the VTR trip record to its corresponding gear and species records (=DOCID).
VGEARID	NUMBER	ID number used to link the VTR gear record to its corresponding trip and species records (IMGID).
ALEVEL	VARCHAR2	Legacy column not currently used in CAMS. See AREA_SOURCE and AREA_IMP_METHOD for area metadata. 1994-2019: The level at which the area was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, gear group, and species group; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter and year; D = Dealer trip matched a group of VTR trips stratified by port group; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation.
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.
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.
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_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.
ELEVEL	VARCHAR2	Legacy column. 1994-2019. The level at which effort was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, year, gear group, species group and area; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter, year and area; D = Dealer trip matched a group of VTR trips stratified by port group, year and area; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation. In CAMS (2020+), effort imputed using hierarchical Bayesian model.
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.
DA_Q25	NUMBER	25% of posterior probability for estimated DA.
DA_Q75	NUMBER	75% of posterior probability for estimated DA.
DF_Q25	NUMBER	25% of posterior for estimated DF.
DF_Q75	NUMBER	75% of posterior for estimated DF.
DOE	DATE	Date of entry from CFDERS or VTR based on landing source.

Table 10.6: CAMS_CFLEN_AA : Biological sampling length data for all years linked to CAMS subtrips

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.
DSM	VARCHAR2	Logical indicator column of whether the data came from the dockside-monitoring program (DSM). 0 = FALSE, 1 = TRUE.
LINK	VARCHAR2	A unique identifying column used to join two or more tables.
YEAR	VARCHAR2	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	VARCHAR2	The numeric month (1-12) of the vessel landing or negative dealer report.
DAY	VARCHAR2	Day of month (1-31)
QTR	VARCHAR2	The quarter of the calendar year in which the vessel landed or the dealer weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month.
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.
PORT2	VARCHAR2	The 3rd and 4th digit of the port code - meaningless without the rest of the port code. Unknown = 09
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.
COUNTY	VARCHAR2	Two digit number of the county. Unknown = 99
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
HULLNUM	VARCHAR2	Official vessel registration number painted on the hull. U.S. Coast Guard, State, or Tribal registration number. Text field–State registrations begin with two character state code. Unknown=blank/null.
VESSEL2	VARCHAR2	Second vessel for paired gears. For Federal data, the 6-digit vessel number; for state data, the official US Coast Guard documentation number or a locally assigned number. 190998=unknown undertonnage vessel; 390998=unknown tonnage vessel; 000000=no vessel or unknown vessel. See CFDBS Master Vessel Table (MSTRVESS) for pre 1994 vessel codes.
STOCK_CT	VARCHAR2	Number of stocks the species could have come from during the trip.
MATCHED_STOCKS	VARCHAR2	The list of stocks the species could have come from during the trip.
ALEVEL	VARCHAR2	Legacy column not currently used in CAMS. See AREA_SOURCE and AREA_IMP_METHOD for area metadata. 1994-2019: The level at which the area was allocated to this unit of dealer landings. A = a Dealer trip matched a VTR trip; B = a Dealer trip matched a group of VTR trips stratified by permit, month, gear group, and species group; C = Dealer trip matched a group of VTR trips stratified by ton class, port group, gear group, species group, calendar quarter and year; D = Dealer trip matched a group of VTR trips stratified by port group; X = Dealer trip enter allocation but did not find a match; and NULL = Dealer trip did not enter allocation.
AREA_CT	VARCHAR2	Number of areas the species could have come from during the trip.
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.
ORIG_AREA	VARCHAR2	Original statistical area in the age and length data. The original area may be replaced by the area assigned during the allocation.
MATCHED_AREAS	VARCHAR2	List of distinct AREA from CFDETS matched to record. When multiple matches exists, AREA is separated by -. For example a record matched to NEMAREA 514 and ARA 515 is represented as 514-515
AREA_SOURCES	VARCHAR2	The area sources contributing to the sample. See AREA_SOURCE for source details.
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.
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.
MATCHED_NEMAREAS	VARCHAR2	List of distinct NEMAREA from CFDETS matched to record. When multiple matches exists, NEMAREA is separated by -. For example a record matched to NEMAREA 514 and AREA 515 is represented as 514-515
ORIG_NEMAREA	VARCHAR2	Original NEMAREA recorded in the AGE data. This NEMAREA may be revised in the NEMAREA column by the allocation.
NEGEAR_CT	VARCHAR2
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code.
MATCHED_NEGEARS	VARCHAR2	List of distinct NEGEAR from CFDETS matched to record. When multiple matches exists, NEGEAR is separated by -. For example a record matched to NEGEAR 100 and NEGEAR 020 is represented as 100-020.
GEAR_SOURCES	VARCHAR2	The list of sources the gear came from during the trip (e.g. VTR, DLR, IMPUTE).
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.
ORIG_NEGEAR	VARCHAR2	Original NEGEAR recorded in the AGE data. This NEGEAR may be revised in the NEGEAR column by the allocation.
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. As reported in CFDERS. NULL for VTR Orphans without matching DLR record.
EFFIND	VARCHAR2	0 = Uninterviewed w/minimal effort data: DA, DF, NTRIPS, FZONE… 1 = Interviewed w/detailed effort data; 2 = Mandatory/Dealer report only, i.e., no effort data; 3 = Mandatory/Vessel log only, i.e., effort data; 4 = Mandatory/Dealer & vessel log, i.e., detailed effort data.
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.
SAMPMETH	NUMBER	The method used to sample the vessels catch: 1=vessel or hold; 2=basket or bushel; 3=chute or conveyor; 4=cart,barrel,tub,large box; 5=bin, floor pile; 6=small box; 7=sorting table. See Manual for Sampling, Interviewing and Coding for the Northeast Region by R.I. Schultz.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
NESPP4	VARCHAR2	Legacy 4-digit Northeast Species code; the fourth digit represents market category. As reported in CFDERS. The standard 2020+ is ITIS_TSN and MKT.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
CATDISP	VARCHAR2	Indicates if the catch from which the sample was taken was: 0=discarded, 1=kept.
AGESTRCT	NUMBER	The structure retained for age determination: 0=No structure taken; 1=Scale; 2=Otoliths; 3=Shells; 4=Pen; 5=Vertebra; 6=Dorsal spine.
SEX	VARCHAR2	Sex code: 0=unsexed; 1=male; 2=female.
NAGESPEC	NUMBER	The number of specimens from which aging structures were removed for this sample.
WGTSAMP	NUMBER	The weight of specimens in sample.
NUMSAMP	NUMBER	The number of specimens in sample.
LENGTH	NUMBER	The length of specimen in centimeters.
NUMLEN	NUMBER	The total number of specimens at specified length.
TALLYNO	VARCHAR2	A generated sequence number used to link a tally sheet to its associated samples.
SAMPNO	VARCHAR2	A unique number, within tallyno, generated to identify an individual biological sample.
SPPLNDLB	NUMBER	The pounds landed for a given species.
SAMPLE_SOURCE_ABBR	VARCHAR2
SAMPLE_SOURCE_CODE	VARCHAR2	Itis code for species. equivalent to ITIS_TSN

Table 10.7: CAMS_COMMENTS : Table of definitions for columns across all tables in CAMS

COLUMN_NAME	DATA_TYPE	COMMENTS
TABLE_NAME	VARCHAR2
COLUMN_NAME	VARCHAR2
COMMENTS	VARCHAR2
ORIGIN_CON_ID	NUMBER

Table 10.8: CAMS_DISCARD_ALL_YEARS : Discards by subtrip for each species

COLUMN_NAME	DATA_TYPE	COMMENTS
DATE_RUN	DATE	Date the CAMS program was run to create the record
FY	NUMBER	Fishing Year
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.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
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.
STRATA_USED_DESC	VARCHAR2	Strata specific values used to estimate discard amount on a given subtrip.
DISCARD_SOURCE	VARCHAR2	Source of discard, observed, EM, VTR, In-season, etc. see documentation for details
SUBTRIP_KALL	NUMBER	Kept all of subtrip from CAMS_LANDINGS
CAMS_DISCARD	NUMBER	CAMS estimated discard in pounds
CAMS_DISCARD_VARIANCE	NUMBER

Table 10.9: CAMS_DISCARD_NBR_NON_FMP : Discards for species not in an FMP to be used in the National Bycatch Report

COLUMN_NAME	DATA_TYPE	COMMENTS
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.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
FLEET_REGION	VARCHAR2	General designation area for the National Bycatch Report. MA = Mid-Atlantic. NE = New England.
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
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.
TRIPCATEGORY	VARCHAR2	Scallop fleet designation, if applicable
ACCESSAREA	VARCHAR2	Scallop Access Area, only relevant for scallop trips
PERMIT_STATE_FED	VARCHAR2	Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000)
CAMS_DISCARD	NUMBER	CAMS estimated discard in pounds
CAMS_DISCARD_VARIANCE	NUMBER
CAMS_CV	NUMBER	Coefficient of variation of CAMS estimated discard rate
DATE_RUN	DATE	Date the CAMS program was run to create the record

Table 10.10: CAMS_DISCARD_STRATA : Discard rates and associated stratification information with primary_key = STRATA_USED_DESC to join with CAMS_DISCARD_ALL_YEARS. The columns with STRATA_ prefixes are the stratification grouping variables where not null. For example a trip might have been within a scallop area or had an exemption but if there were not enough trips with that stratification they can be aggregated and those characteristics of the trip ignored and therefore the strata will have a NULL value for that STRATA variable.

COLUMN_NAME	DATA_TYPE	COMMENTS
STRATA_USED_DESC	VARCHAR2	Strata specific values used to estimate discard amount on a given subtrip.
DISCARD_SOURCE	VARCHAR2	Source of discard, observed, EM, VTR, In-season, etc. see documentation for details
N_OBSERVED	NUMBER	Number of observed subtrips in the discard stratum. For DISCARD_SOURCE = T or G, this value includes observed trips in the previous fishing year.
N_UNOBSERVED	NUMBER	Number of unobserved subtrips in the discard stratum. This value is always within the referenced fishing year (i.e. does not include anything fro the previous fishing year)
CAMS_DISCARD_RATE	NUMBER	CAMS estimated discard rate. Final rate assigned according to business rules and in accordance with DIscard Source
CAMS_CV	NUMBER	Coefficient of variation of CAMS estimated discard rate
DATE_RUN	DATE	Date the CAMS program was run to create the record
FY	NUMBER	Fishing Year
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
FY_TYPE	VARCHAR2	Type of fishing year, i.e. May start, January start, April start, etc.
STRATA_FY	NUMBER
SPECIES_ESTIMATION_REGION	VARCHAR2	Stock of species as defined in support table
CAMS_GEAR_GROUP	VARCHAR2	CAMS gear group used for discard stratification. Species and stock specific
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.
STRATA_TRIPCATEGORY	VARCHAR2	Scallop trip category used in the discard stratification
STRATA_ACCESSAREA	VARCHAR2	Scallop access area used in the discard stratification
STRATA_SECTID	VARCHAR2	Groundfish sector identification number
STRATA_EM	VARCHAR2	EM program 1 or 2 category used in stratification. NULL for non-EM trips
STRATA_REDFISH_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the redfish exemption was used in the discard stratification
STRATA_SNE_SMALLMESH_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the southern New England smallmesh exemption was used in the discard stratification
STRATA_XLRG_GILLNET_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the extra large gillnet exemption was used in the discard stratification
STRATA_EXEMPT_7130	VARCHAR2	Boolian 0/1 for whether the groundfish west of 71 degrees 30 minutes exemption was used in the discard stratification
STRATA_SECTOR_TYPE	VARCHAR2	Sector category used in the discard stratification
STRATA_SCALLOP_AREA	VARCHAR2	Scallop area used in the discard stratification

Table 10.11: CAMS_EM_VTR_HAUL : Information on whether an EM haul was observed or unobserved. Not for end users

COLUMN_NAME	DATA_TYPE	COMMENTS
VTRSERNO	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
REVIEW_SEQ	NUMBER	Unique identifier for electronically reviewed trips.
HAUL_NUM	NUMBER
OBSERVED	VARCHAR2

Table 10.12: CAMS_FISHERY_GROUP : Primary fishery group and individual fishery groups by subtrip

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

Table 10.13: CAMS_GDP_DEFLATOR : Quarterly Gross Domestic Product Implicit Price Deflator from http://research.stlouisfed.org/fred2/data/GDPDEF.txt

COLUMN_NAME	DATA_TYPE	COMMENTS
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.
QUARTER	NUMBER	The quarter of the calendar year in which the vessel landed or the dealer weighout occurred: 1=January-March; 2=April-June; 3=July-September; 4=October-December.
DEFLATOR	NUMBER	Inflation conversion factor relative to a standard year average (Refer to REFERENCE_YEAR). Divide revenue VALUE in US Dollars at the time of the sale by the DEFLATOR to calculate the standardized US dollar value.
DATE_START	DATE
DATE_END	DATE
DATE_RUN	DATE	Date the CAMS program was run to create the record

Table 10.14: CAMS_GF_EM : Primary and secondary EM review data at the haul level.

COLUMN_NAME	DATA_TYPE	COMMENTS
VESSEL_PERMIT_NUM	NUMBER
VTR_DOCID	NUMBER
TRIP_OBSERVED	VARCHAR2
REVIEW_SEQ	NUMBER	Unique identifier for electronically reviewed trips.
REVIEW_TYPE	VARCHAR2
EM_PROGRAM_ID	NUMBER	EM program ID code
TOTAL_HAUL_COUNT	NUMBER
FISHNK_PCT	NUMBER
HAUL_OBSERVED	VARCHAR2	Indicates whether all hauls have been observed by video on a pseudo electronically monitored subtrip.
CT_TOT	NUMBER	Total count of discarded fish.
AREA_FISHED	VARCHAR2
ACCSP_GEAR_CATEGORY	VARCHAR2
OBSERVED_PSUBTRIP	VARCHAR2
PSUBTRIP_HAUL_CT	NUMBER
GF_SPECIES_ITIS	VARCHAR2
SPECIES_WEIGHT_LB_MOD	NUMBER

Table 10.15: CAMS_GF_EM_DELTA_VTR_DISCARD : EM discard weight by species at the subtrip level. Includes VTR, EM and DELTA discards

COLUMN_NAME	DATA_TYPE	COMMENTS
FISHING_YEAR	NUMBER	Fishing Year
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
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
DATE_TRIP	DATE	Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer
VTRSERNO	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
VTR_IMGID	NUMBER	VTR (noaa.images) Primary key. FVTR image identification number. Link to CATCH table.
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
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	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.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
EM_COMPARISON	NUMBER	Indicates whether an EM subtrip was reviewed and passed review criteria
VTR_LBS_DISCARD	NUMBER	Amount discarded. Commercial = pounds; Party/Charter = count.
EM_DISCARD	NUMBER	Pounds of discards estimated from EM
DELTA_DISCARD	NUMBER	Discard amount in pounds predicted by the delta model.
NMFS_DISCARD	NUMBER	Official NMFS discard amount in pounds
NMFS_DISCARD_SOURCE	VARCHAR2	Official NMFS discard source
MODEL_DATE	DATE

Table 10.16: CAMS_GF_EM_VTR_DISCARDS_AREA_ACCSPGEARCAT_TRIP : VTR information for reviewed audit model EM trips a the subtrip level used to fit the delta model. Not for end users

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.
FISHING_YEAR	NUMBER	Fishing Year
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
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
DATE_TRIP	DATE	Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer
VTRSERNO	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
VTR_IMGID	NUMBER	VTR (noaa.images) Primary key. FVTR image identification number. Link to CATCH table.
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.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
EM_COMPARISON	NUMBER	Indicates whether an EM subtrip was reviewed and passed review criteria
VTR_DISCARD	NUMBER	Amount discarded. Commercial = pounds; Party/Charter = count.
EM_DISCARD	NUMBER	Pounds of discards estimated from EM

Table 10.17: CAMS_GF_EM_VTR_DISCARDS_SUBTRIP : VTR information for all EM audit model trips. Not for end users

COLUMN_NAME	DATA_TYPE	COMMENTS
FISHING_YEAR	NUMBER	Fishing Year
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
VTRSERNO	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
DATE_TRIP	DATE	Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer
ACCSP_GEAR_CATEGORY	VARCHAR2
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.
SPECIES_ID	VARCHAR2	Species identification code
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
DISCARDED_MOD	NUMBER
VTR_IMGID	NUMBER	VTR (noaa.images) Primary key. FVTR image identification number. Link to CATCH table.
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.

Table 10.18: CAMS_LAND : All official commercial landings reported to dealers with weighouts apportioned to VTR subtrips

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

Table 10.19: CAMS_LANDINGS_METADATA : Metadata summary information about the status of landings-associated tables. All landings tables are run together by year so this metadata is valid for CAMS_LAND, CAMS_SUBTRIP, CAMS_VTR_ORPHANS, and CAMS_VTR_REC.

COLUMN_NAME	DATA_TYPE	COMMENTS
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.
DATE_RUN	DATE	Date the CAMS program was run to create the record
STATE_COMPLETE	VARCHAR2
STATE_SPRING_LOAD	VARCHAR2
STATE_FALL_LOAD	VARCHAR2
N_REC_FED	NUMBER
N_REC_STATE	NUMBER
N_TRIP_FED	NUMBER
N_TRIP_STATE	NUMBER
LNDLB_SUM_FED	NUMBER
LNDLB_SUM_STATE	NUMBER
LIVLB_SUM_FED	NUMBER
LIVLB_SUM_STATE	NUMBER
VALUE_SUM_FED	NUMBER
VALUE_SUM_STATE	NUMBER
DATE_MAX_FED	DATE
DATE_MAX_STATE	DATE

Table 10.20: CAMS_OBS_CATCH : Observer data matched to landings data for use in discard estimation. Not intended for end users.

COLUMN_NAME	DATA_TYPE	COMMENTS
ACCESSAREA	VARCHAR2	Scallop Access Area, only relevant for scallop trips
ACTIVITY_CODE_1	VARCHAR2	VMS declaration
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.
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.
CLOSED_AREA_EXEMPTION	VARCHAR2	Groundfish specific stratification
DISCARD	NUMBER	Species discard as recorded on the subtrip
DISCARD_PRORATE	NUMBER	Species discard as prorated by KALL on unobserved hauls
DATE_TRIP	DATE	Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
EM	VARCHAR2	EM program, groundfish trips only
GEARTYPE	VARCHAR2	Gear description
GF	VARCHAR2	Indicator of whether the trip was classified as groundfish or not. 1 = groundfish trip. 0 = non-groundfish trip.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
LINK1	VARCHAR2	Observer LINK1 if trip was observed
LINK3	VARCHAR2	Observer recorded haul
OFFWATCH_HAUL	NUMBER
OFFWATCH_LINK1	NUMBER	Indicator whether trip had offwatch hauls. Only relevant for observed trips
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.
MONTH	NUMBER	The numeric month (1-12) of the vessel landing or negative dealer report.
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
NSUBTRIP_LINK1	NUMBER
N_SUBTRIPS_LINK3	NUMBER
OBSRFLAG	VARCHAR2	Flag for whether the haul was observed
LINK3_OBS	NUMBER	Indicator that the observed trip (LINK1) had at least one observed haul
FISHDISP	VARCHAR2	see OBDBS
OBS_AREA	VARCHAR2	The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code reported by the observer. Unknown = 000.
OBS_GEAR	VARCHAR2	Observer recorded gear (NEGEAR)
OBS_HAUL_KALL_TRIP	NUMBER	Kept all pounds recorded by observer on observed hauls. This is the value used in d/k calculations
OBS_HAUL_KEPT	NUMBER	equivalent field in OBDBS
OBS_NOHAUL_KALL_TRIP	NUMBER	Kept all pounds recorded by observer on unobserved hauls. These are not used in d/k calculations but are used to prorate discard
OBS_KALL	NUMBER	Total Kept pounds on an observed trip as recorded by observer. This included both observed and unobserved hauls
OBS_MESH	NUMBER	equivalent field in OBDBS
OBS_MESH_CAT	VARCHAR2
MESH_RECORD_TYPE	VARCHAR2
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. As reported in CFDERS. NULL for VTR Orphans without matching DLR record.
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
PRORATE	NUMBER	ratio of total kept_all / observed kept all
REDFISH_EXEMPTION	VARCHAR2	Exemption fishing under
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
SECTID	VARCHAR2	Groundfish Sector ID number
SNE_SMALLMESH_EXEMPTION	VARCHAR2	Exemption fishing under
SUBTRIP_KALL	NUMBER	Kept all of subtrip from CAMS_LANDINGS
TRIPCATEGORY	VARCHAR2	Scallop fleet designation, if applicable
VTRSERNO	VARCHAR2	A unique serial number used to identify a vessel trip report. NULL = Unknown
XLRG_GILLNET_EXEMPTION	VARCHAR2	Exemption fishing under
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.

Table 10.21:

COLUMN_NAME	DATA_TYPE	COMMENTS
YEAR	VARCHAR2	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.
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
LINK1	VARCHAR2	Observer LINK1 if trip was observed
LINK3	VARCHAR2	Observer recorded haul
OBSRFLAG	VARCHAR2	Flag for whether the haul was observed
OFFWATCH	VARCHAR2
OBS_AREA	VARCHAR2	The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code reported by the observer. Unknown = 000.
VMS_AREA	VARCHAR2

Table 10.22: CAMS_SUBTRIP : All commerical trips and subtrips with official landings reported

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

Table 10.23: CAMS_VTR_ORPHANS : VTR trips that do not match to dealer trips. Considered preliminary or data errors if dealer records have had time to come in.

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

Table 10.24: CAMS_VTR_ORPHANS_SUBTRIP : VTR landings on subtrips trips that do not match to dealer trips. Considered preliminary or data errors if dealer records have had time to come in.

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

Table 10.25: CAMS_VTR_REC : All recreational (party/charter) official landings. These records are not in CAMS_LAND but the structures match for a UNION ALL if needed.

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

Table 10.26: CAMS_VTR_REC_SUBTRIP : All recreational (party/charter) official subtrips from VTRs. This table can be left joined to CAMS_VTR_REC using CAMSID and SUBTRIP

COLUMN_NAME	DATA_TYPE	COMMENTS
CAMS_VTR_REC_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

Table 10.27: CFG_CATCH_SOURCE : Dealer catch source and code

COLUMN_NAME	DATA_TYPE	COMMENTS
DLR_CATCH_SOURCE_CODE	VARCHAR2
DLR_CATCH_SOURCE	VARCHAR2

Table 10.28: CFG_DISCARD_MORTALITY_STOCK : Discard mortality rates by species, stock area and cams_gear_group used in the calculation of discard estimates

COLUMN_NAME	DATA_TYPE	COMMENTS
COMMON_NAME	VARCHAR2	Species common name
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
SPECIES_ESTIMATION_REGION	VARCHAR2	Stock of species as defined in support table
CAMS_GEAR_GROUP	VARCHAR2	CAMS gear group used for discard stratification. Species and stock specific
DISC_MORT_RATIO	NUMBER	Species and gear/mesh specific discard mortality multiplier. Defaults to 1 unless otherwise specified in support table

Table 10.29: CFG_DISCARD_RUNID : List of species itis run with the discard module and relevant fishing year

COLUMN_NAME	DATA_TYPE	COMMENTS
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
ITIS_NAME	VARCHAR2	Integrated Taxonomic Information System species common name
RUN_ID	VARCHAR2

Table 10.30: CFG_DISCARD_SOURCE : All of the possilbe discard sources in CAMS with description

COLUMN_NAME	DATA_TYPE	COMMENTS
DISCARD_SOURCE	VARCHAR2	Source of discard, observed, EM, VTR, In-season, etc. see documentation for details
DISCARD_SOURCE_NAME	VARCHAR2
DESCRIPTION	VARCHAR2

Table 10.31: CFG_EXTRACT_TABLES : Source data tables extraction list

COLUMN_NAME	DATA_TYPE	COMMENTS
LOAD_ORDER	VARCHAR2	Load Order
FILE_NAME	VARCHAR2	MAPS file name
UPDATE_FLAG	VARCHAR2	Flag that sets when to check for updates D = daily
DATA_GROUP	VARCHAR2	Source data group
SQL_TABLE	VARCHAR2	Source database table name
BASE_VALUE	VARCHAR2	Hash value of base table
BASE_DATE	TIMESTAMP(6)	Date of base table extraction
UPDATE_VALUE	VARCHAR2	Hash value of updated table
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.32: CFG_FED_AREA : Federal statistical area support table. One row per statistical area.

COLUMN_NAME	DATA_TYPE	COMMENTS
CFG_FED_AREA_ID	CHAR
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.
REGION_HAKE	VARCHAR2
AREA_HERR	VARCHAR2	Herring management area.
AREA_RHS	VARCHAR2
AREA_HADD_HERR	VARCHAR2
AREA_7130	VARCHAR2
AREA_BROAD_STOCK	VARCHAR2
LOBSTER_AREA	VARCHAR2	Corresponding lobster management area to statistical area.

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
RUN_ID	VARCHAR2
DATE_START	DATE
DATE_END	DATE
COMMENTS	VARCHAR2

Table 10.34: CFG_GEARCODE_STRATA : Species specific cams gear groups defined by VTR gear codes used in the calculation of discard estimates. Includes a column indicating whether or not discards are estimated for a cams gear group by species

COLUMN_NAME	DATA_TYPE	COMMENTS
COMMON_NAME	VARCHAR2	Species common name
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
CAMS_GEAR_GROUP	VARCHAR2	CAMS gear group used for discard stratification. Species and stock specific
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
ESTIMATE_DISCARDS	VARCHAR2

Table 10.35: CFG_ITIS : Definitive species names and codes with one row per Integrated Taxonomic Information System Taxonomic Serial Numer (ITIS_TSN).

COLUMN_NAME	DATA_TYPE	COMMENTS
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name
ITIS_NAME	VARCHAR2	Integrated Taxonomic Information System species common name
ITIS_GROUP0	VARCHAR2	General grouping of ITIS TSN for apportionment
ITIS_GROUP2	VARCHAR2	Specific grouping of ITIS TSN
ITIS_GROUP1	VARCHAR2	Actual grouping of ITIS TSN for apportionment
DLR_NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
DLR_SPPNAME	VARCHAR2	Northeast Species CFDBS dealer (DLR) species common name
VTR_SPPCODE	VARCHAR2	Northeast Vessel Trip Report (VTR) species code
VTR_SPPNAME	VARCHAR2	Northeast Vessel Trip Report (VTR) species name
FAO_3ACODE	VARCHAR2
FAO_SCI_NAME	VARCHAR2
FAO_NAME	VARCHAR2
FMP	VARCHAR2	Fishery Management Plan
COUNCIL	VARCHAR2	Council responsible for management under a federal fisheries management plan. For those species jointly managed by the New England Fisheries Management Council and the Mid-Atlantic Management Council; the first council listed is the lead council for that fisheries management plan.
ESA_LISTED	VARCHAR2	Indicates whether a species is federally listed under the Endangered Species Act.

Table 10.36: CFG_ITIS_UPDATE : Table to update and correct source ITIS TSN values to standardize MAPS ITIS TSN values

COLUMN_NAME	DATA_TYPE	COMMENTS
SRCE_ITIS_TSN	VARCHAR2	Source data species Integrated Taxonomic Information System Taxonomic Serial Number
SRCE_SCI_NAME	VARCHAR2	Source data species scientific name
SRCE_ITIS_STAT	VARCHAR2	Source data Integrated Taxonomic Information System Status
SRCE_ITIS_UPDATE	VARCHAR2	Integrated Taxonomic Information System Update Flag
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name

Table 10.37: CFG_NBR_FLEET : Vessel information to be used in the National Bycatch Report for discard stratification

COLUMN_NAME	DATA_TYPE	COMMENTS
NBR_FLEET_ID	VARCHAR2	Identifier for the region and fishery used in the National Bycatch Report
FISHERY_NAME	VARCHAR2	Full name of the region and fishery used in the National Bycatch Report
FLEET_REGION	VARCHAR2	General designation area for the National Bycatch Report. MA = Mid-Atlantic. NE = New England.
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
SECGEAR_MAPPED_NAME	VARCHAR2
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.
ACCESSAREA	VARCHAR2	Scallop Access Area, only relevant for scallop trips
TRIPCATEGORY	VARCHAR2	Scallop fleet designation, if applicable
PERMIT_STATE_FED	VARCHAR2	Whether the permit number was FEDERAL (<> 000000) or STATE (= 000000)
FISHERY_ID_OLD	NUMBER	Fishery indicator used in older versions of the National Bycatch Report

Table 10.38: CFG_NBR_ITIS : Species information to be used in the National Bycatch Report

COLUMN_NAME	DATA_TYPE	COMMENTS
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
ITIS_NAME	VARCHAR2	Integrated Taxonomic Information System species common name
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name
ITIS_GENUS	VARCHAR2
ITIS_FAMILY	VARCHAR2
ITIS_ORDER	VARCHAR2
ITIS_CLASS	VARCHAR2
HABITAT	VARCHAR2	General classification of whether a species is considered pelagic, demersal, or benthic in the National Bycatch Report
MANAGEMENT	VARCHAR2	Idicator of whether the species is in a fisheries management plan
MANAGEMENT_GROUP	VARCHAR2	Name of the larger regulating body for managed species used in the National Bycatch Report
NBR_SPP_GROUP	VARCHAR2	Larger grouping based on order and habitat for species analyzed in the National Bycatch Report

Table 10.39: CFG_NEGEAR : Information about official set of CAMS gears. One row per NEGEAR.

COLUMN_NAME	DATA_TYPE	COMMENTS
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR_NAME	VARCHAR2	Name for the NEGEAR code.
MESH_MATCH	VARCHAR2
SECGEAR_MAPPED	VARCHAR2	Gear Mapping used for matching VTR subtrip to LINK3
FMCODE	VARCHAR2	Code to indicate mobile gear (M), Fixed gear (F), or other gear (O). Refer to CFG_NEGEAR for specific gear FMCODES.
ACCSP_CATEGORY_CODE	VARCHAR2

Table 10.40: CFG_NEMAREA : Northeast marine statistical area support table. One row per nemarea. NEMAREA to AREA conversion table.

COLUMN_NAME	DATA_TYPE	COMMENTS
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.
AREA_REG	VARCHAR2	NMFS Region code: 0=Mississippi River; 1=New England; 2=Mid-Atlantic; 3=Chesapeake Bay; 4=South Atlantic; 5=Gulf of Mexico; 6=Pacific; 7=Great Lakes; 8= Hawaii
AREA_STCD	VARCHAR2	The standard 2-digit state code (07=CT, 08=DE, 22=ME, 23=MD, 24=MA, 32=NH, 33=NJ, 35=NY, 36=NC, 42=RI, 49=VA, 99=unknown)
AREA_WATCD	VARCHAR2	NMFS Water Body code
AREA_NAME	VARCHAR2	Descriptive name for area
NAFODIV	VARCHAR2	The alpha NAFO Division code.
NAFDVCD	VARCHAR2	The numeric Northwest Atlantic Fisheries Organization (NAFO) Division code

Table 10.41: CFG_NESPP3_ITIS : Table to update NESSP3 missing ITIS_TSN (one-way only)

COLUMN_NAME	DATA_TYPE	COMMENTS
DLR_NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
DLR_SPPNAME	VARCHAR2	Northeast Species CFDBS dealer (DLR) species common name
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name

Table 10.42: CFG_OBSERVER_CODES : Observer codes not used in discard rate estimation by species

COLUMN_NAME	DATA_TYPE	COMMENTS
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
OBS_CODES	VARCHAR2

Table 10.43: CFG_PORT : Table with port-level information

COLUMN_NAME	DATA_TYPE	COMMENTS
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.
PORT_NAME	VARCHAR2
STATE_ABB	VARCHAR2
COUNTY_NAME	VARCHAR2
PSREGION	VARCHAR2
AREA_ADJ_PORT	VARCHAR2
PORT_GRP	VARCHAR2	Port groups used for imputation.
SUFFIX	VARCHAR2
TO_CHECK	VARCHAR2
DOC	DATE

Table 10.44: CFG_SCALLOP_AREA : Provides extended names for scallop access areas

COLUMN_NAME	DATA_TYPE	COMMENTS
PROGRAM	VARCHAR2
CAMS_SCALLOP_CODE	VARCHAR2
PROGNAMEABB	VARCHAR2
PROGNAME	VARCHAR2
PROGDESC	VARCHAR2
STUDYDATES	VARCHAR2
PROGCOMMENTS	VARCHAR2
DOE	DATE	Date of entry from CFDERS or VTR based on landing source.
UOE	VARCHAR2
DOC	DATE
PROG_BEGDATE	DATE
PROG_ENDDATE	DATE

Table 10.45: CFG_SRCE_ITIS : Translational table to map the ITIS codes from source data to a unified set of valid ITIS codes. Multiple rows per ITIS_TSN.

COLUMN_NAME	DATA_TYPE	COMMENTS
SRCE_ITIS_TSN	VARCHAR2	Source data species Integrated Taxonomic Information System Taxonomic Serial Number
SRCE_SCI_NAME	VARCHAR2	Source data species scientific name
SRCE_ITIS_STAT	VARCHAR2	Source data Integrated Taxonomic Information System Status
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name
ITIS_NAME	VARCHAR2	Integrated Taxonomic Information System species common name
ITIS_GROUP0	VARCHAR2	General grouping of ITIS TSN for apportionment
ITIS_GROUP2	VARCHAR2	Specific grouping of ITIS TSN
ITIS_GROUP1	VARCHAR2	Actual grouping of ITIS TSN for apportionment
DLR_NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
DLR_SPPNAME	VARCHAR2	Northeast Species CFDBS dealer (DLR) species common name
VTR_SPPCODE	VARCHAR2	Northeast Vessel Trip Report (VTR) species code
VTR_SPPNAME	VARCHAR2	Northeast Vessel Trip Report (VTR) species name
FAO_3ACODE	VARCHAR2
FAO_SCI_NAME	VARCHAR2
FAO_NAME	VARCHAR2
FMP	VARCHAR2	Fishery Management Plan
COUNCIL	VARCHAR2	Council responsible for management under a federal fisheries management plan. For those species jointly managed by the New England Fisheries Management Council and the Mid-Atlantic Management Council; the first council listed is the lead council for that fisheries management plan.
ESA_LISTED	VARCHAR2	Indicates whether a species is federally listed under the Endangered Species Act.

Table 10.46: CFG_STATAREA_STOCK : Definition of stock area as a fucntion of stat area and species

COLUMN_NAME	DATA_TYPE	COMMENTS
COMMON_NAME	VARCHAR2	Species common name
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
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_TYPE	VARCHAR2
SPECIES_ESTIMATION_REGION	VARCHAR2	Stock of species as defined in support table

Table 10.47: CFG_STOCK_ASSESSMENT_AREAS : Table to define species stocks by ITIS_TSN, GARFO federal statistical area, stock type, and applicable dates. Use STOCK_TYPE = ‘STANDARD’ and date_end is NULL to select the current standard stock definitions

COLUMN_NAME	DATA_TYPE	COMMENTS
CFG_STOCK_ASSESSMENT_AREAS_ID	CHAR
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
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.
ASSESSMENT_TYPE	VARCHAR2
ASSESSMENT_STOCK_AREA	VARCHAR2
DATE_START	DATE
DATE_END	DATE
DATE_MODIFIED	DATE

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
CAMS_VERSION	VARCHAR2
DATE_START	DATE
COMMENTS	VARCHAR2

Table 10.48: CFG_VLGEAR : Table mapping VTR gear codes to NEGEAR codes.

COLUMN_NAME	DATA_TYPE	COMMENTS
VTR_GEAR	VARCHAR2	3-letter VTR gearcode reported by the VTR
FMCODE	VARCHAR2	Code to indicate mobile gear (M), Fixed gear (F), or other gear (O). Refer to CFG_NEGEAR for specific gear FMCODES.
NEGEAR	VARCHAR2	Northeast Gear code. Unknown = 000. Refer to GEAR_SOURCE for metadata about gear in final tables.
NEGEAR2	VARCHAR2	First two digits of the Northeast Gear code.
VTR_GEAR_NAME	VARCHAR2	Name of the gear reported by the VTR
MINHAUL	NUMBER
MAXHAUL	NUMBER
MINSOAK	NUMBER
MAXSOAK	NUMBER
MINQTY	NUMBER
MAXQTY	NUMBER
QTYUNIT	VARCHAR2
MINSIZE	NUMBER
MAXSIZE	NUMBER
SIZUNIT	VARCHAR2
SIZMEAS	VARCHAR2
MINMESH	NUMBER
MAXMESH	NUMBER
MESHUNIT	VARCHAR2
MESHMEAS	VARCHAR2
SOAKUOM	VARCHAR2
SOAKTYPE	VARCHAR2
SOAK_MAY_EXCEED_TRIP	NUMBER

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
CFG_VPS_PORT_ID	CHAR
VPS_PORT_NAME	VARCHAR2
VPS_STATE_PROVINCE_CODE	VARCHAR2
FIPS_PORT_ID	VARCHAR2
PORT_ID	CHAR

Table 10.49: CFG_VTR_ITIS : Table to convert VTR SPPCODE to ITIS_TSN or NESPP3 (one-way only)

COLUMN_NAME	DATA_TYPE	COMMENTS
VTR_SPPCODE	VARCHAR2	Northeast Vessel Trip Report (VTR) species code
VTR_SPPNAME	VARCHAR2	Northeast Vessel Trip Report (VTR) species name
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
DLR_NESPP3	VARCHAR2	The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. Legacy code. For 2020+ use ITIS_TSN.
ITIS_SCI_NAME	VARCHAR2	Integrated Taxonomic Information System Scientific Name

Table 10.50: CFG_VTR_UOM : Table to convert VTR SPPCODE Unit of Measure to pounds

COLUMN_NAME	DATA_TYPE	COMMENTS
VTR_SPPCODE	VARCHAR2	Northeast Vessel Trip Report (VTR) species code
VTR_SPPNAME	VARCHAR2	Northeast Vessel Trip Report (VTR) species name
VTR_UOM	VARCHAR2	Original unit of measurement for the Reported Quantity prior to conversion to landed and live pounds.
VTR_SPP_CONV	NUMBER	Conversion factor to lbs for VTR species reporting standard UOM
VTR_99998_CONV	NUMBER	Conversion factor to lbs for VTR species reporting dealer code 99998
VTR_NO_CONV	NUMBER	Conversion factor to lbs for VTR charty/party reporting counts

Table 10.51: MATCH_AMS_VTR : Table of CAMSID for all trips reported through VTR and VMS (through AMS) systems and their associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
DASID	VARCHAR2	AMS Days At Sea Trip Identifier
AMS_TRIP	NUMBER
ACTIVITY_CODE	VARCHAR2	VMS declaration
AMS_PROG	VARCHAR2	Fishery Program as taken from VMS declaration in AMS
AMS_MULT_CHRG	NUMBER
AMS_SAIL	TIMESTAMP(6)	Date trip departed across VMS demarcation, taken from AMS
AMS_LAND	TIMESTAMP(6)	Date trip returned across VMS decmarc, taken from AMS
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
VTR_TRIPCATG	NUMBER	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_CAR	VARCHAR2	T/F: VTR reported as a herring carrier trip via TRIP_ACTIVITY_TYPE = 5 or using VTR gear code = CAR
VTR_ACTIVITY	NUMBER	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_NC	VARCHAR2	VTR-indicated no-catch trip.
VTR_SAIL	TIMESTAMP(6)	Date and time vessel left the dock.
VTR_LAND	TIMESTAMP(6)	VTR landing date
RECORD_SAIL	TIMESTAMP(6)	Official sail date for the trip.
RECORD_LAND	TIMESTAMP(6)	Official landing date for the trip. Assigned with priority order of VTR, VMS, then DLR based on available data for the trip.
AMSVTRID	VARCHAR2
AMSVTR_ORPHAN	NUMBER
AMSVTR_STITCH	NUMBER
AMSVTR_SCORE	NUMBER
AMSVTR_TRIPID	VARCHAR2
AMSVTR_STITCH_TYPE	VARCHAR2
AMSVTR_STITCHID	VARCHAR2
RECORD_RANK	NUMBER
STITCH_RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.52: MATCH_CFLEN : Table of CAMSID for all trips reported through CFLEN and the associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
CFLEN_LINK	VARCHAR2
CFLEN_DATE	TIMESTAMP(6)
CFLEN_VTR	VARCHAR2
CFLEN_VTRQA_STAT	VARCHAR2
CFLEN_SCORE	NUMBER
CFLEN_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.53: MATCH_CFLEN_DSM : Table of CAMSID for all trips reported through CFLEN collected by the dock side monitoring (DSM) program and the associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
CFLEN_DSM_DOCN	VARCHAR2	Number assigned to each weighout form, or negative dealer report; Unique within a month.
CFLEN_DSM_DATE	TIMESTAMP(6)
CFLEN_DSM_VTR	VARCHAR2
CFLEN_DSM_VTRQA_STAT	VARCHAR2
CFLEN_DSM_SCORE	NUMBER
CFLEN_DSM_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.54: MATCH_DLR : Table of CAMSID for federal trips reported by commercial seafood dealers.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
DLR_COMBOID	VARCHAR2
DLR_DATE	TIMESTAMP(6)	Date of the dealer transaction.
DLR_VTR	VARCHAR2	From CFDERS: VTR serial number (VTRSERNO) reported by the dealer.
DLR_VTRQA_STAT	VARCHAR2
DLR_SCORE	NUMBER
DLR_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.55: MATCH_DLR_PZERO : Table of CAMSID for trips from state vessels reported by commercial seafood dealers.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
DLR_COMBOID	VARCHAR2
DLR_DATE	TIMESTAMP(6)	Date of the dealer transaction.
DLR_VTR	VARCHAR2	From CFDERS: VTR serial number (VTRSERNO) reported by the dealer.
DLR_VTRQA_STAT	VARCHAR2
DLR_SCORE	NUMBER
DLR_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.56: MATCH_HERR_CATCH : Table of CAMSID for all herring trips reported through VMS and the associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
HERRCATID	VARCHAR2
HERRCAT_DATE	TIMESTAMP(6)
HERRCAT_VTR	VARCHAR2
HERRCAT_VTRQA_STAT	VARCHAR2
HERRCAT_SCORE	NUMBER
HERRCAT_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.57: MATCH_MQRS_MRI : Table of CAMSID for all MRI trips and the associated matching information.

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.
MQRS_FISHERY	VARCHAR2
MQRS_MRI	NUMBER
MQRS_APNUM	NUMBER
MQRS_AUTH	VARCHAR2
VPS_AUTHID	NUMBER

Table 10.58: MATCH_MULT_CATCH : Table of CAMSID for all multispecies (groundfish) trips reported through VMS and the associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
MULTCATID	VARCHAR2
MULTCAT_TIME	TIMESTAMP(6)
MULTCAT_VTR	VARCHAR2
MULTCAT_VTRQA_STAT	VARCHAR2
MULTCAT_SCORE	NUMBER
MULTCAT_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.59: MATCH_MULT_SECTID : Table of CAMSID and associated sector information during that trip.

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.
MULT_MRI	NUMBER
SECTID	NUMBER	Groundfish Sector ID number

Table 10.60: MATCH_MULT_SET : NA

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
MULTCATID	VARCHAR2
MULTCAT_TIME	TIMESTAMP(6)
MULTCAT_VTR	VARCHAR2
MULT_SET	VARCHAR2
MULTCAT_SCORE	NUMBER
MULTCAT_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.61: MATCH_MULT_START : NA

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
MULTHAILID	VARCHAR2
MULTHAIL_DATE	TIMESTAMP(6)
MULTHAIL_VTR	VARCHAR2
MULTHAIL_VTRQA_STAT	VARCHAR2
MULTHAIL_SCORE	NUMBER
MULTHAIL_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.62: MATCH_OBS : Table of CAMSID for all trips reported through the observer program and the associated matching information.

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
OBS_LINK1	VARCHAR2	Observer recorded LINK1
OBS_HAULS	NUMBER
OBS_SAIL	TIMESTAMP(6)	equivalent field in OBDBS
OBS_LAND	TIMESTAMP(6)	equivalent field in OBDBS
OBS_VTR	VARCHAR2	Observer recorded VTR Serial number. Only one VTR per observed trip is recorded
OBS_VTRQA_STAT	VARCHAR2
OBS_SCORE	NUMBER
OBS_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.63: MATCH_SCAL_PRELAND : NA

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
SCALPREID	NUMBER
SCALPRE_SENT	TIMESTAMP(6)
SCALPRE_VTR	VARCHAR2
SCALPRE_VTRQA_STAT	VARCHAR2
SCALPRE_SCORE	NUMBER
SCALPRE_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.64: MATCH_SCAL_VMS : NA

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
SCALCAT_MSGID	NUMBER
SCALCAT_SENT	TIMESTAMP(6)
SCALCAT_VTR	VARCHAR2
SCALCAT_VTRQA_STAT	VARCHAR2
SCALCAT_SCORE	NUMBER
SCALCAT_MATCH	VARCHAR2
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.65: MATCH_TRIPID : The complete list of trips and the associated CAMSID for all federally permitted vessels

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
AMS_PROG	VARCHAR2	Fishery Program as taken from VMS declaration in AMS
AMS_MULT_CHRG	NUMBER
RECORD_SAIL	TIMESTAMP(6)	Official sail date for the trip.
RECORD_LAND	TIMESTAMP(6)	Official landing date for the trip. Assigned with priority order of VTR, VMS, then DLR based on available data for the trip.
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.66: MATCH_TRIPID_PZERO : The complete list of trips and the associated CAMSID for all non-federally permitted (state) vessels

COLUMN_NAME	DATA_TYPE	COMMENTS
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
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.
UTID	VARCHAR2
AMS_PROG	VARCHAR2	Fishery Program as taken from VMS declaration in AMS
AMS_MULT_CHRG	NUMBER
RECORD_SAIL	TIMESTAMP(6)	Official sail date for the trip.
RECORD_LAND	TIMESTAMP(6)	Official landing date for the trip. Assigned with priority order of VTR, VMS, then DLR based on available data for the trip.
RANK	NUMBER
UPDATE_DATE	TIMESTAMP(6)	Date of updated table extraction

Table 10.67: MATCH_VPSPLAN : The list of fishery plans associated with each permit during a trip based on the dates of the trip and the federal permit dates.

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.
VPS_PLAN	VARCHAR2
VPS_CAT	VARCHAR2

Table 10.68: MATCH_VPSVESSEL : Vessel information associated with each trip based on the permit and date of the trip.

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.
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
VPS_APYEAR	NUMBER
VPS_APNUM	NUMBER
VPS_HULLID	VARCHAR2
HAIL_PORT	VARCHAR2
HAIL_ST	VARCHAR2
PRINC_PORT	VARCHAR2
PRINC_ST	VARCHAR2
VES_NAME	VARCHAR2
VES_CREW	NUMBER
VES_PASS	NUMBER
VES_BUILT	NUMBER
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.
VES_HOLD	NUMBER
VES_TONS	NUMBER	Tonnage reported for the vessel in the permit system.
VES_LEN	NUMBER	Length of the vessel in feet from the permit system.
VES_MAT	VARCHAR2
VES_PROP	VARCHAR2
VES_HP	NUMBER
VES_PUMP_HP	NUMBER
VES_DREGS	NUMBER
VES_DREG_SIZE	NUMBER
VES_LOB_TRAPS	NUMBER
VES_MAX_TRAPS	NUMBER

Table 10.69: QA_GF_EM_SUBTRIP : Table with information regarding QA/QC with reviewed trips in the groundfish electronic monitoring program

COLUMN_NAME	DATA_TYPE	COMMENTS
DOCID	VARCHAR2	Document ID from VTR. One per trip regardless of number of subtrips.
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
REVIEW_SEQ	NUMBER	Unique identifier for electronically reviewed trips.
EM_PSUEDO_SUBTRIP	VARCHAR2	EM subtrips are defined based on docid, stat area and accsp gear category and are used to match em hauls with vtr subtrips.
DELTA_USED	VARCHAR2	Indicates whether a reviewed em_psuedo_subtrip was used in the fit of the delta model and whether the EM reviewed estimates were used for the subtrip.
EM_PASS	VARCHAR2	Indicates whether an em pseudo subtrip passed or failed review (1 = PASS and 0 = FAIL). EM pseudo subtrips fail if any hauls are unobserved or if percentage of fish unknown (FISHNK) is >0.10 at the pseudo subtrip level.
FISHNK_PCT_WEIGHT_CT30	NUMBER	Average percentage of fish unknown across GF species by EM pseudo subtrip. Average is weighted by the total weight of discards by species and EM pseudo subtrip.
HAUL_OBSERVED	VARCHAR2	Indicates whether all hauls have been observed by video on a pseudo electronically monitored subtrip.
GEAR_AREA_MATCH	VARCHAR2	Indicates whether an electronically monitored subtrip matches to a VTR reported subtrip based on accsp gear category and statistical area.
FISHING_YEAR	NUMBER	Fishing Year
DATE_TRIP	DATE	Hierarchical detemined date of trip based on date landed. Order is : VTR > AMS > Dealer

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
DATE_GRAB	DATE
STRATA_USED_DESC	VARCHAR2	Strata specific values used to estimate discard amount on a given subtrip.
DISCARD_SOURCE	VARCHAR2	Source of discard, observed, EM, VTR, In-season, etc. see documentation for details
N_OBSERVED	NUMBER	Number of observed subtrips in the discard stratum. For DISCARD_SOURCE = T or G, this value includes observed trips in the previous fishing year.
N_UNOBSERVED	NUMBER	Number of unobserved subtrips in the discard stratum. This value is always within the referenced fishing year (i.e. does not include anything fro the previous fishing year)
CAMS_DISCARD_RATE	NUMBER	CAMS estimated discard rate. Final rate assigned according to business rules and in accordance with DIscard Source
DATE_RUN	DATE	Date the CAMS program was run to create the record
FY	NUMBER	Fishing Year
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
FY_TYPE	VARCHAR2	Type of fishing year, i.e. May start, January start, April start, etc.
STRATA_FY	NUMBER
SPECIES_ESTIMATION_REGION	VARCHAR2	Stock of species as defined in support table
CAMS_GEAR_GROUP	VARCHAR2	CAMS gear group used for discard stratification. Species and stock specific
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.
STRATA_TRIPCATEGORY	VARCHAR2	Scallop trip category used in the discard stratification
STRATA_ACCESSAREA	VARCHAR2	Scallop access area used in the discard stratification
STRATA_SECTID	VARCHAR2	Groundfish sector identification number
STRATA_EM	VARCHAR2	EM program 1 or 2 category used in stratification. NULL for non-EM trips
STRATA_REDFISH_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the redfish exemption was used in the discard stratification
STRATA_SNE_SMALLMESH_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the southern New England smallmesh exemption was used in the discard stratification
STRATA_XLRG_GILLNET_EXEMPTION	VARCHAR2	Boolian 0/1 for whether the extra large gillnet exemption was used in the discard stratification
STRATA_EXEMPT_7130	VARCHAR2	Boolian 0/1 for whether the groundfish west of 71 degrees 30 minutes exemption was used in the discard stratification
STRATA_SECTOR_TYPE	VARCHAR2	Sector category used in the discard stratification
STRATA_SCALLOP_AREA	VARCHAR2	Scallop area used in the discard stratification
CAMS_DISCARD	NUMBER	CAMS estimated discard in pounds
SUBTRIP_KALL	NUMBER	Kept all of subtrip from CAMS_LANDINGS
CAMS_SUBTRIP_CNT	NUMBER
CAMS_DISCARD_VARIANCE	NUMBER

Table 10.70: QC_DISCARD_TRACKER : Snapshot grabs of CAMS_DISCARD_ALL_YEARS of new or recalculated discards to support comparisons of discard estimations through time

COLUMN_NAME	DATA_TYPE	COMMENTS
DATE_GRAB	DATE
DATE_RUN	DATE	Date the CAMS program was run to create the record
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.
YEAR_TYPE	VARCHAR2
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
DISCARD_SOURCE	VARCHAR2	Source of discard, observed, EM, VTR, In-season, etc. see documentation for details
SPECIES_ESTIMATION_REGION	VARCHAR2	Stock of species as defined in support table
CAMS_GEAR_GROUP	VARCHAR2	CAMS gear group used for discard stratification. Species and stock specific
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.
CAMS_DISCARD	NUMBER	CAMS estimated discard in pounds
SUBTRIP_KALL	NUMBER	Kept all of subtrip from CAMS_LANDINGS
CAMS_SUBTRIP_CNT	NUMBER
CAMS_DISCARD_VARIANCE	NUMBER

Table 10.71: QC_LANDINGS_TRACKER : Weekly snapshot grabs of CAMS_LAND to support comparisons of reported and imputed landings data through time

COLUMN_NAME	DATA_TYPE	COMMENTS
DATE_GRAB	DATE
DATE_RUN	DATE	Date the CAMS program was run to create the record
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.
ITIS_TSN	VARCHAR2	Integrated Taxonomic Information System (ITIS) - Taxonomic Species Number (TSN). NULL for No-Catch records.
VARIABLE_NAME	VARCHAR2
VARIABLE_LEVEL	VARCHAR2
N_TRIP	NUMBER
N_SUBTRIP	NUMBER	Number of subtrips during the trip. A subtrip is defined as any change in area, gear, or mesh. Calculated after imputations.
N_RECORD	NUMBER
N_NULL_VALUE	NUMBER
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.

Table 10.72: SIMM_DISCARD_STRATA_USED : Discard strata for groundfish pulled for use in building SIMM report tool

COLUMN_NAME	DATA_TYPE	COMMENTS
STRATA_USED_DESC	VARCHAR2	Strata specific values used to estimate discard amount on a given subtrip.
STRATA_USED	VARCHAR2	Stratification used to estimate discard amount on a given subtrip.

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
SECTOR_NAME	VARCHAR2
VESSEL_NAME	VARCHAR2
FISHING_YEAR	NUMBER	Fishing Year
TRIP_ID	VARCHAR2
TRIP_ID_TYPE	CHAR
TRIP_SAIL	DATE
TRIP_LAND	DATE
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
SECTOR_ID	VARCHAR2
FISHERY_GROUP	VARCHAR2	Primary targeted fishery group
OTHER_STRATA	VARCHAR2
GILLNET_EXEMPTION	VARCHAR2
EXEMPTS_7130	VARCHAR2
OBSERVER	NUMBER
LINK1	VARCHAR2	Observer LINK1 if trip was observed
TRIPEXT	VARCHAR2
PROGRAM_CODE	VARCHAR2
OBSERVER_MODE	VARCHAR2
DISCARD_SOURCES	VARCHAR2
MONITOR_PROGRAM	VARCHAR2
OBS_TRIP_NUM	NUMBER
OBS_TRIP_DENOM	NUMBER
ASM_NUM	NUMBER
EM_TRIP_NUM	NUMBER
NEFOP_NUM	NUMBER
NEFOP_LIMITED_NUM	NUMBER
MONITORED_TRIP_NUM	NUMBER
MONITORED_TRIP_DENOM	NUMBER
CAMS_DATE_RUN	DATE
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.

Table 10.33:

COLUMN_NAME	DATA_TYPE	COMMENTS
FISHING_YEAR	NUMBER	Fishing Year
SECTOR_NAME	VARCHAR2
SECTOR_ID	VARCHAR2
VESSEL_PERMIT_NUMBER	VARCHAR2
VESSEL_NAME	VARCHAR2
Groundfish Trips	NUMBER
ASM Observed	NUMBER
EM Observed	NUMBER
NEFOP Observed	NUMBER
NEFOP Limited Observed	NUMBER
Total Observed Trips	NUMBER
ASM Coverage Rate	NUMBER
EM Coverage Rate	NUMBER
NEFOP Coverage Rate	NUMBER
NEFOP Limited Coverage Rate	NUMBER
Combined Coverage Rate	NUMBER
CAMS_DATE_RUN	DATE
VTRSERNO / LINK1_TRIPEXT / Monitor Program	VARCHAR2

Last modified: 2025-12-16