JDBC Driver for Oracle SCM

Build 22.0.8462

QualityCorrectiveAndPreventiveActions

The Quality Corrective Actions resource manages the quality object.

Columns

Name Type Description
ChangeId [KEY] String Value that uniquely identifies the corrective and preventive action.
ChangeTypeId String Value that uniquely identifies the type of corrective and preventive action object.
ChangeNotice String Value that uniquely identifies the change object.
ChangeName String Name of the corrective and preventive action object.
Description String Description of the corrective and preventive action object.
OrganizationId String Value that uniquely identifies the organization of the corrective and preventive action object.
PriorityCode String Abbreviation that identifies the priority of the corrective and preventive action object.
ReasonCode String Abbreviation that identifies the reason for the corrective and preventive action.
ChangeTypeValue String Value that determines the type of corrective and preventive action. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Corrective and Preventive Action task.
OrganizationCode String Abbreviation that identifies the organization of the corrective and preventive action object.
PriorityCodeValue String Value that determines the priority of the corrective and preventive action 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 corrective and preventive action. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Corrective and Preventive Action task.
AssigneeId String Value that uniquely identifies the user assigned to the corrective and preventive action object.
RequestorId String Value that uniquely identifies the user who requested the corrective and preventive action object.
AssignedTo String User who the application assigned to the corrective and preventive action object.
RequestedBy String User who requested the corrective and preventive action object.
StatusType String Type of status of the corrective and preventive action 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 Status task.
StatusCode String Abbreviation that identifies the status of the corrective and preventive action object.
ApprovalStatus String Status of approval of the corrective and preventive action.
StatusTypeValue String Value of the status type of the corrective and preventive action object. Valid values are open, interim approval, approval, scheduled, and completed.
StatusCodeValue String Abbreviation that identifies the status of the corrective and preventive action object. Valid values are open, interim approval, approval, scheduled, and completed.
ApprovalStatusValue String Value that indicates the approval status of the corrective and preventive action 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 corrective and preventive action is effective immediately. If false, then the corrective and preventive action is not effective immediately. The default value is false.
EffectivityIncrementDays Long Number of days by which the effective date of the corrective and preventive action object is incremented.
CreatedBy String User who created the corrective and preventive action object.
LastUpdatedBy String User who most recently updated the corrective and preventive action object.
LastUpdateLogin String Login that the user used when updating the corrective and preventive action.
AssignedToRole String Corrective and preventive actions assigned to the user role.
ApprovalDateTime Datetime Date when the corrective and preventive action was approved.
NeedByDateTime Datetime Date by when the corrective and preventive action is expected to be completed.
InitiationDateTime Datetime Date when the workflow corresponding to the corrective and preventive action was started.
ImplementationDateTime Datetime Date when this corrective and preventive action was implemented.
CancellationDateTime Datetime Date when this corrective and preventive action was canceled.
ApprovalRequestDateTime Datetime Date when this corrective and preventive action was sent for approval.
CreationDateTime Datetime Date when the corrective and preventive action object was created.
LastUpdateDateTime Datetime Date when the corrective and preventive action object was updated.

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