Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
NWFSC Metadata Library > CB (Conservation Biology) Division > SPS Abundance - Salmon spawner abundance data c... >

RECORD_HISTORY

Entity (ENT)  |  Northwest Fisheries Science Center (NWFSC)
GUID: gov.noaa.nmfs.inport:32697  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.

Description

Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TABLE_NAME
VARCHAR2 		Name of the table for the history record.
KEY_COLUMN
VARCHAR2 		Name of the primary key column.
KEY_ID
NUMBER 		Primary key of the record for which this history record applies.
USERNAME
VARCHAR2 		User that has performed the action resulting in the history record creation.,
DATESTAMP
DATE 		Date of the history record creation.
ACTION
VARCHAR2 		What action occurred to create this history record?
HISTORY
CLOB 		Statement describing how THIS RECORD was changed by this transaction including WHEN and by WHOM.
SCHEMA_NAME
VARCHAR2 		Database schema in which the table exists.
COL_TIMESTAMP
TIMESTAMP(4) 		4 decimal second at which the history record was created.

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: RECORD_HISTORY
Short Name: RECORD_HISTORY
Status: Planned
Abstract:

Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.

Entity Information

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

Stores journaled row-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TABLE_NAME VARCHAR2 Name of the table for the history record.
100
 KEY_COLUMN VARCHAR2 Name of the primary key column.
100
 KEY_ID NUMBER Primary key of the record for which this history record applies.
100
 USERNAME VARCHAR2 User that has performed the action resulting in the history record creation.,
100
 DATESTAMP DATE Date of the history record creation.
100
 ACTION VARCHAR2 What action occurred to create this history record?
100
 HISTORY CLOB Statement describing how THIS RECORD was changed by this transaction including WHEN and by WHOM.
100
 SCHEMA_NAME VARCHAR2 Database schema in which the table exists.
100
 COL_TIMESTAMP TIMESTAMP(4) 4 decimal second at which the history record was created.

Attribute Details

TABLE_NAME

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

Name of the table for the history record.
General Data Type: VARCHAR2

KEY_COLUMN

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

Name of the primary key column.
General Data Type: VARCHAR2

KEY_ID

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

Primary key of the record for which this history record applies.
General Data Type: NUMBER

USERNAME

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

User that has performed the action resulting in the history record creation.,
General Data Type: VARCHAR2

DATESTAMP

CC ID: 324298
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date of the history record creation.
General Data Type: DATE

ACTION

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

What action occurred to create this history record?
General Data Type: VARCHAR2

HISTORY

CC ID: 324300
Data Storage Type: CLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Statement describing how THIS RECORD was changed by this transaction including WHEN and by WHOM.
General Data Type: CLOB

SCHEMA_NAME

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

Database schema in which the table exists.
General Data Type: VARCHAR2

COL_TIMESTAMP

CC ID: 324302
Data Storage Type: TIMESTAMP(4)
Max Length: 11
Required: No
Primary Key: No
Status: Active
Description:

4 decimal second at which the history record was created.
General Data Type: TIMESTAMP(4)

Catalog Details

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