Slide Menu
Search Help Show/Hide Menu

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: 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