Results for “do_not_mail_flag”

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

Overview

IGF_AW_PER_LIST_V is a reporting view within the Oracle E-Business Suite Financial Aid module (product code IGF). The view is documented as storing person details used for correspondence, meaning its principal role is to expose a flat, denormalized projection of party and person attributes suitable for generating letters, mailings, and other outbound communications. In EBS 12.1.1 and 12.2.2, the Financial Aid product family has been designated Obsolete, and the ETRM metadata explicitly records that this view is not implemented in this database. Consequently, the view is a legacy object: it may persist in older or customized installations that were upgraded from earlier releases, but it is not created in a fresh 12.1.1 or 12.2.2 instance.

Because the view is labeled Obsolete and is not implemented, it plays no role in current Oracle EBS reporting or integration flows. Its historical purpose was to supply a correspondence-ready list of persons — both organizations and people — with mailing address, salutation, and name components already flattened into a single row, avoiding the joins that would otherwise be required against the Trading Community Architecture (TCA) model.

Underlying Base Objects

The ETRM metadata records no documented base objects and no owner for this view. The view text, however, shows that every column is sourced from a single aliased table, HZ, which corresponds to the TCA party-related registry. Columns such as PARTY_ID, PARTY_NAME, PARTY_NUMBER, PARTY_TYPE, and ORIG_SYSTEM_REFERENCE are canonical TCA party attributes, while PERSON_FIRST_NAME, PERSON_LAST_NAME, PERSON_MIDDLE_NAME, PERSON_NAME_SUFFIX, and PERSON_TITLE are person-specific attributes. The presence of both organization attributes (DUNS_NUMBER, EMPLOYEES_TOTAL, SIC_CODE) and person attributes in one projection confirms that the underlying source is a TCA party view that unions organizations and persons, most likely a person/organization listing view in the HZ schema.

The definitive join path is therefore a straight projection with no aggregation: the view is a column-renaming and column-pruning layer over the TCA source, aliasing TCA column names to Financial Aid naming conventions.

Key Columns

• PERSON_ID / PARTY_NAME / PERSON_NUMBER / PARTY_TYPE — Primary identifiers and classification of the TCA party record; PARTY_TYPE distinguishes person from organization.
• ADDRESS_LINE1 through ADDRESS_LINE4, CITY, COUNTY, PROVINCE, POSTAL_CODE, COUNTRY — Flattened mailing address, intended for correspondence generation.
• KNOWN_AS, KNOWN_AS2, KNOWN_AS3, KNOWN_AS4, KNOWN_AS5 — Alternate or phonetic name fields. KNOWN_AS is aliased to PREFERRED_GIVEN_NAME, indicating that the first slot is the preferred name and the remaining slots store additional name variants.
• PERSON_FIRST_NAME (GIVEN_NAMES), PERSON_LAST_NAME (SURNAME), MIDDLE_NAME, PREFIX, SUFFIX, SALUTATION, TITLE, PERSON_ACADEMIC_TITLE — Name components used to construct the salutation and address block on a letter.
• EMAIL_ADDRESS, DO_NOT_MAIL_FLAG, LANGUAGE_NAME — Contact preference and channel attributes; DO_NOT_MAIL_FLAG supports suppression logic.
• CATEGORY_CODE, GROUP_TYPE, CUSTOMER_KEY, ANALYSIS_FY, CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE, LAST_ORDERED_DATE — Classification and Financial Aid-specific analysis attributes carried through the projection.
• MISSION_STATEMENT, COMPETITOR_FLAG, GSA_INDICATOR_FLAG, HQ_BRANCH_IND, REFERENCE_USE_FLAG, DUNS_NUMBER, EMPLOYEES_TOTAL, SIC_CODE — Organization-level descriptive and compliance attributes.

Common Use Cases and Queries

In instances where the view exists, its typical use is producing a correspondence list filtered by category or group. A representative query selects the minimum fields required for a mailing:

• SELECT PERSON_ID, SALUTATION, GIVEN_NAMES, SURNAME, ADDRESS_LINE1, CITY, POSTAL_CODE, EMAIL_ADDRESS FROM IGF_AW_PER_LIST_V WHERE DO_NOT_MAIL_FLAG = 'N';
• SELECT PARTY_NAME, KNOWN_AS, KNOWN_AS2, KNOWN_AS3 FROM IGF_AW_PER_LIST_V WHERE CATEGORY_CODE = :category;
• SELECT PERSON_NUMBER, PARTY_TYPE, ORIG_SYSTEM_REFERENCE FROM IGF_AW_PER_LIST_V ORDER BY PARTY_NAME;

Before writing any query, confirm the view's existence with SELECT * FROM ALL_VIEWS WHERE VIEW_NAME = 'IGF_AW_PER_LIST_V'. On a standard 12.1.1 or 12.2.2 instance the query returns no rows, because the object is documented as not implemented. In that case, equivalent output must be obtained directly from the TCA party tables rather than from this obsolete view.