Maintenance Notice: Tuesday May 21 @ 12pm-1:30pm Eastern. InPort and its associated services will be under maintenance and unavailable for the deployment of InPort Release 5.3.6. Downtime Schedule Tuesday, May 21, 2024 12:00pm - 1:30pm Eastern / 9:00am - 10:30am Pacific / 6:00am - 8:30am Hawaii Impacted Areas - InPort Website: https://www.fisheries.noaa.gov/inport - InPort WAF: h...
View All
Search Help Show/Hide Menu
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