HWR_EDUCATION_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
EDUCATION_ID SOURCE_ID ACTIVITIES DEGREE DESCRIPTION END_DATE FIELD_OF_STUDY SCHOOL_INSTITUTION_NAME START_DATE EDUCATION_TYPE PRFL_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.EDUCATION_ID , B.SOURCE_ID , B.ACTIVITIES , B.DEGREE , B.DESCRIPTION , B.END_DATE , B.FIELD_OF_STUDY , B.SCHOOL_INSTITUTION_NAME , B.START_DATE , B.EDUCATION_TYPE , X.PRFL_ID , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATE_LOGIN FROM HWR_EDUCATION_B B LEFT JOIN HWR_EDUCATION_PRFL_X X ON (B.EDUCATION_ID = X.EDUCATION_ID AND B.SOURCE_ID = X.SOURCE_ID)