Untitled :: IKAN ALM Documentation

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
F	No	SCMUSEROID	NUMBER
	No	NAME	VARCHAR2(50)
	Yes	DESCRIPTION	VARCHAR2(50)
	Yes	ARCHIVED	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

P

No

OID

NUMBER

F

No

SCMUSEROID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(50)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER

SCMUSEROID

Internal identifier of the IKAN ALM User.

Key	NULL	Column	Type (Size)
F	No	SCMUSEROID	NUMBER

NAME

Name of a Desktop Tab Page.

Key	NULL	Column	Type (Size)
	No	NAME	VARCHAR2(50)

Key

NULL

Column

Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description of a Desktop Tap Page.

Key	NULL	Column	Type (Size)
	Yes	DESCRIPTION	VARCHAR2(50)

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(50)

ARCHIVED

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVED	NUMBER(1)

Key

NULL

Column

Type (Size)

Yes

ARCHIVED

NUMBER(1)

ARCHIVEDDATETIME

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVEDDATETIME	DATE

Key

NULL

Column

Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key	NULL	Column	Type (Size)
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

No

VERSION

NUMBER

Indexes

Index	Primary	Unique	Column(s)	Source Table
DESKTOP_PK	Yes	Yes	OID
DESKTOP_FK_1	No	No	SCMUSEROID	SCMUSER

Index

Primary

Unique

Column(s)

Source Table

DESKTOP_PK

Yes

OID

DESKTOP_FK_1

No

SCMUSEROID

SCMUSER

Relationships

Referenced Tables

SCMUSER

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

Foreign Key	Referenced Column(s)
DESKTOP_FK_1	OID

Foreign Key

Referenced Column(s)

DESKTOP_FK_1

OID

Referencing Tables

DESKTOPASSOCIATION

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

Foreign Key	Referencing Column
DESKTOPASSOCIATION_FK_3	DESKTOPOID

Foreign Key

Referencing Column

DESKTOPASSOCIATION_FK_3

DESKTOPOID

Report Labels

DESKTOP_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

DESKTOP_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

DESKTOP_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

DESKTOP_NAME_LABEL

English:

Name

French:

Nom

German:

Name

DESKTOP_OID_LABEL

English:

OID

French:

OID

German:

OID

DESKTOP_SCMUSEROID_LABEL

English:

ALM User OID

French:

OID Utilisateur ALM

German:

ALM Benutzer OID

DESKTOP_VERSION_LABEL

English:

Version

French:

Version

German:

Version