HRT_EDUCATION_ITEMS_V

Details

  • Schema: FUSION

  • Object owner: HRT

  • 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

STATE_PROVINCE_CODE

COUNTRY_ID

COUNTRY_CODE

CITY

AVG_GRADE

YEAR_ACQUIRED

GPA

REQUIRED_GPA

GRADUATED_FLAG

GRADUATION_REQUIRED_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

RELATED_ITEM_FLAG

DESCRIPTION

ACTIVITY_SUMMARY

EDUCATION_URL

REQUIRED_FLAG

DATE_FROM

DATE_TO

IMPORTANCE

SOURCE_ID

SOURCE_TYPE

SOURCE_KEY1

SOURCE_KEY2

SOURCE_KEY3

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_NUMBER11

ATTRIBUTE_NUMBER12

ATTRIBUTE_NUMBER13

ATTRIBUTE_NUMBER14

ATTRIBUTE_NUMBER15

ATTRIBUTE_NUMBER16

ATTRIBUTE_NUMBER17

ATTRIBUTE_NUMBER18

ATTRIBUTE_NUMBER19

ATTRIBUTE_NUMBER20

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

ATTRIBUTE_DATE11

ATTRIBUTE_DATE12

ATTRIBUTE_DATE13

ATTRIBUTE_DATE14

ATTRIBUTE_DATE15

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

REQUIREMENT_TYPE

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 ,

STATE_PROVINCE_CODE AS STATE_PROVINCE_CODE ,

COUNTRY_ID AS COUNTRY_ID ,

COUNTRY_CODE AS COUNTRY_CODE ,

ITEM_TEXT240_12 AS CITY ,

ITEM_TEXT240_6 AS AVG_GRADE ,

ITEM_NUMBER_8 AS YEAR_ACQUIRED ,

ITEM_DECIMAL_1 AS GPA ,

ITEM_DECIMAL_1 AS REQUIRED_GPA,

ITEM_TEXT30_1 AS GRADUATED_FLAG ,

ITEM_TEXT30_1 AS GRADUATION_REQUIRED_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 ,

ITEM_CLOB_1 AS COMMENTS ,

ITEM_CLOB_4 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_TEXT30_15 AS RELATED_ITEM_FLAG,

ITEM_CLOB_2 AS DESCRIPTION ,

ITEM_CLOB_3 AS ACTIVITY_SUMMARY ,

ITEM_TEXT2000_2 AS EDUCATION_URL ,

MANDATORY AS REQUIRED_FLAG ,

DATE_FROM,

DATE_TO,

IMPORTANCE AS IMPORTANCE,

SOURCE_ID ,

SOURCE_TYPE ,

SOURCE_KEY1 ,

SOURCE_KEY2 ,

SOURCE_KEY3 ,

ATTRIBUTE_CATEGORY ,

ATTRIBUTE1 ,

ATTRIBUTE2 ,

ATTRIBUTE3 ,

ATTRIBUTE4 ,

ATTRIBUTE5 ,

ATTRIBUTE6 ,

ATTRIBUTE7 ,

ATTRIBUTE8 ,

ATTRIBUTE9 ,

ATTRIBUTE10 ,

ATTRIBUTE11 ,

ATTRIBUTE12 ,

ATTRIBUTE13 ,

ATTRIBUTE14 ,

ATTRIBUTE15 ,

ATTRIBUTE16 ,

ATTRIBUTE17 ,

ATTRIBUTE18 ,

ATTRIBUTE19 ,

ATTRIBUTE20 ,

ATTRIBUTE21 ,

ATTRIBUTE22 ,

ATTRIBUTE23 ,

ATTRIBUTE24 ,

ATTRIBUTE25 ,

ATTRIBUTE26 ,

ATTRIBUTE27 ,

ATTRIBUTE28 ,

ATTRIBUTE29 ,

ATTRIBUTE30 ,

ATTRIBUTE_NUMBER1 ,

ATTRIBUTE_NUMBER2 ,

ATTRIBUTE_NUMBER3 ,

ATTRIBUTE_NUMBER4 ,

ATTRIBUTE_NUMBER5 ,

ATTRIBUTE_NUMBER6 ,

ATTRIBUTE_NUMBER7 ,

ATTRIBUTE_NUMBER8 ,

ATTRIBUTE_NUMBER9 ,

ATTRIBUTE_NUMBER10 ,

ATTRIBUTE_NUMBER11 ,

ATTRIBUTE_NUMBER12 ,

ATTRIBUTE_NUMBER13 ,

ATTRIBUTE_NUMBER14 ,

ATTRIBUTE_NUMBER15 ,

ATTRIBUTE_NUMBER16 ,

ATTRIBUTE_NUMBER17 ,

ATTRIBUTE_NUMBER18 ,

ATTRIBUTE_NUMBER19 ,

ATTRIBUTE_NUMBER20 ,

ATTRIBUTE_DATE1 ,

ATTRIBUTE_DATE2 ,

ATTRIBUTE_DATE3 ,

ATTRIBUTE_DATE4 ,

ATTRIBUTE_DATE5 ,

ATTRIBUTE_DATE6 ,

ATTRIBUTE_DATE7 ,

ATTRIBUTE_DATE8 ,

ATTRIBUTE_DATE9 ,

ATTRIBUTE_DATE10 ,

ATTRIBUTE_DATE11 ,

ATTRIBUTE_DATE12 ,

ATTRIBUTE_DATE13 ,

ATTRIBUTE_DATE14 ,

ATTRIBUTE_DATE15 ,

OBJECT_VERSION_NUMBER ,

CREATED_BY ,

CREATION_DATE ,

LAST_UPDATED_BY ,

LAST_UPDATE_DATE ,

LAST_UPDATE_LOGIN ,

ITEM_TEXT30_8 AS REQUIREMENT_TYPE

FROM HRT_PROFILE_ITEMS

WHERE CONTENT_TYPE_ID = 106