ISSUETRACKINGSYSTEMPROPERTY

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

PROPERTYVALUE

VARCHAR2(512)

Yes

SECURED

NUMBER(1)

F

No

ISSUETRACKINGSYSTEMOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: ISSUETRACKINGSYSTEMPROPERTY_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

The name of the Issue Tracking System Property. This name is predefined by IKAN ALM in function of the type of Issue Tracking System.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

PROPERTYVALUE

The value of the Issue Tracking System Property.

Key NULL Column Type (Size)

Yes

PROPERTYVALUE

VARCHAR2(512)

SECURED

This option is managed by IKAN ALM.

Indication whether or not the Issue Tracking System Property is secured and thus its value encrypted.

Key NULL Column Type (Size)

Yes

SECURED

NUMBER(1)
Value List

0 = no

1 = yes

ISSUETRACKINGSYSTEMOID

Internal identifier of the Issue Tracking System.

See also: ISSUETRACKINGSYSTEMPROPER_FK_1.

Key NULL Column Type (Size)

F

No

ISSUETRACKINGSYSTEMOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)

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

ISSUETRACKINGSYSTEMPROPERTY_PK

Yes

Yes

OID

ISSUETRACKINGSYSTEMPROPER_FK_1

No

No

ISSUETRACKINGSYSTEMOID

ISSUETRACKINGSYSTEM

Relationships

Referenced Tables

ISSUETRACKINGSYSTEM

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

Foreign Key Referenced Column(s)

ISSUETRACKINGSYSTEMPROPER_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

ISSUETRACKINGSYSTEMPROPERTY_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

ISSUETRACKINGSYSTEMPROPERTY_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

ISSUETRACKINGSYSTEMPROPERTY_ISSUETRACKINGSYSTEMOID_LABEL

English:

Issue Tracking System OID

French:

Numéro du Système de Suivi des Incidents

German:

Ticketsystem OID

ISSUETRACKINGSYSTEMPROPERTY_NAME_LABEL

English:

Name

French:

Nom

German:

Name

ISSUETRACKINGSYSTEMPROPERTY_OID_LABEL

English:

OID

French:

OID

German:

OID

ISSUETRACKINGSYSTEMPROPERTY_PROPERTYVALUE_LABEL

English:

Property Value

French:

Valeur de la propriété

German:

Property Value

ISSUETRACKINGSYSTEMPROPERTY_SECURED_LABEL

English:

Secured

French:

Sécurisé

German:

Sicher

ISSUETRACKINGSYSTEMPROPERTY_VERSION_LABEL

English:

Version

French:

Version

German:

Version