Results for “start_date_attended”

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

Overview

AMS_LT_HZ_EDUCATION is a data source view owned by the APPS schema in Oracle E-Business Suite. It belongs to the AMS (Marketing) product family and is classified as a VALID database object in the ETRM repository for releases 12.1.1 and 12.2.2. The view is defined over the Oracle Trading Community Architecture (TCA) table HZ_EDUCATION, which stores educational and academic history records for parties such as customers, contacts, and prospects.

The view exists to support Oracle Marketing's "data source" framework, which lets marketing users build audience segments, lists, and campaign target groups from standardized query sources. Rather than exposing the full HZ_EDUCATION table, AMS_LT_HZ_EDUCATION presents a curated column list and filters the base table to include only records where STATUS = 'A' (active). This design ensures that marketing selections and list generation do not pick up inactive or logically deleted education records. For the search term "school_attended_name," this view is the relevant source: the SCHOOL_ATTENDED_NAME column is exposed directly, so marketing queries and reports referencing that attribute can be built against this view instead of against the underlying TCA table.

Underlying Base Objects

According to the ETRM metadata, AMS_LT_HZ_EDUCATION is defined over a single referenced base object: HZ_EDUCATION, accessed through a synonym in the APPS schema. The relationship is a straightforward one-to-one projection: every qualifying row in HZ_EDUCATION produces exactly one row in the view. No joins to other tables are present in the view definition, and no aggregation is applied.

The only row-level restriction is the predicate WHERE STATUS = 'A'. This means the view inherits the TCA data model of HZ_EDUCATION, including its primary key (EDUCATION_ID) and its foreign key relationship to the party model through PARTY_ID. Because the view is a thin layer over a TCA table, it is subject to the same TCA security and data quality conventions as HZ_EDUCATION. It is not a denormalized reporting table, so performance characteristics follow those of the base table and its indexes.

Key Columns

The ETRM documentation lists the following columns exposed by AMS_LT_HZ_EDUCATION:

• EDUCATION_ID — Primary identifier for the education record; uniquely identifies each row.
• PARTY_ID — Foreign key to the party (person or organization) with whom the education record is associated. This is the join key to HZ_PARTIES and to other party-based marketing data sources.
• SCHOOL_ATTENDED_NAME — Name of the school or institution attended. This is the column most commonly targeted by marketing segmentation and reporting queries.
• COURSE_MAJOR — Field of study or academic major pursued at the institution.
• DEGREE_RECEIVED — Degree or qualification awarded, where recorded.
• START_DATE_ATTENDED — Date attendance at the institution began.
• LAST_DATE_ATTENDED — Date attendance ended, or the most recent date of attendance.
• TYPE_OF_SCHOOL — Classification of the institution (for example, college, university, or high school).

The view intentionally omits non-essential HZ_EDUCATION attributes, and its active-status filter means downstream consumers never see records with a status other than 'A'.

Common Use Cases and Queries

Typical uses include building marketing list sources, segmenting contacts by educational background, and producing ad hoc reports on school and degree data. Because the view is registered as an AMS data source, it is commonly referenced by Marketing list-generation setups in addition to direct SQL.

Example 1 — retrieve active education records for a party:

• SELECT education_id, party_id, school_attended_name, course_major, degree_received
• FROM apps.ams_lt_hz_education
• WHERE party_id = :party_id;

Example 2 — find parties associated with a given school, useful for alumni-oriented campaigns:

• SELECT party_id, school_attended_name, course_major, last_date_attended
• FROM apps.ams_lt_hz_education
• WHERE school_attended_name = :school_name;

Example 3 — join to the party table for contactable names:

• SELECT p.party_name, e.school_attended_name, e.type_of_school
• FROM apps.ams_lt_hz_education e, apps.hz_parties p
• WHERE e.party_id = p.party_id;

All queries return only active records by default, which aligns reporting output with the marketing data source definition.