SEARCHFILTER

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

No

SEARCHPAGE

NUMBER

F

Yes

SCMUSEROID

NUMBER

Yes

CRITERIA

VARCHAR2(4000)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SEARCHFILTER_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Search Filter.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Search Filter.

Key NULL Column Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

SEARCHPAGE

The name of the page where the Search Filter is used.

Key NULL Column Type (Size)

No

SEARCHPAGE

NUMBER

SCMUSEROID

Internal identifier of the IKAN ALM User.

See also: SEARCHFILTER_FK_1.

Key NULL Column Type (Size)

F

Yes

SCMUSEROID

NUMBER

CRITERIA

List of search criterea in XML format.

Key NULL Column Type (Size)

Yes

CRITERIA

VARCHAR2(4000)

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

Indexes

Index Primary Unique Column(s) Source Table

SEARCHFILTER_PK

Yes

Yes

OID

SEARCHFILTER_FK_1

No

No

SCMUSEROID

SCMUSER

Relationships

Referenced Tables

SCMUSER

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

Foreign Key Referenced Column(s)

SEARCHFILTER_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

SEARCHFILTER_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SEARCHFILTER_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit

SEARCHFILTER_CRITERIA_LABEL

English:

Search Criteria

French:

Critères de recherche

German:

Suchkriterien

SEARCHFILTER_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Description

SEARCHFILTER_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SEARCHFILTER_OID_LABEL

English:

OID

French:

OID

German:

OID

SEARCHFILTER_SCMUSEROID_LABEL

English:

OID

French:

OID

German:

OID

SEARCHFILTER_SEARCHPAGE_LABEL

English:

Search Page Name

French:

Nom de la Page

German:

Name der Suchseite

SEARCHFILTER_VERSION_LABEL

English:

Version

French:

Version

German:

Version