HRT_PREV_EMPLOYMENT_ITEMS_V

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

PREV_EMPLOYMENT_ID BUSINESS_GROUP_ID PROFILE_ID PARENT_PROFILE_ITEM_ID SECTION_ID CONTENT_TYPE_ID CONTENT_ITEM_ID EMPLOYER_NAME JOB_TITLE START_DATE END_DATE RESPONSIBILITIES EMPLOYER_COUNTRY_ID COUNTRY_CODE EMPLOYER_STATE_ID STATE_PROVINCE_CODE EMPLOYER_CITY CURRENT_JOB_FLAG FULL_TIME_CODE INTERNAL_FLAG BUSINESS_TYPE EMPLOYER_PHONE DEPARTMENT JOB_FAMILY_ID JOB_FUNCTION OTHER_JOB_FUNCTION ACHIEVEMENTS DIRECT_REPORTS STARTING_POSITION SUPERVISOR_NAME SUPERVISOR_TITLE SUPERVISOR_EMAIL SUPERVISOR_PHONE CONTACT_SUPERVISOR_FLAG LEAVING_REASON ADDITIONAL_INFO START_COMPENSATION END_COMPENSATION OTHER_COMPENSATION COMPANY_URL DATE_FROM DATE_TO 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

Query

SQL_Statement

SELECT PROFILE_ITEM_ID AS PREV_EMPLOYMENT_ID , BUSINESS_GROUP_ID , PROFILE_ID , PARENT_PROFILE_ITEM_ID , SECTION_ID , CONTENT_TYPE_ID , CONTENT_ITEM_ID , ITEM_TEXT240_1 AS EMPLOYER_NAME , ITEM_TEXT240_9 AS JOB_TITLE , ITEM_DATE_1 AS START_DATE , ITEM_DATE_2 AS END_DATE , ITEM_CLOB_2 AS RESPONSIBILITIES , COUNTRY_ID AS EMPLOYER_COUNTRY_ID , COUNTRY_CODE AS COUNTRY_CODE , STATE_PROVINCE_ID AS EMPLOYER_STATE_ID , STATE_PROVINCE_CODE AS STATE_PROVINCE_CODE , ITEM_TEXT240_12 AS EMPLOYER_CITY, ITEM_TEXT30_1 AS CURRENT_JOB_FLAG , ITEM_TEXT30_9 AS FULL_TIME_CODE , ITEM_TEXT30_5 AS INTERNAL_FLAG , ITEM_TEXT240_13 AS BUSINESS_TYPE , ITEM_TEXT240_11 AS EMPLOYER_PHONE , ITEM_TEXT240_10 AS DEPARTMENT , ITEM_NUMBER_8 AS JOB_FAMILY_ID , ITEM_TEXT30_7 AS JOB_FUNCTION , ITEM_TEXT240_2 AS OTHER_JOB_FUNCTION , ITEM_CLOB_3 AS ACHIEVEMENTS , ITEM_NUMBER_1 AS DIRECT_REPORTS , ITEM_TEXT240_8 AS STARTING_POSITION , ITEM_TEXT240_6 AS SUPERVISOR_NAME , ITEM_TEXT240_7 AS SUPERVISOR_TITLE , ITEM_TEXT240_4 AS SUPERVISOR_EMAIL , ITEM_TEXT240_3 AS SUPERVISOR_PHONE , ITEM_TEXT30_2 AS CONTACT_SUPERVISOR_FLAG , ITEM_CLOB_4 AS LEAVING_REASON , ITEM_CLOB_1 AS ADDITIONAL_INFO , ITEM_DECIMAL_1 AS START_COMPENSATION , ITEM_DECIMAL_2 AS END_COMPENSATION , ITEM_TEXT240_14 AS OTHER_COMPENSATION , ITEM_TEXT2000_2 AS COMPANY_URL , DATE_FROM, DATE_TO, 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 FROM HRT_PROFILE_ITEMS WHERE CONTENT_TYPE_ID = 129