Table: MRSPECIES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:34824 | Updated: August 9, 2022 | Published / External
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details
Data Attributes
Attribute Summary
|
|
Name | Type | Description |
|---|---|---|---|---|
|
100
|
|
SPECIES_ITIS | VARCHAR2 | Itis species code, see support table MRSPECIES for descriptions. |
|
100
|
SV_SPCODE | VARCHAR2 | Species code in the NEFSC SBDVS survey database. | |
|
100
|
SH_SPCODE | VARCHAR2 | Species code from the Apex Predators (Shark) data tables. | |
|
100
|
SCIENTIFIC_NAME | VARCHAR2 | Scientific name. | |
|
100
|
COMMON_NAME | VARCHAR2 | Common name. | |
|
100
|
AFT | VARCHAR2 | used in shark length calculation. | |
|
100
|
BFT | VARCHAR2 | used in shark length calculation. | |
|
100
|
AFW | VARCHAR2 | used in shark weight calculation. | |
|
100
|
BFW | VARCHAR2 | used in shark weight calculation. | |
|
100
|
FISHERY_STRING | VARCHAR2 | Fisheries to which species is affiliated (comma separated list of fishery codes). | |
|
100
|
DOE | DATE | Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). | |
|
100
|
UOE | VARCHAR2 | The Oracle username of the individual who entered the new record. | |
|
100
|
DOC | DATE | Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). | |
|
100
|
UOC | VARCHAR2 | The Oracle username of the individual who changed the current record. | |
|
100
|
MRSEQUENCE | VARCHAR2 | Sequencing for web application select list |
Attribute Details
SPECIES_ITIS
CC ID: 349743
| Seq. Order: | 1 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 11 |
| Required: | Yes |
| Primary Key: | Yes |
| Status: | Active |
| Description: |
Itis species code, see support table MRSPECIES for descriptions. |
| General Data Type: | VARCHAR2 |
SV_SPCODE
CC ID: 349750
| Seq. Order: | 2 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species code in the NEFSC SBDVS survey database. |
| General Data Type: | VARCHAR2 |
SH_SPCODE
CC ID: 349751
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Species code from the Apex Predators (Shark) data tables. |
| General Data Type: | VARCHAR2 |
SCIENTIFIC_NAME
CC ID: 349752
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 45 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scientific name. |
| General Data Type: | VARCHAR2 |
COMMON_NAME
CC ID: 349753
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 45 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Common name. |
| General Data Type: | VARCHAR2 |
AFT
CC ID: 349754
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
used in shark length calculation. |
| General Data Type: | VARCHAR2 |
BFT
CC ID: 349755
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
used in shark length calculation. |
| General Data Type: | VARCHAR2 |
AFW
CC ID: 349756
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
used in shark weight calculation. |
| General Data Type: | VARCHAR2 |
BFW
CC ID: 349757
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 25 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
used in shark weight calculation. |
| General Data Type: | VARCHAR2 |
FISHERY_STRING
CC ID: 349744
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 20 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fisheries to which species is affiliated (comma separated list of fishery codes). |
| General Data Type: | VARCHAR2 |
DOE
CC ID: 349745
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when record was inserted into Oracle. Date format (DD-MON-YYYY HH24:MI:SS). |
| General Data Type: | DATE |
UOE
CC ID: 349746
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The Oracle username of the individual who entered the new record. |
| General Data Type: | VARCHAR2 |
DOC
CC ID: 349747
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | DATE |
| Max Length: | 7 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date when the current record was updated or changed. Date format (DD-MON-YYYY HH:MI:SS). |
| General Data Type: | DATE |
UOC
CC ID: 349748
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 12 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
The Oracle username of the individual who changed the current record. |
| General Data Type: | VARCHAR2 |
MRSEQUENCE
CC ID: 349749
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 40 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sequencing for web application select list |
| General Data Type: | VARCHAR2 |