Activities Table Formats (Activity)
Follow DPS specifications for preparing a file containing activity data.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| Client | varchar | ||
| ContactLastName | varchar | ||
| ContactFirstName | varchar | ||
| Opportunity | varchar | ||
| WBS1 | varchar | ||
| WBS2 | varchar | ||
| WBS3 | varchar | ||
| Employee | varchar | ||
| Type | varchar | ||
| Subject | varchar | ||
| StartDate | datetime | ||
| EndDate | datetime | ||
| Location | varchar | ||
| ReminderDate | datetime | ||
| ReminderTime | varchar | ||
| Priority | varchar | ||
| Notes | text | ||
| ShowTimeAs | varchar | ||
| AllDayEventInd | varchar | ||
| CompletionInd | varchar | ||
| RecurrenceInd | varchar | ||
| PrivateInd | varchar | ||
| TaskStatus | varchar | ||
| TaskCompletionDate | datetime | ||
| CampaignCode | varchar | ||
| RecurrType | varchar | ||
| RecurrDailyFreq | smallint | ||
| RecurrDailyWeekDay | varchar | ||
| RecurrWeeklyFreq | smallint | ||
| RecurWeeklySun | varchar | ||
| RecurrWeeklyMon | varchar | ||
| RecurrWeeklyTue | varchar | ||
| RecurrWeeklyWed | varchar | ||
| RecurrWeeklyThu | varchar | ||
| RecurrWeeklyFri | varchar | ||
| RecurrWeeklySat | varchar | ||
| RecurrMonthlyFreq | smallint | ||
| RecurrMonthlyDay | smallint | ||
| RecurrYearlyMonth | smallint | ||
| RecurrYearlyDay | smallint | ||
| RecurrStartDate | datetime | ||
| RecurrEndType | varchar | ||
| RP | varchar | ||
| EmailAlertSent | datetime |