JDBC Driver for Oracle SCM

Build 22.0.8462

InspectionPlansspecifications

The Specifications in Inspection Plans resource manages the specifications of the inspection plan.

Columns

Name Type Description
InspectionPlansInspectionPlanId String Value that uniquely identifies the inspection plan.
SpecificationId String Value that uniquely identifies the specification for the inspection plan.
InspectionPlanId String Value that uniquely identifies the inspection plan.
UserSequence Int Sequence to use when associating the inspection characteristic with the inspection plan.
CharacteristicId String Value that uniquely identifies the inspection characteristic against which the specification is being defined.
UOMCode String Abbreviation that identifies the unit of measurement for the quantity that this event inspects.
TargetValue String Target value of the inspection characteristic.
CreatedBy String User who created the inspection specification.
CreationDate Datetime Date when the user created the inspection specification.
LastUpdatedBy String User who most recently updated the inspection specification.
LastUpdateDate Datetime Date and time when the user most recently updated the inspection specification.
MaximumValueDate Datetime Upper limit of the acceptable date range for an inspection characteristic.
MinimumValueDate Datetime Lower limit of the acceptable date range for an inspection characteristic.
TargetValueDate Datetime Optimal date value for the inspection characteristic.
CharacteristicName String Name of the inspection characteristic.
MaximumValueNumber String Upper limit of the acceptable numeric range for an inspection characteristic.
MinimumValueNumber String Lower limit of the acceptable numeric range for an inspection characteristic.
TargetValueNumber String Optimal numeric value for the inspection characteristic.
ItemTargetValue String Optimal value for an item.
OptionalFlag Bool Contains one of the following values: Yes or No. If Yes, then the entry of result value is optional during an inspection. If No, then the entry of result value mandatory during an inspection. This attribute does not have a default value.
DefaultValueFlag Bool Contains one of the following values: Yes or No. If Yes, then the result value should be defaulted from the target value associated to the specification line during an inspection. If No, then the result value is not defaulted from the target value associated to the specification line during an inspection. This attribute does not have a default value.

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