View: STSSN_YR_SPEC_STATE_MONTH_V
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:28395 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: STSSN_YR_SPEC_STATE_MONTH_V |
---|---|
Short Name: | STSSN_YR_SPEC_STATE_MONTH_V |
Status: | Completed |
Notes: |
Loaded by batch 7464, 10-29-2015 15:36 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | STSSN |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ID | NUMBER | no-comment | |
100
|
YEAR | VARCHAR2 | no-comment | |
100
|
SPECIES | VARCHAR2 | no-comment | |
100
|
SPECIESCODE | VARCHAR2 | no-comment | |
100
|
STATE | VARCHAR2 | no-comment | |
100
|
STATECODE | VARCHAR2 | no-comment | |
100
|
JAN | NUMBER | no-comment | |
100
|
FEB | NUMBER | no-comment | |
100
|
MAR | NUMBER | no-comment | |
100
|
APR | NUMBER | no-comment | |
100
|
MAY | NUMBER | no-comment | |
100
|
JUN | NUMBER | no-comment | |
100
|
JUL | NUMBER | no-comment | |
100
|
AUG | NUMBER | no-comment | |
100
|
SEP | NUMBER | no-comment | |
100
|
OCT | NUMBER | no-comment | |
100
|
NOV | NUMBER | no-comment | |
100
|
DEC | NUMBER | no-comment | |
100
|
TOTAL | NUMBER | no-comment |
Attribute Details
ID
CC ID: 240393
Seq. Order: | 1 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
YEAR
CC ID: 240404
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
SPECIES
CC ID: 240405
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
SPECIESCODE
CC ID: 240406
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
STATE
CC ID: 240407
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 21 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
STATECODE
CC ID: 240408
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | VARCHAR2 |
JAN
CC ID: 240409
Seq. Order: | 7 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
FEB
CC ID: 240410
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
MAR
CC ID: 240411
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
APR
CC ID: 240394
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
MAY
CC ID: 240395
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
JUN
CC ID: 240396
Seq. Order: | 12 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
JUL
CC ID: 240397
Seq. Order: | 13 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
AUG
CC ID: 240398
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
SEP
CC ID: 240399
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
OCT
CC ID: 240400
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
NOV
CC ID: 240401
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
DEC
CC ID: 240402
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 38 |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
TOTAL
CC ID: 240403
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
no-comment |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 28395 |
---|---|
GUID: | gov.noaa.nmfs.inport:28395 |
Metadata Record Created By: | Lee M Weinberger |
Metadata Record Created: | 2015-10-29 15:36+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-04-29 |
Owner Org: | SEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-04-29 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-04-29 |