Organizations
The company, business unit of a large company, or government agency that has an organization record in the Oracle B2C Service knowledge base.
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 Organizations WHERE id = 12 SELECT * FROM Organizations WHERE id > 15 SELECT * FROM Organizations WHERE lookUpName LIKE '%test' SELECT * FROM Organizations WHERE id IN (12,23,123) SELECT * FROM Organizations WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the name column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Organizations (name) VALUES ('Incident records')
UPDATE
Update can be executed. The columns that are not read-only can be Updated.
For example:
UPDATE Organizations SET login = '001o0000005xSbZAAU' WHERE parentlookUpName IS NULL
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM Organizations WHERE id = '9'
Columns
| Name | Type | ReadOnly | Description |
| CreatedTime | Datetime | True |
The date and time when the organization was created. This attribute is read-only. |
| ExternalReference | String | True |
The external reference key of the organization. |
| Id [KEY] | Long | True |
The unique identifier of the organization. |
| IndustryId | Long | False |
Id of industry. The industry with which the organization is associated. |
| IndustrylookUpName | String | False |
LookUpName of industry. The industry with which the organization is associated. |
| Login | String | False |
The user name used for authentication. |
| LookupName | String | True |
The name used to look up the organization. |
| Name | String | False |
The business name of the organization. |
| NameFurigana | String | False |
The Furigana reading aid for the Name field. This field is used in the workspaces of the Agent Console and is only available if the site has at least one Japanese interface. |
| NewPassword | String | False |
The write-only field used to set the authentication password. It is stored in a non-plaintext form in the system. |
| NumberOfEmployees | Int | False |
The number of employees in the organization. |
| ParentId | Long | False |
Id of parent. The parent organization. |
| ParentlookUpName | String | False |
LookUpName of parent. The parent organization. |
| SourceId | Long | True |
Id of source. The creation source IDs. This attribute is read-only. |
| SourcelookUpName | String | True |
LookUpName of source. The creation source IDs. This attribute is read-only. |
| SupersededById | Long | True |
Id of supersededBy. The superseding organization for the organization. This attribute is read-only. |
| SupersededBylookUpName | String | True |
LookUpName of supersededBy. The superseding organization for the organization. This attribute is read-only. |
| UpdatedTime | Datetime | True |
The date and time when the organization was last updated. This attribute is read-only. |
| BannerimportanceFlagId | Long | False |
Id of importanceFlag. The importance of the banner. |
| BannerimportanceFlaglookUpName | String | False |
LookUpName of importanceFlag. The importance of the banner. |
| Bannertext | String | False |
The description of a flag. |
| BannerupdatedByAccountId | Long | True |
Id of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only. |
| BannerupdatedByAccountlookUpName | String | True |
LookUpName of updatedByAccount. The staff account that most recently updated the banner flag and/or text. This attribute is read-only. |
| BannerupdatedTime | Datetime | True |
The date and time when the banner was last updated. This attribute is read-only. |
| CRMModulesmarketing | Bool | False |
Indicates whether the marketing module is applicable. The default value is true only if marketing module is enabled. |
| CRMModulessales | Bool | False |
Indicates whether the sales module is applicable. The default value is true only if sales module is enabled. |
| CRMModulesservice | Bool | False |
Indicates whether the service module is applicable. The default value is true only if service module is enabled. |
| SalesSettingsacquiredDate | Date | True |
The date when the first opportunity associated with the organization was closed. This attribute is read-only. |
| SalesSettingssalesAccountId | Long | False |
Id of salesAccount. The sales representative assigned to the account. |
| SalesSettingssalesAccountlookUpName | String | False |
LookUpName of salesAccount. The sales representative assigned to the account. |
| SalesSettingstotalRevenuecurrencyId | Long | False |
Id of currency. The ID of the currency. |
| SalesSettingstotalRevenuecurrencylookUpName | String | False |
LookUpName of currency. The ID of the currency. |
| SalesSettingstotalRevenueexchangeRateId | Long | False |
Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| SalesSettingstotalRevenueexchangeRatelookUpName | String | False |
LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| SalesSettingstotalRevenuevalue | String | False |
The value of the currency. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| addresses | String |
The list of associated addresses. |
| fileAttachments | String |
The list of file attachments. |
| notes | String |
The list of associated notes. |
| sLAInstances | String |
The Service Level Agreement (SLA) instances associated with the organization. This attribute is read-only for versions 1 and 1.1. |