eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRI_CS_CMPTNC_LVL_V

Source

View Text - Preformatted


SELECT 1 row_indicator , 0 no_level_indicator , scale_level_value , min_scale_level_value , max_scale_level_value , rank_level_value , min_rank_level_value , max_rank_level_value , CASE WHEN NVL((max_scale_level_value - min_scale_level_value),0) = 0 THEN 0 ELSE (scale_level_value - min_scale_level_value) / (max_scale_level_value - min_scale_level_value) END nrmlzd_scale_level_value , CASE WHEN NVL((max_rank_level_value - min_rank_level_value),0) = 0 THEN 0 ELSE (rank_level_value - min_rank_level_value) / (max_rank_level_value - min_rank_level_value) END nrmlzd_rank_level_value , competence_id , scale_id , level_id , cmptnc_eval_mthd_code , cmptnc_rnwl_prd_freq_value , cmptnc_rnwl_prd_unit_code , cmptnc_cert_reqrd_flag_code , scale_flag_code , scale_dflt_flag_code , last_change_date FROM (SELECT lvl.STEP_VALUE scale_level_value , MIN(lvl.STEP_VALUE) OVER(PARTITION BY rsc.rating_scale_id, cmp.competence_id ORDER BY rsc.rating_scale_id, cmp.competence_id RANGE UNBOUNDED PRECEDING) min_scale_level_value , MAX(lvl.STEP_VALUE) OVER(PARTITION BY rsc.rating_scale_id, cmp.competence_id ORDER BY rsc.rating_scale_id, cmp.competence_id RANGE UNBOUNDED PRECEDING) max_scale_level_value , RANK() OVER(PARTITION BY rsc.rating_scale_id, cmp.competence_id ORDER BY lvl.STEP_VALUE) rank_level_value , 1 min_rank_level_value , COUNT(lvl.STEP_VALUE) OVER(PARTITION BY rsc.rating_scale_id, cmp.competence_id ORDER BY rsc.rating_scale_id, cmp.competence_id RANGE UNBOUNDED PRECEDING) max_rank_level_value , cmp.competence_id competence_id , NVL(lvl.rating_scale_id,-1) scale_id , lvl.rating_level_id level_id , NVL(cmp.evaluation_method,'NA_EDW') cmptnc_eval_mthd_code , cmp.renewal_period_frequency cmptnc_rnwl_prd_freq_value , NVL(cmp.renewal_period_units,'NA_EDW') cmptnc_rnwl_prd_unit_code , NVL(cmp.certification_required,'N') cmptnc_cert_reqrd_flag_code , DECODE(rsc.rating_scale_id, to_number(NULL),'N','Y') scale_flag_code , NVL(rsc.default_flag,'N') scale_dflt_flag_code , GREATEST(cmp.last_update_date ,NVL(rsc.last_update_date,hr_general.start_of_time) ,NVL(lvl.last_update_date,hr_general.start_of_time)) last_change_date FROM per_competences cmp , per_rating_scales rsc , per_rating_levels lvl WHERE rsc.TYPE (+) = 'PROFICIENCY' AND cmp.rating_scale_id = rsc.rating_scale_id (+) AND (cmp.rating_scale_id = lvl.rating_scale_id OR cmp.competence_id = lvl.competence_id) ) UNION ALL SELECT 1 row_indicator , 1 no_level_indicator , to_number(null) scale_level_value , to_number(null) min_scale_level_value , to_number(null) max_scale_level_value , to_number(null) rank_level_value , to_number(null) min_rank_level_value , to_number(null) max_rank_level_value , to_number(null) nrmlzd_scale_level_value , to_number(null) nrmlzd_rank_level_value , cmp.competence_id competence_id , NVL(cmp.rating_scale_id, -1) scale_id , -1 level_id , NVL(cmp.evaluation_method,'NA_EDW') cmptnc_eval_mthd_code , cmp.renewal_period_frequency cmptnc_rnwl_prd_freq_value , NVL(cmp.renewal_period_units,'NA_EDW') cmptnc_rnwl_prd_unit_code , NVL(cmp.certification_required,'N') cmptnc_cert_reqrd_flag_code , null scale_flag_code , null scale_dflt_flag_code , NVL(cmp.last_update_date,hr_general.start_of_time) last_change_date FROM per_competences cmp WITH READ ONLY

View Text - HTML Formatted

