SYSTEMSETTINGS

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

SCM4ALLURL

VARCHAR2(255)

No

MAILHTML

NUMBER

Yes

MAILTEMPLATELOCATION

VARCHAR2(255)

No

MAILTYPE

NUMBER

Yes

SMTPSERVER

VARCHAR2(255)

Yes

SMTPPORT

NUMBER

Yes

SMTPFROM

VARCHAR2(50)

Yes

SMTPANONYMOUS

NUMBER

Yes

SMTPUSER

VARCHAR2(50)

Yes

SMTPPASSWORD

VARCHAR2(255)

Yes

NOTESCLIENTSERVER

VARCHAR2(255)

Yes

NOTESCLIENTUSERIDFILE

VARCHAR2(255)

Yes

NOTESCLIENTPASSWORD

VARCHAR2(255)

Yes

NOTESCLIENTMAILDATABASE

VARCHAR2(255)

Yes

NOTESDIIOPSERVER

VARCHAR2(255)

Yes

NOTESDIIOPPORT

NUMBER

Yes

NOTESDIIOPUSER

VARCHAR2(50)

Yes

NOTESDIIOPPASSWORD

VARCHAR2(255)

Yes

NOTESDIIOPSSL

NUMBER(1)

No

WORKINGCOPYLOCATION

VARCHAR2(255)

Yes

WORKINGCOPYFILECOPYLOCATION

VARCHAR2(255)

No

BUILDARCHIVELOCATION

VARCHAR2(255)

Yes

BUILDARCHIVEFILECOPYLOCATION

VARCHAR2(255)

No

SCRIPTLOCATION

VARCHAR2(255)

Yes

SCRIPTFILECOPYLOCATION

VARCHAR2(255)

No

PHASECATALOGLOCATION

VARCHAR2(255)

Yes

PHASECATALOGREMOTELOCATION

VARCHAR2(255)

Yes

SSHPORT

NUMBER

Yes

FTPPORT

NUMBER

F

Yes

USERGROUPOID

NUMBER

F

Yes

ADMINGROUPOID

NUMBER

F

Yes

MACHINEOID

NUMBER

Yes

SECUREDXMLRPC

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

No

AUTOREFRESHRATE

NUMBER

No

RSSFEEDENABLED

NUMBER(1)

Yes

SCMUUID

VARCHAR2(255)

No

PARAMPREFIX

NUMBER

No

RESTENABLED

NUMBER(1)

Column Descriptions

OID

Unique table identifier.

See also: SYSTEMSETTINGS_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCM4ALLURL

The base IKAN ALM URL. This URL is used for creating hyperlinks in mails sent by IKAN ALM (Approvals, Pre-Notifications, Post-Notifications, Level Request Success/Fail Notifications) and for constructing the RSS feed link.

Key NULL Column Type (Size)

No

SCM4ALLURL

VARCHAR2(255)

MAILHTML

Indication of which templates will be used to compose notification and approval mail messages. There are two options:

HTML: the templates containing HTML tags will be used.

Plain Text: the templates without HTML tags will be used.

Key NULL Column Type (Size)

No

MAILHTML

NUMBER
Value List

0 = Plain text

1 = HTML

MAILTEMPLATELOCATION

Location of the mail templates. By default, the mail templates are located in the following directory: TOMCAT_HOME/webapps/scm4all/WEB-INF/classes/templates

If you want to customize these templates, we advise you to change this location to a local directory on the IKAN ALM Server.

The locale directories match the language settings of the user:

en for English

fr for French

de for German

If no match is found, the templates in the default directory will be used.

For the HMTL formatted templates, a _html suffix is added before the .vm extension.

For plain text templates, there is no such suffix.

Key NULL Column Type (Size)

Yes

MAILTEMPLATELOCATION

VARCHAR2(255)

MAILTYPE

The mail protocol to be used.

Key NULL Column Type (Size)

No

MAILTYPE

NUMBER
Value List

0 = SMTP

1 = Lotus Notes Client

2 = Lotus Notes DIIOP

SMTPSERVER

