Metadata Rubric

99%

5.96 / 6

NWFSC Metadata Library > CB (Conservation Biology) Division > SPS Abundance - Salmon spawner abundance data c... >

SALMON_POPULATION_GROUPS

Entity (ENT) | Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:32703 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

Salmon abundance data is provided at the population level. This table stores information about the population and used as the base table to associate detail yearly salmon abundance data.

Description

Salmon abundance data is provided at the population level. This table stores information about the population and used as the base table to associate detail yearly salmon abundance data.

Entity Type
Data Table

Data Attribute / Type	Description
POPULATION_DB_ID NUMBER	Database-generated primary key (unique identifier) for each SALMON_POPULATION_GROUPS 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 SP_PKX.
SPECIES_DEFINITION_DB_ID NUMBER	A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.
STREAM_NAME VARCHAR2	Name of the River or drainage identifying or containing the population.
RUN_TIMING VARCHAR2	The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall
START_YEAR NUMBER	The earliest year that viable salmonid population statistics are reported for this population.
END_YEAR NUMBER	The latest year that viable salmonid population statistics are reported for this population.
RECORD_APPROVED_BY_PERSON VARCHAR2	If there is a certification process for these records, name of person who certified approval of the particular record.
RECORD_APPROVED_ON_DATE DATE	If there is a certification process for these records, date that the particular record was approved or officially certified.
RECORD_COMPUTER_LOAD_BY_USER VARCHAR2	The username that loaded the record into the database. The username is dynamically captured by the database trigger when the record is inserted and saved to the database. This person may have no knowledge of content or meaning but ran the computer process that put the record into the database.
RECORD_COMPUTER_LOAD_ON_DATE TIMESTAMP(4)	The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.
RECORD_CREATED_BY_PERSON VARCHAR2	The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.
RECORD_CREATED_ON_DATE DATE	The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.
RECORD_EFFECTIVE_DATE DATE	If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.
RECORD_EXPIRATION_DATE DATE	If necessary, the date that the individual record ceases to be effective. To force a midnight expiration, this may be set by "Select to_date(to_char(sysdate +1 ,'mm/dd/yyyy')\|\|' 23:59:59','mm/dd/yyyy hh24:mi:ss') from dual". After this date and time the record is not valid.
RECORD_LAST_EDITED_BY_USER VARCHAR2	The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.
RECORD_LAST_EDITED_ON_DATE TIMESTAMP(4)	The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.
RECORD_NUMBER_OF_EDITS NUMBER	The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.
RECORD_SOFT_DELETED VARCHAR2	Flag whether or not this record has the "Deleted" status. Null means this record has NOT been deleted. "Y" means this record HAS been deleted. This flag allows "deleted" records to remain in the table for technical reasons. When the record is "Hard Deleted" it will be removed from this table and may or may not be placed in a historical table to preserve historical status.
RECORD_STEWARDSHIP VARCHAR2	If a set of User-Roles are developed for these records, this allows a particular Role (which may be a collection of other Roles) to be assigned to steward individual records. When any user attempts to modify a record, a database procedure will then dynamically examine the user's Role to determine if they are authorized to edit particular records.
RECORD_JOURNAL_NOTE VARCHAR2	Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
RECORD_CHANGE_COMMENT VARCHAR2	Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
PUB_POP_ID NUMBER	Foreign key to population name lookup table. This column has been deprecated.
MAP_RUN VARCHAR2	The running timing of the population used for map display purposes only.
SOURCE VARCHAR2	The source of the input data.
RECORD_HISTORY CLOB	An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.
ATTRIBUTE_SCOPE_TYPE VARCHAR2
NMFS_POPID NUMBER	The foreign key to pull in the Population Name for the source database.

Data Attribute / Type

Description

POPULATION_DB_ID
NUMBER

Database-generated primary key (unique identifier) for each SALMON_POPULATION_GROUPS 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 SP_PKX.

SPECIES_DEFINITION_DB_ID
NUMBER

A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.

STREAM_NAME
VARCHAR2

Name of the River or drainage identifying or containing the population.

RUN_TIMING
VARCHAR2

The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall

START_YEAR
NUMBER

The earliest year that viable salmonid population statistics are reported for this population.

END_YEAR
NUMBER

