REFERENCE_DOCUMENT_TYPES
Entity (ENT) | Northwest Fisheries Science Center (NWFSC)GUID: gov.noaa.nmfs.inport:32700 | Updated: August 9, 2022 | Published / External
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
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: | 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 |