LEVELREQUEST

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

TYPE

NUMBER

No

DESCRIPTION

VARCHAR2(512)

No

ACTIONTYPE

NUMBER

No

STATUS

NUMBER

No

VCRTAG

VARCHAR2(255)

No

REQUESTEDDATETIME

DATE

Yes

STARTDATETIME

DATE

Yes

ENDDATETIME

DATE

No

CREATIONDATETIME

DATE

No

BUILDTYPE

NUMBER

Yes

PARTIALBUILDTAG

VARCHAR2(255)

F

No

SCMLEVELOID

NUMBER

F

No

PROJECTSTREAMOID

NUMBER

Yes

CREATEDBYUSEROID

NUMBER

F

Yes

SCMPACKAGEOID

NUMBER

No

BUILDNUMBER

NUMBER

F

Yes

PROPERTYLOGOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

This field contains the sequential number of the Level Request.

All Level Requests defined for a Project are numbered sequentially.

See also: LEVELREQUEST_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

TYPE

The type of the Level Request.

The following types are available:

Builds based on latest code: this Level Request type can be defined for Build Levels. It will trigger the Build of a source code version that has not been built or tagged before. A new Tag will be created.

Builds based on tagged code: this Level Request type can be defined for Test and Production Levels. It will trigger the Re-Build of a source code version that has already been built and tagged before.

Builds and Deploys on latest code: this Level Request type can be defined for Build Levels. It will trigger the Build of a source code version that has not been built or tagged before. A new Tag will be created. The same Level Request will then deploy this Build.

Builds and Deploys on tagged code: this Level Request type can be defined for Test and Production Levels. It will trigger the Re-Build of a source code version that has already been built and tagged before. The same Level Request will then deploy this Build.

Deploys of archived Build: this Level Request type can be defined for Test and Production Levels. It will retrieve an existing Build from the Build Archive. This Build will then be deployed.

Key NULL Column Type (Size)

No

TYPE

NUMBER
Value List

0 = Build based on latest code

1 = Builds based on tagged code

2 = Builds and Deploys on latest code

3 = Builds and deploys on tagged code

4 = Deploys of archived Build

5 = No Builds or Deploys

DESCRIPTION

The description for the Level Request.

Key NULL Column Type (Size)

No

DESCRIPTION

VARCHAR2(512)

ACTIONTYPE

The type of the Level Request Action.

Key NULL Column Type (Size)

No

ACTIONTYPE

NUMBER
Value List

0 = Build initiated by Scheduler

1 = Force Build

2 = Request Build

3 = Deliver Build

4 = Rollback Build

5 = Dependency Build

6 = Redeliver Build

STATUS

The Level Request Status.

The following status indication icons are possible:

(Success) : the Level Request is executed ccessfully.
(Warning) : the Level Request has been successfully executed, but at least one non-critical Level, Build or Deploy Phase failed.
(Fail): the execution of the Level Request as a whole failed. This is due to the failure of one or more critical Level, Build or Deploy Phases.
(Run): the Level Request is being executed at this moment.
(Awaiting requested Date/Time): the requested execution is in the future.
(Awaiting Pre-Approval or Awaiting Post-Approval): the Level Request is awaiting a Pre- or Post-Approval.
(Rejected): An Approval associated with the Level Request was rejected. The Level Request will never be executed.
(Canceled): the Level Request has been canceled before it was run. It will never be executed.
(Aborted): the Level Request has been aborted during execution. The results (such as Build Results) that were already available at the time of the abort have been cleaned up and cannot be used.
Key NULL Column Type (Size)

No

STATUS

NUMBER
Value List

0 = Unknown

1 = Awaiting Requested Date/Time

2 = Awaiting Pre-Approval

3 = Rejected

4 = Run

5 = Fail

6 = Success

7 = Warning

8 = Canceled

9 = Aborting

10 = Aborted

11 = Awaiting Post-Approval

VCRTAG

The VCR Tag of the Level Request. This Tag matches a Build with its source code in the VCR.

The format of the VCR Tag normally matches the Tag Template defined for the Stream.

However, the user can overwrite the default VCR Tag while creating a Level Request (and is obliged to do so for a Build Level Request in a Tag Based Project Stream), so that the Tag Format can be completely different.

Key NULL Column Type (Size)

No

VCRTAG

VARCHAR2(255)

REQUESTEDDATETIME

The Date and Time at which the execution of the Level Request was requested.

Key NULL Column Type (Size)

No

REQUESTEDDATETIME

DATE

STARTDATETIME

The date and time at which the Level Request execution started.

Key NULL Column Type (Size)

Yes

STARTDATETIME

DATE

ENDDATETIME

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

Key NULL Column Type (Size)

Yes

ENDDATETIME

DATE

CREATIONDATETIME

The Date and Time at which the Level Request was created.

Key NULL Column Type (Size)

No

CREATIONDATETIME

DATE

BUILDTYPE

The Build type.

The following types are possible:

Full Build

Partial Build: only the sources that were modified since the last Build will be rebuilt.

Production-based Partial Build: only the sources that are different from the version on the Production Level will be rebuilt

Tag-based Partial Build: only the sources that were modified compared to a specific Build

Key NULL Column Type (Size)

No

BUILDTYPE

NUMBER
Value List

0 = Full Build

1 = Partial Build based on Previous Build

2 = Partial Build based on Production Build

3 = Partial Build based on specific Tagged Build

PARTIALBUILDTAG

The Partial Build VCR Tag. This tag is used as a reference to determine which sources were modified.

Key NULL Column Type (Size)

Yes

