HRA_CHECK_IN_TMPLS_VL

Details

• Schema: FUSION

• Object owner: HRA

• Object type: VIEW

Columns

Name

CHECK_IN_TEMPLATE_ID BUSINESS_GROUP_ID TEMPLATE_TYPE_CODE WORKER_QUESTIONNAIRE_ID MANAGER_QUESTIONNAIRE_ID NAME COMMENTS DATE_FROM DATE_TO STATUS_CODE FREE_FORM_NOTES_FLAG PERFORMANCE_GOALS_FLAG DEVELOPMENT_GOALS_FLAG GENERAL_DISCUSSION_TOPIC_FLAG QUESTIONNAIRE_FLAG PERF_GOALS_AUTO_POPULATE_FLAG DEV_GOALS_AUTO_POPULATE_FLAG 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 INCLUDE_IN_PERF_DOC_FLAG ALL_REVIEW_PERIODS_FLAG ANYTIME_FEEDBACK_FLAG REQUESTED_FEEDBACK_FLAG COMPETENCY_FLAG DEVELOPING_SKILL_FLAG DEVELOPED_SKILL_FLAG ALL_MANAGER_TYPES_CODE MANAGER_TYPES WKR_QSTNR_SCORING_FLAG WKR_CAN_VIEW_WKR_SCORES_FLAG WKR_CAN_VIEW_MGR_SCORES_FLAG MGR_QSTNR_SCORING_FLAG MGR_CAN_VIEW_WKR_SCORES_FLAG MGR_CAN_VIEW_MGR_SCORES_FLAG CALENDAR_INVITE_FLAG

Query

SQL_Statement

