Results for “qa_control_limits”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QA_CONTROL_LIMITS is a table in the QA (Quality) product module of Oracle E-Business Suite, holding schema owner QA. It is documented as VALID in both ETRM 12.1.1 and 12.2.2. The table stores control limits used in the construction of statistical process control (SPC) charts, providing the upper and lower control boundaries, target values, and subgroup parameters that govern how chart data is evaluated and displayed.

Under a heuristic Data Vault classification mined from its foreign key structure, QA_CONTROL_LIMITS presents as satellite-leaning. This suggests a modeling recommendation in which the table behaves as a descriptive satellite attached to a parent business entity, carrying attributes and limits rather than acting as a standalone hub or an associative link. The only documented foreign key is QA_CONTROL_LIMITS.CRITERIA_ID referencing QA_CRITERIA_HEADERS, reinforcing its role as a dependent detail structure.

Key Information Stored

The table comprises 21 documented columns in the 12.2.2 physical schema. The surrogate primary key is CONTROL_LIMIT_ID, enforced by the QA_CONTROL_LIMITS_PK constraint, and it is also the sole documented unique index (QA_CONTROL_LIMITS_U1), making it the de facto business-key candidate in the provided metadata. Notable columns include:

• CONTROL_LIMIT_ID — surrogate primary key uniquely identifying each control limit record.
• CRITERIA_ID — foreign key to QA_CRITERIA_HEADERS, linking the limits to their governing criteria set.
• CHAR_ID, PLAN_ID, SPEC_ID — identifiers associating the limits with a characteristic, sampling plan, and specification respectively.
• CHART_TYPE — defines the type of control chart the limits apply to.
• NAME, DESCRIPTION — user-facing label and descriptive text.
• SUBGROUP_SIZE, NUMBER_SUBGROUPS — statistical parameters controlling sample grouping used in chart computation.
• LCL, UCL, TARGET — lower control limit, upper control limit, and target value for the primary chart metric.
• R_LCL, R_UCL, R_TARGET — corresponding limits and target for the range (R) chart metric.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical use cases include retrieving control limits for a specific criteria and chart type to drive SPC reporting, validating that limits are populated before chart rendering, and joining limits to characteristic and plan data for quality analytics. A representative query pattern follows:

• Retrieve limits for a criteria: SELECT control_limit_id, chart_type, lcl, ucl, target FROM qa_control_limits WHERE criteria_id = :criteria_id;
• Filter by chart type: SELECT name, subgroup_size, number_subgroups FROM qa_control_limits WHERE chart_type = :chart_type;
• Join to criteria headers: SELECT c.control_limit_id, h.* FROM qa_control_limits c, qa_criteria_headers h WHERE c.criteria_id = h.criteria_id;
• Audit recent changes: SELECT control_limit_id, last_updated_by, last_update_date FROM qa_control_limits ORDER BY last_update_date DESC;

Reporting typically surfaces limits alongside measured quality results to flag out-of-control points and to trend process stability over time.

Related Objects

The most significant related objects are derived from the documented foreign key and the surrounding quality model:

• QA_CRITERIA_HEADERS — parent table joined via QA_CONTROL_LIMITS.CRITERIA_ID.
• QA_CRITERIA_HEADERS_PK — primary key constraint on the parent criteria table.
• QA_CONTROL_LIMITS_PK / QA_CONTROL_LIMITS_U1 — primary key and unique index on CONTROL_LIMIT_ID.
• Characteristic, plan, and specification entities referenced by CHAR_ID, PLAN_ID, and SPEC_ID respectively.
• Quality results and chart data structures that consume these limits for SPC evaluation.

Together these relationships position QA_CONTROL_LIMITS as a dependent satellite of quality criteria, supplying the statistical boundaries required for control chart generation and analysis.