Activity
The task and appointment information.
QName: {http://xmlns.oracle.com/apps/crmCommon/activities/activityManagementService/}Activity
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
AccountId |
long |
The party ID of the activity account (e.g. Customer - org/person, or Partner). |
|
AccountName |
string |
The name of the account associated with the activity. |
|
AccountNumber |
string |
Account Number of account associated with the activity. |
|
ActivityAssignee |
The attribute used to capture the assignees and resources associated with the activity. |
|
|
ActivityContact |
The attribute used to capture the contacts associated to the activity. |
|
|
ActivityCreatedBy |
string |
The original activity created by. |
|
ActivityCreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The original activity creation date. |
|
ActivityDescription |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The text field for capturing descriptive information about the activity. |
|
ActivityEndDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The end date and time of an appointment or the completion time of a task. |
|
ActivityFunctionCode |
string |
The task vs. appointment for system use only. |
|
ActivityId |
long |
The unique identifier of the activity.
|
|
ActivityLastUpdateLogin |
string |
The original activity last update login. |
|
ActivityMtgMinutes |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
The activity meeting minutes. |
|
ActivityNumber |
string |
The system-generated activity number that can come from an external system (user key). |
|
ActivityObjectives |
The activity objectives. |
|
|
ActivityStartDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The start date and time of an appointment or a task that defaults to null for an appointment and to creation datetime for a task. |
|
ActivitySubtypeCode |
string |
Displays a list of subtype values that are dependent on the value of the activity. |
|
ActivityTimezone |
string |
The time zone that the activity needs to be created in, which may be different from the default logged in user's time zone preference. |
|
ActivityTypeCode |
string |
The type or category of the activity. |
|
ActivityUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The original activity update date. |
|
ActivityUpdatedBy |
string |
The original activity updated by. |
|
ActivityUserLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The original activity user last update date. |
|
AllDayFlag |
boolean |
Indicates that an appointment is for the entire day. |
|
ArticleVersionId |
string |
Knowledge Article Version |
|
AssessmentId |
long |
The identifier of the assessment to which the activity or the activity template is associated with. |
|
AssetId |
long |
Id of the Asset associated with the activity. |
|
AssetName |
string |
Name of the Asset associated with the activity |
|
AssetNumber |
string |
Asset Number. |
|
AssetSerialNumber |
string |
Asset Serial Number. |
|
AutoLogSource |
string |
The source system activities that are auto-generated and used later in sync back logic to avoid double appearances of the same activity. |
|
BpId |
long |
The related business plan. |
|
BusinessPlanName |
string |
The business plan name associated with the activity. |
|
BusinessPlanNumber |
string |
Business Plan Number of the business plan associated with the activity. |
|
CallReportToActivity |
The call report to the activity. |
|
|
CallReportUpcomingYN |
string |
Indicates Y,N, or M for upcoming appointments. |
|
CallReportYN |
string |
Indicates to check if the activity has a call report. |
|
CampaignId |
long |
The unique identifier for the campaign. |
|
CampaignName |
string |
The name of the campaign associated with the activity. |
|
CampaignNumber |
string |
Campaign Number of the campaign associated with the activity. |
|
CaseId |
long |
Case Id |
|
CaseNumber |
string |
Case Number |
|
CaseTitle |
string |
Case Title |
|
CheckedInBy |
string |
Specifies the name of the person who checks-in to a location. |
|
CheckedOutBy |
string |
Specifies the name of the person who checks-out to a location. |
|
CheckinDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Stores the date and time when a user checks in to an Appointment. |
|
CheckinLatitude |
decimal |
Stores the latitude of a location where a user checks in to an Appointment. |
|
CheckinLongitude |
decimal |
Stores the longitude of a location where a user checks in to an Appointment. |
|
CheckoutDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Stores the date and time when a user checks out of an Appointment. |
|
CheckoutLatitude |
decimal |
Stores the latitude of a location where a user checks out of an Appointment. |
|
CheckoutLongitude |
decimal |
Stores the longitude of a location where a user checks out of an Appointment. |
|
ClaimId |
long |
The related claim. |
|
ClaimName |
string |
The claim name associated with the activity. |
|
ClaimNumber |
string |
Claim Number of the claim associated with the activity. |
|
ContactNumber |
string |
Contact Number of primary contact associated with the activity. |
|
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. |
|
CreatedBy |
string |
The user who created the record. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
|
CurcyConvRateType |
string |
The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework. |
|
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
|
CustomFKAttribute |
string |
The custom foreign key attribute. |
|
CustomerAccountId |
long |
The ID of the customer account that the activity relates to. |
|
DealId |
long |
The related deal. |
|
DealNumber |
string |
The deal number associated with the activity. |
|
DelegatorId |
long |
The activity resource that delegated activity ownership to another resource. |
|
DelegatorName |
string |
The name of activity resource that delegated activity ownership to another resource. |
|
DeleteFlag |
boolean |
Indicates whether the record can be deleted or not. |
|
DirectionCode |
string |
The inbound/outbound direction code which is optional and defaults to null. |
|
DismissAssignee |
string |
Flag to dismiss Assignee.Valid values are Y and N. |
|
DismissFlag |
boolean |
This Flag indicates if this activity is Dismissed |
|
DoNotCallFlag |
boolean |
Flag to indicate if primary Contact can be called. |
|
DueDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date the task activity is due to be completed. |
|
Duration |
decimal |
The duration of an appointment or task. |
|
EmailSentDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
This field is used to capture the Activity Email Notification shared date for Outlook integration |
|
ExternalContactEmail |
string |
Indicates the Email address of an external contact. |
|
ExternalContactName |
string |
Indicates the name of an external contact. |
|
ExternallyOwnedFlag |
boolean |
Indicates that the activity is not created by an internal resource. |
|
FundRequestId |
long |
The related fund request. |
|
FundRequestName |
string |
The fund request name associated with the activity. |
|
FundRequestNumber |
string |
Fund Request Number of the fund request associated with the activity. |
|
IbAssetId |
long |
Id of the Installed Base Asset associated with the activity. |
|
IbAssetNumber |
string |
Number of the Installed Base Asset associated with the activity. |
|
IbAssetSerialNumber |
string |
Serial Number of the Installed Base Asset associated with the activity. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
|
LastUpdateLogin |
string |
The login of the user who last updated the record. |
|
LastUpdatedBy |
string |
The user who last updated the record. |
|
LeadId |
long |
The related lead ID. |
|
LeadName |
string |
The lead name. |
|
LeadNumber |
string |
Lead Number of lead associated with the activity. |
|
Location |
string |
The appointment location. |
|
LocationId |
long |
Location or Address ID of the activity account or primary contact. |
|
MobileActivityCode |
string |
The unique identifier of an external mobile device. |
|
Note |
The attribute used to capture note records for an activity. |
|
|
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
|
ObjectiveId |
long |
The related objective. |
|
OpportunityId |
long |
The related opportunity. |
|
OpportunityName |
string |
The name of the opportunity associated with the activity. |
|
OpportunityNumber |
string |
Opportunity Number of the opportunity Associated with the activity. |
|
OtherPartyPhoneNumber |
string |
The phone number for inbound phone calls as they apply to the ANI or number being called from. For outbound calls, this applies to the phone number being called. |
|
OutcomeCode |
string |
The outcome of the activity. |
|
OutlookAutoSyncFlag |
boolean |
Indicates whether an appointment was automatically generated by the synchronization process from Microsoft 365 |
|
OutlookFlag |
boolean |
Indicates if activity was created from Outlook and synced. A "Y" indicates yes. |
|
OutlookGlobalId |
string |
The unique identifier of an appointment created from Microsoft 365 |
|
OutlookIdentifier |
string |
The unique identifier from Outlook activity. |
|
OwnerAddress |
string |
Activity Owner's Address. |
|
OwnerEmailAddress |
string |
Activity Owner's Email Address. |
|
OwnerId |
long |
The primary resource on the activity which supports resources only. |
|
OwnerName |
string |
The name of the primary resource of activity. |
|
OwnerPhoneNumber |
string |
Activity Owner's Phone Number. |
|
ParentActivity |
The parent activity. |
|
|
ParentActivityId |
long |
The related activity ID; only applicable if the record is a follow up activity. |
|
PartnerEnrollmentId |
long |
The related partner enrollment. |
|
PartnerPartyId |
long |
Party identifier of the partner organization. |
|
PartnerPartyName |
string |
Party name of the partner organization. |
|
PartnerPartyNumber |
string |
Partner Party Number of partner associated with the activity. |
|
PartnerProgramId |
long |
The related partner program. |
|
PartnerProgramName |
string |
The name of the partner program associated with the activity. |
|
PartnerProgramNumber |
string |
Partner Program Number of partner program associated with the activity. |
|
PartnerUsageFlag |
boolean |
The flag to indicate that the activity has been created for an organization account with usage as partner. |
|
PercentageComplete |
decimal |
Indicates a numeric value 0-100 to reflect the percent complete status of the activity. Free form numeric and % value at end. |
|
PrimaryContactEmailAddress |
string |
The holder for the email ID of the primary contact. |
|
PrimaryContactId |
long |
The primary contact of the activity. |
|
PrimaryContactName |
string |
The name of the primary contact. |
|
PrimaryFormattedAddress |
string |
Holds Address of the primary contact |
|
PrimaryFormattedPhoneNumber |
string |
The holder for the phone number of the primary contact. |
|
PriorityCode |
string |
The priority of the activity which defaults to 2 and has possible values of 1, 2, and 3. |
|
PrivateFlag |
boolean |
Indicates if the activity is private. |
|
RecurDay |
long |
Indicates a repeat on a specified day of the month (for monthly appointments). |
|
RecurEndDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the activity ends on a specified date. |
|
RecurEveryOptionFlag |
boolean |
Indicates if the recurrence occurs for every day, month, or year. For example, a daily recurring appointment can occur every day of the week or weekdays only. If it is everyday of the week, it is set to Y. If it is weekdays only, it is set to N. |
|
RecurExceptionFlag |
boolean |
Indicates if the appointment instance has been updated outside of a recurring appointment series. |
|
RecurFrequency |
decimal |
The frequency that the recurring appointment series repeats. |
|
RecurFriFlag |
boolean |
Indicates an appointment repeat on Friday. |
|
RecurMonFlag |
boolean |
Indicates an appointment repeat on Monday. |
|
RecurMonth |
string |
Indicates an appointment repeat on specified month (for yearly appointments). |
|
RecurNumberOfInstances |
decimal |
The specific number of occurrences for the series to end after. |
|
RecurOrigInstDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The original date of a recurring appointment instance. |
|
RecurPattern |
string |
The week for an appointment to recur (for monthly and yearly appointments). Possible values: First, Second, Third, Fourth, Last. |
|
RecurRecType |
string |
The type to be used for internal use only. Either "I" for instance or "S" for series or "N" for non-recurring. Do not populate it if Activity is of type Task. |
|
RecurSatFlag |
boolean |
Indicates an appointment repeat on Saturday. |
|
RecurSeriesId |
long |
The series ID that links instances of a series together. |
|
RecurSunFlag |
boolean |
Indicates an appointment repeat on Sunday. |
|
RecurThuFlag |
boolean |
Indicates an appointment repeat on Thursday. |
|
RecurTueFlag |
boolean |
Indicates an appointment repeat on Tuesday. |
|
RecurTypeCode |
string |
Indicates how often an appointment is repeated. Possible values include Daily, Weekly, Monthly, and Yearly. |
|
RecurWedFlag |
boolean |
Indicates an appointment repeat on Wednesday. |
|
RecurWeekday |
string |
The recurrence that works in conjunction with the RecurPattern attribute. Possible values include Monday to Sunday, Weekday, Weekend, and Day. |
|
ReferenceCustomerActTypeCode |
string |
The activity type for a reference customer activity to be used as an extension only. |
|
ReferenceCustomerId |
long |
The ID of the reference customer (party) associated with the activity. |
|
ReminderPeriod |
string |
The reminder period. |
|
ResourceNumber |
string |
Resource Number of owner associated with the activity. |
|
ResponseCode |
string |
The response code. |
|
SalesObjectiveName |
string |
The sales objective name associated with the activity. |
|
SalesObjectiveNumber |
string |
Sales Objective Number of the sales objective associated with the activity. |
|
ShowTimeAs |
string |
The show time. |
|
SortDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
This is an internal column which is used to sort the activity based on the due date for task and start date for activity. |
|
SourceObjectCode |
string |
The object code to which the activity will be related to. |
|
SourceObjectId |
long |
The identifier of the object to which activity will be related to. |
|
SrId |
long |
The service request ID. |
|
SrNumber |
string |
The service request number. |
|
StatusCode |
string |
The pre-defined code used to indicate the status. |
|
Subject |
string |
The subject/name/title of the activity. |
|
SubmittedBy |
long |
The call report submitter. |
|
SubmittedByName |
string |
The call report submitter. |
|
SubmittedDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The call report submission date. |
|
SwitchCallId |
string |
The unique identifier of the call on the external phone system. |
|
TaskReminderPeriod |
string |
Task Reminder Period |
|
TemplateDuration |
decimal |
The duration (in days) of the template activity. This attribute is used with the start date when generating an activity from a template in order to calculate the due date. |
|
TemplateLeadTime |
decimal |
The lead time (in days) of the template activity. This attribute is used with the date input parameter when generating an activity from a template in order to calculate the activity start date. Activity start date = date provided as input parameter + lead time. |
|
UpdateFlag |
boolean |
The flag that controls if the user has access to update the record. |
|
UserLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the row was last updated. |
|
WebConferenceDetails |
{http://xmlns.oracle.com/adf/svc/types/}base64Binary-DataHandler |
Web conference details |
|
WebConferenceId |
string |
Web conference unique id |
|
WebConferenceURL |
string |
Web conference join URL |