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.