View: OBSPECCONV
Northeast Fisheries Science Center
Entity
(ENT)
| ID: 33573
| Published / External
Created: 2016-07-27
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 24111
ID: 33573
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | View: OBSPECCONV |
---|---|
Short Name | OBSPECCONV |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Observer Species Conversion Table |
* Purpose | |
Notes |
Loaded by batch 9053, 07-27-2016 19:10 |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | Y |
Alias | |
Schema Name | OBDBS |
» Description |
Observer Species Conversion Table |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | NESPP3 | VARCHAR2 | Northeast commercial fish species NESPP3 codes. *Note these do not translate to the species level for the 6000-series of NESPP4 codes (i.e., there are multiple species NESPP3 code for all NESPP3 codes between 600 and 699). Collected for ASM where applicable. |
100 | Yes | No | NESPP4_OBS | VARCHAR2 | Northeast commercial fish species NESPP4 codes contained in OBSPP and OBIAL and consistent with NESPP4 definitions contained in OBSPEC. *Note these NESPP4 codes do not necessarily correspond with CFDBS NESPP4 codes. |
100 | No | No | COMNAME | VARCHAR2 | Common name for the species. |
100 | No | No | MKTNM_OBSPEC | VARCHAR2 | Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4. |
100 | Yes | No | CATDISP_CODE | VARCHAR2 | Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = unknown). |
100 | No | No | CATDISP_DESC | VARCHAR2 | Text description of the CATDISP_CODE column. |
100 | Yes | No | DRFLAG_CODE | VARCHAR2 | Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned). |
100 | No | No | DRFLAG_DESC | VARCHAR2 | Text description of the DRFLAG_CODE field. |
100 | Yes | No | GRADE_CODE | VARCHAR2 | Contains grade code that corresponds with NESPP4||CATDISP||DRFLAG combination from OBDBS. Rationale for the assignment of the GRADE_CODE is provided in GRADE_ASSIGN_COMMENT. |
100 | No | No | GRADE_DESC | VARCHAR2 | Text description of the GRADE_CODE field. |
100 | Yes | No | NESPP4_REASSIGN | VARCHAR2 | The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE. |
100 | Yes | No | NESPP4_OUTPUT | VARCHAR2 | The CFDBS NESPP4 code corresponding to the round grade code for a given species. |
100 | No | No | SPECIES_ITIS | VARCHAR2 | The Integrated Taxonomic Information System (ITIS) serial number for a species. |
100 | No | No | SCIENTIFIC_NAME | VARCHAR2 | The scientific name for a species. |
100 | No | No | MARKET_CODE | VARCHAR2 | Market code to indicate the market category for a species sold to a dealer. |
100 | No | No | MARKET_DESC | VARCHAR2 | Text description of the MARKET_CODE field. |
100 | Yes | No | UOM | VARCHAR2 | Unit of measure. |
100 | Yes | No | CF_LNDLB_LIVLB | NUMBER | Conversion factor to raise the reported pounds landed to the live pounds landed for a given species. |
100 | Yes | No | CF_RPTQTY_LNDLB | NUMBER | Conversion factor to raise the reported quantity to the pounds landed for a given species. |
100 | Yes | No | CONV_FLAG | NUMBER | Indicates where the translation of the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination could be matched to an existing SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table (1 = match, 0 = no match). |
100 | No | No | GRADE_ASSIGN_COMMENT | VARCHAR2 | Provides description of the logic used to translate the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination to a CFDBS GRADE_CODE. |
100 | No | No | MKT_ASSIGN_COMMENT | VARCHAR2 | Contains any notes related to finding a matching SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table for the species and grade. |
Attribute Details
Attribute Name | NESPP3 |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Northeast commercial fish species NESPP3 codes. *Note these do not translate to the species level for the 6000-series of NESPP4 codes (i.e., there are multiple species NESPP3 code for all NESPP3 codes between 600 and 699). Collected for ASM where applicable. |
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_OBS |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Northeast commercial fish species NESPP4 codes contained in OBSPP and OBIAL and consistent with NESPP4 definitions contained in OBSPEC. *Note these NESPP4 codes do not necessarily correspond with CFDBS NESPP4 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 | COMNAME |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 35 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Common name for the species. |
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 | MKTNM_OBSPEC |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contains data from the MARKET column in the OBSPEC table for the corresponding NESPP4. |
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 | CATDISP_CODE |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Catch Disposition from OBSPP and OBIAL tables (0 = discarded, 1 = kept, 9 = 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 | CATDISP_DESC |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Text description of the CATDISP_CODE column. |
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 | DRFLAG_CODE |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Dressed Round from OBSPP and OBIAL tables (0 = unknown, 1 = dressed, 2 = round, 3 = finned). |
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 | DRFLAG_DESC |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Text description of the DRFLAG_CODE field. |
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 | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contains grade code that corresponds with NESPP4||CATDISP||DRFLAG combination from OBDBS. Rationale for the assignment of the GRADE_CODE is provided in GRADE_ASSIGN_COMMENT. |
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 | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Text description of the GRADE_CODE field. |
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_REASSIGN |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The reassigned NESPP4 code which corresponds to the species and assigned GRADE_CODE in SPECIES_ITIS_NE. |
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_OUTPUT |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The CFDBS NESPP4 code corresponding to the round grade code for a given species. |
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 | 13 |
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. |
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 | SCIENTIFIC_NAME |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 45 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The scientific name for a species. |
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 | 15 |
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. |
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 | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Text description of the MARKET_CODE field. |
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 | 17 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Unit of measure. |
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_LNDLB_LIVLB |
---|---|
Seq. Order | 18 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Conversion factor to raise the reported pounds landed to the live 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 | CF_RPTQTY_LNDLB |
---|---|
Seq. Order | 19 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Conversion factor to raise the reported quantity to 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 | CONV_FLAG |
---|---|
Seq. Order | 20 |
Data Storage Type | NUMBER |
Max Length | 22 |
Min Length | |
Required | Yes |
Primary Key | No |
Precision | 38 |
Scale | |
Status | Active |
Description |
Indicates where the translation of the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination could be matched to an existing SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table (1 = match, 0 = no match). |
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 | GRADE_ASSIGN_COMMENT |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 200 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Provides description of the logic used to translate the NESPP4_OBS||CATDISP_CODE||DRFLAG_CODE combination to a CFDBS GRADE_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 | MKT_ASSIGN_COMMENT |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 201 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Contains any notes related to finding a matching SPECIES_ITIS||GRADE_CODE||MARKET_CODE||UOM record in the SPECIES_ITIS_NE table for the species and grade. |
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 | |
---|---|
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 | |
---|---|
* » 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
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
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 | 33573 |
---|---|
Metadata Record Created By | Patricia L Jones |
Metadata Record Created | 2016-07-27 19:10+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2016-07-28 |
Owner Org | NEFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2016-07-28 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2017-07-28 |
Tags |
---|