View: OBSPEC
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33351 | Updated: August 9, 2022 | Published / External
Item Identification
| Title: | View: OBSPEC |
|---|---|
| Short Name: | OBSPEC |
| Status: | Completed |
| Abstract: |
Observer Species Support Table |
| Notes: |
Loaded by batch 8950, 07-06-2016 08:24 |
Entity Information
| Entity Type: | Data View |
|---|---|
| Active Version?: | Yes |
| Schema Name: | OBDBS |
| Description: |
Observer Species Support Table |
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
NESPP4 | VARCHAR2 | Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. | |
|
100
|
COMNAME | VARCHAR2 | Common name for the species. | |
|
100
|
MARKET | VARCHAR2 | Indicator if species code is for specific market category such as fins, liver, cheeks. | |
|
100
|
SCINAME | VARCHAR2 | Latin name for species. | |
|
100
|
PARTS | VARCHAR2 | Indicator if species code specifies part rather than whole. 1 = yes. | |
|
100
|
IAL | VARCHAR2 | Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table | |
|
100
|
SPP | VARCHAR2 | Flag = 1 if species can appear on species record. | |
|
100
|
INC | VARCHAR2 | Flag = 1 if species can appear in incidental take table. | |
|
100
|
TARGET | VARCHAR2 | Flag = 1 if target species. | |
|
100
|
CETACEAN | VARCHAR2 | Flag = 1 if cetacean species. | |
|
100
|
TURTLE | VARCHAR2 | Flag = 1 if turtle species. | |
|
100
|
PINNIPED | VARCHAR2 | Flag = 1 if pinniped species. | |
|
100
|
SIGHT | VARCHAR2 | Flag = 1 if sighting appears on sighting log.. | |
|
100
|
ROUND | VARCHAR2 | SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round. | |
|
100
|
CRUSTACEAN | VARCHAR2 | Flag = 1 if crustacean. | |
|
100
|
SEXGT0 | VARCHAR2 | Indicator of whether sex should be defaulted to zero if not entered. For internal use. | |
|
100
|
SPECIES_ITIS | VARCHAR2 | The Integrated Taxonomic Information System (ITIS) serial number for a species. | |
|
100
|
SPECCOMMENTS | VARCHAR2 | Additional information on identified species. |
Attribute Details
NESPP4
CC ID: 331181
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | Yes |
| Primary Key: | No |
| Status: | Active |
| Description: |
Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. |
| General Data Type: | VARCHAR2 |
COMNAME
CC ID: 331191
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 35 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Common name for the species. |
| General Data Type: | VARCHAR2 |
MARKET
CC ID: 331192
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator if species code is for specific market category such as fins, liver, cheeks. |
| General Data Type: | VARCHAR2 |
SCINAME
CC ID: 331193
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 45 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Latin name for species. |
| General Data Type: | VARCHAR2 |
PARTS
CC ID: 331194
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator if species code specifies part rather than whole. 1 = yes. |
| General Data Type: | VARCHAR2 |
IAL
CC ID: 331195
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if species may appear on ial log in IAL table, 2 if uncommon species that may appear on ial log in IAL table |
| General Data Type: | VARCHAR2 |
SPP
CC ID: 331196
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if species can appear on species record. |
| General Data Type: | VARCHAR2 |
INC
CC ID: 331197
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if species can appear in incidental take table. |
| General Data Type: | VARCHAR2 |
TARGET
CC ID: 331198
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if target species. |
| General Data Type: | VARCHAR2 |
CETACEAN
CC ID: 331182
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if cetacean species. |
| General Data Type: | VARCHAR2 |
TURTLE
CC ID: 331183
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if turtle species. |
| General Data Type: | VARCHAR2 |
PINNIPED
CC ID: 331184
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if pinniped species. |
| General Data Type: | VARCHAR2 |
SIGHT
CC ID: 331185
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if sighting appears on sighting log.. |
| General Data Type: | VARCHAR2 |
ROUND
CC ID: 331186
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
SPP: Indicator of type of weight. 0=unknown;.1=dressed, 2=round. Older data included 3=finned. Formerly Wgtmktcd. Prior to April 1994 all are 0 (unknown). OBSPEC: Flag = 1 or null if species can appear as round. |
| General Data Type: | VARCHAR2 |
CRUSTACEAN
CC ID: 331187
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Flag = 1 if crustacean. |
| General Data Type: | VARCHAR2 |
SEXGT0
CC ID: 331188
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Indicator of whether sex should be defaulted to zero if not entered. For internal use. |
| General Data Type: | VARCHAR2 |
SPECIES_ITIS
CC ID: 331189
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The Integrated Taxonomic Information System (ITIS) serial number for a species. |
| General Data Type: | VARCHAR2 |
SPECCOMMENTS
CC ID: 331190
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 250 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional information on identified species. |
| General Data Type: | VARCHAR2 |
Catalog Details
| Catalog Item ID: | 33351 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:33351 |
| Metadata Record Created By: | Patricia L Jones |
| Metadata Record Created: | 2016-07-06 08:24+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 Last Review Date: | 2016-07-28 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2017-07-28 |