ENVIRONMENTPHASE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

ENVIRONMENTOID

NUMBER

Yes

DESCRIPTION

VARCHAR2(50)

No

ENVIRONMENTTYPE

NUMBER

F

No

PHASEOID

NUMBER

No

FIRSTPHASE

NUMBER(1)

No

FAILONERROR

NUMBER(1)

Yes

NEXTPHASEONFAILOID

NUMBER

Yes

NEXTPHASEONSUCCESSOID

NUMBER

Yes

NEXTPHASEONWARNINGOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: ENVIRONMENTPHASE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

ENVIRONMENTOID

Internal identifier of the linked Environment.

Key NULL Column Type (Size)

No

ENVIRONMENTOID

NUMBER

DESCRIPTION

The description of the Environment Phase.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(50)

ENVIRONMENTTYPE

Fixed value identifying the type of the linked Environment.

Key NULL Column Type (Size)

No

ENVIRONMENTTYPE

NUMBER
Value List

0 = Build Environment

1 = Deploy Environment

2 = Level

PHASEOID

Internal identifier of the linked Phase.

See also: ENVIRONMENTPHASE_FK_1.

Key NULL Column Type (Size)

F

No

PHASEOID

NUMBER

FIRSTPHASE

Boolean value specifying whether the Environment Phase is the first Phase of the Environment, which means that it will be executed first when the Environment is executed.

Key NULL Column Type (Size)

No

FIRSTPHASE

NUMBER(1)
Value List

0 = no

1 = yes

FAILONERROR

Fixed value specifying whether the status should be set to Fail in case the Phase goes in Error.

Key NULL Column Type (Size)

No

FAILONERROR

NUMBER(1)
Value List

0 = no

1 = yes

NEXTPHASEONFAILOID

The OID of the next Environment Phase to execute if the execution of the current Environment Phase ends with status FAIL.

Key NULL Column Type (Size)

Yes

NEXTPHASEONFAILOID

NUMBER

NEXTPHASEONSUCCESSOID

The OID of the next Environment Phase to execute if the execution of the current Environment Phase ends with status SUCCESS.

Key NULL Column Type (Size)

Yes

NEXTPHASEONSUCCESSOID

NUMBER

NEXTPHASEONWARNINGOID

The OID of the next Environment Phase to execute if the execution of the current Environment Phase ends with status WARNING.

Key NULL Column Type (Size)

Yes

NEXTPHASEONWARNINGOID

NUMBER

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

ENVIRONMENTPHASE_PK

Yes

Yes

OID

ENVIRONMENTPHASE_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)

ENVIRONMENTPHASE_FK_1

OID

Referencing Tables

ENVIRONMENTPHASEPARAMETER

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

Foreign Key Referencing Column

ENVIRONMENTPHASEPARAMETER_FK_1

ENVIRONMENTPHASEOID

Report Labels

ENVIRONMENTPHASE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

ENVIRONMENTPHASE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

ENVIRONMENTPHASE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

ENVIRONMENTPHASE_ENVIRONMENTOID_LABEL

English:

Environment OID

French:

OID Environnement

German:

Umgebungs-OID

ENVIRONMENTPHASE_ENVIRONMENTTYPE_LABEL

English:

Environment Type

French:

Type envir.

German:

Umgebungstyp

ENVIRONMENTPHASE_FAILONERROR_LABEL

English:

Fail on Error

French:

Abandon si erreur

German:

Abbruch bei Fehler

ENVIRONMENTPHASE_FIRSTPHASE_LABEL

English:

First Phase

French:

Première Phase

German:

Erste Phase

ENVIRONMENTPHASE_NEXTPHASEONFAILOID_LABEL

English:

Next Phase on Fail OID

French:

OID Phase suivante si échouée

German:

OID der nächsten Phase bei Fehler

ENVIRONMENTPHASE_NEXTPHASEONSUCCESSOID_LABEL

English:

Next Phase on Success OID

French:

OID Phase suivante si réussie

German:

OID der nächsten Phase bei Erfolg

ENVIRONMENTPHASE_NEXTPHASEONWARNINGOID_LABEL

English:

Next Phase on Warning OID

French:

OID Phase suivante si avertissement

German:

OID der nächsten Phase bei Warnung

ENVIRONMENTPHASE_OID_LABEL

English:

OID

French:

OID

German:

OID

ENVIRONMENTPHASE_PHASEOID_LABEL

English:

Phase OID

French:

OID Phase

German:

ENVIRONMENTPHASE_VERSION_LABEL

English:

Version

French:

Version

German:

Version