[Home] [Help]
View: AMS_PERSON_EDUCATION_V
View Text
SELECT HE.EDUCATION_ID
, HE.PARTY_ID
, HE.SCHOOL_ATTENDED_NAME
, HE.TYPE_OF_SCHOOL
, HE.COURSE_MAJOR
, HE.DEGREE_RECEIVED
, HE.START_DATE_ATTENDED
, HE.LAST_DATE_ATTENDED
FROM HZ_EDUCATION HE
, HZ_PARTIES HP
WHERE HE.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'
Columns
Name |
EDUCATION_ID |
PARTY_ID |
SCHOOL_ATTENDED_NAME |
TYPE_OF_SCHOOL |
COURSE_MAJOR |
DEGREE_RECEIVED |
START_DATE_ATTENDED |
LAST_DATE_ATTENDED |