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	ARCHIVESUFFIX	VARCHAR2(20)
	No	LOGDATEFORMAT	VARCHAR2(50)
	No	LOGDATELOCALE	VARCHAR2(20)
	No	PROJECTDATABASE	VARCHAR2(255)
	Yes	WORKSPACE	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

ARCHIVESUFFIX

VARCHAR2(20)

No

LOGDATEFORMAT

VARCHAR2(50)

No

LOGDATELOCALE

VARCHAR2(20)

No

PROJECTDATABASE

VARCHAR2(255)

Yes

WORKSPACE

VARCHAR2(255)

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

NAME

Name of the PVCS Repository.

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

Key

NULL

Column

Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the PVCS Repository.

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

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

USERID

The User ID that IKAN ALM will use to access the PVCS Repository.

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

Key

NULL

Column

Type (Size)

Yes

USERID

VARCHAR2(50)

PASSWORD

The Password that IKAN ALM will use to access the PVCS Repository.

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

Key

NULL

Column

Type (Size)

Yes

PASSWORD

VARCHAR2(255)

COMMANDPATH

The path to the PCLI executable.

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 PVCS 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

ARCHIVESUFFIX

The suffix for PVCS archive files.

The default value is "-arc"

Key	NULL	Column	Type (Size)
	No	ARCHIVESUFFIX	VARCHAR2(20)

Key

NULL

Column

Type (Size)

No

ARCHIVESUFFIX

VARCHAR2(20)

LOGDATEFORMAT

The Date format of modification dates output by the "pcli vlog" command, e.g. for the default format (MMM dd yyyy HH:mm:ss): Oct 11 2006 11:53:04

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

Key

NULL

Column

Type (Size)

No

LOGDATEFORMAT

VARCHAR2(50)

LOGDATELOCALE

The locale of the date format of modification dates output by the "pcli vlog" command, e.g. for the default format (MMM dd yyyy HH:mm:ss) :

Locale = "en" : Oct 11 2006 11:53:04

Locale = "nl" : Okt 11 2006 11:53:04

The default value is “en”.

Key	NULL	Column	Type (Size)
	No	LOGDATELOCALE	VARCHAR2(20)

Key

NULL

Column

Type (Size)

No

LOGDATELOCALE

VARCHAR2(20)

PROJECTDATABASE

The location of the Project Database.

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

Key

NULL

Column

Type (Size)

No

PROJECTDATABASE

VARCHAR2(255)

WORKSPACE

The Workspace path to use. If none is specified, IKAN ALM will use the Root Workspace ("/RootWorkspace").

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

Key

NULL

Column

Type (Size)

Yes

WORKSPACE

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)

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

Index

Primary

Unique

Column(s)

Source Table

PVCS_PK

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

PVCS_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PVCS_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PVCS_ARCHIVESUFFIX_LABEL

English:

Archive Suffix

French:

Suffixe des Archives

German:

Archivierungssuffix

PVCS_COMMANDPATH_LABEL

English:

Command Path

French:

Chemin de commande

German:

Befehlsverzeichnis

PVCS_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

PVCS_LOGDATEFORMAT_LABEL

English:

Log Date Format

French:

Format de date du Journal

German:

Datumssyntax für die Protokolldatei

PVCS_LOGDATELOCALE_LABEL

English:

Log Date Locale

French:

Code langage Date du Journal

German:

Datumslokalisierung für die Protokolldatei

PVCS_NAME_LABEL

English:

Name

French:

Nom

German:

Name

PVCS_OID_LABEL

English:

OID

French:

OID

German:

OID

PVCS_PASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

PVCS_PROJECTDATABASE_LABEL

English:

Project Database

French:

Base de données du Projet

German:

Projektdatenbank

PVCS_TIMEOUT_LABEL

English:

Time-Out (s)

French:

Délai d’expiration (s)

German:

Zeitlimit (s)

PVCS_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

PVCS_VERSION_LABEL

English:

Version

French:

Version

German:

Version

PVCS_WORKSPACE_LABEL

English:

Workspace

French:

Espace de travail

German:

Arbeitsbereich