The latest year that viable salmonid population statistics are reported for this population.

RECORD_APPROVED_BY_PERSON
VARCHAR2

If there is a certification process for these records, name of person who certified approval of the particular record.

RECORD_APPROVED_ON_DATE
DATE

If there is a certification process for these records, date that the particular record was approved or officially certified.

RECORD_COMPUTER_LOAD_BY_USER
VARCHAR2

The username that loaded the record into the database. The username is dynamically captured by the database trigger when the record is inserted and saved to the database. This person may have no knowledge of content or meaning but ran the computer process that put the record into the database.

RECORD_COMPUTER_LOAD_ON_DATE
TIMESTAMP(4)

The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.

RECORD_CREATED_BY_PERSON
VARCHAR2

The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.

RECORD_CREATED_ON_DATE
DATE

The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.

RECORD_EFFECTIVE_DATE
DATE

If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.

RECORD_EXPIRATION_DATE
DATE

If necessary, the date that the individual record ceases to be effective. To force a midnight expiration, this may be set by "Select to_date(to_char(sysdate +1 ,'mm/dd/yyyy')||' 23:59:59','mm/dd/yyyy hh24:mi:ss') from dual". After this date and time the record is not valid.

RECORD_LAST_EDITED_BY_USER
VARCHAR2

The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.

RECORD_LAST_EDITED_ON_DATE
TIMESTAMP(4)

The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.

RECORD_NUMBER_OF_EDITS
NUMBER

The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.

RECORD_SOFT_DELETED
VARCHAR2

Flag whether or not this record has the "Deleted" status. Null means this record has NOT been deleted. "Y" means this record HAS been deleted. This flag allows "deleted" records to remain in the table for technical reasons. When the record is "Hard Deleted" it will be removed from this table and may or may not be placed in a historical table to preserve historical status.

RECORD_STEWARDSHIP
VARCHAR2

If a set of User-Roles are developed for these records, this allows a particular Role (which may be a collection of other Roles) to be assigned to steward individual records. When any user attempts to modify a record, a database procedure will then dynamically examine the user's Role to determine if they are authorized to edit particular records.

RECORD_JOURNAL_NOTE
VARCHAR2

Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

RECORD_CHANGE_COMMENT
VARCHAR2

Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

PUB_POP_ID
NUMBER

Foreign key to population name lookup table. This column has been deprecated.

MAP_RUN
VARCHAR2

The running timing of the population used for map display purposes only.

SOURCE
VARCHAR2

The source of the input data.

RECORD_HISTORY
CLOB

An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.

ATTRIBUTE_SCOPE_TYPE
VARCHAR2

NMFS_POPID
NUMBER

The foreign key to pull in the Population Name for the source database.

No Child Items for this record.

No contact information is available for this record.

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

Title:	SALMON_POPULATION_GROUPS
Short Name:	SALMON_POPULATION_GROUPS
Status:	Planned
Abstract:	Salmon abundance data is provided at the population level. This table stores information about the population and used as the base table to associate detail yearly salmon abundance data.

Entity Type:	Data Table
Active Version?:	Yes
Schema Name:	SPS
Description:	Salmon abundance data is provided at the population level. This table stores information about the population and used as the base table to associate detail yearly salmon abundance data.

Attribute Summary

	Name	Type	Description
