PROJECTSTREAMDEPENDENCY

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

MASTERPROJECTSTREAMOID

NUMBER

F

No

CHILDPROJECTSTREAMOID

NUMBER

F

Yes

CHILDLEVELREQUESTOID

NUMBER

No

SEQUENCENUMBER

NUMBER

No

RETRIEVECODETYPE

NUMBER

No

TRIGGERBUILDMASTER

NUMBER(1)

No

TRIGGERDEPLOYMASTER

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: PROJECTSTREAMDEPENDENCY_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

MASTERPROJECTSTREAMOID

Identifier for the PROJECTSTREAM table.

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

See also: PROJECTSTREAMDEPENDENCY_FK_1.

Key NULL Column Type (Size)

F

No

MASTERPROJECTSTREAMOID

NUMBER

CHILDPROJECTSTREAMOID

Identifier for the PROJECTSTREAM table.

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

See also: PROJECTSTREAMDEPENDENCY_FK_2.

Key NULL Column Type (Size)

F

No

CHILDPROJECTSTREAMOID

NUMBER

CHILDLEVELREQUESTOID

Identifier for the LEVELREQUEST table.

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

See also: PROJECTSTREAMDEPENDENCY_FK_3.

Key NULL Column Type (Size)

F

Yes

CHILDLEVELREQUESTOID

NUMBER

SEQUENCENUMBER

Number indicating the position of the Project Stream dependency within the sequence of Dependencies associated with the Project Stream.

Key NULL Column Type (Size)

No

SEQUENCENUMBER

NUMBER

RETRIEVECODETYPE

The code retrieval type.

The following options are available:

  • Latest tagged code from the VCR

The source code of the last successful Build of the Child Branch will be used to build the code of the Master Project.

  • Specific tagged code from the VCR

The source code of the Child Branch tagged with a specific VCR tag will be used to build the code of the Master Project.

  • Latest tagged build from the Build Archive

The Build result of the last successful Build of the Child Branch will be used to build the code of the Master Project.

  • Specific build from the build archive

The Build result of the Build of the Child Branch with the selected VCR Tag will be used to build the code of the Master Project.

  • Latest Production code from the VCR

The source code that was tagged with the VCR tag of the Build that is currently Active on the last Level (usually a Production Level) of the Life-cycle of the Child Project Stream will be used to build the code of the Master Project.

  • Latest Production Build from the Build Archive

The Build result of the Build that is currently Active on the LAST Level of the Life-cycle of the Child Project Stream will be used to build the code of the Master Project.

Key NULL Column Type (Size)

No

RETRIEVECODETYPE

NUMBER
Value List

1 = Latest tagged code from the VCR

2 = Specific tagged code from the VCR

3 = Latest tagged code from the Build Archive

4 = Specific Build from the Build Archive

5 = Latest Production Code from the VCR

6 = Latest Production Build from the Build Archive

TRIGGERBUILDMASTER

Indication whether or not a new Build of the Child should trigger a rebuild of the Master.

Key NULL Column Type (Size)

No

TRIGGERBUILDMASTER

NUMBER(1)
Value List

0 = no

1 = yes

TRIGGERDEPLOYMASTER

Indication whether or not the related Master should be triggered to the same level if the Child gets delivered or rolled back to certain level.

Key NULL Column Type (Size)

No

TRIGGERDEPLOYMASTER

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

PROJECTSTREAMDEPENDENCY_PK

Yes

Yes

OID

PROJECTSTREAMDEPENDENCY_FK_1

No

No

MASTERPROJECTSTREAMOID

PROJECTSTREAM

PROJECTSTREAMDEPENDENCY_FK_2

No

No

CHILDPROJECTSTREAMOID

PROJECTSTREAM

PROJECTSTREAMDEPENDENCY_FK_3

No

No

CHILDLEVELREQUESTOID

LEVELREQUEST

Relationships

Referenced Tables

LEVELREQUEST

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

Foreign Key Referenced Column(s)

PROJECTSTREAMDEPENDENCY_FK_3

OID
PROJECTSTREAM

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

Foreign Key Referenced Column(s)

PROJECTSTREAMDEPENDENCY_FK_1

OID

PROJECTSTREAMDEPENDENCY_FK_2

OID

Referencing Tables

No referencing tables available.

Report Labels

PROJECTSTREAMDEPENDENCY_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PROJECTSTREAMDEPENDENCY_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PROJECTSTREAMDEPENDENCY_CHILDLEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAMDEPENDENCY_CHILDPROJECTSTREAMOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAMDEPENDENCY_MASTERPROJECTSTREAMOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAMDEPENDENCY_OID_LABEL

English:

OID

French:

OID

German:

OID

PROJECTSTREAMDEPENDENCY_RETRIEVECODETYPE_LABEL

English:

Code Retrieval

French:

Récup. des données issues de

German:

Code abrufen

PROJECTSTREAMDEPENDENCY_SEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

PROJECTSTREAMDEPENDENCY_TRIGGERBUILDMASTER_LABEL

English:

Trigger Build Master

French:

Déclench. constr. Br. Maître

German:

Kompilierung des Masters starten

PROJECTSTREAMDEPENDENCY_TRIGGERDEPLOYMASTER_LABEL

English:

Trigger Deploy Master

French:

Déclench. déploiemt Br. Maître

German:

Auslieferung Master starten

PROJECTSTREAMDEPENDENCY_VERSION_LABEL

English:

Version

French:

Version

German:

Version