Metadata Rubric

100%

6 / 6

OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: AUDIT_TABLE_HISTORIES

Entity (ENT) | NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26990 | Updated: August 9, 2022 | Published / External

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

	Name	Type	Description
100	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.

Name

Type

Description

100

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