DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_PERSON_EDUCATION_V

Object Details
Object Name: AMS_PERSON_EDUCATION_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PERSON_EDUCATION_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EDUCATION_ID NUMBER (15) Yes Unique identifier of this education record
PARTY_ID NUMBER (15) Yes Unique party indentifier. Foreign key to the HZ_PARTIES table
SCHOOL_ATTENDED_NAME VARCHAR2 (60)
The name of the school.
TYPE_OF_SCHOOL VARCHAR2 (30)
The classification of the educational organization. For example, high school, college, university, or professional school. Note that the classification of schools varies among different cultures.
COURSE_MAJOR VARCHAR2 (60)
Primary area of study
DEGREE_RECEIVED VARCHAR2 (60)
Abbreviation for the degree. For example, BA, BSc, MBA, MSc, PhD, Gd (graduate diploma).
START_DATE_ATTENDED DATE

Date that the person's attendance starts.
LAST_DATE_ATTENDED DATE

The year and month a person last attended the educational institution.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EDUCATION_ID
,      PARTY_ID
,      SCHOOL_ATTENDED_NAME
,      TYPE_OF_SCHOOL
,      COURSE_MAJOR
,      DEGREE_RECEIVED
,      START_DATE_ATTENDED
,      LAST_DATE_ATTENDED
FROM APPS.AMS_PERSON_EDUCATION_V;

Dependencies

[top of page]

APPS.AMS_PERSON_EDUCATION_V references the following:

SchemaAPPS
SynonymHZ_EDUCATION
SynonymHZ_PARTIES

APPS.AMS_PERSON_EDUCATION_V is not referenced by any database object