LIFECYCLE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

No

DESCRIPTION

VARCHAR2(255)

No

ISBASE

NUMBER(1)

F

No

PROJECTOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: LIFECYCLE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Life-Cycle.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Life-Cycle.

Key NULL Column Type (Size)

No

DESCRIPTION

VARCHAR2(255)

ISBASE

Indication whether or not the Life-Cycles is a Base Life-Cycle or a Branch.

Key NULL Column Type (Size)

No

ISBASE

NUMBER(1)
Value List

0 = no

1 = yes

PROJECTOID

Identifier for the PROJECT table.

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

See also: LIFECYCLE_FK_1.

Key NULL Column Type (Size)

F

No

PROJECTOID

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

LIFECYCLE_PK

Yes

Yes

OID

LIFECYCLE_FK_1

No

No

PROJECTOID

PROJECT

Relationships

Referenced Tables

PROJECT

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

Foreign Key Referenced Column(s)

LIFECYCLE_FK_1

OID

Referencing Tables

PROJECTSTREAM

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

Foreign Key Referencing Column

PROJECTSTREAM_FK_1

LIFECYCLEOID
SCMLEVEL_LIFECYCLE

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

Foreign Key Referencing Column

SCMLEVEL_LIFECYCLE_FK_1

LIFECYCLEOID

Report Labels

LIFECYCLE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

LIFECYCLE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

LIFECYCLE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

LIFECYCLE_ISBASE_LABEL

English:

Base

French:

Base

German:

Base

LIFECYCLE_NAME_LABEL

English:

Name

French:

Nom

German:

Name

LIFECYCLE_OID_LABEL

English:

OID

French:

OID

German:

OID

LIFECYCLE_PROJECTOID_LABEL

English:

OID

French:

OID

German:

OID

LIFECYCLE_VERSION_LABEL

English:

Version

French:

Version

German:

Version