Views

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData SSIS Components for Oracle Service Cloud Views


Name	Description
AccountGroupsDescriptions	The language-specific string used for localization.
AccountGroupsNames	The language-specific strings used for localization of fields.
AccountsEmails	The email address and its associated information.
AccountsPhones	The details related to the phone number.
AnalyticsReports	The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components.
AnalyticsReportsFilters	The filters used for running an analytics report.
AnalyticsReportsNames	The language-specific strings used for localization of fields.
AnswersCategories	The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswersCommonAttachments	The file attachment shared by sibling answers.
AnswersCommonAttachmentsNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
AnswersFileAttachments	The file attachment shared by answers.
AnswersNotes	The note text associated with the objects such as contacts and organizations.
AnswersProducts	The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswersRelatedAnswers	The knowledge base information that provides solutions to the common customer support questions.
AnswersSiblingAnswers	The knowledge base information that provides solutions to the common customer support questions.
AnswerVersionsCategories	The hierarchical service category that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswerVersionsCommonAttachments	The file attachment shared by sibling answers.
AnswerVersionsCommonAttachmentsNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
AnswerVersionsFileAttachments	The file attachment shared by answers.
AnswerVersionsNotes	The note text associated with the objects such as contacts and organizations.
AnswerVersionsProducts	The hierarchical service product that provides an option to group answers and incidents for better organization and refined searching in the knowledge base.
AnswerVersionsRelatedAnswers	The link to related answers.
AssetsSLAInstances	The instance of a Service Level Agreement (SLA).
AssetStatuses	The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service.
AssetStatusesNames	The language-specific strings used for localization of fields.
Campaigns	The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service.
ChannelTypes	The social channels tracked in contact records when storing social account user names and associating social monitor incidents to contacts.
ChannelTypesNames	The language-specific strings used for localization of fields.
Chats	The real-time, two-way dialog between a customer and one or more chat agents.
Configurations	The information about the configuration settings within Oracle B2C Service.
ContactsChannelUsernames	The user name of the channel.
ContactsEmails	The email address and its associated information.
ContactsFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
ContactsNotes	The note text associated with the objects such as contacts and organizations.
ContactsOpenIDAccounts	The OpenID related information for the contact.
ContactsPhones	The details related to the phone number.
CountriesNames	The language-specific strings used for localization of fields.
CountriesProvinces	The information about the provinces in the Countries/Provinces customizable menu.
CountriesProvincesNames	The language-specific strings used for localization of fields. The label text cannot be empty or null. The labels are assembled in a list associated with a particular text field.
HolidaysAdminVisibleInterfaces	The named ID that can be included in a list.
IncidentsBilledMinutes	The work time applied to incidents through the Time Billed feature.
IncidentsFileAttachments	The file attachment that includes fields specific to incidents.
IncidentsMilestoneInstances	The milestone instances associated with incidents.
IncidentsThreads	The incident discussion thread entry.
Mailboxes	The mailbox used for collecting email inquiries sent by customers, responses to mailings, and bounced messages.
MarketingMailboxes	The mailbox used to send and receive emails and process bounced messages.
MessageBases	The editable text string that allows international language support and customization of headings, labels, buttons, and other text in the administration interface and customer portal. It also applies to email messages and notifications.
NamedIDs	An ID which has an associated name string. These IDs can be set by either value or name.
OpportunitiesFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
OpportunitiesNotes	The note text associated with the objects such as contacts and organizations.
OpportunitiesOtherContacts	The secondary contact associated with the opportunity.
OpportunitiesQuotes	The sales quote associated with an opportunity.
OpportunitiesQuotesFileAttachments	The file that is attached or associated with another object.
OpportunitiesQuotesLineItems	The product line item in a quote.
OpportunityStatuses	The information about the default and custom opportunity statuses and their corresponding types.
OpportunityStatusesNames	The language-specific strings used for localization of fields.
OrganizationsAddresses	The physical address of the organization.
OrganizationsFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
OrganizationsNotes	The note text associated with the objects such as contacts and organizations.
SalesProductsAdminVisibleInterfaces	The named ID that can be included in a list.
SalesProductsDescriptions	The language-specific string used for localization.
SalesProductsNames	The language-specific strings used for localization of fields.
SalesProductsSchedules	The price schedule for a sales product.
SalesTerritoriesAdminVisibleInterfaces	The named ID that can be included in a list.
SalesTerritoriesNames	The language-specific strings used for localization of fields.
ServiceCategoriesAdminVisibleInterfaces	The named ID that can be included in a list.
ServiceCategoriesDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceCategoriesEndUserVisibleInterfaces	The named ID that can be included in a list.
ServiceCategoriesNames	The language-specific strings used for localization of fields.
ServiceCategoriesProductLinks	The product linking for a category or a disposition.
ServiceDispositionsAdminVisibleInterfaces	The named ID that can be included in a list.
serviceDispositionsDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceDispositionsNames	The language-specific strings used for localization of fields.
ServiceDispositionsProductLinks	The product linking for a category or a disposition.
ServiceMailboxes	The email box dedicated to collect email inquiries sent by customers.
ServiceProductsAdminVisibleInterfaces	The named ID that can be included in a list.
ServiceProductsCategoryLinks	The category linking for a product.
ServiceProductsDescriptions	The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.
ServiceProductsDispositionLinks	The disposition linking for a product.
ServiceProductsEndUserVisibleInterfaces	The named ID that can be included in a list.
ServiceProductsNames	The language-specific strings used for localization of fields.
SiteInterfaces	The console, windows, and pages used by staff members and customers to access the application and interact with a single knowledge base.
StandardContentsAdminVisibleInterfaces	The named ID that can be included in a list.
StandardContentsContentValues	The standard content value with a data type and a formatted data value.
TasksFileAttachments	The file attachment that includes additional fields used for attachments to various classes.
TasksNotes	The note text associated with the objects such as contacts and organizations.
VariablesInterfaceValues	The interface-specific value of a variable.