Accounts
The account represents a staff member in Oracle B2C Service.
Table-Specific Information
SELECT
The connector 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 connector.
SELECT * FROM Accounts WHERE id = 12 SELECT * FROM Accounts WHERE id > 15 SELECT * FROM Accounts WHERE lookUpName LIKE '%test' SELECT * FROM Accounts WHERE id IN (12, 23, 123) SELECT * FROM Accounts WHERE lookUpName IS NOT NULL
INSERT
Insert can be executed by specifying the login, namefirst, namelast, profileId, staffGroupId and newpassword columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Accounts (login, namefirst, namelast, profileId, staffGroupId, newpassword) VALUES ('testadministrator', 'abc', 'xyz', '14', '102243', 'testpw')
UPDATE
Update can be executed by specifying the id in WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Accounts SET namelast = 'abcd' WHERE id = 1
DELETE
Delete can be executed by specifying id in the WHERE Clause.
For example:
DELETE FROM Accounts WHERE id = '4'
Columns
Name | Type | ReadOnly | Description |
CountryId | Long | False |
Id of country. The default country identifier. |
CountrylookUpName | String | False |
LookUpName of country. The default country identifier. |
CreatedTime | Datetime | True |
The date and time when the account was created. This attribute is read-only. |
DisplayName | String | False |
The display name of the account. |
DisplayOrder | Int | False |
The order in which this staff account is displayed relative to other members of the same group. |
EmailNotificationId | Long | False |
Id of emailNotification. The format the staff member prefers for email notifications. |
EmailNotificationlookUpName | String | False |
LookUpName of emailNotification. The format the staff member prefers for email notifications. |
Id [KEY] | Long | True |
The unique identifier of the account. |
Login | String | False |
The user name used for authentication. |
LookupName | String | True |
The name used to look up the account. |
ManagerId | Long | False |
Id of manager. The manager of the staff member. |
ManagerlookUpName | String | False |
LookUpName of manager. The manager of the staff member. |
NewPassword | String | False |
The new password for authentication. It is stored with a one-way encryption in the system. This attribute is write-only. |
NotificationPending | Bool | True |
Indicates whether any notifications are pending. This attribute does not have a default value and is read-only. |
PasswordExpirationTime | Datetime | True |
The date and time when the password is set to expire. This attribute is read-only. |
ProfileId | Long | False |
Id of profile. The profile to which the staff account is assigned. |
ProfilelookUpName | String | False |
LookUpName of profile. The profile to which the staff account is assigned. |
Signature | String | False |
The email signature of the account. |
StaffGroupId | Long | False |
Id of staffGroup. The group to which the staff member is assigned. |
StaffGrouplookUpName | String | False |
LookUpName of staffGroup. The group to which the staff member is assigned. |
UpdatedTime | Datetime | True |
The date and time when the account was last updated. This attribute is read-only. |
AttributesaccountLocked | Bool | False |
Indicates whether the account is temporarily locked. For example, you may lock a staff member's account who has taken a leave of absence. An account automatically gets locked if the staff member has exceeded the number of invalid login attempts or if the password has expired. The default value is false. |
AttributescanModifyEmailSignature | Bool | False |
Indicates whether the staff member can modify the email signature. The default value is false. |
AttributesforcePasswordChange | Bool | False |
Indicates whether the staff member must change the password at the next login. The value remains true until the staff member changes the password. The default value is false. |
AttributesinfrequentUser | Bool | False |
Indicates whether the staff member is considered as an infrequent user seat, as opposed to a full seat. The default value is false. |
AttributespasswordNeverExpires | Bool | False |
Indicates whether the staff member's account password never expires. This setting overrides system-wide password expiration configurations. The default value is false. |
AttributespermanentlyDisabled | Bool | False |
Indicates whether the staff member's account is permanently disabled. For example, an account is permanently disabled when a staff member leaves your organization. A disabled account appears in the tree of the Staff Accounts management console if Show Disabled setting is enabled, but you cannot deselect the Permanently Disable check box if you edit the account. You can reuse the login name of a permanently disabled account for a different account. The default value is false. |
AttributesstaffAssignmentDisabled | Bool | False |
Indicates whether the staff member's account cannot be assigned to incidents, answers, opportunities, and tasks. The default value is false. |
AttributesviewsReportsDisabled | Bool | False |
Indicates whether the staff member's account cannot be included in the list for filters in reports. The default value is false. |
AttributesvirtualAccount | Bool | True |
Indicates whether the staff member's account is virtual. The default value is false. This attribute is read-only. |
Namefirst | String | False |
The first name of the person. |
Namelast | String | False |
The surname or last name of the person. |
NameFuriganafirst | String | False |
The first name of the person. |
NameFuriganalast | String | False |
The surname or last name of the person. |
SalesSettingsdefaultCurrencyId | Long | False |
Id of defaultCurrency. The default currency ID. |
SalesSettingsdefaultCurrencylookUpName | String | False |
LookUpName of defaultCurrency. The default currency ID. |
SalesSettingsterritoryId | Long | False |
Id of territory. The sales territory ID. |
SalesSettingsterritorylookUpName | String | False |
LookUpName of territory. The sales territory ID. |
ServiceSettingsscreenPopPort | Int | False |
The port number assigned for screen-pop alerts for the staff account. It is used in Citrix and Terminal Services environments where there are multiple agents logged in to different sessions on the same machine. |
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 |
emails | String |
The list of email addresses. |
phones | String |
The list of phone numbers. |