SCMLEVEL

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

No

TYPE

NUMBER

No

LOCKED

NUMBER(1)

No

DEBUG

NUMBER(1)

No

NOTIFICATIONTYPE

NUMBER

No

NOTIFICATIONCRITERIA

NUMBER

F

No

PROJECTOID

NUMBER

F

Yes

SCHEDULEOID

NUMBER

F

Yes

REQUESTERUSERGROUPOID

NUMBER

F

Yes

PRENOTIFICATIONUSERGROUPOID

NUMBER

F

Yes

POSTNOTIFICATIONUSERGROUPOID

NUMBER

Yes

POSTNOTIFICATIONCRITERIA

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMLEVEL_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Level.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Level.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

TYPE

The Level Type.

Key NULL Column Type (Size)

No

TYPE

NUMBER
Value List

0 = Build

1 = Test

2 = Production

LOCKED

Indication whether the Level is currently still Locked.

You need to audit the Project to unlock a Build Level.

Key NULL Column Type (Size)

No

LOCKED

NUMBER(1)
Value List

0 = not locked

1 = locked

DEBUG

Indication whether or not the Debug option is activated for the Level.

If Debug is activated for a Level the Clean-up Work Copy Phase will not be performed, so that the contents of this directory can be verified.

Key NULL Column Type (Size)

No

DEBUG

NUMBER(1)
Value List

0 = no

1 = yes

NOTIFICATIONTYPE

The Notification Type for the Level.

If Mail or Netsend is chosen, notifications will be created at the end of a Level Request on the Level, depending on the Notification Criteria. The notification is sent to the members of the Project User, Project Admin and Level Requester User Groups.

Key NULL Column Type (Size)

No

NOTIFICATIONTYPE

NUMBER
Value List

0 = Netsend

1 = Mail

2 = No notification

NOTIFICATIONCRITERIA

The Notification Criteria for the Level.

The following options are available:

  • Always : A Notification will be sent when a Level Request for this Level has ended with status Fail, Warning or Success.

  • Fail : A notification will be sent when a Level Request for this Level has ended with status Fail.

  • Successful : A notification will be sent when a Level Request for this Level has ended with status Warning or Success.

  • Never : No notification will be sent when a Level Request for this Level has ended.

Key NULL Column Type (Size)

No

NOTIFICATIONCRITERIA

NUMBER
Value List

0 = Always

1 = Fail

2 = Successful

3 = Never

PROJECTOID

Identifier for the PROJECT table.

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

See also: SCMLEVEL_FK_2.

Key NULL Column Type (Size)

F

No

PROJECTOID

NUMBER

SCHEDULEOID

Identifier for the SCHEDULE table.

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

See also: SCMLEVEL_FK_1.

Key NULL Column Type (Size)

F

Yes

SCHEDULEOID

NUMBER

REQUESTERUSERGROUPOID

Identifier for the USERGROUP table.

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

See also: SCMLEVEL_FK_3.

Key NULL Column Type (Size)

F

Yes

REQUESTERUSERGROUPOID

NUMBER

PRENOTIFICATIONUSERGROUPOID

Identifier for the USERGROUP table.

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

See also: SCMLEVEL_FK_4.

Key NULL Column Type (Size)

F

Yes

PRENOTIFICATIONUSERGROUPOID

NUMBER

POSTNOTIFICATIONUSERGROUPOID

Identifier for the USERGROUP table.

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

See also: SCMLEVEL_FK_5.

Key NULL Column Type (Size)

F

Yes

POSTNOTIFICATIONUSERGROUPOID

NUMBER

POSTNOTIFICATIONCRITERIA

The Post-Notification Criteria (for Test or Production Levels).

The following options are available:

  • Always : A Post-notification will be sent if the Level Request ends with status Success, Warning, Fail or in case of a rejected Post-Approval.

  • Fail/Reject : A Post-notification will be sent if the Level Request fails or in case of a rejected Post-Approval.

  • Success : A Post-notification will be sent

Key NULL Column Type (Size)

Yes

POSTNOTIFICATIONCRITERIA

NUMBER
Value List

0 = Always

1 = Fail/Reject

2 = Success

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_PK

Yes

Yes

OID

SCMLEVEL_FK_1

No

No

SCHEDULEOID

SCHEDULE

SCMLEVEL_FK_2

No

No

PROJECTOID

PROJECT

SCMLEVEL_FK_3

No

No

REQUESTERUSERGROUPOID

USERGROUP

SCMLEVEL_FK_4

No

No

PRENOTIFICATIONUSERGROUPOID

USERGROUP

SCMLEVEL_FK_5

No

No

POSTNOTIFICATIONUSERGROUPOID

USERGROUP

Relationships

Referenced Tables

PROJECT

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

Foreign Key Referenced Column(s)

SCMLEVEL_FK_2

OID
SCHEDULE

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

Foreign Key Referenced Column(s)

SCMLEVEL_FK_1

OID
USERGROUP

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

Foreign Key Referenced Column(s)

SCMLEVEL_FK_3

OID

SCMLEVEL_FK_4

OID

SCMLEVEL_FK_5

OID

Referencing Tables

BUILDENVIRONMENT

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

Foreign Key Referencing Column

BUILDENVIRONMENT_FK_1

SCMLEVELOID
DEPLOYENVIRONMENT

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

Foreign Key Referencing Column

DEPLOYENVIRONMENT_FK_1

SCMLEVELOID
DESKTOPASSOCIATION

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

Foreign Key Referencing Column

DESKTOPASSOCIATION_FK_1

SCMLEVELOID
LEVELREQUEST

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

Foreign Key Referencing Column

LEVELREQUEST_FK_2

SCMLEVELOID
SCMLEVEL_LIFECYCLE

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

Foreign Key Referencing Column

SCMLEVEL_LIFECYCLE_FK_2

SCMLEVELOID
SCMLEVEL_POSTAPPRUSERGROUP

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

Foreign Key Referencing Column

SCMLEVEL_POSTAPPRUSERGROU_FK_1

SCMLEVELOID
SCMLEVEL_PREAPPRUSERGROUP

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

Foreign Key Referencing Column

SCMLEVEL_PREAPPRUSERGROUP_FK_1

SCMLEVELOID

Report Labels

SCMLEVEL_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMLEVEL_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMLEVEL_DEBUG_LABEL

English:

Debug Option

French:

Option débogage

German:

Debug

SCMLEVEL_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SCMLEVEL_LOCKED_LABEL

English:

Locked

French:

Verrouillé

German:

Gesperrt

SCMLEVEL_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SCMLEVEL_NOTIFICATIONCRITERIA_LABEL

English:

Notification Criteria

French:

Critères de notification

German:

Benachrichtigungskriterien

SCMLEVEL_NOTIFICATIONTYPE_LABEL

English:

Notification Type

French:

Type de notification

German:

Benachrichtigungstyp

SCMLEVEL_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_POSTNOTIFICATIONCRITERIA_LABEL

English:

Post-Notification Criteria

French:

Critère de post-notification

German:

Nachbenachrichtigungskriterien

SCMLEVEL_POSTNOTIFICATIONUSERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_PRENOTIFICATIONUSERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_PROJECTOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_REQUESTERUSERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_SCHEDULEOID_LABEL

English:

OID

French:

OID

German:

OID

SCMLEVEL_TYPE_LABEL

English:

Type

French:

Type

German:

Typ

SCMLEVEL_VERSION_LABEL

English:

Version

French:

Version

German:

Version