PROJECTSTREAM

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

STATUS

NUMBER

Yes

DESCRIPTION

VARCHAR2(512)

No

ISHEAD

NUMBER(1)

No

ISTAGBASED

NUMBER(1)

No

BUILDPREFIX

VARCHAR2(50)

No

LOCKED

NUMBER(1)

No

BUILDTYPE

NUMBER

No

TAGTEMPLATE

VARCHAR2(255)

Yes

PARTIALBUILDTAG

VARCHAR2(255)

No

HIGHESTBUILDNUMBER

NUMBER

Yes

VCRBRANCHIDENTIFICATION

VARCHAR2(255)

Yes

BUILDSUFFIX

VARCHAR2(50)

No

ACCEPTFORCEDBUILD

NUMBER(1)

F

No

PROJECTOID

NUMBER

F

No

LIFECYCLEOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: PROJECTSTREAM_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

STATUS

The status of the Branch Project Stream.

Key NULL Column Type (Size)

No

STATUS

NUMBER
Value List

0 = under construction

1 = planning

2 = development

3 = testing

4 = stable

5 = general available

6 = frozen

7 = closed

DESCRIPTION

Description for the Branch Project Stream.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(512)

ISHEAD

The type of the Project Stream.

Key NULL Column Type (Size)

No

ISHEAD

NUMBER(1)
Value List

0 = Head

1 = Branch

ISTAGBASED

Indication whether or not the Project Stream is tag-based.

If the Project Stream is tag-based, it is possible to retrieve sources labeled with a user-defined tag in the head or branch stream for a build action on the Build Level.

Warning: This functionality requires strict adherence to the internal tagging conventions, as by manual tagging artifacts are no longer under the exclusive control of IKAN ALM. Tags may be defined before a build, but should remain consistent for the affected artifacts for their full Life-Cycle.

If tag-based builds are activated for the Project Stream, the Tag Template has no effect any more as the VCR Tag will be defined by the User during the Level Request creation process.

Furthermore, when the IKAN ALM Scheduler notices that a Build Level is connected to a tag-based Project Stream, it will take no action since it has no reference to check for changes in the versioning system. Triggered builds (for example, after the creation of a tag in the VCR) can be activated via a hook script in the versioning system (possible for CVS and Subversion only) which will call the IKAN ALM command line to create a Level Request on the Build Level. Therefore, it is recommended to disconnect any Schedule from the Build Level of a tag-based Project Stream. If that is not possible (for example, because the Level is also used in another Project Stream), make sure that Accept Forced Build is set to Yes.

Key NULL Column Type (Size)

No

ISTAGBASED

NUMBER(1)
Value List

0 = no

1 = yes

BUILDPREFIX

The Build Prefix for the Project Stream. The Build Prefix is used, among other things, for generating unique Build archive file names, and is therefore required.

Key NULL Column Type (Size)

No

BUILDPREFIX

VARCHAR2(50)

LOCKED

Indication whether or not the Project Stream is locked. Locking a Project Stream means blocking all activity on that Project Stream.

Key NULL Column Type (Size)

No

LOCKED

NUMBER(1)
Value List

0 = no

1 = yes

BUILDTYPE

The Build type.

The following types are possible:

Full Build

Partial Build: only the sources that were modified since the last Build will be rebuilt.

Production-based Partial Build: only the sources that are different from the version on the Production Level will be rebuilt

Tag-based Partial Build: only the sources that were modified compared to a specific Build

Key NULL Column Type (Size)

No

BUILDTYPE

NUMBER
Value List

0 = Full Build

1 = Partial Build based on Previous Build

2 = Partial Build based on Production Build

3 = Partial Build based on specific Tagged Build

TAGTEMPLATE

The Template that should be used for tagging Builds generated in this Project Stream. The Tags will be used to display these Builds in the VCR.

A template can be a combination of constants and variables.

The following constants are allowed:

  • letters

  • numbers

  • underscores

  • hyphens

  • Some other characters (such as , ; $ @) may be illegal, depending on the VCR type.

The following variables are available. They all have the format ${name}:

  • ${prefix}: This variable returns the Build Prefix defined for the Project Stream.

  • ${suffix}: This variable returns the Build Suffix defined for the Branch Stream. (If this variable is included in a Template for a Head Stream, it is ignored.)

  • ${streamType}: This variable returns the Type indication for a Stream: H for Head Stream or B for Branch Stream.

  • ${buildNumber}: This variable returns the number of the Build, so that the Build can be matched with its Tag.

  • ${projectName}: This variable returns the name of the IKAN ALM Project.

  • ${vcrProjectName}: This variable returns the VCR name of the Project.

  • ${dateTime(dateformat)}: This variable returns the timestamp of the Building action in the indicated format. yyyy-MM-dd is a valid format. For

other valid formats, refer to http://java.sun.com/j2se/1.4.2/docs/api/java/

text/SimpleDateFormat.html

Key NULL Column Type (Size)

No

TAGTEMPLATE

VARCHAR2(255)

