Siebel Innovation Pack 2017: Types of Tables and Columns That CIAI Query Supports

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 113 lists the types of tables that CIAI query supports.

Table 113. 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 114 lists the types of columns that CIAI query supports.

Table 114. 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 115 lists the physical types of columns that CIAI query supports.

Table 115. 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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.