The field drop-down list contains fields defined by the OpenEMM for internal use as well as user-defined fields. You can easily identify user-defined fields by the name which you have selected for them. Fields for internal use have the following names (see list):
Field for internal use |
Description |
---|---|
CREATION_DATE |
Date when the recipient was entered into the database. |
CUSTOMER_ID |
The OpenEMM will automatically assign a customer ID to all new recipients. This ID is unique. Each recipient can be identified unmistakably by his or her CUSTOMER_ID. |
DATASOURCE_ID |
ID of the data source from where recipient data were imported. If CSV data is imported, the OpenEMM will automatically assign an ID (see chapter "Import function for recipient data"). |
Recipient’s email address. |
|
FIRSTNAME |
Recipient’s first name. |
GENDER |
Recipient’s sex (gender). The OpenEMM uses numbers to identify a recipient’s sex: 0 means male, 1 means female, and all recipients whose sex is unknown are marked 2. |
LASTNAME |
Recipient’s last name. |
MAILTYPE |
Which mail type the recipient selected. 0 means text, 1 is HTML and 2 means Offline-HTML. |
CHANGE_DATE |
Date of last profile change. |
TITLE |
Recipient’s title (Dr. etc.). |