The Machine name of the SMTP Mail Server.

This field is mandatory if SMTP was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

SMTPSERVER

VARCHAR2(255)

SMTPPORT

The SMTP Port number used by IKAN ALM to connect to the Mail Server.

By default port 25 is used.

Key NULL Column Type (Size)

Yes

SMTPPORT

NUMBER

SMTPFROM

The From: E-Mail Address used in IKAN ALM notification e-mails.

This field is mandatory if SMTP was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

SMTPFROM

VARCHAR2(50)

SMTPANONYMOUS

The Authentication Type.

Anonymous: if the SMTP Server can be used without authentication.

Authentication: if the SMTP Server requires authentication.

Key NULL Column Type (Size)

Yes

SMTPANONYMOUS

NUMBER
Value List

0 = Authentication

1 = Anonymous

SMTPUSER

The User name used to authenticate on the SMTP Server.

This field is mandatory if Authentication was chosen as Authentication Type.

Key NULL Column Type (Size)

Yes

SMTPUSER

VARCHAR2(50)

SMTPPASSWORD

The masked Password used to authenticate on the SMTP Server.

This field is mandatory if Authentication was chosen as Authentication Type.

Key NULL Column Type (Size)

Yes

SMTPPASSWORD

VARCHAR2(255)

NOTESCLIENTSERVER

The Lotus Notes name of the Server containing the Mail Database, e.g.: CN=MachineName/0=SCM/C=BE

This field is mandatory if Lotus Notes Client was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESCLIENTSERVER

VARCHAR2(255)

NOTESCLIENTUSERIDFILE

The complete path of the User’s ID file, e.g.: c:\notes\data\certoid

This field is mandatory if Lotus Notes Client was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESCLIENTUSERIDFILE

VARCHAR2(255)

NOTESCLIENTPASSWORD

The masked User’s Password.

This field is mandatory if Lotus Notes Client was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESCLIENTPASSWORD

VARCHAR2(255)

NOTESCLIENTMAILDATABASE

The name of the User’s Mail Database.

This field is mandatory if Lotus Notes Client was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESCLIENTMAILDATABASE

VARCHAR2(255)

NOTESDIIOPSERVER

The Internet name or the IP Address of the Server.

This field is mandatory if Lotus Notes DIIOP was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESDIIOPSERVER

VARCHAR2(255)

NOTESDIIOPPORT

The Port number of the Server.

If you leave this field empty, the default port number (63148) is used, but you may also specify another Port.

Key NULL Column Type (Size)

Yes

NOTESDIIOPPORT

NUMBER

NOTESDIIOPUSER

The Domino User Name used by IKAN ALM to send e-mail notifications.

This field is mandatory if Lotus Notes DIIOP was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESDIIOPUSER

VARCHAR2(50)

NOTESDIIOPPASSWORD

The masked User’s Internet Password.

This field is mandatory if Lotus Notes DIIOP was chosen as mail Protocol.

Key NULL Column Type (Size)

Yes

NOTESDIIOPPASSWORD

VARCHAR2(255)

NOTESDIIOPSSL

Indication whether or not SSL is required

If required, the actual service requests take place over the DIIOP SSL Port, which is 63149 by default. In this case, it is required to set up the Server and Client with a commonly trusted root certificate from a Certificate Authority.

Key NULL Column Type (Size)

Yes

NOTESDIIOPSSL

NUMBER(1)
Value List

0 = no

1 = yes

WORKINGCOPYLOCATION

The location of the Work Copy displayed as a remote location.

This is the location where the VCR interface places the checked out sources or dependent build results on the IKAN ALM Server, so that they are accessible for a remote IKAN ALM Agent handling a build process.

Key NULL Column Type (Size)

No

WORKINGCOPYLOCATION

VARCHAR2(255)

WORKINGCOPYFILECOPYLOCATION

The path to the Work Copy Location.

In preparation of the Build process, the IKAN ALM Monitor places the sources (checked out sources from a VCR and sometimes also dependent build results) in a subdirectory of this location. The tagging of the VCR after a successful Build is done from this location as well.