PARTIALBUILDTAG

The Partial Build VCR Tag. This tag is used as a reference to determine which sources were modified.

Key NULL Column Type (Size)

Yes

PARTIALBUILDTAG

VARCHAR2(255)

HIGHESTBUILDNUMBER

The highest Build number for this Project Stream.

This number is incremented automatically each time a Level Request is created.

This number does not necessarily match the number of successful Builds.

Key NULL Column Type (Size)

No

HIGHESTBUILDNUMBER

NUMBER

VCRBRANCHIDENTIFICATION

For Branch Streams: the VCR Branch ID. The same ID must be available in the VCR linked to the Project.

For Head Streams belonging to a ClearCase UCM Project: the UCM Integration Stream.

For Head Streams belonging to other Project types: no value.

Key NULL Column Type (Size)

Yes

VCRBRANCHIDENTIFICATION

VARCHAR2(255)

BUILDSUFFIX

For Branch Streams: the Build Suffix.

For Head Streams: no value.

Key NULL Column Type (Size)

Yes

BUILDSUFFIX

VARCHAR2(50)

ACCEPTFORCEDBUILD

Indication whether or not the Project Stream accepts Forced Builds.

Key NULL Column Type (Size)

No

ACCEPTFORCEDBUILD

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 PROJECTSTREAM_FK_2.

See also: PROJECTSTREAM_FK_2.

Key NULL Column Type (Size)

F

No

PROJECTOID

NUMBER

LIFECYCLEOID

Identifier for the LIFECYCLE table.

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

See also: PROJECTSTREAM_FK_1.

Key NULL Column Type (Size)

F

No

LIFECYCLEOID

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

PROJECTSTREAM_PK

Yes

Yes

OID

PROJECTSTREAM_FK_1

No

No

LIFECYCLEOID

LIFECYCLE

PROJECTSTREAM_FK_2

No

No

PROJECTOID

PROJECT

Relationships

Referenced Tables

LIFECYCLE

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

Foreign Key Referenced Column(s)

PROJECTSTREAM_FK_1

OID
PROJECT

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

Foreign Key Referenced Column(s)

PROJECTSTREAM_FK_2

OID

Referencing Tables

DESKTOPASSOCIATION

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

Foreign Key Referencing Column

DESKTOPASSOCIATION_FK_2

PROJECTSTREAMOID
LEVELREQUEST

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

Foreign Key Referencing Column

LEVELREQUEST_FK_1

PROJECTSTREAMOID
PROJECTSTREAMDEPENDENCY

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

Foreign Key Referencing Column

PROJECTSTREAMDEPENDENCY_FK_1

MASTERPROJECTSTREAMOID

PROJECTSTREAMDEPENDENCY_FK_2

CHILDPROJECTSTREAMOID
SCMPACKAGE

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

Foreign Key Referencing Column

SCMPACKAGE_FK_1

PROJECTSTREAMOID

Report Labels

PROJECTSTREAM_ACCEPTFORCEDBUILD_LABEL

English:

Accept Forced Build

French:

Construction forcée autorisée

German:

Erzwungene Bereitstellung erlaubt

PROJECTSTREAM_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PROJECTSTREAM_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PROJECTSTREAM_BUILDPREFIX_LABEL

English:

Build Prefix

French:

Préfixe de construction

German:

Bereitstellungspräfix

PROJECTSTREAM_BUILDSUFFIX_LABEL

English:

Build Suffix

French:

Suffixe de construction

German:

Bereitstellungskennzeichen

PROJECTSTREAM_BUILDTYPE_LABEL

English:

Build Type

French:

Type de construction

German:

Bereitstellungstyp

PROJECTSTREAM_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

PROJECTSTREAM_HIGHESTBUILDNUMBER_LABEL

English:

Highest Build Number

French:

Numéro dernière construction

German:

Letzte Bereitstellungsnummer

PROJECTSTREAM_ISHEAD_LABEL

English:

Project Stream Type

French:

Type de Branche

German:

Hauptverlauf

PROJECTSTREAM_ISTAGBASED_LABEL

English:

Tag-based

French:

Balise existante

German:

Versionsbasiert

PROJECTSTREAM_LIFECYCLEOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAM_LOCKED_LABEL

English:

Locked

French:

Verrouillée

German:

Gesperrt

PROJECTSTREAM_OID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAM_PARTIALBUILDTAG_LABEL

English:

Partial Build VCR Tag

French:

Balise RCV constr. partielle

German:

Version für partielle Bereitstellung

PROJECTSTREAM_PROJECTOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAM_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

PROJECTSTREAM_TAGTEMPLATE_LABEL

English:

Tag Template

French:

Modèle de Balise

German:

Versionskennzeichnung

PROJECTSTREAM_VCRBRANCHIDENTIFICATION_LABEL

English:

VCR Branch ID

French:

Nom de Branche dans le RCV

German:

Zweig-ID im VCR

PROJECTSTREAM_VERSION_LABEL

English:

Version

French:

Version

German:

Version