ActivityAssignees
Table used to capture the assignees/resources associated to the activity.
Columns
Name | Type | ReadOnly | References | Description |
ActivityAssigneeId [KEY] | Long | False |
Activity Assignee Id.This is the surrogate primary key added for BI and Outlook. | |
ActivityFunctionCode | String | False |
null | |
ActivityId [KEY] | Long | False |
System generated non-nullable primary key of the Parent Activity. | |
ActivityNumber [KEY] | String | False | ||
AssigneeId [KEY] | Long | False |
ID of assignee associated with the activity. | |
AssigneeName | String | False |
Assignee Name | |
AssigneePartyNumber | String | False |
Holds Party Number of the contact | |
AtkMessageId | Long | False |
null | |
AttendeeFlag | Bool | False |
Flag to Check If the Contact Attended the Activity | |
ConflictId | Long | False |
null | |
CorpCurrencyCode | String | False |
Holds Corporate Currency Code from profile | |
CreatedBy | String | False |
System attribute to capture the user Id of the activity assignee creator. This is defaulted by the system. | |
CreationDate | Datetime | False |
System attribute to capture the date and time the activity assignee was created. This is defaulted by the system. | |
CurcyConvRateType | String | False |
Holds Currency Conversion Rate Type from profile | |
CurrencyCode | String | False |
Holds currency code of a record | |
DismissFlag | Bool | False |
This Flag indicates if this activity is Dismissed | |
JobName | String | False |
Job Name | |
LastUpdateDate | Datetime | False |
System attribute to capture the date and time the activity assignee was last updated. This is defaulted by the system. | |
LastUpdateLogin | String | False |
System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system. | |
LastUpdatedBy | String | False |
System attribute to capture the Id of the user who last updated the activity assignee. This is defaulted by the system. | |
Phone | String | False |
Holds Phone Number of the contact | |
PrimaryAssigneeFlag | String | False |
null | |
PrimaryEmail | String | False |
Holds Email Id of the contact | |
PrimaryFormattedAddress | String | False |
Holds Primary Address of the resource | |
RecurSeriesId | Long | False |
null | |
ReminderDatetime | Datetime | False |
The date/time to send the appointment reminder. | |
ReminderPeriod | Int | False |
Designates how soon before the appointment to send a reminder. | |
ResourceName | String | False |
null | |
ResponseCode | String | False |
Flag to indicate whether a reminder if needed. | |
SenderJobId | Long | False |
null | |
ShowTimeAsCode | String | False |
Designates how to show your appointment time on the calendar (free, busy, tentative). | |
SortDate | Datetime | False |
null | |
StatusCode | String | False |
null | |
UpgSourceObjectId | Long | False |
null | |
UpgSourceObjectType | String | False |
null | |
UserGuid | String | False |
null | |
UserGuid1 | String | False |
null | |
UserLastUpdateDate | Datetime | False |
Attribute to capture when the record was last updated by a user in disconnect mode. | |
UserName | String | False |
null | |
ActivityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String |
Input specifying the Finder type. |
ContactIDAttr | String |
The contact ID related to the activities. |
AccountIdAttr | String |
Finds the account ID related to the call reports. |
LeadIdAttr | String |
Finds the lead ID related to the call reports. |
OpportunityIdAttr | String |
Finds the opportunity ID related to the call reports. |
ParentActivityIdAttr | String |
The parent activity ID related to the call reports. |
EndDtRFAttr | String |
The appointment end date. |
StartDtRFAttr | String |
The appointment start date. |
DateRange | String |
The date range within which you want search for appointments. |
Bind_CurrentDate | String |
Finds the date used to locate completed activities. |
Bind_RecurSeriesType_BV | String |
The recurring type code of an appointment. |
Bind_TaskActFuncCd_BV | String |
The activities with a function code of task. |
Bind_TaskStatus_BV | String |
The status of the tasks. |
Bind_UserResourceId | String |
Finds the resource ID of the user. |
Bind_Subject | String |
Open activities owned by a specified user. |
Bind_LoggedInUserId_BV | String |
The ID of the user who is logged into the application. |
Bind_TaskStatus_Cancel_BV | String |
The tasks with a cancelled status. |
Bind_TaskPriority_BV | String |
The priority of the task. |
Bind_CurrentUPTZDate | String |
The date used to locate the Tasks whose due date is before the current date. |