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_UNDO_HISTORY

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

Summary

Abstract

Stores journaled individual column-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers. Each individual column change has an associated executable statement that can be used to revert/undo transactions or portions of transactions.

Description

Stores journaled individual column-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers. Each individual column change has an associated executable statement that can be used to revert/undo transactions or portions of transactions.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
UNDO_ID
NUMBER 		Database generated unique identifier/primary key for the UNDO table.
SCHEMA_NAME
VARCHAR2 		Database schema in which the table exists.
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?
UNDO_TEXT
CLOB 		Front half of executable SQL statement to revert the individual journaled transaction.
UNDO_WHERE
VARCHAR2 		WHERE clause of executable SQL statement to revert the individual journaled transaction.
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_UNDO_HISTORY
Short Name: RECORD_UNDO_HISTORY
Status: Planned
Abstract:

Stores journaled individual column-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers. Each individual column change has an associated executable statement that can be used to revert/undo transactions or portions of transactions.

Entity Information

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

Stores journaled individual column-level transactions (insert, update, delete) performed on tables with BIUDR journaling triggers. Each individual column change has an associated executable statement that can be used to revert/undo transactions or portions of transactions.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 UNDO_ID NUMBER Database generated unique identifier/primary key for the UNDO table.
100
 SCHEMA_NAME VARCHAR2 Database schema in which the table exists.
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
 UNDO_TEXT CLOB Front half of executable SQL statement to revert the individual journaled transaction.
100
 UNDO_WHERE VARCHAR2 WHERE clause of executable SQL statement to revert the individual journaled transaction.
100
 COL_TIMESTAMP TIMESTAMP(4) 4 decimal second at which the history record was created.

Attribute Details

UNDO_ID

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

Database generated unique identifier/primary key for the UNDO table.
General Data Type: NUMBER

SCHEMA_NAME

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

TABLE_NAME

CC ID: 324305
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: 324306
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: 324307
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: 324308
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: 324309
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: 324310
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

UNDO_TEXT

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

Front half of executable SQL statement to revert the individual journaled transaction.
General Data Type: CLOB

UNDO_WHERE

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

WHERE clause of executable SQL statement to revert the individual journaled transaction.
General Data Type: VARCHAR2

COL_TIMESTAMP

CC ID: 324313
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: 32698
GUID: gov.noaa.nmfs.inport:32698
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