SELECT CIT.CHECK_IN_TEMPLATE_ID CHECK_IN_TEMPLATE_ID, CIT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CIT.TEMPLATE_TYPE_CODE TEMPLATE_TYPE_CODE, CIT.WORKER_QUESTIONNAIRE_ID WORKER_QUESTIONNAIRE_ID, CIT.MANAGER_QUESTIONNAIRE_ID MANAGER_QUESTIONNAIRE_ID, CITTL.NAME NAME, CITTL.COMMENTS COMMENTS, CIT.DATE_FROM DATE_FROM, CIT.DATE_TO DATE_TO, CIT.STATUS_CODE STATUS_CODE, CIT.FREE_FORM_NOTES_FLAG FREE_FORM_NOTES_FLAG, CIT.PERFORMANCE_GOALS_FLAG PERFORMANCE_GOALS_FLAG, CIT.DEVELOPMENT_GOALS_FLAG DEVELOPMENT_GOALS_FLAG, CIT.GENERAL_DISCUSSION_TOPIC_FLAG GENERAL_DISCUSSION_TOPIC_FLAG, CIT.QUESTIONNAIRE_FLAG QUESTIONNAIRE_FLAG, CIT.PERF_GOALS_AUTO_POPULATE_FLAG PERF_GOALS_AUTO_POPULATE_FLAG, CIT.DEV_GOALS_AUTO_POPULATE_FLAG DEV_GOALS_AUTO_POPULATE_FLAG, CIT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CIT.ATTRIBUTE1 ATTRIBUTE1, CIT.ATTRIBUTE2 ATTRIBUTE2, CIT.ATTRIBUTE3 ATTRIBUTE3, CIT.ATTRIBUTE4 ATTRIBUTE4, CIT.ATTRIBUTE5 ATTRIBUTE5, CIT.ATTRIBUTE6 ATTRIBUTE6, CIT.ATTRIBUTE7 ATTRIBUTE7, CIT.ATTRIBUTE8 ATTRIBUTE8, CIT.ATTRIBUTE9 ATTRIBUTE9, CIT.ATTRIBUTE10 ATTRIBUTE10, CIT.ATTRIBUTE11 ATTRIBUTE11, CIT.ATTRIBUTE12 ATTRIBUTE12, CIT.ATTRIBUTE13 ATTRIBUTE13, CIT.ATTRIBUTE14 ATTRIBUTE14, CIT.ATTRIBUTE15 ATTRIBUTE15, CIT.ATTRIBUTE16 ATTRIBUTE16, CIT.ATTRIBUTE17 ATTRIBUTE17, CIT.ATTRIBUTE18 ATTRIBUTE18, CIT.ATTRIBUTE19 ATTRIBUTE19, CIT.ATTRIBUTE20 ATTRIBUTE20, CIT.ATTRIBUTE21 ATTRIBUTE21, CIT.ATTRIBUTE22 ATTRIBUTE22, CIT.ATTRIBUTE23 ATTRIBUTE23, CIT.ATTRIBUTE24 ATTRIBUTE24, CIT.ATTRIBUTE25 ATTRIBUTE25, CIT.ATTRIBUTE26 ATTRIBUTE26, CIT.ATTRIBUTE27 ATTRIBUTE27, CIT.ATTRIBUTE28 ATTRIBUTE28, CIT.ATTRIBUTE29 ATTRIBUTE29, CIT.ATTRIBUTE30 ATTRIBUTE30, CIT.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, CIT.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, CIT.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, CIT.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, CIT.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, CIT.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, CIT.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, CIT.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, CIT.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, CIT.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, CIT.ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER11, CIT.ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER12, CIT.ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER13, CIT.ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER14, CIT.ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER15, CIT.ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER16, CIT.ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER17, CIT.ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER18, CIT.ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER19, CIT.ATTRIBUTE_NUMBER20 ATTRIBUTE_NUMBER20, CIT.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, CIT.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, CIT.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, CIT.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, CIT.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, CIT.ATTRIBUTE_DATE6 ATTRIBUTE_DATE6, CIT.ATTRIBUTE_DATE7 ATTRIBUTE_DATE7, CIT.ATTRIBUTE_DATE8 ATTRIBUTE_DATE8, CIT.ATTRIBUTE_DATE9 ATTRIBUTE_DATE9, CIT.ATTRIBUTE_DATE10 ATTRIBUTE_DATE10, CIT.ATTRIBUTE_DATE11 ATTRIBUTE_DATE11, CIT.ATTRIBUTE_DATE12 ATTRIBUTE_DATE12, CIT.ATTRIBUTE_DATE13 ATTRIBUTE_DATE13, CIT.ATTRIBUTE_DATE14 ATTRIBUTE_DATE14, CIT.ATTRIBUTE_DATE15 ATTRIBUTE_DATE15, CIT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CIT.CREATED_BY CREATED_BY, CIT.CREATION_DATE CREATION_DATE, CIT.LAST_UPDATED_BY LAST_UPDATED_BY, CIT.LAST_UPDATE_DATE LAST_UPDATE_DATE, CIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CIT.INCLUDE_IN_PERF_DOC_FLAG INCLUDE_IN_PERF_DOC_FLAG, CIT.ALL_REVIEW_PERIODS_FLAG ALL_REVIEW_PERIODS_FLAG, CIT.ANYTIME_FEEDBACK_FLAG ANYTIME_FEEDBACK_FLAG, CIT.REQUESTED_FEEDBACK_FLAG REQUESTED_FEEDBACK_FLAG, CIT.COMPETENCY_FLAG COMPETENCY_FLAG, CIT.DEVELOPING_SKILL_FLAG DEVELOPING_SKILL_FLAG, CIT.DEVELOPED_SKILL_FLAG DEVELOPED_SKILL_FLAG, CIT.ALL_MANAGER_TYPES_CODE, CIT.MANAGER_TYPES, CIT.WKR_QSTNR_SCORING_FLAG, CIT.WKR_CAN_VIEW_WKR_SCORES_FLAG, CIT.WKR_CAN_VIEW_MGR_SCORES_FLAG, CIT.MGR_QSTNR_SCORING_FLAG, CIT.MGR_CAN_VIEW_WKR_SCORES_FLAG, CIT.MGR_CAN_VIEW_MGR_SCORES_FLAG, CIT.CALENDAR_INVITE_FLAG FROM HRA_CHECK_IN_TMPLS_B CIT, HRA_CHECK_IN_TMPLS_TL CITTL WHERE CIT.CHECK_IN_TEMPLATE_ID = CITTL.CHECK_IN_TEMPLATE_ID AND CIT.BUSINESS_GROUP_ID = CITTL.BUSINESS_GROUP_ID AND CITTL.LANGUAGE = USERENV('LANG')