Inspection Levels

The Inspection Levels view object consolidates information for the inspection level, such as level name, description, sampling enabled, skip lot enabled, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.QaBiccExtractAM.QaInspectionLevelsExtractPVO

Primary Keys : InspectionLevelsTLPEOInspectionLevelId, InspectionLevelsTLPEOLanguage

Initial Extract Date : InspectionLevelsTLPEOCreationDate

Incremental Extract Date : InspectionLevelsTLPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
InspectionLevelsBasePEOAcceptanceQualityLimit	Acceptance Quality Limit along with the Sample Size Code Letter is used to determine the sampling size. A list of accepted values is defined in the lookup type ORA_QA_SAMPLING_AQL.
InspectionLevelsBasePEOFixedSamplingCount	Number of samples to inspect when sampling plan type is fixed count.
InspectionLevelsBasePEOInspectionLevelCode	Determines the relationship between the lot or batch size and the sample size. A list of accepted values is defined in the lookup type ORA_QA_SAMPLING_INSP_LEVEL.
InspectionLevelsBasePEOInspectionLevelId	Value that uniquely identifies the inspection level.
InspectionLevelsBasePEONumLots	Number of Lots available for inspection.
InspectionLevelsBasePEONumLotsInspect	Number of lots to inspect in the current inspection level.
InspectionLevelsBasePEOPercentSampling	Percentage of sampling required.
InspectionLevelsBasePEOQuantityPerSample	Quantity of material required for inspection on a per sample basis.
InspectionLevelsBasePEOSampleUomCode	Code that identifies the unit of measure for quantity per sample.
InspectionLevelsBasePEOSamplingEnabledFlag	Contains one of the following values: Y or N. If Y, then Sampling percentage must be specified. If N, then percentage is assumed to be 100, which means no sampling. The default value is N.
InspectionLevelsBasePEOSamplingPlanType	Type of sampling plan. A list of accepted values is defined in the lookup type ORA_QA_SAMPLING_PLAN_TYPE.
InspectionLevelsBasePEOSamplingStdCode	Sampling standard code associated with the inspection level. A list of accepted values is defined in the lookup type ORA_QA_SAMPLING_STD.
InspectionLevelsBasePEOSkiplotEnabledFlag	Contains one of the following values: Y or N. If Y, then value for number of lots and number of lots to inspect must be specified. If N, then skip lot isn't enabled. The default value is N.
InspectionLevelsTLPEOCreatedBy	User who created the inspection level.
InspectionLevelsTLPEOCreationDate	Date and time when the inspection level was created.
InspectionLevelsTLPEODescription	Translatable description of Inspection Level.
InspectionLevelsTLPEOInspectionLevelId	Value that uniquely identifies the inspection level.
InspectionLevelsTLPEOLanguage	Code that identifies the language into which the contents of the translatable columns are translated.
InspectionLevelsTLPEOLastUpdateDate	Date and time when the user last updated the inspection level.
InspectionLevelsTLPEOLastUpdateLogin	Session login associated with the user who last updated the inspection level.
InspectionLevelsTLPEOLastUpdatedBy	User who last updated the inspection level.
InspectionLevelsTLPEOName	Translatable name of the Inspection Level.
InspectionLevelsTLPEOSourceLang	Code that identifies the language in which the contents of the translatable columns were originally created.