Field name requirements and data types

Field name requirements

  • Must be 30 or fewer characters in length.
  • Field names must include only Permitted characters: A-Z a-z 0-9, and _ (underscore).
  • Name must start with A-Z a-z.

    Warning: All system-defined field names are reserved and end with an underscore character, for example EMAIL_ADDRESS_. Therefore, to avoid duplication, imported custom field names shouldnot end with an underscore. See System-Defined List Fields to review these fields and details.

  • Field names cannot contain the single letters A, E, G, K, M P, T and U. These are reserved by the application.
  • We recommend that field names contain at least two characters.
  • Field names are not case-sensitive, for example: FirstName is the same as firstname.

Reserved Oracle CX Audience field name words

Warning: To avoid conflicts with the database used by Oracle CX Audience, do not use any of the following reserved words as field names in your tables.

access add admin administrator advisor all alter and any as
asc audit baseurl between by byte char check cluster column
comment connect compress create current data date decimal default delete
desc distinct double drop else exclusive exists extends false file
first float for from grant group having ID identified if
immediate import in increment index initial insert int integer intersect
into is last level like lock long M maxextents minextents
minus mlslabel mode modify noaudit nocompress nologging not nowait null
number of offline on online option or order package pctfree
pctused prior private privileges program protected public raw rename resource
revoke row rowid rownum rows select session set share size
smallint start successful synonym sysdate table test then to trigger
true uid union unique update user validate values varchar varchar2
view whenever where with

Note: When you define fields, be sure your field names match the $text$ replacement fields and input field names used in your message documents and forms.

Available Field data types

The following data types are available for all system- and custom-defined fields.

Data Type Details
Text (up to 500 chars) Data type of a field unless you specify otherwise
Text (to 50 chars) Data type for a text field.
Medium Text (up to 255 chars) Data type for a text field.
Long Text (up to 4000 chars) Does not use excessive space – Only stores text that is actually present. This limit applies to single-byte character sets, such as English. The limit is lower for multi-byte character sets, such as those used in Asian languages or UTF-8 characters.
Number Number that may include a decimal
Integer Whole number with no fractional part. Accommodates values from – 2,147,483,648 through 2,147,483,647
Timestamp (date + time) Used by Oracle CX Audience for internal purposes. Format must be yyyy-mm-dd hh:mm:ss

Learn more

Understanding Data and List Management

System-Defined List Fields

Viewing and Editing List Data

Viewing List Load History