SCMLEVEL_LIFECYCLE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

SCMLEVELOID

NUMBER

F

No

LIFECYCLEOID

NUMBER

No

LIFECYCLELEVELSEQUENCENUMBER

NUMBER

Yes

NEXTSCHEDULEDREQUEST

DATE

No

OPTIONAL

NUMBER(1)

No

OPTIONALDEPLOY

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMLEVEL_LIFECYCLE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCMLEVELOID

Identifier for the SCMLEVEL table.

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

See also: SCMLEVEL_LIFECYCLE_FK_2.

Key NULL Column Type (Size)

F

No

SCMLEVELOID

NUMBER

LIFECYCLEOID

Identifier for the LIFECYCLE table.

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

See also: SCMLEVEL_LIFECYCLE_FK_1.

Key NULL Column Type (Size)

F

No

LIFECYCLEOID

NUMBER

LIFECYCLELEVELSEQUENCENUMBER

Number indicating the position of the Level within the sequence of Levels in the Life-Cycle

Key NULL Column Type (Size)

No

LIFECYCLELEVELSEQUENCENUMBER

NUMBER

NEXTSCHEDULEDREQUEST

Date and Time at which the next verification for modifications in the VCR will be done and a Level Request may be created. Only appropriate if the Build Level for the Project Stream is associated with a Schedule.

Key NULL Column Type (Size)

Yes

NEXTSCHEDULEDREQUEST

DATE

OPTIONAL

Indication whether or not the Level is optional. Optional Levels may be skipped in the Life-Cycle.

The default value is 0.

Key NULL Column Type (Size)

No

OPTIONAL

NUMBER(1)
Value List

0 = no

1 = yes

OPTIONALDEPLOY

Indication whether or not to skip Deploys to specific Deploy Environments at the moment a Level Request is created.

Key NULL Column Type (Size)

No

OPTIONALDEPLOY

NUMBER(1)
Value List

0 = no

1 = yes

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

SCMLEVEL_LIFECYCLE_PK

Yes

Yes

OID

SCMLEVEL_LIFECYCLE_FK_1

No

No

LIFECYCLEOID

LIFECYCLE

SCMLEVEL_LIFECYCLE_FK_2

No

No

SCMLEVELOID

SCMLEVEL

Relationships

Referenced Tables

LIFECYCLE

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

Foreign Key Referenced Column(s)

SCMLEVEL_LIFECYCLE_FK_1

OID
SCMLEVEL

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

Foreign Key Referenced Column(s)

SCMLEVEL_LIFECYCLE_FK_2

OID

Referencing Tables

No referencing tables available.

Report Labels

SCMLEVEL_LIFECYCLE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMLEVEL_LIFECYCLE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMLEVEL_LIFECYCLE_LIFECYCLELEVELSEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

SCMLEVEL_LIFECYCLE_LIFECYCLEOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_LIFECYCLE_NEXTSCHEDULEDREQUEST_LABEL

English:

Next Scheduled Request

French:

Prochaine Requête prévue

German:

Nächste geplante Anfrage

SCMLEVEL_LIFECYCLE_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_LIFECYCLE_OPTIONAL_LABEL

English:

Optional

French:

Optionnel

German:

Optional

SCMLEVEL_LIFECYCLE_OPTIONALDEPLOY_LABEL

English:

Optional Deploys

French:

Déploiements optionnels

German:

Optionale Auslieferungen

SCMLEVEL_LIFECYCLE_SCMLEVELOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_LIFECYCLE_VERSION_LABEL

English:

Version

French:

Version

German:

Version