ODBC Driver for Oracle Sales

Build 25.0.9434

ResourceUsers

The resource users REST resource is used to view, create, update, and delete a resource user. Note that this REST resource should be used only to work with Oracle CX Sales and B2B Service, and not for any other product family.

Columns

Name Type ReadOnly References Description
ResourceProfileId [KEY] Long True

The profile identifier of the resource.

AddressLine1 String False

The first line of the address of resource.

AddressLine2 String False

The second line of the address of resource.

BusinessUnit String False

Name of the business unit of worker record of resource.

City String False

The name of the city for address of resource.

Country String False

The name of the country for address of resource.

County String False

Name of the county of the address of resource.

CreateUserAccountFlag Bool False

Indicates if a user account can be created for the resource.

CreatedBy String True

CreatedBy

CreationDate Datetime True

CreationDate

DeleteFlag Bool True

DeleteFlag

FaxCountryCode String False

The country code of the fax.

FirstName String False

The first name of the resource.

FormattedAddress String True

Primary Formatted address for the resource.

HRManagerEmailAddress String False

Email address of the human resource manager of worker record for resource.

HireDate Date False

Start date of the worker record for resource.

IndividualRoleCode String False

IndividualRoleCode

IndividualRoleEndDate Date False

IndividualRoleEndDate

IndividualRoleStartDate Date False

IndividualRoleStartDate

JobCode String False

Job code assigned to the resource.

JobTitle String True

Title of the job assigned to resource.

LastName String False

The last name of the resource.

LastUpdateDate Datetime True

The date when the record was last updated.

LastUpdatedBy String True

LastUpdatedBy

LegalEntity String False

Name of legal entity of the worker record for resource.

MiddleName String False

The lmiddle name of the resource.

MobilePhoneCountryCode String False

The country code associated with the mobile phone.

PartyName String True

A person's name

PersonNumber String True

Person number identifier of the worker record for resource.

PersonType String False

Person type of the worker record for resource.

PostalCode String False

The postal code for the address of resource.

Province String False

Name of the province for address of resource.

RawFaxNumber String False

The fax number of the resource in raw format.

RawMobilePhoneNumber String False

The mobile phone number of the resource.

RawWorkPhoneNumber String False

The resource's work phone number in raw format.

ResourceEmail String False

The email address of the resource.

ResourceEndDate Date False

The date up to which the resource role is active.

ResourceManagerFirstName String False

The first name of the reporting manager of resource.

ResourceManagerLastName String False

The last name of the reporting manager of resource.

ResourceManagerName String False

The name of the manager for the resource.

ResourceManagerPartyId Long True

The unique internal identifier for the reporting manager of resource.

ResourceManagerPartyNumber String True

The unique public identifier of the reporting manager of resource.

ResourceOrgManagerEmail String False

The email address of the reporting manager of resource.

ResourceOrgMemRoleEndDate Date False

Indicates the date when the resource organization membership of the resource ends

ResourceOrgMemRoleStartDate Date False

ResourceOrgMemRoleStartDate

ResourceOrgRoleCode String False

The code that indicates the role of the resource in association with organization membership.

ResourceOrgRoleName String True

The role that defines the function of the resource in an organization or hierarchy.

ResourceOrganizationName String False

The name of the resource organization associated to the resource.

ResourceOrganizationUsage String True

The usage type of the resource organization.

ResourceParentOrganizationName String False

The name of the parent organization of resource.

ResourcePartyId Long False

The unique party identifier of the person record for resource.

ResourcePartyNumber String False

The party number of the person record for resource.

ResourceStartDate Date False

Date on which the resource becomes active.

ResourceType String False

Describes the resource type.

State String False

The state in the resource's address.

TimezoneCode String False

The code of time zone for the resource.

Title String False

The title for the name of resource.

TopResourceFlag Bool False

TopResourceFlag

UpdateFlag Bool True

Indicates if the user can update the resource.

UserStatus String False

Indicates the the status of the user account for the resource. The supported values are A for active and S for suspended. The status is set to A for new accounts.

Username String False

User login account name of resource user.

WorkPhoneCountryCode String False

The country code associated with the work phone.

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
Finder String

Input specifying the Finder type.

BindPartyId String

The unique primary key identifier of the party associated with the resource.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434