SCMPACKAGE

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

PROJECTSTREAMOID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(512)

No

HIGHESTBUILDNUMBER

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMPACKAGE_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

PROJECTSTREAMOID

Internal identifier of the Project Stream.

See also: SCMPACKAGE_FK_1.

Key NULL Column Type (Size)

F

No

PROJECTSTREAMOID

NUMBER

NAME

Name of the Package.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description of the Package.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(512)

HIGHESTBUILDNUMBER

The highest Build Number of the Package. Each Build Level Request for this Package will increment this field by one.

Key NULL Column Type (Size)

No

HIGHESTBUILDNUMBER

NUMBER

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

SCMPACKAGE_PK

Yes

Yes

OID

SCMPACKAGE_FK_1

No

No

PROJECTSTREAMOID

PROJECTSTREAM

Relationships

Referenced Tables

PROJECTSTREAM

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

Foreign Key Referenced Column(s)

SCMPACKAGE_FK_1

OID

Referencing Tables

DESKTOPASSOCIATION

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

Foreign Key Referencing Column

DESKTOPASSOCIATION_FK_4

SCMPACKAGEOID
LEVELREQUEST

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

Foreign Key Referencing Column

LEVELREQUEST_FK_3

SCMPACKAGEOID
PACKAGEBUILDGROUP_PACKAGE

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

Foreign Key Referencing Column

PACKAGEBUILDGROUP_PACKAGE_FK_2

SCMPACKAGEOID
SCMPACKAGEEVENTLOG

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

Foreign Key Referencing Column

SCMPACKAGEEVENTLOG_FK_1

SCMPACKAGEOID
SCMPACKAGE_FILEINFO

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

Foreign Key Referencing Column

SCMPACKAGE_FILEINFO_FK_1

SCMPACKAGEOID

Report Labels

SCMPACKAGE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMPACKAGE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMPACKAGE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SCMPACKAGE_HIGHESTBUILDNUMBER_LABEL

English:

Highest Build Number

French:

Numéro dernière construction

German:

Letzte Bereitstellungsnummer

SCMPACKAGE_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SCMPACKAGE_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMPACKAGE_PROJECTSTREAMOID_LABEL

English:

Project Stream OID

French:

German:

SCMPACKAGE_VERSION_LABEL

English:

Version

French:

Version

German:

Version