Table: CFDERS_ALL_YEARS
Greater Atlantic Regional Fisheries Office
Entity
(ENT)
| ID: 17366
| Published / External
Created: 2013-01-02
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 12205
ID: 17366
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | Table: CFDERS_ALL_YEARS |
---|---|
Short Name | CFDERS_ALL_YEARS |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
CFDERS ALL YEARS combines years 1996 to present from the Northeast Fisheries Science Center. The Science Center maintains a separate table for each fishing year. CFDERS ALL YEARS also has added several attributes that do not exist in the CFDERS data provided by the Center. |
* Purpose |
Local consolidated copies of mandatory dealer reports. Updated nightly from primary data tables in CFDBS. |
Notes |
Loaded by batch 3993, 01-02-2013 14:42 |
Other Citation Details | |
• Supplemental Information |
Server: NERO; Schema: FSO_ADMIN; Table: CFDERS_All_Years |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
None | commercial |
None | commercial fishing |
None | compliance |
None | data quality |
None | dealer |
None | dealer reporting |
None | dealer weighout |
None | electronic reporting |
None | fdsd |
None | fisheries data services division |
None | fishery dependent data |
None | fso |
None | nero |
None | processed products report |
None | quota monitoring |
None | safis |
None | scbi |
Temporal Keywords
Thesaurus | Keyword |
---|---|
None | 1961-present |
* Spatial Keywords
Thesaurus | Keyword |
---|---|
None | atlantic |
None | connecticut |
None | ct |
None | de |
None | delaware |
None | georges bank |
None | gloucester |
None | gulf of maine |
None | ma |
None | maine |
None | maryland |
None | massachusetts |
None | md |
None | me |
None | mid-atlantic |
None | ne |
None | new england |
None | new hampshire |
None | new jersey |
None | new york |
None | nh |
None | nj |
None | northeast |
None | northeast atlantic |
None | northeast u.s. |
None | northern atlantic |
None | northwest atlantic |
None | ny |
None | rhode island |
None | ri |
None | va |
None | virginia |
Stratum Keywords
Thesaurus | Keyword |
---|---|
None | area |
None | catch |
None | effort |
None | species |
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | Greater Atlantic Regional Fisheries Office |
---|---|
• » City | Gloucester |
• » State/Province | MA |
• Country | USA |
• » Location Description |
Fisheries Data Services Division (FDSD) 55 Great Republic Drive |
Entity Information
Entity Type | Data Table |
---|---|
Active Version? | Y |
Alias | |
Schema Name | FSO_ADMIN |
» Description |
CFDERS ALL YEARS combines years 1996 to present from the Northeast Fisheries Science Center. The Science Center maintains a separate table for each fishing year. CFDERS ALL YEARS also has added several attributes that do not exist in the CFDERS data provided by the Center. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | YEAR | VARCHAR2 | The year in which the landings or negative report occurred. |
100 | No | No | YEAR_LINK | VARCHAR2 | The year in which the landings or negative report occurred -- concatenated with -- LINK -The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. |
100 | No | No | DRID_LANDSEQ_SRC | VARCHAR2 | Dealer Report ID, Landing Sequence and Data Source joined to create a key that will be unique when data source is SAFIS - SWCB data sources do not have landing sequences and therefore SWCB records cannot be uniquely identified. |
100 | No | No | PORT | VARCHAR2 | A combined code for state, port and county. The port in which the vessel landed the catch. |
100 | No | No | STATE | VARCHAR2 | 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. |
100 | No | No | PORT2 | VARCHAR2 | The 3rd and 4th digit of the port code--meaningless without the rest of the port code. |
100 | No | No | COUNTY | VARCHAR2 | Name of county., ex.ESSEX. |
100 | No | No | LINK | VARCHAR2 | The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. |
100 | No | No | MONTH | VARCHAR2 | The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. |
100 | No | No | DOCN | VARCHAR2 | Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). |
100 | No | No | DAY | VARCHAR2 | Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. |
100 | No | No | DEALNUM | NUMBER | The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. |
100 | No | No | 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. |
100 | No | No | 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. |
100 | No | No | NEGEAR | VARCHAR2 | Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. |
100 | No | No | NEGEAR2 | VARCHAR2 | First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. |
100 | No | No | 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. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. |
100 | No | No | AREA | VARCHAR2 | The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. |
100 | No | No | HARVEST_AREA | VARCHAR2 | Area codes used by States to identify inshore harvest locations, primarily for shellfish. |
100 | No | No | 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 and vessel log, i.e., detailed effort data. |
100 | No | No | 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 w/o Dealer Report; 13=Canadian Transhipment (no IWP*); 14=NMFS Enforcement; 15=State Enforcement.; *IWP = Internal Waters Processing. |
100 | No | No | 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. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null. |
100 | No | No | SUBTRIP | VARCHAR2 | The split or subtrip number. The subtrip number is 1 for non-split trips (whole trip fished within one area). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. Post 1981 subtrips are identified by document number (DOCN) and subtrip number (SUBTRIP); pre 1982 subtrips are identified by vessel, month, day and subtrip. |
100 | No | No | 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. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table. |
100 | No | No | TONCL1 | VARCHAR2 | The first digit of the tonnage class code:1 = 1 - 4 tons;2 = 5 - 50 tons;3 = 51 - 150 tons;4 = 151 - 500 tons;5 = 501 - 1000 tons;6 = 1001+ tons. |
100 | No | No | TONCL2 | VARCHAR2 | The first two digits of the tonnage class code. |
100 | No | No | SAMPAREA | VARCHAR2 | The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. |
100 | No | No | NESPP4 | VARCHAR2 | The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. |
100 | No | No | NESPP3 | VARCHAR2 | The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. |
100 | No | No | WHSPP | VARCHAR2 | The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes. |
100 | No | No | SPPLNDLB | NUMBER | The pounds landed for a given species. |
100 | No | No | SPPLIVLB | NUMBER | The live weight of species landed. |
100 | No | No | SPPVALUE | NUMBER | The value of landed catch to the nearest dollar (U.S.), paid to fisherman by dealer, for a given species. 0 = unknown. |
100 | No | No | SPRATIO | NUMBER | The ratio of live pounds of a species to total live pounds of the trip. |
100 | No | No | 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. |
100 | No | No | FZONE | VARCHAR2 | The fishing zone in which sample was taken: 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. For 1994+ allocated data, if Area Level = A then Fzone is determined from the VTR trip point location, if available. If Area Level = B, C, or D then Fzone is null. |
100 | No | No | VTRSERNO | VARCHAR2 | The serial number of the first page of the trip report, printed in the upper right corner of the vessel trip report (vtr) form. |
100 | No | No | REPORTED_QUANTITY | NUMBER | The reported quantity of a species by a dealer. Must use unit of measure to interpret. |
100 | No | No | DISPOSITION_CODE | VARCHAR2 | A code indicating the disposition of the catch. See CFDBS. SFDISP for the code descriptions. |
100 | No | No | SPECIES_ITIS | VARCHAR2 | The Integrated Taxonomic Information System (ITIS) serial number for a species. See the SPECIES_ITIS_NE table for a desription of the codes. |
100 | No | No | UOM | VARCHAR2 | The unit of measure for a species reported quantity. See the cfdbs.SAFISUOM table for a description of the codes. |
100 | No | No | GRADE_CODE | VARCHAR2 | Species grade code used by ACCSP. See cfdbs.safisgrade for code descriptions. |
100 | No | No | MARKET_CODE | VARCHAR2 | Market code to indicate the market category for a species sold to a dealer. See cfdbs.safismarket for category descriptions. |
100 | No | No | GEAR_CODE | VARCHAR2 | Gear codes used by ACCSP. |
100 | No | No | FIPS_STATE | VARCHAR2 | FIPS55 state code used by ACCSP. |
100 | No | No | FIPS_PLACE | VARCHAR2 | FIPS55 place code used by ACCSP. |
100 | No | No | FIPS_COUNTY | VARCHAR2 | FIPS55 county code used by ACCSP. |
100 | No | No | DERSOURCE | VARCHAR2 | The code for the system used to report dealer data electronically. SAFIS_K = data is keyed using SAFIS webform; SAFIS_U = data is uploaded from the dealer to SAFIS; SAFIS_S = data is entered through a PC-based entry system and uploaded to SAFIS; CODES = the original data entry system used by Port Agents. |
100 | No | No | CF_LICENSE | VARCHAR2 | Commercial fisherman license issued by a State. |
100 | No | No | PARTNER_ID | VARCHAR2 | A 4-digit code used by ACCSP to identify a partner. The partners are the States on the Atlantic coast and Gulf of Mexico and the Federal Government (0016). |
100 | No | No | STATE_DNUM | VARCHAR2 | State Dealer License Number |
100 | No | No | NEGEAR_VTR | VARCHAR2 | NEGEAR code assigned from the vessel trip report. |
100 | No | No | DEALER_RPT_ID | NUMBER | Confirmation number that identifes the record and is given to the dealer. |
100 | No | No | LANDING_SEQ | NUMBER | Landing Sequence only applies to records from a SAFIS source - the landing sequence identifies each catch level report for a dealer report id. |
100 | No | No | DOE | DATE | Date of entry. |
100 | No | No | ENTRY_DATE | DATE | Entry Date from the SAFIS Audit Dealer Reports reflecting date record entered into SAFIS. |
100 | No | No | DDATE | DATE | Dealer Date is a concatenation of DAY-MONTH-YEAR columns. |
100 | No | No | SPP_COMMON_NAME | VARCHAR2 | Common name for a species based on the nespp3 code. |
100 | No | No | GRADE_DESC | VARCHAR2 | Description of a grade based on SAFIS Grade Code Descriptions. |
100 | No | No | MARKET_DESC | VARCHAR2 | Description of a market based on SAFIS Market Categories. |
100 | No | No | LANDING_DATE_SAFIS | DATE | Landing date from SAFIS Audit Dealer Reports for a corresponding dealer_rpt_id. |
Attribute Details
Attribute Name | YEAR |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year in which the landings or negative report occurred. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEAR_LINK |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The year in which the landings or negative report occurred -- concatenated with -- LINK -The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DRID_LANDSEQ_SRC |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dealer Report ID, Landing Sequence and Data Source joined to create a key that will be unique when data source is SAFIS - SWCB data sources do not have landing sequences and therefore SWCB records cannot be uniquely identified. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PORT |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A combined code for state, port and county. The port in which the vessel landed the catch. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATE |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PORT2 |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 3rd and 4th digit of the port code--meaningless without the rest of the port code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | COUNTY |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Name of county., ex.ESSEX. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINK |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 17 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The field (month-document) used to link species and biological sampling data to the trip information. Length of the link field depends on the year: pre 1994 document numbers (DOCN) were 4 characters; post 1993, 6 characters. For 1994+ allocated data, for CFDETTyyyyAA and CFDETSyyyyAA, LINK = (dlrtrpid, month, docn, subtrip); VARCHAR2(35); For CFAGEyyyyAA and CFLENyyyyAA, 1994 to 2003, Link = (dlrtrpid, month, docn, subtrip); For CFAGEyyyyAA and CFLENyyyyAA, 2004 to present, LINK = (month,docn,tallyno,sampno,linkpad) where linkpad is 15 zeros. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONTH |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The month (01-12) of the vessel landing or negative dealer report. 00 = unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOCN |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Number assigned to each weighout form, or negative dealer report; Unique within a month. For 1994+ allocated data , DOCN column width is expanded, VARCHAR2(15). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DAY |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day of month (01-31). Unknown=00. Day = 00 may indicate a consolidated trip that represents more than one trip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEALNUM |
---|---|
Seq. Order | 12 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | 0 |
Status | Active |
Description |
The dealer permit number assigned by the Northeast Regional Office Permit System (PERMIT). 00000=Unknown. Not available for 1994 in CFDBS data. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PERMIT |
---|---|
Seq. Order | 13 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HULLNUM |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEGEAR |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Northeast Gear code; 999=Unknown. See CFDBS Gear Table(GEAR) for actual codes. For 1994+ allocated data, negear is taken from the matched VTR trip when Area Level = A; negear is supplied by the Dealer when Area Level = B,C,D or X. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEGEAR2 |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First two digits of the Northeast Gear code. See CFDBS Gear Table (GEAR) for actual codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEMAREA |
---|---|
Seq. Order | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then NEMAREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X, then nemarea is unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | AREA |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Northwest Atlantic Fisheries Organization (NAFO) Statistical Area code. See CFDBS Area Table (AREA) for actual codes. For 1994+ allocated data, if Area Level = A then NEMAREA is from the VTR trip. If Area Level = B, C,D then AREA is selected from a group of VTR trips with similar trip characteristics on a probabilistic basis. If Area Level = X then AREA is unknown. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | HARVEST_AREA |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Area codes used by States to identify inshore harvest locations, primarily for shellfish. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | EFFIND |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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 and vessel log, i.e., detailed effort data. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SOURCE |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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 w/o Dealer Report; 13=Canadian Transhipment (no IWP*); 14=NMFS Enforcement; 15=State Enforcement.; *IWP = Internal Waters Processing. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTHCD |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. For 1994+ allocated data, if Area Level = A, then depthcd is derived from the VTR trip; if Area Level = B,C, D or X, depthcd is null. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SUBTRIP |
---|---|
Seq. Order | 23 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The split or subtrip number. The subtrip number is 1 for non-split trips (whole trip fished within one area). For split trips, the first subtrip is 1, the second is 2, the third is 3, etc. Post 1981 subtrips are identified by document number (DOCN) and subtrip number (SUBTRIP); pre 1982 subtrips are identified by vessel, month, day and subtrip. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TONCLASS |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. For pre-82 data, see the applicable appendix of the port manual. For post-81 data, see CFDBS Vesstoncl Table. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TONCL1 |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The first digit of the tonnage class code:1 = 1 - 4 tons;2 = 5 - 50 tons;3 = 51 - 150 tons;4 = 151 - 500 tons;5 = 501 - 1000 tons;6 = 1001+ tons. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TONCL2 |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The first two digits of the tonnage class code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SAMPAREA |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The sample area code for a given species in a given statistical area. See Port Sampling Manual, Appendix A, for details. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NESPP4 |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 4-digit Northeast Species code; the fourth digit represents market category. See CFDBS Species Table (CFSPP) for actual codes. For discard species in the CFDISCyyyy and WODISCyy views, NESPP4 is redefined as NESPP3 preceded by a 9, e.g. yellowtail flounder is 9123. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NESPP3 |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Northeast Species code, without the market category, i.e. the first 3 digits of NESPP4. See CFDBS Species Table (CFSPP) for actual codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WHSPP |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The 3 digit commercial species code developed by the Woods Hole lab. See CFDBS Species Table (CFSPP) for actual codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPPLNDLB |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The pounds landed for a given species. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPPLIVLB |
---|---|
Seq. Order | 32 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The live weight of species landed. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPPVALUE |
---|---|
Seq. Order | 33 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
The value of landed catch to the nearest dollar (U.S.), paid to fisherman by dealer, for a given species. 0 = unknown. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPRATIO |
---|---|
Seq. Order | 34 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | 3 |
Status | Active |
Description |
The ratio of live pounds of a species to total live pounds of the trip. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UTILCD |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
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. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FZONE |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The fishing zone in which sample was taken: 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. For 1994+ allocated data, if Area Level = A then Fzone is determined from the VTR trip point location, if available. If Area Level = B, C, or D then Fzone is null. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VTRSERNO |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The serial number of the first page of the trip report, printed in the upper right corner of the vessel trip report (vtr) form. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | REPORTED_QUANTITY |
---|---|
Seq. Order | 38 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 17 |
Scale | 2 |
Status | Active |
Description |
The reported quantity of a species by a dealer. Must use unit of measure to interpret. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DISPOSITION_CODE |
---|---|
Seq. Order | 39 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A code indicating the disposition of the catch. See CFDBS. SFDISP for the code descriptions. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_ITIS |
---|---|
Seq. Order | 40 |
Data Storage Type | VARCHAR2 |
Max Length | 11 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The Integrated Taxonomic Information System (ITIS) serial number for a species. See the SPECIES_ITIS_NE table for a desription of the codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | UOM |
---|---|
Seq. Order | 41 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The unit of measure for a species reported quantity. See the cfdbs.SAFISUOM table for a description of the codes. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRADE_CODE |
---|---|
Seq. Order | 42 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Species grade code used by ACCSP. See cfdbs.safisgrade for code descriptions. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MARKET_CODE |
---|---|
Seq. Order | 43 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Market code to indicate the market category for a species sold to a dealer. See cfdbs.safismarket for category descriptions. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_CODE |
---|---|
Seq. Order | 44 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear codes used by ACCSP. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIPS_STATE |
---|---|
Seq. Order | 45 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
FIPS55 state code used by ACCSP. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIPS_PLACE |
---|---|
Seq. Order | 46 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
FIPS55 place code used by ACCSP. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | FIPS_COUNTY |
---|---|
Seq. Order | 47 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
FIPS55 county code used by ACCSP. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DERSOURCE |
---|---|
Seq. Order | 48 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The code for the system used to report dealer data electronically. SAFIS_K = data is keyed using SAFIS webform; SAFIS_U = data is uploaded from the dealer to SAFIS; SAFIS_S = data is entered through a PC-based entry system and uploaded to SAFIS; CODES = the original data entry system used by Port Agents. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CF_LICENSE |
---|---|
Seq. Order | 49 |
Data Storage Type | VARCHAR2 |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Commercial fisherman license issued by a State. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | PARTNER_ID |
---|---|
Seq. Order | 50 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A 4-digit code used by ACCSP to identify a partner. The partners are the States on the Atlantic coast and Gulf of Mexico and the Federal Government (0016). |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STATE_DNUM |
---|---|
Seq. Order | 51 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
State Dealer License Number |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | NEGEAR_VTR |
---|---|
Seq. Order | 52 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
NEGEAR code assigned from the vessel trip report. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEALER_RPT_ID |
---|---|
Seq. Order | 53 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 10 |
Scale | 0 |
Status | Active |
Description |
Confirmation number that identifes the record and is given to the dealer. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LANDING_SEQ |
---|---|
Seq. Order | 54 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Landing Sequence only applies to records from a SAFIS source - the landing sequence identifies each catch level report for a dealer report id. |
General Data Type | NUMBER |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DOE |
---|---|
Seq. Order | 55 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date of entry. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | ENTRY_DATE |
---|---|
Seq. Order | 56 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Entry Date from the SAFIS Audit Dealer Reports reflecting date record entered into SAFIS. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DDATE |
---|---|
Seq. Order | 57 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dealer Date is a concatenation of DAY-MONTH-YEAR columns. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPP_COMMON_NAME |
---|---|
Seq. Order | 58 |
Data Storage Type | VARCHAR2 |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Common name for a species based on the nespp3 code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GRADE_DESC |
---|---|
Seq. Order | 59 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of a grade based on SAFIS Grade Code Descriptions. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MARKET_DESC |
---|---|
Seq. Order | 60 |
Data Storage Type | VARCHAR2 |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Description of a market based on SAFIS Market Categories. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LANDING_DATE_SAFIS |
---|---|
Seq. Order | 61 |
Data Storage Type | DATE |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Landing date from SAFIS Audit Dealer Reports for a corresponding dealer_rpt_id. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | Metadata Contact |
---|---|
* » Date Effective From | 2010-01-01 |
Date Effective To | |
Person | Ferguson, Alison |
Address |
55 Great Republic Drive Gloucester, MA 01930 United States |
Email Address | alison.ferguson@noaa.gov |
Phone | 978-281-9209 |
Fax | 978-281-9161 |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Originator |
---|---|
* » Date Effective From | 2010-01-01 |
Date Effective To | |
Person | Washick, Denise A |
Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address | denise.washick@noaa.gov |
Phone | 978-675-2197 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | Point of Contact |
---|---|
* » Date Effective From | 2010-01-01 |
Date Effective To | |
Person | St Cyr, James R |
Address |
55 Great Republic Drive Gloucester, MA 01930 USA |
Email Address | james.stcyr@noaa.gov |
Phone | 978-281-9369 |
Fax | |
Mobile | |
URL | |
Business Hours | |
Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame 1
* » Time Frame Type | Continuing |
---|---|
* » Start | 2010 |
End | |
Alternate Start As Of Info | |
Alternate End As Of Info | |
Description |
CFDERS ALL YEARS combines years 1996 to present from the Northeast Fisheries Science Center. The Science Center maintains a separate table for each fishing year. |
Access Information
* » Security Class | Confidential |
---|---|
* Security Classification System | |
Security Handling Description | |
• Data Access Policy |
Access to dealer data is governed by 50CFR600 - Confidentiality of Information. Access by state fishery management agency staff and Fisheries Management Council staff may be allowed through Memorandum of Understanding that are signed by the NE Regional Administrator and Directors of the State Agency or Councils that describe the need and uses of the data and list the individuals who will have access to the data. Contractors may be granted access provided they are working under contract to NOAA or a cooperating partner (state, Council, Commission) on a specific project under the oversight of a partner. |
» Data Access Procedure |
Contact POC to request access. |
• » Data Access Constraints |
Access is restricted to personnel authorized in accordance with NOAA Administrative Order 216-100. A signed non-disclosure agreement must be on file for all authorized personnel. The APSD Data Request staff are the POC for non-disclosure forms. |
• Data Use Constraints |
Access to individual reports is restricted to NOAA employees and our partners who have signed non-disclosure agreements. Summary data may be made available based on the "rule of 3", i.e., there must be at least three entities included in a summary for the summary information to be made publically available. Data may be made available if there is no information included that could uniquely link the information to an individual entity (person, vessel operating unit, business, etc.). Individually identifiable information may not be released without written authorization from the provider or by court order. |
Metadata Access Constraints | |
Metadata Use Constraints |
There are no constraints on the use of the metadata associated with this program. |
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 17366 |
---|---|
Metadata Record Created By | Denise A Washick |
Metadata Record Created | 2013-01-02 14:42+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-02-29 |
Owner Org | GARFO |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-02-29 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-02-28 |
Tags |
---|