Slide Menu
Search Help Show/Hide Menu

Item Identification

Title: POP_REF_BY_TYPE_ARCV
Short Name: POP_REF_BY_TYPE_ARCV
Status: Planned
Abstract:

Table used to store population to reference relationships when an archive is created.

Entity Information

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

Table used to store population to reference relationships when an archive is created.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
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_CHANGE_COMMENT CLOB 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
NMFS_POPID NUMBER The foreign key to pull in the Population Name for the source database.
100
Primary Key POPREFBYTEYPARCV_DB_ID NUMBER Database-generated primary key (unique identifier) for each POP_REF_BY_TYPE_ARCV 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 POPREFBYTEYPARCV_DB_ID.
100
SPS_ARCHIVE_DB_ID NUMBER Foreign key to the SPS_ARCHIVE table to link POP_REF_BY_TYPE_ARCV records to a specific ARCHIVE_DB_ID using the SPS_ARCHIVE_PK primary key. This foreign key constraint is named SPSARCV_PRBTARCV_FK.
100
POP_REF_MATRIX_DB_ID NUMBER Foreign key to population to reference intersection table.
100
POPULATION_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
NWR_POPULATION_NAME VARCHAR2 Name of the population as defined by NMFS: A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group.
100
ESU_DB_ID NUMBER Foreign key to the ESU lookup table.
100
ESU_NAME VARCHAR2 A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species.
100
REFERENCE_DOCUMENT_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
REFERENCE_TYPE VARCHAR2 The classification of a reference document to its PRIMARY category. (If the reference document can be classified to more than one category, others are not accomodated here.) Acceptable values include: Age Reference, Catch Reference, Hatchery Reference, Spawner Reference, and Wild-Fraction Reference.
100
REFERENCE_DATA_TYPE_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
NOTES VARCHAR2 Any comments or other information about the reference material or its publication or use.
100
TITLE VARCHAR2 The recognized, given title for a piece of reference material.
100
AUTHOR VARCHAR2 The name of the author of a piece of reference material.
100
PUB_YEAR VARCHAR2 If the reference material is published, the four-digit year in which the reference material was published.
100
PUBLISHER VARCHAR2 If the reference material is published, the name of the publisher of the reference material.
100
BROOD_YEAR NUMBER The year that adults enter to the river to spawn.
100
RECORD_HISTORY CLOB An accumulated set of statements describing how THIS RECORD has been edited over time including WHEN and by WHOM.
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_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 TIMESTAMP(4) The date, or approximate date, that the person with content knowledge originated this record PRIOR to its being entered into the database.

Attribute Details

RECORD_EFFECTIVE_DATE

CC ID: 324261
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: 324262
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: 324263
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: 324264
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: 324265
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: 324266
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: 324267
Data Storage Type: VARCHAR2
Max Length: 40
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_CHANGE_COMMENT

CC ID: 324268
Data Storage Type: CLOB
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: CLOB

NMFS_POPID

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

POPREFBYTEYPARCV_DB_ID

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

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

General Data Type: NUMBER

SPS_ARCHIVE_DB_ID

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

Foreign key to the SPS_ARCHIVE table to link POP_REF_BY_TYPE_ARCV records to a specific ARCHIVE_DB_ID using the SPS_ARCHIVE_PK primary key. This foreign key constraint is named SPSARCV_PRBTARCV_FK.

General Data Type: NUMBER

POP_REF_MATRIX_DB_ID

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

Foreign key to population to reference intersection table.

General Data Type: NUMBER

POPULATION_DB_ID

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

NWR_POPULATION_NAME

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

Name of the population as defined by NMFS: A group of fish of the same species that spawns in a particular locality at a particular season and does not interbreed substantially with fish from any other group.

General Data Type: VARCHAR2

ESU_DB_ID

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

Foreign key to the ESU lookup table.

General Data Type: NUMBER

ESU_NAME

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

A group of Pacific salmon or steelhead trout that is (1) substantially reproductively isolated from other conspecific units and (2) represents an important component of the evolutionary legacy of the species.

General Data Type: VARCHAR2

REFERENCE_DOCUMENT_DB_ID

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

REFERENCE_TYPE

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

The classification of a reference document to its PRIMARY category. (If the reference document can be classified to more than one category, others are not accomodated here.) Acceptable values include: Age Reference, Catch Reference, Hatchery Reference, Spawner Reference, and Wild-Fraction Reference.

General Data Type: VARCHAR2

REFERENCE_DATA_TYPE_DB_ID

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

NOTES

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

Any comments or other information about the reference material or its publication or use.

General Data Type: VARCHAR2

TITLE

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

The recognized, given title for a piece of reference material.

General Data Type: VARCHAR2

AUTHOR

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

The name of the author of a piece of reference material.

General Data Type: VARCHAR2

PUB_YEAR

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

If the reference material is published, the four-digit year in which the reference material was published.

General Data Type: VARCHAR2

PUBLISHER

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

If the reference material is published, the name of the publisher of the reference material.

General Data Type: VARCHAR2

BROOD_YEAR

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

The year that adults enter to the river to spawn.

General Data Type: NUMBER

RECORD_HISTORY

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

RECORD_JOURNAL_NOTE

CC ID: 324287
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_APPROVED_BY_PERSON

CC ID: 324288
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: 324289
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: 324290
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
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: 324291
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: 324292
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: 324293
Data Storage Type: TIMESTAMP(4)
Max Length: 11
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: TIMESTAMP(4)

Catalog Details

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