Slide Menu
Search Help Show/Hide Menu

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