100	POPULATION_DB_ID	NUMBER	Database-generated primary key (unique identifier) for each SALMON_POPULATION_GROUPS 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 SP_PKX.
100	SPECIES_DEFINITION_DB_ID	NUMBER	A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.
100	STREAM_NAME	VARCHAR2	Name of the River or drainage identifying or containing the population.
100	RUN_TIMING	VARCHAR2	The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall
100	START_YEAR	NUMBER	The earliest year that viable salmonid population statistics are reported for this population.
100	END_YEAR	NUMBER	The latest year that viable salmonid population statistics are reported for this population.
100	RECORD_APPROVED_BY_PERSON	VARCHAR2	If there is a certification process for these records, name of person who certified approval of the particular record.
100	RECORD_APPROVED_ON_DATE	DATE	If there is a certification process for these records, date that the particular record was approved or officially certified.
100	RECORD_COMPUTER_LOAD_BY_USER	VARCHAR2	The username that loaded the record into the database. The username is dynamically captured by the database trigger when the record is inserted and saved to the database. This person may have no knowledge of content or meaning but ran the computer process that put the record into the database.
100	RECORD_COMPUTER_LOAD_ON_DATE	TIMESTAMP(4)	The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.
100	RECORD_CREATED_BY_PERSON	VARCHAR2	The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.
100	RECORD_CREATED_ON_DATE	DATE	The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.
100	RECORD_EFFECTIVE_DATE	DATE	If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.
100	RECORD_EXPIRATION_DATE	DATE	If necessary, the date that the individual record ceases to be effective. To force a midnight expiration, this may be set by "Select to_date(to_char(sysdate +1 ,'mm/dd/yyyy')\|\|' 23:59:59','mm/dd/yyyy hh24:mi:ss') from dual". After this date and time the record is not valid.
100	RECORD_LAST_EDITED_BY_USER	VARCHAR2	The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.
100	RECORD_LAST_EDITED_ON_DATE	TIMESTAMP(4)	The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.
100	RECORD_NUMBER_OF_EDITS	NUMBER	The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.
100	RECORD_SOFT_DELETED	VARCHAR2	Flag whether or not this record has the "Deleted" status. Null means this record has NOT been deleted. "Y" means this record HAS been deleted. This flag allows "deleted" records to remain in the table for technical reasons. When the record is "Hard Deleted" it will be removed from this table and may or may not be placed in a historical table to preserve historical status.
100	RECORD_STEWARDSHIP	VARCHAR2	If a set of User-Roles are developed for these records, this allows a particular Role (which may be a collection of other Roles) to be assigned to steward individual records. When any user attempts to modify a record, a database procedure will then dynamically examine the user's Role to determine if they are authorized to edit particular records.
100	RECORD_JOURNAL_NOTE	VARCHAR2	Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
100	RECORD_CHANGE_COMMENT	VARCHAR2	Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
100	PUB_POP_ID	NUMBER	Foreign key to population name lookup table. This column has been deprecated.
100	MAP_RUN	VARCHAR2	The running timing of the population used for map display purposes only.
100	SOURCE	VARCHAR2	The source of the input data.
100	RECORD_HISTORY	CLOB	An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.
67	ATTRIBUTE_SCOPE_TYPE	VARCHAR2
100	NMFS_POPID	NUMBER	The foreign key to pull in the Population Name for the source database.

Name

Type

Description

100

POPULATION_DB_ID

NUMBER

100

SPECIES_DEFINITION_DB_ID

NUMBER

A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.

100

STREAM_NAME

VARCHAR2

Name of the River or drainage identifying or containing the population.

100

RUN_TIMING

VARCHAR2

The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall

100

START_YEAR

NUMBER

The earliest year that viable salmonid population statistics are reported for this population.

100

END_YEAR

NUMBER

The latest year that viable salmonid population statistics are reported for this population.

100

RECORD_APPROVED_BY_PERSON

VARCHAR2

If there is a certification process for these records, name of person who certified approval of the particular record.

100

RECORD_APPROVED_ON_DATE

DATE

If there is a certification process for these records, date that the particular record was approved or officially certified.

100

RECORD_COMPUTER_LOAD_BY_USER

VARCHAR2

100

RECORD_COMPUTER_LOAD_ON_DATE

TIMESTAMP(4)

The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.

100

RECORD_CREATED_BY_PERSON

VARCHAR2

The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.

100

RECORD_CREATED_ON_DATE

DATE

The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.

100

RECORD_EFFECTIVE_DATE

DATE

If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.

100

RECORD_EXPIRATION_DATE

DATE

100

RECORD_LAST_EDITED_BY_USER

VARCHAR2

The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.

100

RECORD_LAST_EDITED_ON_DATE

TIMESTAMP(4)

The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.

100

RECORD_NUMBER_OF_EDITS

NUMBER

The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.

100

RECORD_SOFT_DELETED

VARCHAR2

100

RECORD_STEWARDSHIP

VARCHAR2

100

RECORD_JOURNAL_NOTE

VARCHAR2

Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

100

RECORD_CHANGE_COMMENT

VARCHAR2

Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.

100

PUB_POP_ID

NUMBER

Foreign key to population name lookup table. This column has been deprecated.

100

MAP_RUN

