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.

TDV Adapter for Oracle Sales

ActivityAssignees

Columns

Pseudo-Columns