BUILD

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

TAGGEDBUILD

NUMBER(1)

No

BUILDNUMBER

NUMBER

No

STATUS

NUMBER

Yes

STARTDATE

DATE

Yes

ENDDATE

DATE

No

FILENAME

VARCHAR2(255)

F

No

BUILDENVIRONMENTOID

NUMBER

F

No

LEVELREQUESTOID

NUMBER

F

No

PROPERTYLOGOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

ARCHIVESTATUS

NUMBER

Yes

FILESIZE

NUMBER(20)

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: BUILD_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

TAGGEDBUILD

Indication whether the Build is based on tagged code (Rebuild) or untagged code (original build).

Key NULL Column Type (Size)

No

TAGGEDBUILD

NUMBER(1)
Value List

0 = no

1 = yes

BUILDNUMBER

The Build Number for this Build associated with this Level Request.

Key NULL Column Type (Size)

No

BUILDNUMBER

NUMBER

STATUS

The Build Status indication. This Status indication is derived from the status of the different Build Phases.

Key NULL Column Type (Size)

No

STATUS

NUMBER
Value List

0 = Unknown

1 = Canceled

2 = Rejected

3 = Wait

4 = In progress

5 = Run

6 = Fail

7 = Success

8 = Warning

9 = Aborted

STARTDATE

The date and time at which the Build execution started.

Key NULL Column Type (Size)

Yes

STARTDATE

DATE

ENDDATE

The date and time at which the Build execution ended.

Key NULL Column Type (Size)

Yes

ENDDATE

DATE

FILENAME

Name of the Build File that holds the compressed Build results. This file is stored in the IKAN ALM Build Archive Location.

This name has the following format:

DEMOCVS_H_1-0_b9_CONTBUILD_Win.zip

where:

  • DEMOCVS = Project Name

  • H = Stream type indication: H = Head, B = Branch

  • 1-0 = Build Prefix

  • b9 = Build Number

  • CONTBUILD = Build Environment name

  • win = Build Environment suffix: win, linux

  • zip = filename extension. For Builds on a Windows Machine, this is .zip, for Linux/Unix Builds, the extension is .tar.gz.

If the Build failed, this field is empty.

Key NULL Column Type (Size)

No

FILENAME

VARCHAR2(255)

BUILDENVIRONMENTOID

Identifier for the BUILDENVIRONMENT table.

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

See also: BUILD_FK_1.

Key NULL Column Type (Size)

F

No

BUILDENVIRONMENTOID

NUMBER

LEVELREQUESTOID

Identifier for the LEVELREQUEST table.

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

See also: BUILD_FK_2.

Key NULL Column Type (Size)

F

No

LEVELREQUESTOID

NUMBER

PROPERTYLOGOID

Identifier for the PROPERTYLOG table.

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

See also: BUILD_FK_3.

Key NULL Column Type (Size)

F

No

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

ARCHIVESTATUS

Archive status of the Build.

Key NULL Column Type (Size)

No

ARCHIVESTATUS

NUMBER
Value List

0 = non-existing

1 = present

2 = trash bin

3 = deleted

FILESIZE

The file size in kilobytes (kB).

Key NULL Column Type (Size)

Yes

FILESIZE

NUMBER(20)

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

BUILD_PK

Yes

Yes

OID

BUILD_FK_1

No

No

BUILDENVIRONMENTOID

BUILDENVIRONMENT

BUILD_FK_2

No

No

LEVELREQUESTOID

LEVELREQUEST

BUILD_FK_3

No

No

PROPERTYLOGOID

PROPERTYLOG

Relationships

Referenced Tables

BUILDENVIRONMENT

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

Foreign Key Referenced Column(s)

BUILD_FK_1

OID
LEVELREQUEST

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

Foreign Key Referenced Column(s)

BUILD_FK_2

OID
PROPERTYLOG

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

Foreign Key Referenced Column(s)

BUILD_FK_3

OID

Referencing Tables

BUILDDEPENDENCY

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

Foreign Key Referencing Column

BUILDDEPENDENCY_FK_1

MASTERBUILDOID

BUILDDEPENDENCY_FK_2

CHILDBUILDOID
BUILDLOG

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

Foreign Key Referencing Column

BUILDLOG_FK_1

BUILDOID
DEPLOY

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

Foreign Key Referencing Column

DEPLOY_FK_1

BUILDOID

Report Labels

BUILD_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

BUILD_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

BUILD_ARCHIVESTATUS_LABEL

English:

Archive Status

French:

Statut Archive

German:

Archivstatus

BUILD_BUILDENVIRONMENTOID_LABEL

English:

OID

French:

OID

German:

OID

BUILD_BUILDNUMBER_LABEL

English:

Build Number

French:

Numéro de la Construction

German:

Bereitstellungsnummer

BUILD_ENDDATE_LABEL

English:

End Date/Time

French:

Fin d’exécution

German:

Ausführungsende

BUILD_FILENAME_LABEL

English:

Build File Name

French:

Fichier de construction

German:

Bereitstellungsdatei

BUILD_FILESIZE_LABEL

English:

File Size

French:

Taille Fichier

German:

Dateigröße

BUILD_LEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

BUILD_OID_LABEL

English:

OID

French:

OID

German:

OID

BUILD_PROPERTYLOGOID_LABEL

English:

OID

French:

OID

German:

OID

BUILD_STARTDATE_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

BUILD_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

BUILD_TAGGEDBUILD_LABEL

English:

Based on Tagged Code

French:

Construction balisée

German:

Bereitstellungsversion

BUILD_VERSION_LABEL

English:

Version

French:

Version

German:

Version