Changing list schemas
Use the Change Schema page to add and remove custom fields to a list. On the Manage Lists page, click Actions and select Change Schema to open the Change Schema page.
TIP: You can also add custom fields by importing a file.
About system-defined fields
All system-defined field names end with an underscore character (_)
You may not edit or delete system-defined fields. For more information, see System List Fields and Data Types and Field Names.
About indexing fields
Field indexing is usually necessary only for custom queries, database join operations, or for performance issues. Indexes are automatically created for system fields, such as recipient ID, email address, and customer ID.
Note: Excessive indexing can have negative impact on performance. We recommend that you index and review the results one field at a time. If noticeable improvement is not evident, clear the Index selection. For indexing advice and details, contact Oracle CX Audience Support.
Field name requirements
- Names must start with A-Z or a-z and may not end with an underscore character (_).
- Permitted characters are: A-Z a-z 0-9 , $, # and _ (underscore).
- Field names cannot contain the single letters A, E, G, K, M P, T and U. These are reserved by Oracle CX Audience.
- We recommend that field names contain at least two characters.
- You cannot reuse a field name in the same list.
Understanding Data and List Management
Understanding Filters