PHASE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

U

No

NAME

VARCHAR2(255)

U

No

PHASEVERSION

VARCHAR2(50)

No

DEFAULTDISPLAYNAME

VARCHAR2(512)

Yes

DESCRIPTION

VARCHAR2(512)

No

EXECUTIONTYPE

NUMBER

No

COREPHASE

NUMBER(1)

No

LEVELENABLED

NUMBER(1)

No

BUILDENABLED

NUMBER(1)

No

DEPLOYENABLED

NUMBER(1)

No

CERTIFIED

NUMBER(1)

No

RELEASED

NUMBER(1)

Yes

AUTHOR

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: PHASE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

The name of the Phase.

See also: PHASE_U_1.

Key NULL Column Type (Size)

U

No

NAME

VARCHAR2(255)

PHASEVERSION

The version of the Phase.

See also: PHASE_U_1.

Key NULL Column Type (Size)

U

No

PHASEVERSION

VARCHAR2(50)

DEFAULTDISPLAYNAME

The name of the Phase as it will be displayed in the IKAN ALM user interface. This default name will be used if no language-specific display name is provided.

Key NULL Column Type (Size)

No

DEFAULTDISPLAYNAME

VARCHAR2(512)

DESCRIPTION

The description of the Phase.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(512)

EXECUTIONTYPE

The type of Scripting Tool that will be used to execute the scripts of the Phase.

Key NULL Column Type (Size)

No

EXECUTIONTYPE

NUMBER
Value List

0 = Core (used for Core Phases)

1 = Ant

2 = NAnt

3 = Maven2

4 = Gradle

COREPHASE

Indicates whether the Phase is a Core Phase. A Core Phase is an internal IKAN ALM Phase that performs some core functionality.

Key NULL Column Type (Size)

No

COREPHASE

NUMBER(1)
Value List

0 = no

1 = yes

LEVELENABLED

Indicates whether the Phase can be used on a Level.

Key NULL Column Type (Size)

No

LEVELENABLED

NUMBER(1)
Value List

0 = no

1 = yes

BUILDENABLED

Indicates whether the Phase can be used on a Build Environment.

Key NULL Column Type (Size)

No

BUILDENABLED

NUMBER(1)
Value List

0 = no

1 = yes

DEPLOYENABLED

Indicates whether the Phase can be used on a Deploy Environment.

Key NULL Column Type (Size)

No

DEPLOYENABLED

NUMBER(1)
Value List

0 = no

1 = yes

CERTIFIED

Indicates whether the Phase is certified.

Key NULL Column Type (Size)

No

CERTIFIED

NUMBER(1)
Value List

0 = no

1 = yes

RELEASED

Indicates whether the Phase has been released.

A Phase that has not been released is regarded as being under development, i.e., its script(s) and other containing files may still be changed.

Key NULL Column Type (Size)

No

RELEASED

NUMBER(1)
Value List

0 = no

1 = yes

AUTHOR

The author of the Phase.

Key NULL Column Type (Size)

Yes

AUTHOR

VARCHAR2(255)

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

PHASE_U_1

No

Yes

NAMEPHASEVERSION

PHASE_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

ENVIRONMENTPHASE

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

Foreign Key Referencing Column

ENVIRONMENTPHASE_FK_1

PHASEOID
PHASEPARAMETER

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

Foreign Key Referencing Column

PHASEPARAMETER_FK_1

PHASEOID
PHASE_LOCALIZATION_INFO

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

Foreign Key Referencing Column

PHASE_LOCALIZATION_INFO_FK_1

PHASEOID

Report Labels

PHASE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PHASE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PHASE_AUTHOR_LABEL

English:

Author

French:

Auteur

German:

Ersteller

PHASE_BUILDENABLED_LABEL

English:

Build Enabled

French:

Construction activée

German:

Bereitstellung aktiviert

PHASE_CERTIFIED_LABEL

English:

Certified

French:

Certifiée

German:

Zertifiziert

PHASE_COREPHASE_LABEL

English:

Core Phase

French:

Phase de noyau

German:

Kernphase

PHASE_DEFAULTDISPLAYNAME_LABEL

English:

Default Display Name

French:

Nom d’affichage par défaut

German:

Standard Anzeigename

PHASE_DEPLOYENABLED_LABEL

English:

Deploy Enabled

French:

Déploiement activé

German:

Auslieferung aktiviert

PHASE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

PHASE_EXECUTIONTYPE_LABEL

English:

Execution Type

French:

Type d’exécution

German:

Ausführungstyp

PHASE_LEVELENABLED_LABEL

English:

Level Enabled

French:

Niveau activé

German:

Ebene aktiviert

PHASE_NAME_LABEL

English:

Name

French:

Nom

German:

Name

PHASE_OID_LABEL

English:

OID

French:

OID

German:

OID

PHASE_PHASEVERSION_LABEL

English:

Phase Version

French:

Version de la Phase

German:

Phasenversion

PHASE_RELEASED_LABEL

English:

Released

French:

Publiée

German:

Freigegeben

PHASE_VERSION_LABEL

English:

Version

French:

Version

German:

Version