Results for “jty_webadi_qual_type_header”

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

Overview

The JTY_WEBADI_QUAL_TYPE_HEADER table is an interface table that resides in the JTF (CRM Foundation) schema and is shipped as part of the Oracle E-Business Suite 12.1.1 / 12.2.2 technology stack. Its documented purpose is to store data that needs to be displayed in Microsoft Excel through the WebADI (Web Applications Desktop Integrator) framework. WebADI enables users to download, manipulate, and upload EBS data using Excel worksheets that act as a client-side front end; JTY_WEBADI_QUAL_TYPE_HEADER serves as the staging or interface layer that supplies the qualification-type header information rendered on those worksheets.

The object is marked VALID in the data dictionary and belongs to the JTF – CRM Foundation product family. A heuristic Data Vault classification mined from the foreign-key structure identifies this table as standalone, meaning it does not behave as a strict hub, link, or satellite in a Data Vault model. For modeling purposes, it is best treated as a staging/interface entity rather than a conformed dimensional structure. It carries a single documented foreign key to JTF_QUAL_TYPES_ALL and exposes five physical columns in the 12.2.2 schema.

Key Information Stored

The documented physical schema for 12.2.2 consists of five columns, all of which are relevant to the WebADI exchange:

• QUAL_TYPE_ID – The qualification type identifier and the sole documented foreign key, referencing JTF_QUAL_TYPES_ALL.QUAL_TYPE_ID. This is the business-key linkage that ties each staging row to its master qualification type record.
• QUAL_TYPE_NUM – The qualification type number, a human-readable business identifier commonly used in CRM qualification setups.
• QUAL_TYPE_NAME – The descriptive name of the qualification type, populated into the Excel worksheet for display.
• QUAL_TYPE_DESCR – The long description of the qualification type, used for supporting detail on the worksheet.
• USER_SEQUENCE – The sequencing column used to control the order in which rows are presented to the user in the WebADI layout.

No explicit primary key is documented in the provided metadata beyond the FK relationship on QUAL_TYPE_ID; no unique index candidates were published. In practice, QUAL_TYPE_ID functions as the surrogate identifier linking to the master, while QUAL_TYPE_NUM is the natural business-key candidate. Because the table is an interface table, it is not a persistent transactional entity and may be populated and cleared per WebADI session.

Common Use Cases and Queries

This table is primarily consulted when diagnosing WebADI qualification-type layouts, troubleshooting Excel download/upload behavior, or generating ad-hoc extracts for CRM qualification-type maintenance.

• Retrieve the WebADI staging content: SELECT qual_type_id, qual_type_num, qual_type_name, qual_type_descr, user_sequence FROM jtf.jty_webadi_qual_type_header ORDER BY user_sequence;
• Join to the master qualification type for reconciliation: SELECT h.qual_type_num, h.qual_type_name, q.qual_type_id FROM jtf.jty_webadi_qual_type_header h JOIN jtf.jtf_qual_types_all q ON h.qual_type_id = q.qual_type_id;
• Detect orphaned staging rows: SELECT h.* FROM jtf.jty_webadi_qual_type_header h WHERE NOT EXISTS (SELECT 1 FROM jtf.jtf_qual_types_all q WHERE q.qual_type_id = h.qual_type_id);

Typical scenarios include verifying that a user's Excel template displays the correct set of qualification types after a setup change, and confirming that a newly created qualification type in JTF_QUAL_TYPES_ALL is staged correctly. Because the table is an interface artifact, it should not be queried for authoritative reporting; the underlying master table is the correct reporting source.

Related Objects

The following objects are most significant when working with this table:

• JTF_QUAL_TYPES_ALL – The master qualification types table; the documented FK on QUAL_TYPE_ID targets this object.
• JTF_QUAL_TYPES_TL – Translation table supplying language-specific names and descriptions for qualification types.
• JTY_WEBADI_* interface tables – Sibling WebADI staging tables following the same pattern for other EBS entities.
• JTF_RS_SALESREPS and related CRM resource tables – Qualification types are commonly assigned to resources and referenced alongside this interface.
• WebADI Integrator / BNE – Banner/WebADI framework APIs that read this interface table to render Excel worksheets.
• JTF_QUAL_TYPES_VL – The multilingual view frequently used in place of the base tables for reporting.