Bookshelf Home | Contents | Index | PDF     

Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Applications >

Types of Tables and Columns That CIAI Query Supports

Table 109 lists the types of tables that CIAI query supports.

Table 109. Types of Tables That CIAI Query Supports
Table Type
Supported for a CIAI Query

Data (Intersection)

Yes

Data (Private)

Yes

Data (Public)

Yes

Database View

No

Dictionary

No

Extension

Yes

Extension (Siebel)

Yes

External

No

Interface

No

Log

No

Repository

No

Table 110 lists the types of columns that CIAI query supports.

Table 110. Types of Columns That CIAI Query Supports
Column Type
Supported for a CIAI Query

Data (Private)

Yes

Data (Public)

Yes

Denormalized

Yes

Extension

Yes

External

No

IFMGR: Exists

No

IFMGR: FKey

No

IFMGR: Status

No

IFMGR: ROW_ID

No

System

No

Table 111 lists the physical types of columns that CIAI query supports.

Table 111. Physical Types of Columns That CIAI Query Supports
Physical Type
 
DB Value
Type
Supported for a CIAI Query

C

Char

Yes

D

Date

No

L

Long

Yes

L

CLOB

Yes

N

Number

No

S

Time Stamp

No

T

Date Time

No

U

UTC Date Time

No

V

Varchar

Yes

X

Text

Yes
      
Configuring Siebel Business Applications Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.