Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
OPR Meta Data Library > Permits and Conservation Division (F/PR1) > Public Display of Marine Mammals > National Inventory of Marine Mammals (NIMM) >

Table: AUDIT_COLUMN_HISTORIES

Entity (ENT)  |  NMFS Office Of Protected Resources (OPR)
GUID: gov.noaa.nmfs.inport:26988  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

This table shall capture the column/value that is changed or deleted by a user. For Updates, it captures the column that is changed, its old value and new value. For Deletes, it captures all the columns and their old values.

Description

This table shall capture the column/value that is changed or deleted by a user. For Updates, it captures the column that is changed, its old value and new value. For Deletes, it captures all the columns and their old values.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
AUDIT_COLUMN_HISTORY_ID
NUMBER 		System generated unique identifier for audit column history
AUDIT_TABLE_HISTORY_ID
NUMBER 		The parent table/record for these columns
ACH_COLUMN_NAME
VARCHAR2 		The name of the column where the data is updated or deleted by a user
ACH_OLD_VALUE
VARCHAR2 		The original value of the column before user made the change
ACH_NEW_VALUE
VARCHAR2 		The value that the user changed to

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_COLUMN_HISTORIES
Short Name: AUDIT_COLUMN_HISTORIES
Status: Completed
Abstract:

This table shall capture the column/value that is changed or deleted by a user. For Updates, it captures the column that is changed, its old value and new value. For Deletes, it captures all the columns and their old values.
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 column/value that is changed or deleted by a user. For Updates, it captures the column that is changed, its old value and new value. For Deletes, it captures all the columns and their old values.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key AUDIT_COLUMN_HISTORY_ID NUMBER System generated unique identifier for audit column history
100
 AUDIT_TABLE_HISTORY_ID NUMBER The parent table/record for these columns
100
 ACH_COLUMN_NAME VARCHAR2 The name of the column where the data is updated or deleted by a user
100
 ACH_OLD_VALUE VARCHAR2 The original value of the column before user made the change
100
 ACH_NEW_VALUE VARCHAR2 The value that the user changed to

Attribute Details

AUDIT_COLUMN_HISTORY_ID

CC ID: 219077
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 audit column history
General Data Type: NUMBER

AUDIT_TABLE_HISTORY_ID

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

The parent table/record for these columns
General Data Type: NUMBER
Foreign Key Relations:

NIMM_APPS.AUDIT_TABLE_HISTORIE

ACH_COLUMN_NAME

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

The name of the column where the data is updated or deleted by a user
General Data Type: VARCHAR2

ACH_OLD_VALUE

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

The original value of the column before user made the change
General Data Type: VARCHAR2

ACH_NEW_VALUE

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

The value that the user changed to
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 26988
GUID: gov.noaa.nmfs.inport:26988
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