VIEW: HRI.HRI_CS_CMPTNC_LVL_CT#

Source

View Text - Preformatted

select ROW_INDICATOR ROW_INDICATOR, NO_LEVEL_INDICATOR NO_LEVEL_INDICATOR, SCALE_LEVEL_VALUE SCALE_LEVEL_VALUE, MIN_SCALE_LEVEL_VALUE MIN_SCALE_LEVEL_VALUE, MAX_SCALE_LEVEL_VALUE MAX_SCALE_LEVEL_VALUE, RANK_LEVEL_VALUE RANK_LEVEL_VALUE, MIN_RANK_LEVEL_VALUE MIN_RANK_LEVEL_VALUE, MAX_RANK_LEVEL_VALUE MAX_RANK_LEVEL_VALUE, NRMLZD_SCALE_LEVEL_VALUE NRMLZD_SCALE_LEVEL_VALUE, NRMLZD_RANK_LEVEL_VALUE NRMLZD_RANK_LEVEL_VALUE, COMPETENCE_ID COMPETENCE_ID, SCALE_ID SCALE_ID, LEVEL_ID LEVEL_ID, CMPTNC_EVAL_MTHD_CODE CMPTNC_EVAL_MTHD_CODE, CMPTNC_RNWL_PRD_FREQ_VALUE CMPTNC_RNWL_PRD_FREQ_VALUE, CMPTNC_RNWL_PRD_UNIT_CODE CMPTNC_RNWL_PRD_UNIT_CODE, CMPTNC_CERT_REQRD_FLAG_CODE CMPTNC_CERT_REQRD_FLAG_CODE, SCALE_FLAG_CODE SCALE_FLAG_CODE, SCALE_DFLT_FLAG_CODE SCALE_DFLT_FLAG_CODE, LAST_CHANGE_DATE LAST_CHANGE_DATE from "HRI"."HRI_CS_CMPTNC_LVL_CT"

View Text - HTML Formatted

SELECT ROW_INDICATOR ROW_INDICATOR
, NO_LEVEL_INDICATOR NO_LEVEL_INDICATOR
, SCALE_LEVEL_VALUE SCALE_LEVEL_VALUE
, MIN_SCALE_LEVEL_VALUE MIN_SCALE_LEVEL_VALUE
, MAX_SCALE_LEVEL_VALUE MAX_SCALE_LEVEL_VALUE
, RANK_LEVEL_VALUE RANK_LEVEL_VALUE
, MIN_RANK_LEVEL_VALUE MIN_RANK_LEVEL_VALUE
, MAX_RANK_LEVEL_VALUE MAX_RANK_LEVEL_VALUE
, NRMLZD_SCALE_LEVEL_VALUE NRMLZD_SCALE_LEVEL_VALUE
, NRMLZD_RANK_LEVEL_VALUE NRMLZD_RANK_LEVEL_VALUE
, COMPETENCE_ID COMPETENCE_ID
, SCALE_ID SCALE_ID
, LEVEL_ID LEVEL_ID
, CMPTNC_EVAL_MTHD_CODE CMPTNC_EVAL_MTHD_CODE
, CMPTNC_RNWL_PRD_FREQ_VALUE CMPTNC_RNWL_PRD_FREQ_VALUE
, CMPTNC_RNWL_PRD_UNIT_CODE CMPTNC_RNWL_PRD_UNIT_CODE
, CMPTNC_CERT_REQRD_FLAG_CODE CMPTNC_CERT_REQRD_FLAG_CODE
, SCALE_FLAG_CODE SCALE_FLAG_CODE
, SCALE_DFLT_FLAG_CODE SCALE_DFLT_FLAG_CODE
, LAST_CHANGE_DATE LAST_CHANGE_DATE
FROM "HRI"."HRI_CS_CMPTNC_LVL_CT"