Key NULL Column Type (Size)

Yes

WORKINGCOPYFILECOPYLOCATION

VARCHAR2(255)

BUILDARCHIVELOCATION

The location of the Build Archive displayed as remote location.

This is the location where the Builds are stored in or retrieved from by a remote IKAN ALM Agent handling a build or deploy process.

Key NULL Column Type (Size)

No

BUILDARCHIVELOCATION

VARCHAR2(255)

BUILDARCHIVEFILECOPYLOCATION

The path to the location of the Build Archive on the IKAN ALM Server.

Build Results will be stored in or retrieved from this location. They will be placed in a subdirectory per Project Stream and per Project. If required, you can edit the location.

Key NULL Column Type (Size)

Yes

BUILDARCHIVEFILECOPYLOCATION

VARCHAR2(255)

SCRIPTLOCATION

This location used to store build and deploy scripts.

When the build or deploy script is not available in the sources or build result, it will be retrieved from this location.

This option allows Scripts to be stored outside the Version Control Repository and managed on a (secured) central location.

Key NULL Column Type (Size)

No

SCRIPTLOCATION

VARCHAR2(255)

SCRIPTFILECOPYLOCATION

The location used to store build and deploy scripts.

When the build or deploy script is not available in the sources or build result, it will be retrieved from this location. You can edit the location if required.

This field allows that the Scripts are stored outside the Version Control Repository and managed on a (secured) central location.

Key NULL Column Type (Size)

Yes

SCRIPTFILECOPYLOCATION

VARCHAR2(255)

PHASECATALOGLOCATION

The path to the location of the Phase Catalog on the IKAN ALM Server.

Key NULL Column Type (Size)

No

PHASECATALOGLOCATION

VARCHAR2(255)

PHASECATALOGREMOTELOCATION

The location of the Phase Catalog displayed as remote location.

Newly created Phases and Phases that have been imported will be stored in this location. A remote IKAN ALM Agent that needs to install a Phase will use this location to retrieve it.

Key NULL Column Type (Size)

Yes

PHASECATALOGREMOTELOCATION

VARCHAR2(255)

SSHPORT

The SSH Port Number. This is only necessary if the SSH Server on the IKAN ALM Server uses an SSH Port other than the default port number 22. An SSH Server daemon must be installed on the IKAN ALM server in order to use SSH as a Transporter Protocol.

Note: This port number may be overwritten by the port number defined in the Transporter definition.

Key NULL Column Type (Size)

Yes

SSHPORT

NUMBER

FTPPORT

The FTP Port Number. This is only necessary if the FTP Server on the IKAN ALM Server uses a TCP Port other than the default port number 21. An FTP server must be installed on the IKAN ALM Server in order to use FTP as a Transporter protocol.

Note: This port number may be overwritten by the port number defined in the Transporter definition.

Key NULL Column Type (Size)

Yes

FTPPORT

NUMBER

USERGROUPOID

Identifier for the USERGROUP table.

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

See also: SYSTEMSETTINGS_FK_2.

Key NULL Column Type (Size)

F

Yes

USERGROUPOID

NUMBER

ADMINGROUPOID

Identifier for the USERGROUP table.

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

See also: SYSTEMSETTINGS_FK_1.

Key NULL Column Type (Size)

F

Yes

ADMINGROUPOID

NUMBER

MACHINEOID

Identifier for the MACHINE table.

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

See also: SYSTEMSETTINGS_FK_3.

Key NULL Column Type (Size)

F

Yes

MACHINEOID

NUMBER

SECUREDXMLRPC

Indication whether or not all communication (webserver-server, server-agent) is done over SSL.

Key NULL Column Type (Size)

Yes

SECUREDXMLRPC

NUMBER(1)
Value List

NULL = -

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

AUTOREFRESHRATE

The number of seconds for the automatic refresh function on the Desktop Overview, Level Request Overview and Build History Overview.

As a result, these overview screens will be refreshed each time the interval expires (if the user has activated the Auto Refresh function on his Desktop submenu).

