JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeRequests

The Product Change Requests resource manages the change object.

Columns

Name Type Description
ChangeId [KEY] String Value that uniquely identifies the change request object.
ChangeTypeId String Value that uniquely identifies the type of change request object.
ChangeNotice String Value that uniquely identifies the change request object.
ChangeName String Name of the change request object.
Description String Description of the change request object.
OrganizationId String Value that uniquely identifies the organization of the change request object.
PriorityCode String Abbreviation that identifies the priority of the change request object.
ReasonCode String Abbreviation that identifies the reason for the change.
ChangeTypeValue String Value that determines the type of change. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task.
OrganizationCode String Abbreviation that identifies the organization of the change request object.
PriorityCodeValue String Value that determines the priority of the change request object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Priorities task.
ReasonCodeValue String Value that determines the reason for the change request object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Reasons task.
AssigneeId String Value that uniquely identifies the user assigned to the change request object.
RequestorId String Value that uniquely identifies the user who requested the change request object.
AssignedTo String User who the application assigned to the change request object.
RequestedBy String User who requested the change request object.
StatusType String Type of status of the change request object. Valid values are open, interim approval, approval, scheduled, and completed. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Statuses task.
StatusCode String Abbreviation that identifies the status of the change request object.
ApprovalStatus String Status of approval of the change request.
StatusTypeValue String Value of the status type of the change request object. Valid values are open, interim approval, approval, scheduled, and completed.
StatusCodeValue String Abbreviation that identifies the status of the change request object. Valid values are open, interim approval, approval, scheduled, and completed.
ApprovalStatusValue String Value that indicates the approval status of the change request object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task.
EffectiveImmediatelyFlag Bool Contains one of the following values: true or false. If true, then the change request is effective immediately. If false, then the change request is not effective immediately. The default value is false.
EffectivityIncrementDays Long Number of days by which the effective date of the change request object is incremented.
CreatedBy String User who created the change request object.
LastUpdatedBy String User who most recently updated the change request relationship.
LastUpdateLogin String Login that the user used when updating the change request object.
AssignedToRole String Role that is used to define users to whom the change request object can be assigned.
ApprovalDateTime Datetime Date when the change request object was approved.
NeedByDateTime Datetime Date by when the change request object is expected to be completed.
InitiationDateTime Datetime Date when the workflow corresponding to the change request was started.
ImplementationDateTime Datetime Date when this change request was implemented.
CancellationDateTime Datetime Date when this change request was canceled.
ApprovalRequestDateTime Datetime Date when this change request was sent for approval.
CreationDateTime Datetime Date when the change request relationship was created.
LastUpdateDateTime Datetime Date when the change request object was updated.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462