Recipients - Managing customer data > Searching for recipients > Searching for fields > Field drop-down list

Field drop-down list

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").

EMAIL

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.).