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: HR.PER_CAGR_GRADES_DEF

Object Details

Object Name:	PER_CAGR_GRADES_DEF
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_CAGR_GRADES_DEF
Subobject Name:
Status:	VALID

PER_CAGR_GRADES_DEF is a key flexfield combinations table. It stores segment combinations for collectively agreed grades that are stored in PER_CAGR_GRADES.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_CAGR_GRADES_DEF_PK

CAGR_GRADE_DEF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_CAGR_GRADES_DEF_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAGR_GRADE_DEF_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_ALL_ASSIGNMENTS_F		PER_CAGR_GRADES_DEF	PER_ALL_ASSIGNMENTS_F CAGR_GRADE_DEF_ID
PER_CAGR_GRADES		PER_CAGR_GRADES_DEF	PER_CAGR_GRADES CAGR_GRADE_DEF_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CAGR_GRADE_DEF_ID	NUMBER	(15)	Yes	System-generated primary key using sequence PER_CAGR_GRADES_DEF_S
ID_FLEX_NUM	NUMBER	(15)	Yes	Key flexfield structure foreign key
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Key flexfield summary flag
ENABLED_FLAG	VARCHAR2	(1)	Yes	Key flexfield enabled flag
START_DATE_ACTIVE	DATE			Date the key flexfield combination becomes active or valid
END_DATE_ACTIVE	DATE			Date the key flexfield combination becomes inactive or invalid
SEGMENT1	VARCHAR2	(150)		Key flexfield segment column
SEGMENT2	VARCHAR2	(150)		Key flexfield segment column
SEGMENT3	VARCHAR2	(150)		Key flexfield segment column
SEGMENT4	VARCHAR2	(150)		Key flexfield segment column
SEGMENT5	VARCHAR2	(150)		Key flexfield segment column
SEGMENT6	VARCHAR2	(150)		Key flexfield segment column
SEGMENT7	VARCHAR2	(150)		Key flexfield segment column
SEGMENT8	VARCHAR2	(150)		Key flexfield segment column
SEGMENT9	VARCHAR2	(150)		Key flexfield segment column
SEGMENT10	VARCHAR2	(150)		Key flexfield segment column
SEGMENT11	VARCHAR2	(150)		Key flexfield segment column
SEGMENT12	VARCHAR2	(150)		Key flexfield segment column
SEGMENT13	VARCHAR2	(150)		Key flexfield segment column
SEGMENT14	VARCHAR2	(150)		Key flexfield segment column
SEGMENT15	VARCHAR2	(150)		Key flexfield segment column
SEGMENT16	VARCHAR2	(150)		Key flexfield segment column
SEGMENT17	VARCHAR2	(150)		Key flexfield segment column
SEGMENT18	VARCHAR2	(150)		Key flexfield segment column
SEGMENT19	VARCHAR2	(150)		Key flexfield segment column
SEGMENT20	VARCHAR2	(150)		Key flexfield segment column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
CONCATENATED_SEGMENTS	VARCHAR2	(2000)		Concatination of all selected segments

Query Text

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


SELECT CAGR_GRADE_DEF_ID
,      ID_FLEX_NUM
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CONCATENATED_SEGMENTS
FROM HR.PER_CAGR_GRADES_DEF;

Dependencies

[top of page]

HR.PER_CAGR_GRADES_DEF does not reference any database object

HR.PER_CAGR_GRADES_DEF is referenced by following:

HR: PER_CAGR_GRADES_DEF#