Search Results as_card_rule_qual_values




Overview
Explore in AI Chat

Overview

The AS_CARD_RULE_QUAL_VALUES table is an Oracle EBS Sales Foundation (AS) object owned by the OSM schema. It functions as a child table of the sales lead card rule framework, holding the qualification parameter values that govern how individual card rules are evaluated. In the Sales Foundation model, a card rule defines a scoring or qualification test applied to a sales lead or opportunity; AS_CARD_RULE_QUAL_VALUES stores the specific thresholds, ranges, and reference values that the rule compares against. The table description notes that records can be deleted, indicating it is a transactional configuration store rather than a static seeded reference table.

From a modeling perspective, the heuristic Data Vault classification derived from the foreign key structure is that of a link. This is consistent with the presence of multiple foreign keys pointing to independent parent entities — card rules, seed qualifications, scorecards, and security groups — with the table capturing the association between a rule and the qualification values it requires.

Key Information Stored

The documented schema contains 21 columns. The most significant include:

Common Use Cases and Queries

Typical reporting scenarios involve retrieving the qualification thresholds for a given rule, or identifying which scorecards consume a particular qualification value. A representative query joining the parent rule table is:

  • SELECT qv.qual_value_id, qv.card_rule_id, qv.seed_qual_id, qv.low_value_number, qv.high_value_number, qv.score FROM as_card_rule_qual_values qv WHERE qv.card_rule_id = :rule_id AND SYSDATE BETWEEN NVL(qv.start_date_active, SYSDATE) AND NVL(qv.end_date_active, SYSDATE + 1);
  • Joining to AS_SALES_LEAD_QUALS_B on SEED_QUAL_ID to resolve the qualification name for user-facing reports.
  • Joining to AS_SALES_LEAD_SCORECARDS on SCORECARD_ID to determine which scorecards depend on each qualification value.
  • Auditing configured ranges per currency using CURRENCY_CODE to detect cross-currency inconsistencies.

Because records can be deleted, historical reporting should persist snapshots rather than relying solely on the current table state.

Related Objects

The principal related objects, derived from the documented foreign key relationships, are:

  • AS_SALES_LEAD_CARD_RULES — joined via AS_CARD_RULE_QUAL_VALUES.CARD_RULE_ID; the parent rule definition.
  • AS_SALES_LEAD_QUALS_B — joined via AS_CARD_RULE_QUAL_VALUES.SEED_QUAL_ID; the seeded qualification definition (base table of a TL pair).
  • AS_SALES_LEAD_SCORECARDS — joined via AS_CARD_RULE_QUAL_VALUES.SCORECARD_ID; the scoring model consuming the value.
  • FND_SECURITY_GROUPS — joined via AS_CARD_RULE_QUAL_VALUES.SECURITY_GROUP_ID; governs row-level access.
  • Unique index AS_CARD_RULE_QUAL_VALUES_U1 — the business-key candidate over (QUAL_VALUE_ID, ZD_EDITION_NAME).