REFERENCE_DOCUMENT_TYPES
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:32700 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
Lookup table that provides the types of reference documents used to provide salmonid abundance data.
DescriptionLookup table that provides the types of reference documents used to provide salmonid abundance data.
Entity Information
Entity Type
Data Table
Data Attribute / Type | Description |
---|---|
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. |
DOCUMENT_TYPE
VARCHAR2 |
The type of document such as journal, NOAA Technical memo, personal contact, etc. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (NWFSC) for inquiries on this record.
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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-05-11 |
Owner Org: | NWFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-05-11 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-05-11 |