VARCHAR2

The running timing of the population used for map display purposes only.

100

SOURCE

VARCHAR2

The source of the input data.

100

RECORD_HISTORY

CLOB

An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.

ATTRIBUTE_SCOPE_TYPE

VARCHAR2

100

NMFS_POPID

NUMBER

The foreign key to pull in the Population Name for the source database.

Attribute Details

POPULATION_DB_ID

CC ID: 324406

Data Storage Type:	NUMBER
Max Length:	22
Required:	Yes
Primary Key:	Yes
Status:	Active
Description:	Database-generated primary key (unique identifier) for each SALMON_POPULATION_GROUPS 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 SP_PKX.
General Data Type:	NUMBER

SPECIES_DEFINITION_DB_ID

CC ID: 324407

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	A unique identifier for each record; assigned by an internal Sequence Generator and used by the database to maintain foreign-key relationships. This ID is not designed to be managed by users.
General Data Type:	NUMBER

STREAM_NAME

CC ID: 324408

Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	Name of the River or drainage identifying or containing the population.
General Data Type:	VARCHAR2

RUN_TIMING

CC ID: 324409

Data Storage Type:	VARCHAR2
Max Length:	50
Required:	No
Primary Key:	No
Status:	Active
Description:	The season of the year for the return of the population to its anadromous waters. i.e. Spring, Summer, Winter or Fall
General Data Type:	VARCHAR2

START_YEAR

CC ID: 324410

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	The earliest year that viable salmonid population statistics are reported for this population.
General Data Type:	NUMBER

END_YEAR

CC ID: 324411

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	The latest year that viable salmonid population statistics are reported for this population.
General Data Type:	NUMBER

RECORD_APPROVED_BY_PERSON

CC ID: 324412

Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	If there is a certification process for these records, name of person who certified approval of the particular record.
General Data Type:	VARCHAR2

RECORD_APPROVED_ON_DATE

CC ID: 324413

Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	If there is a certification process for these records, date that the particular record was approved or officially certified.
General Data Type:	DATE

RECORD_COMPUTER_LOAD_BY_USER

CC ID: 324414

Data Storage Type:	VARCHAR2
Max Length:	40
Required:	Yes
Primary Key:	No
Status:	Active
Description:	The username that loaded the record into the database. The username is dynamically captured by the database trigger when the record is inserted and saved to the database. This person may have no knowledge of content or meaning but ran the computer process that put the record into the database.
General Data Type:	VARCHAR2

RECORD_COMPUTER_LOAD_ON_DATE

CC ID: 324415

Data Storage Type:	TIMESTAMP(4)
Max Length:	11
Required:	No
Primary Key:	No
Status:	Active
Description:	The date that the record was loaded into the database. This date is dynamically captured by the database trigger when the record is inserted and saved.
General Data Type:	TIMESTAMP(4)

RECORD_CREATED_BY_PERSON

CC ID: 324416

Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	The name of the person who originated this record PRIOR to its being entered into the database. The name of the person to contact with administrative questions or an explanation of it content.
General Data Type:	VARCHAR2

RECORD_CREATED_ON_DATE

CC ID: 324417

Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.
General Data Type:	DATE

RECORD_EFFECTIVE_DATE

CC ID: 324418

Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	If necessary, the date that the individual record becomes effective. Prior to this date the record is not valid.
General Data Type:	DATE

RECORD_EXPIRATION_DATE

CC ID: 324419

Data Storage Type:	DATE
Max Length:	7
Required:	No
Primary Key:	No
Status:	Active
Description:	If necessary, the date that the individual record ceases to be effective. To force a midnight expiration, this may be set by "Select to_date(to_char(sysdate +1 ,'mm/dd/yyyy')\|\|' 23:59:59','mm/dd/yyyy hh24:mi:ss') from dual". After this date and time the record is not valid.
General Data Type:	DATE

RECORD_LAST_EDITED_BY_USER

CC ID: 324420

Data Storage Type:	VARCHAR2
Max Length:	40
Required:	No
Primary Key:	No
Status:	Active
Description:	The username of the last person who modified this record. This username is dynamically captured by the database trigger any time the record is edited.
General Data Type:	VARCHAR2

RECORD_LAST_EDITED_ON_DATE

CC ID: 324421

