Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Entity Information

Entity Type
Data View

Data Attribute / Type Description
YEAR
VARCHAR2
no-comment
STATE
VARCHAR2
no-comment
CC
NUMBER
no-comment
CM
NUMBER
no-comment
DC
NUMBER
no-comment
EI
NUMBER
no-comment
LK
NUMBER
no-comment
LO
NUMBER
no-comment
UN
NUMBER
no-comment
TOTAL
NUMBER
no-comment
STATECODE
VARCHAR2
no-comment

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: View: STSSN_YR_STATE_SPEC_V
Short Name: STSSN_YR_STATE_SPEC_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

Rubric Score Primary Key? Name Type Description
100
YEAR VARCHAR2 no-comment
100
STATE VARCHAR2 no-comment
100
CC NUMBER no-comment
100
CM NUMBER no-comment
100
DC NUMBER no-comment
100
EI NUMBER no-comment
100
LK NUMBER no-comment
100
LO NUMBER no-comment
100
UN NUMBER no-comment
100
TOTAL NUMBER no-comment
100
STATECODE VARCHAR2 no-comment

Attribute Details

YEAR

CC ID: 240487
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 9
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: VARCHAR2

STATE

CC ID: 240490
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 21
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: VARCHAR2

CC

CC ID: 240491
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: NUMBER

CM

CC ID: 240492
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

no-comment

General Data Type: NUMBER

DC

CC ID: 240493
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: NUMBER

EI

CC ID: 240494
Seq. Order: 6
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

no-comment

General Data Type: NUMBER

LK

CC ID: 240495
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: NUMBER

LO

CC ID: 240496
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

UN

CC ID: 240497
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: NUMBER

TOTAL

CC ID: 240488
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

STATECODE

CC ID: 240489
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

no-comment

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 28400
GUID: gov.noaa.nmfs.inport:28400
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