[Home] [Help] [Dependency Information]

TABLE: HR.PER_GRADES

Object Details

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

PER_GRADES stores grade definitions. The NAME is the concatenation of
key flexfield segments and is generated when the grade is defined.
Grades are used to show the level or rank of an employee in an
assignment, and may be related to job or position by the definition of
valid grades. They are often used to specify element eligibility
rules. The DATE_FROM and DATE_TO columns define the date limits for
using grades in the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_GRADES_PK

1. GRADE_ID

Unique Key: PER_GRADES_UK2

1. NAME
2. BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_GRADES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRADE_ID
PER_GRADES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME BUSINESS_GROUP_ID
PER_GRADES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_GRADES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_DEFINITION_ID
PER_GRADES_NK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHORT_NAME BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PER_GRADES		HR_ALL_ORGANIZATION_UNITS	PER_GRADES BUSINESS_GROUP_ID
PER_GRADES		PER_GRADE_DEFINITIONS	PER_GRADES GRADE_DEFINITION_ID
GHR_PA_REQUESTS		PER_GRADES	GHR_PA_REQUESTS TO_GRADE_ID
HR_ALL_POSITIONS_F		PER_GRADES	HR_ALL_POSITIONS_F ENTRY_GRADE_ID
PAY_ELEMENT_LINKS_F		PER_GRADES	PAY_ELEMENT_LINKS_F GRADE_ID
PER_ALL_ASSIGNMENTS_F		PER_GRADES	PER_ALL_ASSIGNMENTS_F GRADE_ID
PER_ALL_VACANCIES		PER_GRADES	PER_ALL_VACANCIES GRADE_ID
PER_BUDGET_ELEMENTS		PER_GRADES	PER_BUDGET_ELEMENTS GRADE_ID
PER_GRADE_SPINES_F		PER_GRADES	PER_GRADE_SPINES_F GRADE_ID
PER_MM_ASSIGNMENTS		PER_GRADES	PER_MM_ASSIGNMENTS GRADE_ID
PER_MM_VALID_GRADES		PER_GRADES	PER_MM_VALID_GRADES TARGET_GRADE_ID
PER_SALARY_SURVEY_MAPPINGS		PER_GRADES	PER_SALARY_SURVEY_MAPPINGS GRADE_ID
PER_VALID_GRADES		PER_GRADES	PER_VALID_GRADES GRADE_ID
PQH_BUDGET_DETAILS		PER_GRADES	PQH_BUDGET_DETAILS GRADE_ID
PQH_POSITION_TRANSACTIONS		PER_GRADES	PQH_POSITION_TRANSACTIONS ENTRY_GRADE_ID
PQH_WORKSHEET_DETAILS		PER_GRADES	PQH_WORKSHEET_DETAILS GRADE_ID

Columns

Query Text

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

SELECT GRADE_ID
,      BUSINESS_GROUP_ID
,      GRADE_DEFINITION_ID
,      DATE_FROM
,      SEQUENCE
,      DATE_TO
,      NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      OBJECT_VERSION_NUMBER
,      COMMENTS
,      SHORT_NAME
FROM HR.PER_GRADES;

Dependencies

[top of page]

HR.PER_GRADES does not reference any database object

HR.PER_GRADES is referenced by following:

APPS

PER_GRADES

PER_GRADES_WHO

PUBLIC

PER_GRADES