IRC_PROFILE_EDUCATION_ITEMS_V

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name

EDUCATION_ID BUSINESS_GROUP_ID PROFILE_ID PARENT_PROFILE_ITEM_ID SECTION_ID CONTENT_TYPE_ID CONTENT_ITEM_ID DEGREE_NAME MAJOR EDUCATIONAL_ESTABLISHMENT_ID EDUCATIONAL_ESTABLISHMENT START_DATE END_DATE EDUCATION_LEVEL STATE_PROVINCE_ID COUNTRY_ID CITY AVG_GRADE YEAR_ACQUIRED GPA GRADUATED_FLAG TRMNL_DEG_DISCP_FLAG DATE_ACQUIRED EDUCATOR MINOR PROJECTED_COMP_DATE FEE COMPLETED_AMOUNT TOTAL_AMOUNT COMMENTS REIMBURSEMENTS COMP_TRAINING_UNITS STATUS FEE_CURRENCY TUITION_METHOD EDU_LEVEL_COMP_FLAG AWARDING_BODY TITLE HIGHEST_EDU_LEVEL AREA_OF_STUDY DEPARTMENT DURATION DURATION_UNITS ACADEMIC_STANDING PART_TIME_FLAG DESCRIPTION ACTIVITY_SUMMARY EDUCATION_URL IMPORTANCE DATE_FROM DATE_TO OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN STATE_PROVINCE_CODE COUNTRY_CODE

Query

SQL_Statement

SELECT PROFILE_ITEM_ID AS EDUCATION_ID, BUSINESS_GROUP_ID, PROFILE_ID, PARENT_PROFILE_ITEM_ID, SECTION_ID, CONTENT_TYPE_ID, CONTENT_ITEM_ID AS CONTENT_ITEM_ID , ITEM_TEXT240_11 AS DEGREE_NAME , ITEM_TEXT240_1 AS MAJOR , ITEM_NUMBER_9 AS EDUCATIONAL_ESTABLISHMENT_ID , ITEM_TEXT2000_1 AS EDUCATIONAL_ESTABLISHMENT , ITEM_DATE_7 AS START_DATE , ITEM_DATE_4 AS END_DATE , ITEM_TEXT30_8 AS EDUCATION_LEVEL , STATE_PROVINCE_ID AS STATE_PROVINCE_ID , COUNTRY_ID AS COUNTRY_ID , ITEM_TEXT240_12 AS CITY , ITEM_TEXT240_6 AS AVG_GRADE , ITEM_NUMBER_8 AS YEAR_ACQUIRED , ITEM_DECIMAL_1 AS GPA , ITEM_TEXT30_1 AS GRADUATED_FLAG , ITEM_TEXT30_2 AS TRMNL_DEG_DISCP_FLAG , ITEM_DATE_6 AS DATE_ACQUIRED , ITEM_TEXT240_4 AS EDUCATOR , ITEM_TEXT240_5 AS MINOR , ITEM_DATE_8 AS PROJECTED_COMP_DATE , ITEM_NUMBER_1 AS FEE , ITEM_NUMBER_2 AS COMPLETED_AMOUNT , ITEM_NUMBER_3 AS TOTAL_AMOUNT , NVL(ITEM_CLOB_1,TO_CLOB(ITEM_TEXT2000_3)) AS COMMENTS , NVL(ITEM_CLOB_4,TO_CLOB(ITEM_TEXT2000_5)) AS REIMBURSEMENTS , ITEM_TEXT240_7 AS COMP_TRAINING_UNITS , ITEM_TEXT30_11 AS STATUS , ITEM_TEXT30_3 AS FEE_CURRENCY , ITEM_TEXT30_7 AS TUITION_METHOD , ITEM_TEXT30_12 AS EDU_LEVEL_COMP_FLAG , ITEM_TEXT240_3 AS AWARDING_BODY , ITEM_TEXT240_10 AS TITLE , ITEM_TEXT30_13 AS HIGHEST_EDU_LEVEL , ITEM_TEXT240_2 AS AREA_OF_STUDY , ITEM_TEXT240_9 AS DEPARTMENT , ITEM_TEXT240_8 AS DURATION , ITEM_TEXT30_6 AS DURATION_UNITS , ITEM_TEXT30_4 AS ACADEMIC_STANDING , ITEM_TEXT30_5 AS PART_TIME_FLAG , ITEM_CLOB_2 AS DESCRIPTION , ITEM_CLOB_3 AS ACTIVITY_SUMMARY , ITEM_TEXT2000_2 AS EDUCATION_URL, IMPORTANCE AS IMPORTANCE, DATE_FROM, DATE_TO, OBJECT_VERSION_NUMBER , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , STATE_PROVINCE_CODE AS STATE_PROVINCE_CODE , COUNTRY_CODE AS COUNTRY_CODE FROM HRT_PROFILE_ITEMS PI WHERE CONTENT_TYPE_ID = 106 AND SECTION_ID IN (SELECT SECTION_ID FROM IRC_PROFILE_CONT_SECTIONS_V PTS WHERE PTS.PROFILE_TYPE_ID = 1 AND PTS.CONTENT_TYPE_ID = 106 AND PTS.BUSINESS_GROUP_ID = PI.BUSINESS_GROUP_ID)