How the Case Insensitivity Wizard Verifies Eligibility

The Case Insensitivity Wizard verifies that all tables and columns it configures for CIAI meet the following eligibility criteria:

• The table and column exist in the Siebel repository.

• The column is active and belongs to the defined table.

• Siebel CRM supports the table type, column functional type, and column physical type for each CIAI configuration.

• The column already includes one or more indexes. If no index is defined on the column, but the column is otherwise eligible, then the wizard accepts the column but does not create a CIAI column or any CIAI indexes for the column. The Case Insensitivity Wizard sets the Default Insensitivity property to DB Case & Accent. For more information, see Using the Case Insensitivity Wizard on Columns That Do Not Contain an Index.