Creating table fields
Use this page to enter the field names and set the corresponding types for your new table.
Note: To modify the schema of the data source later, click next to its name on the Manage Lists page, and select Change Schema.
Field name requirements and recommendations
- System Generated fields (EMAIL_ADDRESS_, CUSTOMER_ID_, RIID_,MOBILE_NUMBER_) cannot be added manually into a Profile Extension Table.
- Field names cannot contain the single letters A, E, G, K, M P, T and U. These letters are reserved by the application.
- Field names must start with a letter.
- The Filter Designer does not support profile extension table fields of the Maximum Text Field (to 4000 chars*) data type.
- We recommend that field names contain at least two characters.
- System field names end with an underscore. To avoid duplication of system fields, we recommend that custom table field names do not end with a trailing underscore.
- It's best practice to use the Text, Number or Integer field specific to the field content. Example: numerical field names should use Number or Integer as opposed to text fields to improve query performance.