Resources
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.
Columns
| Name | Type | References | Description |
| ResourceProfileId [KEY] | Long | Unique identifier for the Resource Profile. | |
| CreatedBy | String | Who column: indicates the user who created the row. | |
| CreationDate | Datetime | Who column: indicates the date and time of the creation of the row. | |
| DeleteFlag | Bool | Indicates if the user can delete the resource. | |
| 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 | |
| JobMeaning | String | Job for this resource if it is employee | |
| LastUpdateDate | Datetime | Who column: indicates the date and time of the last update of the row. | |
| LastUpdateLogin | String | Who column: indicates the session login associated to the user who last updated the row. | |
| LastUpdatedBy | String | Who column: indicates the user who last updated the row. | |
| Manager | String | Name of the manager for this resource | |
| ManagerPartyId | Long | ||
| PartyId | Long | Identifier for the party. Foreign key to the HZ_PARTIES PARTY_ID. | |
| PartyName | String | Name of the Party | |
| PartyNumber [KEY] | String | Unique identification number for this 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 | |
| PrimaryOrganization | String | Primary organizations for this resource | |
| RecordSet | String | ||
| ResourceType | String | Type of Resource ex employee | |
| StartDateActive | Date | Indicates the date at which the resource becomes active | |
| UpdateFlag | Bool | Indicates if the user can update the resource. | |
| 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. |