JDBC Driver for Oracle SCM

Build 22.0.8462

InspectionEventsSampleSampleDispositionSampleResult

The Sample Results resource manages the sample results for an item.

Columns

Name Type Description
InspectionEventsIpEventId String Value that uniquely identifies the inspection event.
SampleSampleId String Value that uniquely identifies the sample.
SampledispositionSampleEventDispositionId String Value that uniquely identifies the sample disposition.
CharacteristicId String Value that uniquely identifies the characteristic that this event is inspecting in the sample.
Comments String Comments that the user enters during inspection.
Disposition String Inspection disposition result. Valid values include ACCEPT or REJECT.
Evaluation String Value that indicates whether the disposition evaluates the result.
InSpecification String Describes whether the result remained within specifications.
InspectionDate Datetime Date and time that this event collected this result.
IpEventId String Value that uniquely identifies the inspection event that collected the result.
ObjectVersionNumber Int Number that identifies the object version. You can use this attribute to lock the object. The Inspection Events resource increments this value every time it updates the row. It compares this number at the start and end of the transaction to determine whether another session updated the same row during the inspection.
Quantity String Quantity of samples that this event inspected.
ResultValueChar String Inspection result represented as a string. If this resource can represent this result as a string, then it uses ResultValueChar.
ResultValueDate Datetime Date when this event entered the sample inspection result.
ResultValueNumber String Inspection result represented as a number. If this resource can represent this result as a number, then it uses ResultValueNumber.
SampleId String Value that uniquely identifies the sample results that this event is entering.
SampleResultId String Value that uniquely identifies the result of the sample inspection.
UOMCode String Unit of measurement for the quantity of samples that this event inspects.
UserSequence Int User sequence.
CharacteristicName String Name that identifies the characteristic that this event is inspecting in the sample.
DataType String Name of the type of data for the characteristic that the application is inspecting.
ResultValueCharNonValidated String Value that identifies the results of the character data type that the application does not validate.
OptionalFlag Bool Contains one of the following values: true or false. If true, then the entry of result value is optional during an inspection. If false, then the entry of result value is mandatory during an inspection. This attribute does not have a default value.

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