Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table shall capture the table/record that is changed or deleted by a user. The actual column/value that is changed or deleted are stored in the AUDIT_COLUMN_HISTORIES table. New/inserted records are stored in the original tables only. This table should be created in each application schema.

Description

This table shall capture the table/record that is changed or deleted by a user. The actual column/value that is changed or deleted are stored in the AUDIT_COLUMN_HISTORIES table. New/inserted records are stored in the original tables only. This table should be created in each application schema.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AUDIT_TABLE_HISTORY_ID
NUMBER
System generated unique identifier for a audit table history
ATH_TABLE_NAME
VARCHAR2
The name of the table where the data is updated or deleted by a user
ATH_PRIMARY_KEY
VARCHAR2
The primary key column and value to identify which record is changed. If there are more than one columns in the PK, it will be in the following format: col1=value AND col2=value
ATH_ACTION
VARCHAR2
The action taken on this record, i.e. Update or Delete.
ATH_ACTION_DATE
DATE
The date this record was deleted or updated
ATH_USER_LOGON
VARCHAR2
The user who modified the record. In case of Update, this column will be populated with the application user, if the application passes that information in the DML. In case of Delete, this column will be null since the application cannot pass in the information in the DML.
ATH_ORACLE_LOGON
VARCHAR2
The oracle (i.e. database) logon. When Updates or Deleted are done direcly in the database, this column will capture the actual db logon who performs the request.

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (OPR) for inquiries on this record.

Item Identification

Title: Table: AUDIT_TABLE_HISTORIES
Short Name: AUDIT_TABLE_HISTORIES
Status: Completed
Abstract:

This table shall capture the table/record that is changed or deleted by a user. The actual column/value that is changed or deleted are stored in the AUDIT_COLUMN_HISTORIES table. New/inserted records are stored in the original tables only. This table should be created in each application schema.

Notes:

Loaded by batch 7077, 09-17-2015 08:15

Entity Information

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

This table shall capture the table/record that is changed or deleted by a user. The actual column/value that is changed or deleted are stored in the AUDIT_COLUMN_HISTORIES table. New/inserted records are stored in the original tables only. This table should be created in each application schema.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
Primary Key AUDIT_TABLE_HISTORY_ID NUMBER System generated unique identifier for a audit table history
100
ATH_TABLE_NAME VARCHAR2 The name of the table where the data is updated or deleted by a user
100
ATH_PRIMARY_KEY VARCHAR2 The primary key column and value to identify which record is changed. If there are more than one columns in the PK, it will be in the following format: col1=value AND col2=value
100
ATH_ACTION VARCHAR2 The action taken on this record, i.e. Update or Delete.
100
ATH_ACTION_DATE DATE The date this record was deleted or updated
100
ATH_USER_LOGON VARCHAR2 The user who modified the record. In case of Update, this column will be populated with the application user, if the application passes that information in the DML. In case of Delete, this column will be null since the application cannot pass in the information in the DML.
100
ATH_ORACLE_LOGON VARCHAR2 The oracle (i.e. database) logon. When Updates or Deleted are done direcly in the database, this column will capture the actual db logon who performs the request.

Attribute Details

AUDIT_TABLE_HISTORY_ID

CC ID: 219089
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 10
Scale: 0
Status: Active
Description:

System generated unique identifier for a audit table history

General Data Type: NUMBER

ATH_TABLE_NAME

CC ID: 219090
Seq. Order: 2
Data Storage Type: VARCHAR2
Max Length: 30
Required: No
Primary Key: No
Status: Active
Description:

The name of the table where the data is updated or deleted by a user

General Data Type: VARCHAR2

ATH_PRIMARY_KEY

CC ID: 219091
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

The primary key column and value to identify which record is changed. If there are more than one columns in the PK, it will be in the following format: col1=value AND col2=value

General Data Type: VARCHAR2

ATH_ACTION

CC ID: 219092
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

The action taken on this record, i.e. Update or Delete.

General Data Type: VARCHAR2

ATH_ACTION_DATE

CC ID: 219093
Seq. Order: 5
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

The date this record was deleted or updated

General Data Type: DATE

ATH_USER_LOGON

CC ID: 219094
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 200
Required: No
Primary Key: No
Status: Active
Description:

The user who modified the record. In case of Update, this column will be populated with the application user, if the application passes that information in the DML. In case of Delete, this column will be null since the application cannot pass in the information in the DML.

General Data Type: VARCHAR2

ATH_ORACLE_LOGON

CC ID: 219095
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 100
Required: No
Primary Key: No
Status: Active
Description:

The oracle (i.e. database) logon. When Updates or Deleted are done direcly in the database, this column will capture the actual db logon who performs the request.

General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 26990
GUID: gov.noaa.nmfs.inport:26990
Metadata Record Created By: Nathan Wilson
Metadata Record Created: 2015-09-17 08:15+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2018-05-16
Owner Org: OPR
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2018-05-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2019-05-16