LEVELREQUESTLOG

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

PHASE

NUMBER

No

PHASENAME

VARCHAR2(255)

Yes

PHASEVERSION

VARCHAR2(50)

No

STATUS

NUMBER

Yes

MESSAGE

CLOB

Yes

STACKTRACE

CLOB

Yes

ALMLOG

CLOB

F

No

LEVELREQUESTOID

NUMBER

F

No

LOGFORMATOID

NUMBER

Yes

PROPERTYLOGOID

NUMBER

Yes

STARTDATETIME

DATE

Yes

ENDDATETIME

DATE

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: LEVELREQUESTLOG_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

PHASE

The Sequence number of the Level Phase.

Key NULL Column Type (Size)

No

PHASE

NUMBER

PHASENAME

The name of the Level Phase at the moment the logging took place. This name defines at the same time the function of the Phase.

Key NULL Column Type (Size)

No

PHASENAME

VARCHAR2(255)

PHASEVERSION

The version of the Phase.

Key NULL Column Type (Size)

Yes

PHASEVERSION

VARCHAR2(50)

STATUS

The status of the Phase.

Key NULL Column Type (Size)

No

STATUS

NUMBER
Value List

-1 = Not executed

0 = Success

1 = Warning

2 = Fail

3 = Run

4 = Aborted

MESSAGE

The log of the Phase.

Key NULL Column Type (Size)

Yes

MESSAGE

CLOB

STACKTRACE

In case the Phase encountered an error, this field contains the complete Stack Trace generated by the failed Phase.

Key NULL Column Type (Size)

Yes

STACKTRACE

CLOB

ALMLOG

The actual Level Request Log generated by the Build or Deploy tool using the format defined by the LOGFORMATOID.

Key NULL Column Type (Size)

Yes

ALMLOG

CLOB

LEVELREQUESTOID

Identifier for the LEVELREQUEST table at the moment the log item was created.

See also: LEVELREQUESTLOG_FK_1.

Key NULL Column Type (Size)

F

No

LEVELREQUESTOID

NUMBER

LOGFORMATOID

Internal identifier of the object.

See also: LEVELREQUESTLOG_FK_2.

Key NULL Column Type (Size)

F

No

LOGFORMATOID

NUMBER

PROPERTYLOGOID

Internal identifier of the object.

Key NULL Column Type (Size)

Yes

PROPERTYLOGOID

NUMBER

STARTDATETIME

The date and time at which the Level Phase execution was started.

Key NULL Column Type (Size)

Yes

STARTDATETIME

DATE

ENDDATETIME

The date and time at which the Level Phase execution ended.

Key NULL Column Type (Size)

Yes

ENDDATETIME

DATE

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)

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

LEVELREQUESTLOG_PK

Yes

Yes

OID

LEVELREQUESTLOG_FK_1

No

No

LEVELREQUESTOID

LEVELREQUEST

LEVELREQUESTLOG_FK_2

No

No

LOGFORMATOID

LOGFORMAT

Relationships

Referenced Tables

LEVELREQUEST

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

Foreign Key Referenced Column(s)

LEVELREQUESTLOG_FK_1

OID
LOGFORMAT

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

Foreign Key Referenced Column(s)

LEVELREQUESTLOG_FK_2

OID

Referencing Tables

No referencing tables available.

Report Labels

LEVELREQUESTLOG_ALMLOG_LABEL

English:

ALM Log

French:

Journal ALM

German:

ALM Protokoll

LEVELREQUESTLOG_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

LEVELREQUESTLOG_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

LEVELREQUESTLOG_ENDDATETIME_LABEL

English:

End Date/Time

French:

Fin d’exécution

German:

Ausführungsende

LEVELREQUESTLOG_LEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUESTLOG_LOGFORMATOID_LABEL

English:

Log Format OID

French:

OID Format du Journal

German:

Protokollformat OID

LEVELREQUESTLOG_MESSAGE_LABEL

English:

Log

French:

Trace

German:

Protokoll

LEVELREQUESTLOG_OID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUESTLOG_PHASE_LABEL

English:

Phase

French:

Phase

German:

Phase

LEVELREQUESTLOG_PHASENAME_LABEL

English:

Phase Name

French:

Nom de Phase

German:

Name der Phase

LEVELREQUESTLOG_PHASEVERSION_LABEL

English:

Phase Version

French:

Version de la Phase

German:

Phasenversion

LEVELREQUESTLOG_PROPERTYLOGOID_LABEL

English:

Property Log OID

French:

OID du Journal des propriétés

German:

Eigenschaftenprotokoll OID

LEVELREQUESTLOG_STACKTRACE_LABEL

English:

Stack Trace

French:

Trace de pile

German:

Stack-Trace

LEVELREQUESTLOG_STARTDATETIME_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

LEVELREQUESTLOG_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

LEVELREQUESTLOG_VERSION_LABEL

English:

Version

French:

Version

German:

Version