SELECT 1 ROW_INDICATOR
, 0 NO_LEVEL_INDICATOR
, SCALE_LEVEL_VALUE
, MIN_SCALE_LEVEL_VALUE
, MAX_SCALE_LEVEL_VALUE
, RANK_LEVEL_VALUE
, MIN_RANK_LEVEL_VALUE
, MAX_RANK_LEVEL_VALUE
, CASE WHEN NVL((MAX_SCALE_LEVEL_VALUE - MIN_SCALE_LEVEL_VALUE)
, 0) = 0 THEN 0 ELSE (SCALE_LEVEL_VALUE - MIN_SCALE_LEVEL_VALUE) / (MAX_SCALE_LEVEL_VALUE - MIN_SCALE_LEVEL_VALUE) END NRMLZD_SCALE_LEVEL_VALUE
, CASE WHEN NVL((MAX_RANK_LEVEL_VALUE - MIN_RANK_LEVEL_VALUE)
, 0) = 0 THEN 0 ELSE (RANK_LEVEL_VALUE - MIN_RANK_LEVEL_VALUE) / (MAX_RANK_LEVEL_VALUE - MIN_RANK_LEVEL_VALUE) END NRMLZD_RANK_LEVEL_VALUE
, COMPETENCE_ID
, SCALE_ID
, LEVEL_ID
, CMPTNC_EVAL_MTHD_CODE
, CMPTNC_RNWL_PRD_FREQ_VALUE
, CMPTNC_RNWL_PRD_UNIT_CODE
, CMPTNC_CERT_REQRD_FLAG_CODE
, SCALE_FLAG_CODE
, SCALE_DFLT_FLAG_CODE
, LAST_CHANGE_DATE
FROM (SELECT LVL.STEP_VALUE SCALE_LEVEL_VALUE
, MIN(LVL.STEP_VALUE) OVER(PARTITION BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID ORDER BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID RANGE UNBOUNDED PRECEDING) MIN_SCALE_LEVEL_VALUE
, MAX(LVL.STEP_VALUE) OVER(PARTITION BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID ORDER BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID RANGE UNBOUNDED PRECEDING) MAX_SCALE_LEVEL_VALUE
, RANK() OVER(PARTITION BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID ORDER BY LVL.STEP_VALUE) RANK_LEVEL_VALUE
, 1 MIN_RANK_LEVEL_VALUE
, COUNT(LVL.STEP_VALUE) OVER(PARTITION BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID ORDER BY RSC.RATING_SCALE_ID
, CMP.COMPETENCE_ID RANGE UNBOUNDED PRECEDING) MAX_RANK_LEVEL_VALUE
, CMP.COMPETENCE_ID COMPETENCE_ID
, NVL(LVL.RATING_SCALE_ID
, -1) SCALE_ID
, LVL.RATING_LEVEL_ID LEVEL_ID
, NVL(CMP.EVALUATION_METHOD
, 'NA_EDW') CMPTNC_EVAL_MTHD_CODE
, CMP.RENEWAL_PERIOD_FREQUENCY CMPTNC_RNWL_PRD_FREQ_VALUE
, NVL(CMP.RENEWAL_PERIOD_UNITS
, 'NA_EDW') CMPTNC_RNWL_PRD_UNIT_CODE
, NVL(CMP.CERTIFICATION_REQUIRED
, 'N') CMPTNC_CERT_REQRD_FLAG_CODE
, DECODE(RSC.RATING_SCALE_ID
, TO_NUMBER(NULL)
, 'N'
, 'Y') SCALE_FLAG_CODE
, NVL(RSC.DEFAULT_FLAG
, 'N') SCALE_DFLT_FLAG_CODE
, GREATEST(CMP.LAST_UPDATE_DATE
, NVL(RSC.LAST_UPDATE_DATE
, HR_GENERAL.START_OF_TIME)
, NVL(LVL.LAST_UPDATE_DATE
, HR_GENERAL.START_OF_TIME)) LAST_CHANGE_DATE
FROM PER_COMPETENCES CMP
, PER_RATING_SCALES RSC
, PER_RATING_LEVELS LVL
WHERE RSC.TYPE (+) = 'PROFICIENCY'
AND CMP.RATING_SCALE_ID = RSC.RATING_SCALE_ID (+)
AND (CMP.RATING_SCALE_ID = LVL.RATING_SCALE_ID OR CMP.COMPETENCE_ID = LVL.COMPETENCE_ID) ) UNION ALL SELECT 1 ROW_INDICATOR
, 1 NO_LEVEL_INDICATOR
, TO_NUMBER(NULL) SCALE_LEVEL_VALUE
, TO_NUMBER(NULL) MIN_SCALE_LEVEL_VALUE
, TO_NUMBER(NULL) MAX_SCALE_LEVEL_VALUE
, TO_NUMBER(NULL) RANK_LEVEL_VALUE
, TO_NUMBER(NULL) MIN_RANK_LEVEL_VALUE
, TO_NUMBER(NULL) MAX_RANK_LEVEL_VALUE
, TO_NUMBER(NULL) NRMLZD_SCALE_LEVEL_VALUE
, TO_NUMBER(NULL) NRMLZD_RANK_LEVEL_VALUE
, CMP.COMPETENCE_ID COMPETENCE_ID
, NVL(CMP.RATING_SCALE_ID
, -1) SCALE_ID
, -1 LEVEL_ID
, NVL(CMP.EVALUATION_METHOD
, 'NA_EDW') CMPTNC_EVAL_MTHD_CODE
, CMP.RENEWAL_PERIOD_FREQUENCY CMPTNC_RNWL_PRD_FREQ_VALUE
, NVL(CMP.RENEWAL_PERIOD_UNITS
, 'NA_EDW') CMPTNC_RNWL_PRD_UNIT_CODE
, NVL(CMP.CERTIFICATION_REQUIRED
, 'N') CMPTNC_CERT_REQRD_FLAG_CODE
, NULL SCALE_FLAG_CODE
, NULL SCALE_DFLT_FLAG_CODE
, NVL(CMP.LAST_UPDATE_DATE
, HR_GENERAL.START_OF_TIME) LAST_CHANGE_DATE
FROM PER_COMPETENCES CMP WITH READ ONLY