ProjectResourceRequests
The Project Resource Requests resource is used to view, create, and manage project resource requests.
Columns
| Name | Type | Description |
| ResourceRequestId [KEY] | Long | Identifier of the project resource request. |
| RequestName | String | Name of the project resource request. |
| RequestStatusCode | String | Code of the resource request status. The valid values are OPEN or DRAFT when creating the request. The default value is DRAFT. You can only update the request status from DRAFT to OPEN. |
| RequestStatus | String | Status of the project resource request. |
| RequestedStartDate | Date | Date from which a resource is requested. If no value is provided, the value is set to the current date for projects with start date in the past, and to the project start date for projects with start date in the future. |
| RequestedFinishDate | Date | Date until which a resource is requested. If no value is provided, the value is set to the project end date. You must provide a value if the project does not have an end date. |
| RequestFulfilledDate | Date | Date on which the project resource request is fulfilled. |
| RequestedHoursperDay | Double | Period of time measured in hours that establishes the number of requested hours per working day on a project resource request. You must provide a value if you have set the Use Project Calendar Indicator attribute value to N. |
| UseProjectCalendarFlag | Bool | Flag that indicates if the hours for the assignment is provided in Requested Hours per Day attribute or should be derived from the project calendar. The valid values are Y and N. If the value is Y, the request hours is derived from the project calendar. |
| Location | String | Resource assignment location specificed on the resource request. |
| RequestedResourceId | Long | Identifier of the resource who is selected to fulfill the project resource request, if the Requested Quantity is equal to 1. You may enter a value for only this attribute or for Requested Resource Email but not both. |
| RequestedResourceName | String | Name of the project enterprise resource who is selected to fulfill the project resource request, if the Requested Quantity is equal to 1. |
| RequestedResourceEmail | String | Email of the resource who is selected to fulfill the project resource request, if the Requested Quantity is equal to 1. You may enter a value for only this attribute or for Requested Resource ID but not both. |
| RequestedResourcePersonId | Long | HCM person identifier for the project enterprise resource who is selected to fulfill the project resource request, if the Requested Quantity is equal to 1. |
| ProjectId | Long | Unique identifier of the project associated to the resource request. To identify the project, you may provide a value only for this attribute, the Project Number attribute, or the Project Name attribute. Project is mandatory when creating an OPEN request. |
| ProjectName | String | Name of the project associated to the resource request. To identify the project, you may provide a value only for this attribute, the Project ID attribute, or the Project Name attribute. |
| ProjectNumber | String | Unique number of the project associated to the resource request. To identify the project, you may provide a value only for this attribute, the Project ID attribute, or the Project Name attribute. |
| ProjectRoleId | Long | Unique identifier of the role that the selected resources will be assigned to on the project. You may enter a value only for this attribute or for Project Role Name but not both. |
| ProjectRoleName | String | Role that the selected resources will be assigned to on the project. You may enter a value only for this attribute or for Project Role ID but not both. |
| RequesterResourceId | Long | Unique identifier of the project enterprise resource who requests the resources, mostly the project manager. You may enter a value only for this attribute or for Requester Email but not both. |
| RequesterName | String | Name of the project enterprise resource who requests the resources. |
| RequesterEmail | String | Email of the project enterprise resource who requests the resources, mostly the project manager. You may enter a value only for this attribute or for Requester Resource ID but not both. |
| RequesterPersonId | Long | Identifier of the HCM person who requests the resources. |
| SpecialInstructions | String | Special instructions for the project resource request, such as requester instructions to the resource manager. |
| StaffingOwnerResourceId | Long | Identifier of the project enterprise resource who is responsible for finding resources to fulfill the request. You may enter a value for only this attribute or for Staffing Owner Email but not both. |
| StaffingOwnerName | String | Name of the person who is responsible for finding a resource to fulfill the request. |
| StaffingOwnerEmail | String | Email of the person who is responsible for finding resources to fulfill the request. You may enter a value for only this attribute or Staffing Owner ID but not both. |
| StaffingOwnerPersonId | Long | Identifier of the HCM person who is responsible for finding a resource to fulfill the request. |
| StaffingRemarks | String | Remarks added by the resource manager during staffing. |
| RequestSubmittedDate | Date | Date on which the project resource request is submitted. |
| TargetBillRate | Decimal | Bill rate that represents the targeted rate for the resources who fulfill the request. |
| TargetBillRateCurrencyCode | String | Code of the currency used to define the bill rate. |
| TargetCostRate | Decimal | Cost rate that represents the targeted rate for the resources who are selected on the request. |
| TargetCostRateCurrencyCode | String | Code of the currency used to define the cost rate. |
| RequestedQuantity | Long | The quantity of resources requested for the project resource request. If no value is provided, the value is set to 1. |
| AssignedQuantity | Long | The number of resources assigned to the project for the resource request. |
| ProposedQuantity | Long | The number of resources proposed or nominated for the project resource request. |
| RemainingQuantity | Long | The number of resources remaining to fulfill the project resource request. |
| AssignmentTypeCode | String | Code to indicate if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank. |
| AssignmentType | String | Indicates if a request is for a billable or a nonbillable assignment. Examples are BILLABLE, NON-BILLABLE, or leave blank. |
| BillablePercentReasonCode | String | Code that indicates the reason that the billable percentage of the project resource assignment is less than 100%. For a non-billable assignment, the value is ignored. |
| BillablePercentReason | String | Indicates the reason that the billable percentage of the project resource assignment is less than 100%. For a non-billable assignment, the value is ignored. |
| BillablePercent | Int | Indicates the percentage of assignment time that is billable for an assignment that is defined as Billable assignment. For a non-billable assignment, the value is ignored. Valid values are positive integer between 0 and 100 |
| RequestSource | String | The requester's role specificed on the resource request. |
| UseVariableHoursFlag | Bool | Indicates if the hours for the request are variable for every day of the week or not. Valid values are True and False. If the value is True, the requested hours are derived from the attributes Monday Hours through Sunday Hours. |
| SundayHours | Double | Hours for Sunday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| MondayHours | Double | Hours for Monday of every week for the requested time period. Applicable only if Use Variable Hours Indicator value is true. |
| TuesdayHours | Double | Hours for Tuesday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| WednesdayHours | Double | Hours for Wednesday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| ThursdayHours | Double | Hours for Thursday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| FridayHours | Double | Hours for Friday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| SaturdayHours | Double | Hours for Saturday of every week for the requested time period. Applicable only if Use Variable Hours Indicator is true. |
| UseWeeklyHoursFlag | Bool | Indicates if the hours for the request are for every week or not. Valid values are True and False. If the value is True, the requested hours are derived from the attributes RequestedHoursPerWeek. |
| RequestedHoursPerWeek | Double | Hours for every week of the requested duration. Applicable only if Use Weekly Hours Indicator value is true. |
| TotalHours | Decimal | Total requested hours for the resource for the particular assignment. |
| Finder | String | finder |