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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Finder | String | Input specifying the Finder type. | |
| BindSysdate | String | The identifier for the resource based on the manager reports flag. |