GLOBALEVENTLOG

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

OBJECTTYPE

NUMBER

No

OBJECTOID

NUMBER

Yes

OBJECTVERSION

NUMBER

No

CHANGEDATETIME

DATE

No

CHANGETYPE

NUMBER

No

USERID

VARCHAR2(20)

Yes

NOTE

VARCHAR2(512)

Yes

CHANGEDSTATE

VARCHAR2(4000)

Yes

LEFTOBJECTTYPE

NUMBER

Yes

LEFTOBJECTOID

NUMBER

Yes

RIGHTOBJECTTYPE

NUMBER

Yes

RIGHTOBJECTOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: GLOBALEVENTLOG_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

OBJECTTYPE

The type of the Global Administration object for which the log is created.

Key NULL Column Type (Size)

No

OBJECTTYPE

NUMBER
Value List

0 = System Settings

1 = User

2 = User Group

3 = User Group - User Association

4 = Machine

5 = FileCopy

6 = FTP

7 = Secure Shell

8 = CVS

9 = SVN

10 = VSS

11 = ClearCase

12 = PVCS

13 = Issue Tracking System

14 = ANT

15 = ANT WSAD

16 = NANT

17 = MAVEN2

18 = Schedule

19 = Issue Tracking System Property

20 = Machine Parameter

21 = Phase

22 = Phase Parameter

23 = Git

24 = TFVC

25 = Gradle

OBJECTOID

OID of the Global Administration object for which the log is created.

Key NULL Column Type (Size)

No

OBJECTOID

NUMBER

OBJECTVERSION

The version number of the Global Administration object after the current update has been persisted.

Key NULL Column Type (Size)

Yes

OBJECTVERSION

NUMBER

CHANGEDATETIME

The date and time at which the Global Administration object was created, updated or deleted.

Key NULL Column Type (Size)

No

CHANGEDATETIME

DATE

CHANGETYPE

The type of change made to the Global Administration object.

Key NULL Column Type (Size)

No

CHANGETYPE

NUMBER
Value List

0 = Create

1 = Update

2 = Delete

USERID

The User ID of the User who performed the modification (create/update/delete) of the Global Administration object.

Key NULL Column Type (Size)

No

USERID

VARCHAR2(20)

NOTE

For future use.

Key NULL Column Type (Size)

Yes

NOTE

VARCHAR2(512)

CHANGEDSTATE

Serialized xml of the object after the change.

Key NULL Column Type (Size)

Yes

CHANGEDSTATE

VARCHAR2(4000)

LEFTOBJECTTYPE

The type of the “parent” object in case the object type is a OneToN or MtoN Association.

Key NULL Column Type (Size)

Yes

LEFTOBJECTTYPE

NUMBER

LEFTOBJECTOID

OID of the parent object for which the log is created.

Key NULL Column Type (Size)

Yes

LEFTOBJECTOID

NUMBER

RIGHTOBJECTTYPE

The type of the "child" object in case the object type is a MToN Association.

This will only be used for the UserGroupAssociation (MtoN Association between UserGroup and User). The RIGHTOBJECTTYPE will then be “User”.

Key NULL Column Type (Size)

Yes

RIGHTOBJECTTYPE

NUMBER

RIGHTOBJECTOID

OID of the child object for which the log is created.

Key NULL Column Type (Size)

Yes

RIGHTOBJECTOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

GLOBALEVENTLOG_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

GLOBALEVENTLOG_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

GLOBALEVENTLOG_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

GLOBALEVENTLOG_CHANGEDATETIME_LABEL

English:

Modification Date/Time

French:

Date / Heure de la modification

German:

Änderungsdatum

GLOBALEVENTLOG_CHANGEDSTATE_LABEL

English:

Changed State

French:

Etat modifié

German:

Modifizierte Status

GLOBALEVENTLOG_CHANGETYPE_LABEL

English:

Modification Type

French:

Type de modification

German:

Änderungsart

GLOBALEVENTLOG_LEFTOBJECTOID_LABEL

English:

OID

French:

OID

German:

OID

GLOBALEVENTLOG_LEFTOBJECTTYPE_LABEL

English:

Left Object Type

French:

Left Object Type

German:

Left Object Type

GLOBALEVENTLOG_NOTE_LABEL

English:

Note

French:

Remarque

German:

Anmerkung

GLOBALEVENTLOG_OBJECTOID_LABEL

English:

OID

French:

OID

German:

OID

GLOBALEVENTLOG_OBJECTTYPE_LABEL

English:

Object Type

French:

Type d’objet

German:

Objekttyp

GLOBALEVENTLOG_OBJECTVERSION_LABEL

English:

Object Version

French:

Version d’objet

German:

Version des Objekts

GLOBALEVENTLOG_OID_LABEL

English:

OID

French:

OID

German:

OID

GLOBALEVENTLOG_RIGHTOBJECTOID_LABEL

English:

OID

French:

OID

German:

OID

GLOBALEVENTLOG_RIGHTOBJECTTYPE_LABEL

English:

Right Object Type

French:

Right Object Type

German:

Right Object Type

GLOBALEVENTLOG_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

GLOBALEVENTLOG_VERSION_LABEL

English:

Version

French:

Version

German:

Version