If the use of the Auto Refresh option is not allowed, the value is 0 (zero).

Key NULL Column Type (Size)

No

AUTOREFRESHRATE

NUMBER

RSSFEEDENABLED

Indication whether the RSS functionality is enabled.

If enabled, an RSS button will become available on the user’s Level Requests Overview panel.

By default the RSS Feeds are enabled.

Key NULL Column Type (Size)

No

RSSFEEDENABLED

NUMBER(1)
Value List

0 = no

1 = yes

SCMUUID

For internal use only.

Key NULL Column Type (Size)

Yes

SCMUUID

VARCHAR2(255)

PARAMPREFIX

This option determines the value of the IKAN ALM Build/Deploy parameter’s prefix (by default alm) and the name of the ANT property file that is generated for Execute Build and Execute Deploy Phases (by default alm_ant.properties).

In case you are upgrading from a version prior to IKAN ALM 5.0, this feature allows you to keep on working with the old scm4all parameter prefix and the old scm4all_ant.properties file, and to not have to modify your Build and/or Deploy scripts.

Note: This is a compatibility solution. At a certain point in time, you will have to modify your scripts and use the new alm prefix.

Key NULL Column Type (Size)

No

PARAMPREFIX

NUMBER
Value List

0 = scm4all

1 = alm

RESTENABLED

Indicates whether RESTful Web Services are enabled. This feature is only functional for the integration with an SAP Lifecycle.

Key NULL Column Type (Size)

No

RESTENABLED

NUMBER(1)
Value List

0 = no

1 = yes

Indexes

Index Primary Unique Column(s) Source Table

SYSTEMSETTINGS_PK

Yes

Yes

OID

SYSTEMSETTINGS_FK_1

No

No

ADMINGROUPOID

USERGROUP

SYSTEMSETTINGS_FK_2

No

No

USERGROUPOID

USERGROUP

SYSTEMSETTINGS_FK_3

No

No

MACHINEOID

MACHINE

Relationships

Referenced Tables

MACHINE

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

Foreign Key Referenced Column(s)

SYSTEMSETTINGS_FK_3

OID
USERGROUP

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

Foreign Key Referenced Column(s)

SYSTEMSETTINGS_FK_2

OID

SYSTEMSETTINGS_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

SYSTEMSETTINGS_ADMINGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SYSTEMSETTINGS_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SYSTEMSETTINGS_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SYSTEMSETTINGS_AUTOREFRESHRATE_LABEL

English:

Auto Refresh Rate

French:

Intervalle d’actualisation automatique

German:

Automatische Aktualisierungsrate

SYSTEMSETTINGS_BUILDARCHIVEFILECOPYLOCATION_LABEL

English:

Build Archive Location

French:

Emplacement Archives de construction

German:

Standort des Bereitstellungsarchivs

SYSTEMSETTINGS_BUILDARCHIVELOCATION_LABEL

English:

Build Archive Location

French:

Emplacement Archives de construction

German:

Standort des Bereitstellungsarchivs

SYSTEMSETTINGS_FTPPORT_LABEL

English:

FTP Port

French:

Port FTP

German:

FTP Port

SYSTEMSETTINGS_MACHINEOID_LABEL

English:

OID

French:

OID

German:

OID

SYSTEMSETTINGS_MAILHTML_LABEL

English:

Content Type

French:

Type de contenu

German:

Inhaltstyp

SYSTEMSETTINGS_MAILTEMPLATELOCATION_LABEL

English:

Template Location

French:

Emplacement des modèles

German:

Standort der Vorlagen

SYSTEMSETTINGS_MAILTYPE_LABEL

English:

Protocol

French:

Protocole

German:

Protokoll

SYSTEMSETTINGS_NOTESCLIENTMAILDATABASE_LABEL

English:

Mail Database

French:

Base de courrier

German:

Mail-Datenbank

SYSTEMSETTINGS_NOTESCLIENTPASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

SYSTEMSETTINGS_NOTESCLIENTSERVER_LABEL

English:

Server

French:

Serveur

German:

Server

SYSTEMSETTINGS_NOTESCLIENTUSERIDFILE_LABEL

