JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Campaigns

The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service.

Table-Specific Information

SELECT

The driver will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the driver.

SELECT * FROM Campaigns WHERE id = 12
SELECT * FROM Campaigns WHERE id > 15
SELECT * FROM Campaigns WHERE lookUpName LIKE '%test'
SELECT * FROM Campaigns WHERE id IN (12,23,123)
SELECT * FROM Campaigns WHERE lookUpName IS NOT NULL

Columns

Name Type Description
ActualLeads Int The number of actual leads generated from the campaign.
ActualOpportunities Int The number of actual opportunities generated from the campaign.
AssignedToAccountId Long Id of assignedToAccount. The staff member assigned to the campaign.
AssignedToAccountlookUpName String LookUpName of assignedToAccount. The staff member assigned to the campaign.
CampaignEndTime Datetime The date and time when the campaign ends.
CampaignStartTime Datetime The date and time when the campaign begins.
CreatedByAccountId Long Id of createdByAccount. The ID number of the staff member who created the campaign.
CreatedByAccountlookUpName String LookUpName of createdByAccount. The ID number of the staff member who created the campaign.
CreatedTime Datetime The date and time when the campaign was created. This attribute is read-only.
ExpectedLeads Int The number of expected leads generated from the campaign.
ExpectedOpportunities Int The number of expected opportunities generated from the campaign.
FlowId Long Id of flow. The ID of the flow that the campaign is associated with.
FlowlookUpName String LookUpName of flow. The ID of the flow that the campaign is associated with.
Id [KEY] Long The unique identifier of the campaign.
InterfaceId Long Id of interface. The ID of the interface that the campaign is associated with.
InterfacelookUpName String LookUpName of interface. The ID of the interface that the campaign is associated with.
IsSingleExecute Bool Indicates whether the contacts are allowed to flow through the recurring campaign only one time. This attribute does not have a default value.
LookupName String The name used to look up the campaign.
Name String The name of the campaign.
ObjectivesSummary String The summary of the objectives specified for the campaign.
UpdatedByAccountId Long Id of updatedByAccount. The ID of the staff member who last updated the campaign.
UpdatedByAccountlookUpName String LookUpName of updatedByAccount. The ID of the staff member who last updated the campaign.
UpdatedTime Datetime The date and time when the campaign was last updated. This attribute is read-only.
ActualCostcurrencyId Long Id of currency. The ID of the currency.
ActualCostcurrencylookUpName String LookUpName of currency. The ID of the currency.
ActualCostexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualCostexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualCostvalue String The value of the currency.
ActualSalescurrencyId Long Id of currency. The ID of the currency.
ActualSalescurrencylookUpName String LookUpName of currency. The ID of the currency.
ActualSalesexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualSalesexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ActualSalesvalue String The value of the currency.
BudgetcurrencyId Long Id of currency. The ID of the currency.
BudgetcurrencylookUpName String LookUpName of currency. The ID of the currency.
BudgetexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
BudgetexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
Budgetvalue String The value of the currency.
ExpectedCostcurrencyId Long Id of currency. The ID of the currency.
ExpectedCostcurrencylookUpName String LookUpName of currency. The ID of the currency.
ExpectedCostexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedCostexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedCostvalue String The value of the currency.
ExpectedSalescurrencyId Long Id of currency. The ID of the currency.
ExpectedSalescurrencylookUpName String LookUpName of currency. The ID of the currency.
ExpectedSalesexchangeRateId Long Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedSalesexchangeRatelookUpName String LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies.
ExpectedSalesvalue String The value of the currency.
Folderid Long ID value
FolderlookupName String Name used to lookup this object

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462