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

Object Details

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

PER_CAGR_GRADES holds the grades which exist within a Collective Agreement. They act as a reference set of collectively agreed grades which will be used by an assignment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_CAGR_GRADES_PK

CAGR_GRADE_ID

Unique Key: PER_CAGR_GRADES_UK1

CAGR_GRADE_STRUCTURE_ID
CAGR_GRADE_DEF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_CAGR_GRADES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAGR_GRADE_ID
PER_CAGR_GRADES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAGR_GRADE_STRUCTURE_ID CAGR_GRADE_DEF_ID
PER_CAGR_GRADES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAGR_GRADE_DEF_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_CAGR_GRADES		PER_CAGR_GRADES_DEF	PER_CAGR_GRADES CAGR_GRADE_DEF_ID
PER_CAGR_GRADES		PER_CAGR_GRADE_STRUCTURES	PER_CAGR_GRADES CAGR_GRADE_STRUCTURE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CAGR_GRADE_ID	NUMBER	(15)	Yes	System generated primary key from PER_CAGR_GRADES_S
CAGR_GRADE_STRUCTURE_ID	NUMBER	(15)	Yes	Foreign key to PER_CAGR_GRADE_STRUCTURES
CAGR_GRADE_DEF_ID	NUMBER	(15)	Yes	Foreign key to PER_CAGR_GRADES_DEF
SEQUENCE	NUMBER	(15)		Sequence number of the grade within the structure
OBJECT_VERSION_NUMBER	NUMBER	(15)		System-generated version of row. Increments by one with each update
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

Query Text

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


SELECT CAGR_GRADE_ID
,      CAGR_GRADE_STRUCTURE_ID
,      CAGR_GRADE_DEF_ID
,      SEQUENCE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_CAGR_GRADES;

Dependencies

[top of page]

HR.PER_CAGR_GRADES does not reference any database object

HR.PER_CAGR_GRADES is referenced by following:

HR: PER_CAGR_GRADES#