Data Storage Type:	TIMESTAMP(4)
Max Length:	11
Required:	No
Primary Key:	No
Status:	Active
Description:	The last date that the particular record was modified. This date is dynamically captured by the database trigger any time the record is edited.
General Data Type:	TIMESTAMP(4)

RECORD_NUMBER_OF_EDITS

CC ID: 324422

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	The number of times that the particular record was modified. This count is dynamically incremented by 1 by the database trigger each time the record is edited.
General Data Type:	NUMBER

RECORD_SOFT_DELETED

CC ID: 324423

Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Flag whether or not this record has the "Deleted" status. Null means this record has NOT been deleted. "Y" means this record HAS been deleted. This flag allows "deleted" records to remain in the table for technical reasons. When the record is "Hard Deleted" it will be removed from this table and may or may not be placed in a historical table to preserve historical status.
General Data Type:	VARCHAR2

RECORD_STEWARDSHIP

CC ID: 324424

Data Storage Type:	VARCHAR2
Max Length:	100
Required:	No
Primary Key:	No
Status:	Active
Description:	If a set of User-Roles are developed for these records, this allows a particular Role (which may be a collection of other Roles) to be assigned to steward individual records. When any user attempts to modify a record, a database procedure will then dynamically examine the user's Role to determine if they are authorized to edit particular records.
General Data Type:	VARCHAR2

RECORD_JOURNAL_NOTE

CC ID: 324425

Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Short narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
General Data Type:	VARCHAR2

RECORD_CHANGE_COMMENT

CC ID: 324426

Data Storage Type:	VARCHAR2
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	Unlimited narrative describing the last change/edit made to this particular record. In a post-edit summary, this text is intended to describe what was done by the latest edit job.
General Data Type:	VARCHAR2

PUB_POP_ID

CC ID: 324427

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Foreign key to population name lookup table. This column has been deprecated.
General Data Type:	NUMBER

MAP_RUN

CC ID: 324428

Data Storage Type:	VARCHAR2
Max Length:	30
Required:	No
Primary Key:	No
Status:	Active
Description:	The running timing of the population used for map display purposes only.
General Data Type:	VARCHAR2

SOURCE

CC ID: 324429

Data Storage Type:	VARCHAR2
Max Length:	255
Required:	No
Primary Key:	No
Status:	Active
Description:	The source of the input data.
General Data Type:	VARCHAR2

RECORD_HISTORY

CC ID: 324430

Data Storage Type:	CLOB
Max Length:	4000
Required:	No
Primary Key:	No
Status:	Active
Description:	An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.
General Data Type:	CLOB

ATTRIBUTE_SCOPE_TYPE

CC ID: 324431

Data Storage Type:	VARCHAR2
Max Length:	20
Required:	No
Primary Key:	No
Status:	Active
General Data Type:	VARCHAR2

NMFS_POPID

CC ID: 324432

Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	The foreign key to pull in the Population Name for the source database.
General Data Type:	NUMBER

Catalog Item ID:	32703
GUID:	gov.noaa.nmfs.inport:32703
Metadata Record Created By:	Jeffrey W Cowen
Metadata Record Created:	2016-05-09 14:20+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

SALMON_POPULATION_GROUPS

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

POPULATION_DB_ID

SPECIES_DEFINITION_DB_ID

STREAM_NAME

RUN_TIMING

START_YEAR

END_YEAR

RECORD_APPROVED_BY_PERSON

RECORD_APPROVED_ON_DATE

RECORD_COMPUTER_LOAD_BY_USER

RECORD_COMPUTER_LOAD_ON_DATE

RECORD_CREATED_BY_PERSON

RECORD_CREATED_ON_DATE

RECORD_EFFECTIVE_DATE

RECORD_EXPIRATION_DATE

RECORD_LAST_EDITED_BY_USER

RECORD_LAST_EDITED_ON_DATE

RECORD_NUMBER_OF_EDITS

RECORD_SOFT_DELETED

RECORD_STEWARDSHIP

RECORD_JOURNAL_NOTE

RECORD_CHANGE_COMMENT

PUB_POP_ID

MAP_RUN

SOURCE

RECORD_HISTORY

ATTRIBUTE_SCOPE_TYPE

NMFS_POPID

Catalog Details