PHASEPARAMETER

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

PHASEOID

NUMBER

No

NAME

VARCHAR2(255)

Yes

DESCRIPTION

VARCHAR2(512)

No

REQUIRED

NUMBER(1)

No

SECURED

NUMBER(1)

Yes

DEFAULTVALUE

VARCHAR2(255)

No

INTEGRATIONTYPE

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: PHASEPARAMETER_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

PHASEOID

Internal identifier of the Phase Parameter.

See also: PHASEPARAMETER_FK_1.

Key NULL Column Type (Size)

F

No

PHASEOID

NUMBER

NAME

Name of the Phase Parameter.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(255)

DESCRIPTION

Description of the Phase Parameter.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(512)

REQUIRED

Indicates whether the Parameter will always be created when adding the Phase to an Environment.

Key NULL Column Type (Size)

No

REQUIRED

NUMBER(1)
Value List

0 = no

1 = yes

SECURED

Indicates whether the Parameter is secured or not.

Key NULL Column Type (Size)

No

SECURED

NUMBER(1)
Value List

0 = no

1 = yes

DEFAULTVALUE

The default value the Parameter will get when the Phase is added to an Environment in case no value has been explicitly set.

Key NULL Column Type (Size)

Yes

DEFAULTVALUE

VARCHAR2(255)

INTEGRATIONTYPE

This field indicates whether the value of the Parameter is a simple text value or whether it represents a link (an integration) to an IKAN ALM object type.

Key NULL Column Type (Size)

No

INTEGRATIONTYPE

NUMBER
Value List

0 = None (Value is simple text)

1 = Transporter

2 = Version Control Repository

3 = Issue Tracking System

4 = Scripting Tool

5 = Ant Scripting Tool

6 = NAnt Scripting Tool

7 = Maven2 Scripting Tool

8 = Gradle Scripting Tool

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

PHASEPARAMETER_PK

Yes

Yes

OID

PHASEPARAMETER_FK_1

No

No

PHASEOID

PHASE

Relationships

Referenced Tables

PHASE

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

Foreign Key Referenced Column(s)

PHASEPARAMETER_FK_1

OID

Referencing Tables

ENVIRONMENTPHASEPARAMETER

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

Foreign Key Referencing Column

ENVIRONMENTPHASEPARAMETER_FK_2

PHASEPARAMETEROID

Report Labels

PHASEPARAMETER_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PHASEPARAMETER_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PHASEPARAMETER_DEFAULTVALUE_LABEL

English:

Default Value

French:

Valeur par défaut

German:

Standard Wert

PHASEPARAMETER_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

PHASEPARAMETER_INTEGRATIONTYPE_LABEL

English:

Integration Type

French:

Type d’intégration

German:

Integrationstyp

PHASEPARAMETER_NAME_LABEL

English:

Name

French:

Nom

German:

Name

PHASEPARAMETER_OID_LABEL

English:

OID

French:

OID

German:

OID

PHASEPARAMETER_PHASEOID_LABEL

English:

Phase OID

French:

OID Phase

German:

Phasen-OID

PHASEPARAMETER_REQUIRED_LABEL

English:

Required

French:

Requis

German:

Notwendig

PHASEPARAMETER_SECURED_LABEL

English:

Secured

French:

Sécurisé

German:

Sicher

PHASEPARAMETER_VERSION_LABEL

English:

Version

French:

Version

German:

Version