Table: MRSPECIES
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33176 | 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: 328329
| 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: 328336
| 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: 328337
| 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: 328338
| 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: 328339
| 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: 328340
| 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: 328341
| 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: 328342
| 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: 328343
| 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: 328330
| 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: 328331
| 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: 328332
| 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: 328333
| 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: 328334
| 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: 328335
| 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 |