English:

ID File

French:

Fichier des utilisateurs

German:

ID-Datei

SYSTEMSETTINGS_NOTESDIIOPPASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

SYSTEMSETTINGS_NOTESDIIOPPORT_LABEL

English:

Notes DIIOP Port

French:

Port Notes DIIOP

German:

Notes DIIOP Port

SYSTEMSETTINGS_NOTESDIIOPSERVER_LABEL

English:

Server

French:

Serveur

German:

Server

SYSTEMSETTINGS_NOTESDIIOPSSL_LABEL

English:

SSL required

French:

SSL

German:

SSL

SYSTEMSETTINGS_NOTESDIIOPUSER_LABEL

English:

User

French:

Utilisateur

German:

Benutzer

SYSTEMSETTINGS_OID_LABEL

English:

OID

French:

OID

German:

OID

SYSTEMSETTINGS_PARAMPREFIX_LABEL

English:

Parameter Prefix

French:

Préfixe du paramètre

German:

Präfix des Parameters

SYSTEMSETTINGS_PHASECATALOGLOCATION_LABEL

English:

Phase Catalog Location

French:

Emplacement du Catalogue des Phases

German:

Standort für den Phasekatalog

SYSTEMSETTINGS_PHASECATALOGREMOTELOCATION_LABEL

English:

Phase Catalog Remote Location

French:

Emplacement distant du Catalogue des Phases

German:

Entfernter Standort der Phasekatalog

SYSTEMSETTINGS_RESTENABLED_LABEL

English:

Rest Enabled

French:

Rest activé

German:

REST aktiviert

SYSTEMSETTINGS_RSSFEEDENABLED_LABEL

English:

Rss Feed Enabled

French:

Flux RSS activé

German:

RSS Feed aktiviert

SYSTEMSETTINGS_SCM4ALLURL_LABEL

English:

IKAN ALM4ALL URL

French:

URL SCM4ALL

German:

URL SCM4ALL

SYSTEMSETTINGS_SCMUUID_LABEL

English:

ALM UUID

French:

UUID ALM

German:

ALM UUID

SYSTEMSETTINGS_SCRIPTFILECOPYLOCATION_LABEL

English:

Script Location

French:

Emplacement des Scripts

German:

Standort der Skripte

SYSTEMSETTINGS_SCRIPTLOCATION_LABEL

English:

Script Location

French:

Emplacement des Scripts

German:

Standort der Skripte

SYSTEMSETTINGS_SECUREDXMLRPC_LABEL

English:

Secured XML-RPC

French:

XML-RPC sécurisé

German:

Sicheres XML-RPC

SYSTEMSETTINGS_SMTPANONYMOUS_LABEL

English:

Authentication Type

French:

Type d’authentification

German:

Authentifizierungstyp

SYSTEMSETTINGS_SMTPFROM_LABEL

English:

From User

French:

Expéditeur

German:

Notes DIIOP Port

SYSTEMSETTINGS_SMTPPASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

SYSTEMSETTINGS_SMTPPORT_LABEL

English:

SMTP Port

French:

Port SMTP

German:

SMTP Port

SYSTEMSETTINGS_SMTPSERVER_LABEL

English:

Server

French:

Serveur

German:

Server

SYSTEMSETTINGS_SMTPUSER_LABEL

English:

User

French:

Utilisateur

German:

Benutzer

SYSTEMSETTINGS_SSHPORT_LABEL

English:

SSH Port

French:

Port SSH

German:

SSH Port

SYSTEMSETTINGS_USERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

SYSTEMSETTINGS_VERSION_LABEL

English:

Version

French:

Version

German:

Version

SYSTEMSETTINGS_WORKINGCOPYFILECOPYLOCATION_LABEL

English:

Work Copy Location

French:

Emplacement des Copies de travail

German:

Standort der Arbeitskopie

SYSTEMSETTINGS_WORKINGCOPYLOCATION_LABEL

English:

Work Copy Location

French:

Emplacement des Copies de travail

German:

Standort der Arbeitskopie