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.

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

TABLE: HRI.HRI_CS_CMPTNC_LVL_CT

Object Details

Object Name:	HRI_CS_CMPTNC_LVL_CT
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_CS_CMPTNC_LVL_CT_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	COMPETENCE_ID LEVEL_ID

Columns

Name	Datatype	Length	Comments
ROW_INDICATOR	NUMBER		Row Indicator
NO_LEVEL_INDICATOR	NUMBER		No Level Indictor
SCALE_LEVEL_VALUE	NUMBER		Scale Level Value
MIN_SCALE_LEVEL_VALUE	NUMBER		Min Scale Level Value
MAX_SCALE_LEVEL_VALUE	NUMBER		Max Scale Level Value
RANK_LEVEL_VALUE	NUMBER		Rank Level Value
MIN_RANK_LEVEL_VALUE	NUMBER		Min Rank Level Value
MAX_RANK_LEVEL_VALUE	NUMBER		Max Rank Level Value
NRMLZD_SCALE_LEVEL_VALUE	NUMBER		Normalized Scale Level Value
NRMLZD_RANK_LEVEL_VALUE	NUMBER		Normalized Rank Level Value
COMPETENCE_ID	NUMBER		Competence Id
SCALE_ID	NUMBER		Scale Id
LEVEL_ID	NUMBER		Level Id
CMPTNC_EVAL_MTHD_CODE	VARCHAR2	(30)	Competence Evaluation Method Code
CMPTNC_RNWL_PRD_FREQ_VALUE	NUMBER		Competence renewal period freuency
CMPTNC_RNWL_PRD_UNIT_CODE	VARCHAR2	(30)	Competence renewal period unit
CMPTNC_CERT_REQRD_FLAG_CODE	VARCHAR2	(30)	Certification required
SCALE_FLAG_CODE	VARCHAR2	(1)	Scale flag code
SCALE_DFLT_FLAG_CODE	VARCHAR2	(30)	Scale default flag code
LAST_CHANGE_DATE	DATE		Last change 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 HRI.HRI_CS_CMPTNC_LVL_CT;

Dependencies

[top of page]

HRI.HRI_CS_CMPTNC_LVL_CT does not reference any database object

HRI.HRI_CS_CMPTNC_LVL_CT is referenced by following:

APPS: HRI_CS_CMPTNC_LVL_CT