DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HRI_CS_CMPTNC_LVL_V

Object Details
Object Name: HRI_CS_CMPTNC_LVL_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Creates a structure of Competence and Competence Levels.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_INDICATOR NUMBER

NO_LEVEL_INDICATOR NUMBER

SCALE_LEVEL_VALUE NUMBER

MIN_SCALE_LEVEL_VALUE NUMBER

MAX_SCALE_LEVEL_VALUE NUMBER

RANK_LEVEL_VALUE NUMBER

MIN_RANK_LEVEL_VALUE NUMBER

MAX_RANK_LEVEL_VALUE NUMBER

NRMLZD_SCALE_LEVEL_VALUE NUMBER

NRMLZD_RANK_LEVEL_VALUE NUMBER

COMPETENCE_ID NUMBER (15)
SCALE_ID NUMBER

LEVEL_ID NUMBER

CMPTNC_EVAL_MTHD_CODE VARCHAR2 (30)
CMPTNC_RNWL_PRD_FREQ_VALUE NUMBER (11)
CMPTNC_RNWL_PRD_UNIT_CODE VARCHAR2 (30)
CMPTNC_CERT_REQRD_FLAG_CODE VARCHAR2 (30)
SCALE_FLAG_CODE VARCHAR2 (1)
SCALE_DFLT_FLAG_CODE VARCHAR2 (30)
LAST_CHANGE_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_INDICATOR
,      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
,      NRMLZD_SCALE_LEVEL_VALUE
,      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 APPS.HRI_CS_CMPTNC_LVL_V;

Dependencies

[top of page]

APPS.HRI_CS_CMPTNC_LVL_V references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymPER_COMPETENCES
SynonymPER_RATING_LEVELS
SynonymPER_RATING_SCALES

APPS.HRI_CS_CMPTNC_LVL_V is not referenced by any database object