FILECOPY

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

No

WORKCOPYPATHPREFIX

VARCHAR2(512)

No

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

No

SCRIPTPATHPREFIX

VARCHAR2(512)

No

PHASECATALOGPATHPREFIX

VARCHAR2(512)

No

LOCAL

NUMBER(1)

Column Descriptions

OID

Unique table identifier.

See also: FILECOPY_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the FileCopy Transporter.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the FileCopy Transporter.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

ARCHIVED

For internal use only.

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

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

WORKCOPYPATHPREFIX

The prefix for the Work Copy Location (the location where the VCR interface places the checked out sources on the IKAN ALM Server so that it is accessible from a remote IKAN ALM Agent handling a build process). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Example:

For a Windows Transporter: //IKAN110/scm4all

In this sample "IKAN110" is the name of the IKAN ALM server, "scm4all" is the share name on that IKAN ALM server.

If in the System Settings the Relative Work Copy location is defined as "workCopy", the IKAN ALM Agent will try to retrieve the sources from a directory under \\IKAN110/scm4all/workCopy.

For a Linux/Unix Transporter: /mnt/ikan110/scm4all

This location is a mount of a directory on the IKAN ALM server (on the ikan110 machine) containing the Work Copy location.

If in the System Settings the Relative Work Copy location is defined as "workCopy", the IKAN ALM Agent will try to retrieve the sources from a directory under /mnt/ikan110/scm4all/workCopy.

Key NULL Column Type (Size)

No

WORKCOPYPATHPREFIX

VARCHAR2(512)

BUILDARCHIVEPATHPREFIX

The prefix for the Build Archive Location (the location where the Builds are stored or retrieved from by an IKAN ALM Agent handling a Build or Deploy process). The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Key NULL Column Type (Size)

No

BUILDARCHIVEPATHPREFIX

VARCHAR2(512)

SCRIPTPATHPREFIX

The prefix for the Script Location (the location where the IKAN ALM Agent will retrieve the build or deploy script from, if it cannot be found in the sources).

The Server Location will be formed by concatenating this prefix together with the Relative Location defined in the System Settings.

Key NULL Column Type (Size)

No

SCRIPTPATHPREFIX

VARCHAR2(512)

PHASECATALOGPATHPREFIX

The prefix for the Phase Catalog location (the location where newly created Phases and Phases that have been imported will be stored). A remote IKAN ALM Agent that needs to install a Phase will use this location to retrieve it.

Key NULL Column Type (Size)

No

PHASECATALOGPATHPREFIX

VARCHAR2(512)

LOCAL

Indication whether or not the FileCopy object is the local FileCopy of the ALM Server.

Key NULL Column Type (Size)

No

LOCAL

NUMBER(1)
Value List

0 = no

1 = yes

Indexes

Index Primary Unique Column(s) Source Table

FILECOPY_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

FILECOPY_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

FILECOPY_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

FILECOPY_BUILDARCHIVEPATHPREFIX_LABEL

English:

Build Archive Path Prefix

French:

Préf. Empl. Archives Constr.

German:

Präfix des Bereitstellungsarchivverzeichnisses

FILECOPY_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

FILECOPY_LOCAL_LABEL

English:

Local FileCopy

French:

Local FileCopy

German:

Local FileCopy

FILECOPY_NAME_LABEL

English:

Name

French:

Nom

German:

Name

FILECOPY_OID_LABEL

English:

OID

French:

OID

German:

OID

FILECOPY_PHASECATALOGPATHPREFIX_LABEL

English:

Phase Catalog Path Prefix

French:

Préfixe Chemin du Catalogue des Phases

German:

Präfix für den Phasekatalog

FILECOPY_SCRIPTPATHPREFIX_LABEL

English:

Script Path Prefix

French:

Préf. Empl. Scripts

German:

Präfix des Skriptverzeichnisses

FILECOPY_VERSION_LABEL

English:

Version

French:

Version

German:

Version

FILECOPY_WORKCOPYPATHPREFIX_LABEL

English:

Work Copy Path Prefix

French:

Préf. Empl. Copies de travail

German:

Präfix des Arbeitskopieverzeichnisses