Tables
The connector models the data in Oracle Service Cloud as a list of tables in a relational database that can be queried using standard SQL statements.
CData Python Connector for Oracle Service Cloud Tables
Name | Description |
AccountGroups | The language-specific strings used for localization of fields. |
Accounts | The account represents a staff member in Oracle B2C Service. |
Answers | The knowledge base information that provides solutions to the common customer support questions. |
AnswerVersions | The versioned instance of an answer. Answers are solutions to common customer support questions. |
Assets | The product or service associated with an organization's customers. |
ContactMarketingRosters | The information about the contact lists used in audiences in Oracle Service Cloud Outreach Cloud Service. |
Contacts | The customers or end users of Oracle B2C Service site. |
Countries | The details about the countries and provinces which are used to maintain accurate address information for the organizations and contacts in Oracle B2C Service. |
EventSubscriptions | The event-based subscription management object that allows external applications to discover objects that can be subscribed. |
Holidays | The list of holidays in your organization. |
Incidents | The question or the request for help submitted by a customer through the Ask a Question page, email, a chat session, site or answer feedback, or from an external source using the API. |
Opportunities | The information about a specific sale or a pending deal with a contact or an organization that is tracked and maintained in the Oracle B2C Service knowledge base. |
Organizations | The company, business unit of a large company, or government agency that has an organization record in the Oracle B2C Service knowledge base. |
PurchasedProducts | The information about a purchased product. |
SalesProducts | The items or services sold by an organization. |
SalesTerritories | The specific geographical sales region. Sales representatives can be assigned specific territories for opportunity assignment. |
ServiceCategories | The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
ServiceDispositions | The hierarchical service disposition that provides an option for classifying and recording how incidents are ultimately resolved. |
ServiceProducts | The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base. |
StandardContents | The preformed text or HTML content that can be sent to customers when responding to incidents, appended to responses by a business rule, or sent by an agent during a chat session. |
Tasks | The information about an action or an activity scheduled to be completed within a specified time. |
Variables | A shortcut defined for a larger string that can be inserted in the body of an answer or inserted inline during a chat session. |