Table: GAS_DATA_MODEL_AUDIT

GAS_DATA_MODEL_AUDIT

Name

GAS_DATA_MODEL_AUDIT

Comment

GAS_DATA_MODEL_AUDIT shows the audit trail of scripts applied to this installation of Gas Data Model. Participants should ensure that if a database is cloned the content of this table is copied to the target database


Primary Key Columns

Name

GASDM_VERSION

INSTALL_TYPE

INSTALLATION_DATE


Content

Name

Data Type

Mandatory

Comment

INSTALLATION_DATE

DATE

X

The date in which the changes to the Gas Data Model were installed

GASDM_VERSION

VARCHAR2(20)

X

The version of Gas Data Model after the script has been applied

INSTALL_TYPE

VARCHAR2(10)

X

The type of the patch applied. Valid entries are: FULL, UPGRADE, DML

SCRIPT_VERSION

VARCHAR2(20)

 

The version of the patch set to the Gas Data Model

GAS_CHANGE_NOTICE

VARCHAR2(20)

 

The Gas Change notice for which this Gas Data Model applies

PROJECT_TITLE

VARCHAR2(200)

 

The name of the business project for which these changes to the Gas Data Model apply

USERNAME

VARCHAR2(40)

 

The USER applying this script

STATUS

VARCHAR2(10)

 

The status of the upgrade. Valid entries are STARTED, FAILED, SUCCESS