Results for “education_id”

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

Overview

AMS_PERSON_EDUCATION_V is a seeded Oracle E-Business Suite view owned by the APPS schema and delivered under the AMS (Marketing) product family. Its documented purpose is to expose a person's education information in a reporting-friendly format. The view is registered as VALID in the EBS data dictionary and is available in both the 12.1.1 and 12.2.2 releases.

From a functional standpoint, the view consolidates education records stored against the Trading Community Architecture (TCA) party model and restricts the result set to active person parties. This makes it suitable for marketing segmentation, profiling, and downstream analytics where academic background is a qualifier, such as targeting campaigns at individuals with a particular degree or field of study. Because the object is a view rather than a table, it carries no storage of its own and reflects the current state of the underlying TCA records at query time.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms in the APPS schema:

• HZ_EDUCATION — the TCA table holding education history records for parties, including institution, degree, major, and attendance dates.
• HZ_PARTIES — the master TCA party table, supplying party identity and status attributes.

The join is an inner join on PARTY_ID, with two filter predicates applied to HZ_PARTIES: STATUS must equal 'A' (active) and PARTY_TYPE must equal 'PERSON'. Consequently, organization parties and inactive person records are excluded from the view entirely. The documented view text is a straightforward two-table equijoin with no aggregation, no outer joins, and no use of function-based or analytical constructs, which keeps it inexpensive to query and predictable in cardinality.

Key Columns

• EDUCATION_ID — primary identifier of the education record in HZ_EDUCATION; unique per record and useful as a join key or for de-duplication.
• PARTY_ID — foreign key to HZ_PARTIES identifying the person to whom the education record belongs; the principal join column to other TCA-based views.
• SCHOOL_ATTENDED_NAME — name of the institution attended.
• TYPE_OF_SCHOOL — classification of the institution.
• COURSE_MAJOR — the field or major of study.
• DEGREE_RECEIVED — the qualification or degree awarded.
• START_DATE_ATTENDED — date attendance began.
• LAST_DATE_ATTENDED — date attendance ended or is expected to end.

No derived or translated columns are documented, so displayed values are the stored TCA values subject to any standard date formatting in the reporting layer.

Common Use Cases and Queries

Typical uses include marketing list generation by academic profile, enrichment of person profiles in customer intelligence reporting, and extraction feeds into external analytics platforms. A representative query returning education details for active persons is:

• SELECT party_id, school_attended_name, degree_received, course_major, start_date_attended, last_date_attended FROM apps.ams_person_education_v WHERE degree_received IS NOT NULL ORDER BY party_id;
• SELECT course_major, COUNT(*) FROM apps.ams_person_education_v GROUP BY course_major ORDER BY 2 DESC;
• SELECT e.party_id, p.person_first_name, p.person_last_name, e.school_attended_name FROM apps.ams_person_education_v e, apps.hz_parties p WHERE e.party_id = p.party_id AND e.type_of_school = :school_type;

Because the view enforces active person filtering, it should not be used where inactive or organization parties are required; in those cases HZ_EDUCATION should be queried directly.