For details about configuring activity data sets, see Overview of the Activity Data Set
Activity Data Set
| Table Column | Description |
|---|---|
| SYS_ID |
System ID for the contact to update with the activity in the row. This column only applies when mapping by data source system ID. |
| LISTING_ID |
InterAction Contact ID of the contact to update with the activity in this row. This column only applies when mapping by InterAction Contact ID (ListingID). The contact ID is called Listing ID in previous versions and in the InterAction database. |
| LISTING_SRC_ID |
InterAction Contact Source ID of the contact to update with the activity in this row. This column only applies when mapping by InterAction Contact ID (ListingID). The Contact Source ID identifies the database on which the contact was created. Combined with the Contact ID, it uniquely identifies the contact. The contact Source ID is called Listing Source ID in previous versions and in the InterAction database. |
| ACT_TYPE |
The type for the activity. This value must be a number that matches the activity type ID for an existing InterAction activity type. This column only applies if you select to use activity types from the data source. If you are assigning all the activities the same activity type, leave this column blank when harvesting. |
| ACT_DATE | The date for the activity. |
| ACCOUNT_NM | The InterAction account name for the originator of the activity. |
| SUMMARY | The summary text for the activity. |
| NOTES | The notes text for the activity. |
| EXPIRE_DATE | The expiration date for the activity. |
| NEVER_EXPIRE | If the value is 0 or NULL, the activity uses the expiration date set in Administrator or the EXPIRE_DATE column. If the value is set to 1, the expiration date is overwritten and the activity never expires. |
| [MAPPING_FIELD] |
This column displays if you choose to map contacts using an additional field value. The value in this column is used to find the contacts to update with the activity harvested in the previous columns. The column is renamed to a valid SQL column name - for example, Client Code becomes CLIENT_CODE. |