ProjectChangeRequests
Returns the change requests raised against projects, including their status, priority, reason, ownership, and approval or cancellation details.
Columns
| Name | Type | SupportedFinders | Description |
| ChangeRequestId [KEY] | Long | PrimaryKey | The unique identifier of the change request. |
| ProjectId | Long | The identifier of the project associated with the change request. | |
| ProjectNumber | String | The number of the project associated with the change request. | |
| ProjectName | String | The name of the project associated with the change request. | |
| Number | String | The number of the change request. | |
| Name | String | The name of the change request. | |
| ReasonCode | String | Identifier for the change request reason type, decoded using the lookup type ORA_PJE_CR_REASON. | |
| Reason | String | The reason summarizes the need for the change request, such as a new requirement, technical issue, or design error. | |
| StatusCode | String | The code that represents the status of the change request such as new, submitted, approved, or canceled. | |
| Status | String | The status of the change request, for example approved or rejected. | |
| PriorityCode | String | Identifier for the priority, decoded using the lookup type PJE_CHANGE_PRIORITY. | |
| Priority | String | The relative importance of the change request such as high, medium, or low. | |
| Description | String | Description of the change request. | |
| Justification | String | Justification for the change request. | |
| ImpactIfNotImpl | String | Impact if the change request isn't implemented. | |
| Comments | String | Comments for the change request. | |
| OwnerId | Long | The identifier of the project person who owns the change request. | |
| OwnerName | String | The name of the project person who owns the change request. | |
| OwnerEmail | String | The email of the project person who owns the change request. | |
| ApproverId | Long | The identifier of the project person who made the approval or cancellation decision for the change request. | |
| ApproverName | String | The name of the project person who made the approval or cancellation decision for the change request. | |
| ApprovalDate | Date | The date the approval or cancellation decision of the change request was made. | |
| CancellationReasonCode | String | Identifier for the cancellation reason type, decoded using the lookup type ORA_PJE_CR_CANCEL_TYPE. | |
| CancellationReason | String | The cancellation reason for a canceled change request such as duplicate, not required, or rejected. | |
| RejectionReasonCode | String | Identifier for the rejection reason type, decoded using the lookup type ORA_PJE_CR_REJECT_TYPE. | |
| RejectionReason | String | The rejection reason for a change request such as high risk or more information requested. | |
| ProjectCurrencyCode | String | The code of the currency in which the financial information is tracked for the project associated with the change request. | |
| CreatedBy | String | The identifier of the person who created the change request. | |
| CreatedByPersonId | Long | The identifier of the project person who created the change request. | |
| CreationDate | Datetime | The date and time when the change request was created. | |
| LastUpdateDate | Datetime | The date and time when the change request was last updated. | |
| Finder | String | A named finder reference used to filter or locate specific project change request records when querying. |