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
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. |