DESKTOPASSOCIATION

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

DESKTOPOID

NUMBER

F

No

SCMLEVELOID

NUMBER

F

No

PROJECTSTREAMOID

NUMBER

F

Yes

SCMPACKAGEOID

NUMBER

No

SEQUENCENUMBER

NUMBER

No

TYPE

NUMBER

Yes

EXPANDED

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: DESKTOPASSOCIATION_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

DESKTOPOID

Internal identifier of the object.

See also: DESKTOPASSOCIATION_FK_3.

Key NULL Column Type (Size)

F

No

DESKTOPOID

NUMBER

SCMLEVELOID

Identifier for the SCMLEVEL table.

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

See also: DESKTOPASSOCIATION_FK_1.

Key NULL Column Type (Size)

F

No

SCMLEVELOID

NUMBER

PROJECTSTREAMOID

Identifier for the PROJECTSTREAM table.

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

See also: DESKTOPASSOCIATION_FK_2.

Key NULL Column Type (Size)

F

No

PROJECTSTREAMOID

NUMBER

SCMPACKAGEOID

Internal identifier of the object.

See also: DESKTOPASSOCIATION_FK_4.

Key NULL Column Type (Size)

F

Yes

SCMPACKAGEOID

NUMBER

SEQUENCENUMBER

Number indicating the position of the element (Project Stream, Level or Package) within the list of elements assigned to the Desktop.

Key NULL Column Type (Size)

No

SEQUENCENUMBER

NUMBER

TYPE

The type of element assigned to the Desktop: Project Stream or Level.

Key NULL Column Type (Size)

No

TYPE

NUMBER
Value List

0 = Project Stream

1 = Level

2 = Package

EXPANDED

Indication whether or not the element assigned to the Desktop is expanded on the User’s Desktop.

Key NULL Column Type (Size)

Yes

EXPANDED

NUMBER(1)

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

DESKTOPASSOCIATION_PK

Yes

Yes

OID

DESKTOPASSOCIATION_FK_1

No

No

SCMLEVELOID

SCMLEVEL

DESKTOPASSOCIATION_FK_2

No

No

PROJECTSTREAMOID

PROJECTSTREAM

DESKTOPASSOCIATION_FK_3

No

No

DESKTOPOID

DESKTOP

DESKTOPASSOCIATION_FK_4

No

No

SCMPACKAGEOID

SCMPACKAGE

Relationships

Referenced Tables

DESKTOP

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

Foreign Key Referenced Column(s)

DESKTOPASSOCIATION_FK_3

OID
PROJECTSTREAM

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

Foreign Key Referenced Column(s)

DESKTOPASSOCIATION_FK_2

OID
SCMLEVEL

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

Foreign Key Referenced Column(s)

DESKTOPASSOCIATION_FK_1

OID
SCMPACKAGE

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

Foreign Key Referenced Column(s)

DESKTOPASSOCIATION_FK_4

OID

Referencing Tables

No referencing tables available.

Report Labels

DESKTOPASSOCIATION_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

DESKTOPASSOCIATION_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

DESKTOPASSOCIATION_DESKTOPOID_LABEL

English:

OID

French:

OID

German:

OID

DESKTOPASSOCIATION_EXPANDED_LABEL

English:

Expanded

French:

Développé

German:

Expandiert

DESKTOPASSOCIATION_OID_LABEL

English:

OID

French:

OID

German:

OID

DESKTOPASSOCIATION_PROJECTSTREAMOID_LABEL

English:

OID

French:

OID

German:

OID

DESKTOPASSOCIATION_SCMLEVELOID_LABEL

English:

OID

French:

OID

German:

OID

DESKTOPASSOCIATION_SCMPACKAGEOID_LABEL

English:

ALM Package OID

French:

OID Paquet ALM

German:

ALM Paket OID

DESKTOPASSOCIATION_SEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

DESKTOPASSOCIATION_TYPE_LABEL

English:

Type

French:

Type

German:

Typ

DESKTOPASSOCIATION_VERSION_LABEL

English:

Version

French:

Version

German:

Version