PARTIALBUILDTAG

VARCHAR2(255)

SCMLEVELOID

Identifier for the SCMLEVEL table.

For more information, refer to the description of the foreign key LEVELREQUEST_FK_2.

See also: LEVELREQUEST_FK_2.

Key NULL Column Type (Size)

F

No

SCMLEVELOID

NUMBER

PROJECTSTREAMOID

Identifier for the PROJECTSTREAM table.

For more information, refer to the description of the foreign key LEVELREQUEST_FK_1.

See also: LEVELREQUEST_FK_1.

Key NULL Column Type (Size)

F

No

PROJECTSTREAMOID

NUMBER

CREATEDBYUSEROID

OID identifying the User who created the Level Request. Refers to the primary key of the appropriate User table.

Key NULL Column Type (Size)

Yes

CREATEDBYUSEROID

NUMBER

SCMPACKAGEOID

Internal identifier of the Package.

See also: LEVELREQUEST_FK_3.

Key NULL Column Type (Size)

F

Yes

SCMPACKAGEOID

NUMBER

BUILDNUMBER

The Build number of the Level Request.

Key NULL Column Type (Size)

No

BUILDNUMBER

NUMBER

PROPERTYLOGOID

Internal identifier of the Issue.

See also: LEVELREQUEST_FK_4.

Key NULL Column Type (Size)

F

Yes

PROPERTYLOGOID

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

LEVELREQUEST_PK

Yes

Yes

OID

LEVELREQUEST_FK_1

No

No

PROJECTSTREAMOID

PROJECTSTREAM

LEVELREQUEST_FK_2

No

No

SCMLEVELOID

SCMLEVEL

LEVELREQUEST_FK_3

No

No

SCMPACKAGEOID

SCMPACKAGE

LEVELREQUEST_FK_4

No

No

PROPERTYLOGOID

PROPERTYLOG

Relationships

Referenced Tables

PROJECTSTREAM

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

Foreign Key Referenced Column(s)

LEVELREQUEST_FK_1

OID
PROPERTYLOG

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

Foreign Key Referenced Column(s)

LEVELREQUEST_FK_4

OID
SCMLEVEL

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

Foreign Key Referenced Column(s)

LEVELREQUEST_FK_2

OID
SCMPACKAGE

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

Foreign Key Referenced Column(s)

LEVELREQUEST_FK_3

OID

Referencing Tables

BUILD

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

Foreign Key Referencing Column

BUILD_FK_2

LEVELREQUESTOID
BUILDDEPENDENCY

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

Foreign Key Referencing Column

BUILDDEPENDENCY_FK_3

CHILDLEVELREQUESTOID
DEPLOY

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

Foreign Key Referencing Column

DEPLOY_FK_3

LEVELREQUESTOID
ISSUE

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

Foreign Key Referencing Column

ISSUE_FK_1

LEVELREQUESTOID
LEVELAPPROVAL

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

Foreign Key Referencing Column

LEVELAPPROVAL_FK_1

LEVELREQUESTOID
LEVELREQUESTLOG

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

Foreign Key Referencing Column

LEVELREQUESTLOG_FK_1

LEVELREQUESTOID
LEVELREQUEST_FILEREVISION

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

Foreign Key Referencing Column

LEVELREQUEST_FILEREVISION_FK_2

LEVELREQUESTOID
PROJECTSTREAMDEPENDENCY

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

Foreign Key Referencing Column

PROJECTSTREAMDEPENDENCY_FK_3

CHILDLEVELREQUESTOID

Report Labels

LEVELREQUEST_ACTIONTYPE_LABEL

English:

Action Type

French:

Type d’action

German:

Aktionstyp

LEVELREQUEST_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

LEVELREQUEST_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

LEVELREQUEST_BUILDNUMBER_LABEL

English:

Build Number

French:

Numéro de la Construction

German:

Bereitstellungsnummer

LEVELREQUEST_BUILDTYPE_LABEL

English:

Build Type

French:

Type de construction

German:

Bereitstellungstyp

LEVELREQUEST_CREATEDBYUSEROID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUEST_CREATIONDATETIME_LABEL

English:

Creation Date

French:

Date de création

German:

Erstellungsdatum

LEVELREQUEST_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

LEVELREQUEST_ENDDATETIME_LABEL

English:

End Date/Time

French:

Fin d’exécution

German:

Ausführungsende

LEVELREQUEST_OID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUEST_PARTIALBUILDTAG_LABEL

English:

Partial Build VCR Tag

French:

Balise RCV constr. partielle

German:

Version für partielle Bereitstellung

LEVELREQUEST_PROJECTSTREAMOID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUEST_PROPERTYLOGOID_LABEL

English:

Property Log OID

French:

OID du Journal des propriétés

German:

Eigenschaftenprotokoll OID

LEVELREQUEST_REQUESTEDDATETIME_LABEL

English:

Requested Date/Time

French:

Exécution demandée

German:

Angefordert am

LEVELREQUEST_SCMLEVELOID_LABEL

English:

OID

French:

OID

German:

OID

LEVELREQUEST_SCMPACKAGEOID_LABEL

English:

ALM Package OID

French:

OID Paquet ALM

German:

ALM Paket OID

LEVELREQUEST_STARTDATETIME_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

LEVELREQUEST_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

LEVELREQUEST_TYPE_LABEL

English:

Type

French:

Type

German:

Typ

LEVELREQUEST_VCRTAG_LABEL

English:

VCR Tag

French:

Balise RCV

German:

Version

LEVELREQUEST_VERSION_LABEL

English:

Version

French:

Version

German:

Version