JDBC Driver for Oracle Sales

Build 24.0.9060

EmployeeResources

The resources resource is used to view, create, and update a resource. A resource is a person within the deploying company who can be assigned work to accomplish business objectives, such as sales persons or partner members. The EmployeeResources is deprecated, please use Resources view to access resource data.

Columns

Name Type References Description
PartyNumber [KEY] String Unique identification number for this party
EmailAddress String E-mail address
EndDateActive Date Indicates the date at which the resource becomes inactive
FormattedAddress String Primary Formatted address for the resource
FormattedPhoneNumber String Primary Formatted phone number for the resource
PartyId Long Identifier for the party. Foreign key to the HZ_PARTIES PARTY_ID.
PartyName String Name of the Party
PersonFirstName String Peron First Name
PersonLastName String Peron LastName
PersonLastNamePrefix String Resource Peron Last name
PersonMiddleName String Peron Middle Name.
PersonNameSuffix String Peron Name suffix
PersonPreNameAdjunct String Person Preferred Name adjacency
PersonPreviousLastName String perin Previous flag mage
PersonSecondLastName String peron secind last name
ResourceProfileId Long Unique identifier for the Resource Profile. Primary Key.
ResourceType String Type of Resource ex employee
StartDateActive Date Indicates the date at which the resource becomes active
Url String Primary URL for the resource
Usage String Read only party usage for resource party

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.
BindSysdate String The identifier for the resource based on the manager reports flag.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060