Untitled :: IKAN ALM Documentation

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
	No	NAME	VARCHAR2(50)
	Yes	DESCRIPTION	VARCHAR2(255)
	Yes	USERID	VARCHAR2(50)
	Yes	PASSWORD	VARCHAR2(255)
	No	COMMANDPATH	VARCHAR2(255)
	No	TIMEOUT	NUMBER
	No	COLLECTIONURL	VARCHAR2(255)
	Yes	ARCHIVED	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

Yes

USERID

VARCHAR2(50)

Yes

PASSWORD

VARCHAR2(255)

No

COMMANDPATH

VARCHAR2(255)

No

TIMEOUT

NUMBER

No

COLLECTIONURL

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER

NAME

The name of the TFVC Repository.

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

Key

NULL

Column

Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

The description for the TFVC Repository.

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

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

USERID

The User ID

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

Key

NULL

Column

Type (Size)

Yes

USERID

VARCHAR2(50)

PASSWORD

The password.

Key	NULL	Column	Type (Size)
	Yes	PASSWORD	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

PASSWORD

VARCHAR2(255)

COMMANDPATH

The location of the Team Foundation executable. This may be the tf.cmd from the TEE client, or the tf.exe from the TFVC command line client.

Key	NULL	Column	Type (Size)
	No	COMMANDPATH	VARCHAR2(255)

Key

NULL

Column

Type (Size)

No

COMMANDPATH

VARCHAR2(255)

TIMEOUT

The time-out value in seconds.

If IKAN ALM is not able to establish a connection with the TFVC Repository within the defined period, it will consider the Repository to be inaccessible.

Key	NULL	Column	Type (Size)
	No	TIMEOUT	NUMBER

Key

NULL

Column

Type (Size)

No

TIMEOUT

NUMBER

COLLECTIONURL

The URL to the Team Project Collection.

Key	NULL	Column	Type (Size)
	No	COLLECTIONURL	VARCHAR2(255)

Key

NULL

Column

Type (Size)

No

COLLECTIONURL

VARCHAR2(255)

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
TFVC_PK	Yes	Yes	OID

Index

Primary

Unique

Column(s)

Source Table

TFVC_PK

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

TFVC_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

TFVC_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

TFVC_COLLECTIONURL_LABEL

English:

Collection URL

French:

URL de collection

German:

Collection URL

TFVC_COMMANDPATH_LABEL

English:

Command Path

French:

Chemin de commande

German:

Befehlsverzeichnis

TFVC_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

TFVC_NAME_LABEL

English:

Name

French:

Nom

German:

Name

TFVC_OID_LABEL

English:

OID

French:

OID

German:

OID

TFVC_PASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

TFVC_TIMEOUT_LABEL

English:

Time-Out (s)

French:

Délai d’expiration (s)

German:

Zeitlimit (s)

TFVC_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

TFVC_VERSION_LABEL

English:

Version

French:

Version

German:

Version