Configuring Siebel Business Applications > Reference Materials for Configuring Siebel Business Application >
Types of Tables and Columns That CIAI Query Supports
Table 115 lists the types of tables that CIAI query supports.
Table 115. Types of Tables That CIAI Query Supports
|
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 116 lists the types of columns that CIAI query supports.
Table 116. Types of Columns That CIAI Query Supports
|
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 117 lists the physical types of columns that CIAI query supports.
Table 117. Physical Types of Columns That CIAI Query Supports
|
|
|
|
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 |
|