PROJECTEVENTLOG

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

PROJECTOID

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: PROJECTEVENTLOG_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

PROJECTOID

OID of the Project for which the object has been changed.

Key NULL Column Type (Size)

No

PROJECTOID

NUMBER

OBJECTTYPE

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

Key NULL Column Type (Size)

No

OBJECTTYPE

NUMBER
Value List

0 = Project

1 = Project Stream

2 = Project Stream Dependency

3 = Life-Cycle

4 = Level

5 = Life-Cycle Association

7 = Pre-Approval User Group Association

8 = Post-Approval User Group Association

9 = Build Environment

11 = Build Parameter

12 = Deploy Environment

14 = Deploy Parameter

15 = Environment Phase

16 = Environment Phase Parameter

OBJECTOID

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

Key NULL Column Type (Size)

No

OBJECTOID

NUMBER

OBJECTVERSION

The version number of the Project 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 Project 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 that created/updated/deleted 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.

Example: the LifeCycleAssociation (MtoN Association between Life-Cycle and Level), where the rightObjectType will be “Level”.

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

PROJECTEVENTLOG_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

PROJECTEVENTLOG_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PROJECTEVENTLOG_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PROJECTEVENTLOG_CHANGEDATETIME_LABEL

English:

Modification Date/Time

French:

Date / Heure de la modification

German:

Änderungsdatum

PROJECTEVENTLOG_CHANGEDSTATE_LABEL

English:

Changed State

French:

Etat modifié

German:

Modifizierte Status

PROJECTEVENTLOG_CHANGETYPE_LABEL

English:

Modification Type

French:

Type de modification

German:

Änderungsart

PROJECTEVENTLOG_LEFTOBJECTOID_LABEL

English:

OID

French:

Right Object Type

German:

Right Object Type

PROJECTEVENTLOG_LEFTOBJECTTYPE_LABEL

English:

Left Object Type

French:

Left Object Type

German:

Left Object Type

PROJECTEVENTLOG_NOTE_LABEL

English:

Note

French:

Remarque

German:

Anmerkung

PROJECTEVENTLOG_OBJECTOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTEVENTLOG_OBJECTTYPE_LABEL

English:

Object Type

French:

Type d’objet

German:

Objekttyp

PROJECTEVENTLOG_OBJECTVERSION_LABEL

English:

Object Version

French:

Version d’objet

German:

Version des Objekts

PROJECTEVENTLOG_OID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTEVENTLOG_PROJECTOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTEVENTLOG_RIGHTOBJECTOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTEVENTLOG_RIGHTOBJECTTYPE_LABEL

English:

Right Object Type

French:

Right Object Type

German:

Right Object Type

PROJECTEVENTLOG_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

PROJECTEVENTLOG_VERSION_LABEL

English:

Version

French:

Version

German:

Version