Results for “ast_education_v”

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

Overview

AST_EDUCATION_V is an APPS-owned database view within the Oracle E-Business Suite TeleSales (AST) product family. It exposes education and academic history records associated with trading community parties, presenting them in a denormalized, report-friendly format. The view consolidates columns from the HZ_EDUCATION base entity and enriches them with a decoded lookup meaning, so that consumers do not need to resolve lookup codes manually.

Because it is a view rather than a table, AST_EDUCATION_V holds no data of its own. Its role is to provide a stable, read-only projection over the underlying education records for reporting, integration, and inquiry purposes. In the TeleSales context, this view supports the representation of a contact's or customer's educational background — including degrees earned, institutions attended, and attendance dates — which is relevant to relationship management and targeted selling scenarios. The view is documented as VALID in the ETRM metadata for both 12.1.1 and 12.2.2, and it is part of the standard APPS schema layer.

Underlying Base Objects

The view text references two objects: HZ_EDUCATION (documented as a SYNONYM) and AR_LOOKUPS (documented as a VIEW). HZ_EDUCATION is the Trading Community Architecture (TCA) entity that physically stores education records keyed to a PARTY_ID. AR_LOOKUPS supplies lookup code translations. The join is an outer join: HED.TYPE_OF_SCHOOL = ALK.LOOKUP_CODE(+) AND ALK.LOOKUP_TYPE(+)='HZ_TYPE_OF_SCHOOL'. This ensures every education row is returned even when no matching lookup exists, with TYPE_OF_SCHOOL_MEANING null in those cases. The lookup type restricted is HZ_TYPE_OF_SCHOOL, which classifies the school category.

Key Columns

• EDUCATION_ID — Primary identifier for the education record.
• PARTY_ID — Foreign key to the TCA party (person or organization) to whom the education record belongs.
• DEGREE_RECEIVED — The degree or academic credential attained; this is the column most relevant to the user search term "degree_received".
• COURSE_MAJOR — Field of study or major associated with the record.
• SCHOOL_ATTENDED_NAME — Name of the institution attended.
• START_DATE_ATTENDED / LAST_DATE_ATTENDED — Attendance period boundaries.
• TYPE_OF_SCHOOL / TYPE_OF_SCHOOL_MEANING — Raw lookup code and its decoded meaning for school classification.
• Audit and concurrency columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, APPLICATION_ID, CREATED_BY_MODULE, and ROW_ID.

Common Use Cases and Queries

Typical usage includes party education profile reports, degree verification lookups, and data migrations where education data must be extracted with decoded lookup values. A simple query to retrieve degree information for a party is:

SELECT party_id, degree_received, course_major,
       school_attended_name, type_of_school_meaning
FROM   apps.ast_education_v
WHERE  party_id = :p_party_id;

To list all parties holding a specific degree:

SELECT party_id, degree_received, school_attended_name
FROM   apps.ast_education_v
WHERE  UPPER(degree_received) LIKE '%MBA%';

Because the view already resolves the lookup, reports can select TYPE_OF_SCHOOL_MEANING directly rather than joining AR_LOOKUPS again. Note that the view is read-only; inserts and updates to education data must target HZ_EDUCATION or the supported TCA APIs, not the view itself.