SCMPACKAGEEVENTLOG

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

SCMPACKAGEOID

NUMBER

Yes

SCMPACKAGEVERSION

NUMBER

No

CHANGEDATETIME

DATE

No

CHANGETYPE

NUMBER

No

USERID

VARCHAR2(20)

Yes

NOTE

VARCHAR2(512)

Yes

CHANGEDSTATE

CLOB

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMPACKAGEEVENTLOG_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCMPACKAGEOID

Internal identifier of the Package.

See also: SCMPACKAGEEVENTLOG_FK_1.

Key NULL Column Type (Size)

F

No

SCMPACKAGEOID

NUMBER

SCMPACKAGEVERSION

The version number of the Package.

Key NULL Column Type (Size)

Yes

SCMPACKAGEVERSION

NUMBER

CHANGEDATETIME

The date and time at which the Package was created, updated or deleted.

Key NULL Column Type (Size)

No

CHANGEDATETIME

DATE

CHANGETYPE

The type of change made to the Package.

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 Package.

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 Package after the change.

Key NULL Column Type (Size)

Yes

CHANGEDSTATE

CLOB

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
Value List

0 = no

1 = yes

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

SCMPACKAGEEVENTLOG_PK

Yes

Yes

OID

SCMPACKAGEEVENTLOG_FK_1

No

No

SCMPACKAGEOID

SCMPACKAGE

Relationships

Referenced Tables

SCMPACKAGE

Refer to the chapter SCMPACKAGE for a detailed description of the table.

Foreign Key Referenced Column(s)

SCMPACKAGEEVENTLOG_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

SCMPACKAGEEVENTLOG_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMPACKAGEEVENTLOG_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMPACKAGEEVENTLOG_CHANGEDATETIME_LABEL

English:

Modification Date/Time

French:

Date / Heure de la modification

German:

Änderungsdatum

SCMPACKAGEEVENTLOG_CHANGEDSTATE_LABEL

English:

Changed State

French:

Etat modifié

German:

Modifizierte Status

SCMPACKAGEEVENTLOG_CHANGETYPE_LABEL

English:

Modification Type

French:

Type de modification

German:

Änderungsart

SCMPACKAGEEVENTLOG_NOTE_LABEL

English:

Note

French:

Remarque

German:

Anmerkung

SCMPACKAGEEVENTLOG_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMPACKAGEEVENTLOG_SCMPACKAGEOID_LABEL

English:

ALM Package OID

French:

OID Paquet ALM

German:

ALM Paket OID

SCMPACKAGEEVENTLOG_SCMPACKAGEVERSION_LABEL

English:

ALM Package Version

French:

Version du Paquet ALM

German:

ALM Paketversion

SCMPACKAGEEVENTLOG_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

SCMPACKAGEEVENTLOG_VERSION_LABEL

English:

Version

French:

Version

German:

Version