Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: REFERENCE_DOCUMENT_TYPES
Short Name: REFERENCE_DOCUMENT_TYPES
Status: Planned
Abstract:

Lookup table that provides the types of reference documents used to provide salmonid abundance data.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: SPS
Description:

Lookup table that provides the types of reference documents used to provide salmonid abundance data.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key REF_NO NUMBER Database-generated primary key (unique identifier) for each REFERENCE_DOCUMENT_TYPES record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named REFERENCEDOCUMENTTYPE_PK.
100
DOCUMENT_TYPE VARCHAR2 The type of document such as journal, NOAA Technical memo, personal contact, etc.

Attribute Details

REF_NO

CC ID: 324345
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Status: Active
Description:

Database-generated primary key (unique identifier) for each REFERENCE_DOCUMENT_TYPES record, created by an internal sequence generator and used by the database to maintain referential integrity. This ID is not designed to be managed by users. This primary key constraint is named REFERENCEDOCUMENTTYPE_PK.

General Data Type: NUMBER

DOCUMENT_TYPE

CC ID: 324346
Data Storage Type: VARCHAR2
Max Length: 255
Required: No
Primary Key: No
Status: Active
Description:

The type of document such as journal, NOAA Technical memo, personal contact, etc.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 32700
GUID: gov.noaa.nmfs.inport:32700
Metadata Record Created By: Jeffrey W Cowen
Metadata Record Created: 2016-05-09 14:19+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2019-06-04 13:14+0000
Metadata Record Published: 2016-05-11
Owner Org: NWFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Next Review Date: 2017-05-12