QualityProblemReports

The Quality Problem Reports resource manages the quality object.

Columns


Name	Type	Description
ChangeId [KEY]	String	Value that uniquely identifies the problem report.
ChangeTypeId	String	Value that uniquely identifies the type of problem report object.
ChangeNotice	String	Value that uniquely identifies the Problem Report Object.
ChangeName	String	Name of the problem report object.
Description	String	Description of the Problem Report Object.
OrganizationId	String	Value that uniquely identifies the organization of the problem report object.
PriorityCode	String	Abbreviation that identifies the priority of the problem report object.
ReasonCode	String	Abbreviation that identifies the reason for the corrective and preventive action.
ChangeTypeValue	String	Value that determines the type of problem report. 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 problem report object.
PriorityCodeValue	String	Value that determines the priority of the problem report 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 Quality Problem Report. 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 problem report object.
RequestorId	String	Value that uniquely identifies the user who requested the problem report object.
AssignedTo	String	User who the application assigned to the Problem Report Object.
RequestedBy	String	User who requested the problem report object.
StatusType	String	Type of status of the problem report 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 Problem Report Object.
ApprovalStatus	String	Status of approval of the quality problem report.
StatusTypeValue	String	Value of the status type of the problem report object. Valid values are open, interim approval, approval, scheduled, and completed.
StatusCodeValue	String	Abbreviation that identifies the status of the problem report object. Valid values are open, interim approval, approval, scheduled, and completed.
ApprovalStatusValue	String	Value that indicates the approval status of the problem report object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Quality Problem Reports Types task.
EffectiveImmediatelyFlag	Bool	Contains one of the following values: true or false. If true, then the Quality Problem Reports is effective immediately. If false, then the Quality Problem Reports is not effective immediately. The default value is false.
EffectivityIncrementDays	Long	Number of days by which the effective date of the problem report object is incremented.
CreatedBy	String	User who created the problem report object.
LastUpdatedBy	String	User who most recently updated the Problem Report Object.
LastUpdateLogin	String	Logged in user who last updated the quality problem report.
AssignedToRole	String	Role that is used to define users to whom the problem report can be assigned.
ApprovalDateTime	Datetime	Date when the Problem Report 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 quality problem report was started.
ImplementationDateTime	Datetime	Date when this quality problem report was implemented.
CancellationDateTime	Datetime	Date when this quality problem reports was canceled.
ApprovalRequestDateTime	Datetime	Date when this quality problem report was sent for approval.
CreationDateTime	Datetime	Date when the Problem Report Object was created.
LastUpdateDateTime	Datetime	Date when the Problem Report Object was updated.

JDBC Driver for Oracle SCM

QualityProblemReports

Columns