SCMUSER

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

USERID

VARCHAR2(20)

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

No

EMAILADDRESS

VARCHAR2(255)

Yes

LOCATION

VARCHAR2(50)

Yes

TELNUMBER

VARCHAR2(50)

Yes

MOBILENUMBER

VARCHAR2(50)

No

LOCALE

VARCHAR2(20)

No

RESERVED

NUMBER(1)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMUSER_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

USERID

The User ID.

Key NULL Column Type (Size)

No

USERID

VARCHAR2(20)

NAME

Name associated with the User ID.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description associated with the User ID.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

EMAILADDRESS

The E-mail Address associated with the User ID.

Key NULL Column Type (Size)

No

EMAILADDRESS

VARCHAR2(255)

LOCATION

The Location associated with the User ID.

Key NULL Column Type (Size)

Yes

LOCATION

VARCHAR2(50)

TELNUMBER

The Phone Number associated with the User ID.

Key NULL Column Type (Size)

Yes

TELNUMBER

VARCHAR2(50)

MOBILENUMBER

The Mobile Number associated with the User ID.

Key NULL Column Type (Size)

Yes

MOBILENUMBER

VARCHAR2(50)

LOCALE

The Language setting associated with the User ID.

Key NULL Column Type (Size)

No

LOCALE

VARCHAR2(20)
Value List

fr = French

en = English

de = German

RESERVED

Indication whether or not the User ID is a Reserved User ID. A Reserved non archived User ID may always log on to IKAN ALM, without occupying a Floating license. It is typically assigned to IKAN ALM Users with Global Administration Access Rights.

Key NULL Column Type (Size)

No

RESERVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVED

Indication whether or not the User ID has been archived.

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

SCMUSER_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

DESKTOP

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

Foreign Key Referencing Column

DESKTOP_FK_1

SCMUSEROID
LEVELAPPROVAL

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

Foreign Key Referencing Column

LEVELAPPROVAL_FK_2

APPROVEDBYUSEROID
SCMUSER_USERGROUP

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

Foreign Key Referencing Column

SCMUSER_USERGROUP_FK_2

SCMUSEROID
SEARCHFILTER

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

Foreign Key Referencing Column

SEARCHFILTER_FK_1

SCMUSEROID

Report Labels

SCMUSER_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMUSER_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMUSER_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SCMUSER_EMAILADDRESS_LABEL

English:

E-mail Address

French:

Adresse de Courrier

German:

E-Mail-Adresse

SCMUSER_LOCALE_LABEL

English:

Language

French:

Langue

German:

Sprache

SCMUSER_LOCATION_LABEL

English:

Location

French:

Emplacement

German:

Standort

SCMUSER_MOBILENUMBER_LABEL

English:

Mobile Number

French:

Mobile

German:

Handy

SCMUSER_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SCMUSER_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMUSER_RESERVED_LABEL

English:

Reserved

French:

Réservé

German:

Reserviert

SCMUSER_TELNUMBER_LABEL

English:

Phone Number

French:

Téléphone

German:

Telefon

SCMUSER_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

SCMUSER_VERSION_LABEL

English:

Version

French:

Version

German:

Version