HRE_TOUCHPT_CELEB_INTRCNS_V

Details

• Schema: FUSION

• Object owner: HRE

• Object type: VIEW

Columns

Name
REFERENCE_ID STATUS_CODE ENGAGEMENT_TYPE ENGAGEMENT_DATE PERSON_ID ASSIGNMENT_ID CREATED_BY_PERSON_ID CREATED_BY_ASSIGNMENT_ID HIDDEN_FLAG VISIBILITY BUSINESS_GROUP_ID REQUEST_ID CHECKIN_TOPICS_DISCUSSED_COUNT CHECKIN_TOPICS_TOTAL_COUNT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT REFERENCE_ID, STATUS_CODE, ENGAGEMENT_TYPE, ENGAGEMENT_DATE, CREATED_FOR_PERSON_ID PERSON_ID, CREATED_FOR_ASSIGNMENT_ID ASSIGNMENT_ID, CREATED_BY_PERSON_ID, CREATED_BY_ASSIGNMENT_ID, HIDDEN_FLAG, VISIBILITY, BUSINESS_GROUP_ID, REQUEST_ID, CHECKIN_TOPICS_DISCUSSED_COUNT, CHECKIN_TOPICS_TOTAL_COUNT, OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM hre_touchpt_empl_evts_intrcns where ENGAGEMENT_TYPE IN ('ORA_HRE_AWARD','ORA_HRE_RECOGNITION')