Untitled :: IKAN ALM Documentation

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
	No	ISSUEID	VARCHAR2(512)
	Yes	DESCRIPTION	VARCHAR2(512)
	Yes	STATUS	VARCHAR2(50)
	Yes	OWNER	VARCHAR2(50)
	Yes	PRIORITY	VARCHAR2(50)
F	No	LEVELREQUESTOID	NUMBER
	Yes	ARCHIVED	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

P

No

OID

NUMBER

No

ISSUEID

VARCHAR2(512)

Yes

DESCRIPTION

VARCHAR2(512)

Yes

STATUS

VARCHAR2(50)

Yes

OWNER

VARCHAR2(50)

Yes

PRIORITY

VARCHAR2(50)

F

No

LEVELREQUESTOID

NUMBER

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

ISSUEID

Internal identifier of the Issue.

Key	NULL	Column	Type (Size)
	No	ISSUEID	VARCHAR2(512)

Key

NULL

Column

Type (Size)

No

ISSUEID

VARCHAR2(512)

DESCRIPTION

The description for the Issue.

This description is not automatically filled in when IKAN ALM searches for Issues in the VCR. This value needs to be manually provided by editing the Issue.

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

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(512)

STATUS

The Status of the Issue. This status is not automatically filled in when IKAN ALM searches for Issues in the VCR. This value needs to be manually provided by editing the Issue.

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

Key

NULL

Column

Type (Size)

Yes

STATUS

VARCHAR2(50)

OWNER

Internal identifier of the owner.

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

Key

NULL

Column

Type (Size)

Yes

OWNER

VARCHAR2(50)

PRIORITY

The Priority of the Issue.

The priority is not automatically filled in when IKAN ALM searches for Issues in the VCR. This value needs to be manually provided by editing the Issue.

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

Key

NULL

Column

Type (Size)

Yes

PRIORITY

VARCHAR2(50)

LEVELREQUESTOID

Identifier for the LEVELREQUEST table.

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

Key	NULL	Column	Type (Size)
F	No	LEVELREQUESTOID	NUMBER

ARCHIVED

For internal use only.

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

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

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
ISSUE_PK	Yes	Yes	OID
ISSUE_FK_1	No	No	LEVELREQUESTOID	LEVELREQUEST

Index

Primary

Unique

Column(s)

Source Table

ISSUE_PK

Yes

OID

ISSUE_FK_1

No

LEVELREQUESTOID

LEVELREQUEST

Relationships

Referenced Tables

LEVELREQUEST

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

Foreign Key	Referenced Column(s)
ISSUE_FK_1	OID

Foreign Key

Referenced Column(s)

ISSUE_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

ISSUE_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

ISSUE_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

ISSUE_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

ISSUE_ISSUEID_LABEL

English:

Issue ID

French:

Incident

German:

Ticketnummer

ISSUE_LEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

ISSUE_OID_LABEL

English:

OID

French:

OID

German:

OID

ISSUE_OWNER_LABEL

English:

Owner

French:

Propriétaire

German:

Besitzer

ISSUE_PRIORITY_LABEL

English:

Priority

French:

Priorité

German:

Priorität

ISSUE_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

ISSUE_VERSION_LABEL

English:

Version

French:

Version

German:

Version