Search Results as_card_rule_qual_values_pk

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:

• QUAL_VALUE_ID — the surrogate primary key, defined by the constraint AS_CARD_RULE_QUAL_VALUES_PK. It is also the leading column of the unique index AS_CARD_RULE_QUAL_VALUES_U1 (QUAL_VALUE_ID, ZD_EDITION_NAME), which is the business-key candidate.
• CARD_RULE_ID — foreign key to AS_SALES_LEAD_CARD_RULES, identifying the parent rule to which the qualification value belongs.
• SEED_QUAL_ID — foreign key to AS_SALES_LEAD_QUALS_B, referencing the seeded qualification definition.
• SCORECARD_ID — foreign key to AS_SALES_LEAD_SCORECARDS, linking the value to a scorecard used for lead assessment.
• HIGH_VALUE_NUMBER / LOW_VALUE_NUMBER — numeric bounds applied when the qualification evaluates a numeric attribute.
• HIGH_VALUE_CHAR / LOW_VALUE_CHAR — character bounds used for text-based qualification comparisons.
• HIGH_VALUE_DATE / LOW_VALUE_DATE — date bounds for temporal qualification criteria.
• CURRENCY_CODE — currency context for numeric thresholds, supporting multi-currency deployments.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating of the qualification value.
• SCORE — the score assigned when the qualification value matches, feeding the scorecard outcome.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing data access control.
• ZD_EDITION_NAME — editioning column supporting online patching in Release 12.2.x.
• Standard audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

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).