Tableau Connector for Oracle Sales Cloud

Build 20.0.7695

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 Long False

System generated non-nullable primary key of the Parent Activity.

ActivityNumber String False

AssigneeId 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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695