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


TABLE: HR.PER_GRADES

Object Details
Object Name: PER_GRADES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_GRADES_PK
  1. ColumnGRADE_ID
Unique Key: PER_GRADES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_GRADES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_ID
PER_GRADES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
PER_GRADES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_GRADES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_DEFINITION_ID
PER_GRADES_NK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHORT_NAME
ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_GRADES PER_GRADES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_GRADES BUSINESS_GROUP_ID
PER_GRADES PER_GRADES_FK2 TablePER_GRADE_DEFINITIONS PER_GRADES GRADE_DEFINITION_ID
TableGHR_PA_REQUESTS GHR_PA_REQUESTS_FK7 PER_GRADES GHR_PA_REQUESTS TO_GRADE_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK11 PER_GRADES HR_ALL_POSITIONS_F ENTRY_GRADE_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK9 PER_GRADES PAY_ELEMENT_LINKS_F GRADE_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK3 PER_GRADES PER_ALL_ASSIGNMENTS_F GRADE_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK4 PER_GRADES PER_ALL_VACANCIES GRADE_ID
TablePER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK2 PER_GRADES PER_BUDGET_ELEMENTS GRADE_ID
TablePER_GRADE_SPINES_F PER_GRADE_SPINES_F_FK3 PER_GRADES PER_GRADE_SPINES_F GRADE_ID
TablePER_MM_ASSIGNMENTS PER_MM_ASSIGNMENTS_FK3 PER_GRADES PER_MM_ASSIGNMENTS GRADE_ID
TablePER_MM_VALID_GRADES PER_MM_VALID_GRADES_FK3 PER_GRADES PER_MM_VALID_GRADES TARGET_GRADE_ID
TablePER_SALARY_SURVEY_MAPPINGS PER_SURVEY_MAPPINGS_FK3 PER_GRADES PER_SALARY_SURVEY_MAPPINGS GRADE_ID
TablePER_VALID_GRADES PER_VALID_GRADES_FK2 PER_GRADES PER_VALID_GRADES GRADE_ID
TablePQH_BUDGET_DETAILS PQH_BUDGET_DETAILS_FK5 PER_GRADES PQH_BUDGET_DETAILS GRADE_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK11 PER_GRADES PQH_POSITION_TRANSACTIONS ENTRY_GRADE_ID
TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK6 PER_GRADES PQH_WORKSHEET_DETAILS GRADE_ID
Columns
Name Datatype Length Mandatory Comments
GRADE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
GRADE_DEFINITION_ID NUMBER (15) Yes Foreign key to PER_GRADE_DEFINITIONS.
DATE_FROM DATE
Yes The date on which the grade becomes effective.
SEQUENCE NUMBER (15) Yes Sequence number for the grade. Used for ordering a list of grades.
DATE_TO DATE

The date after which the grade is no longer effective.
NAME VARCHAR2 (240)
Grade name.
REQUEST_ID NUMBER (15)
Standard Who Column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who Column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield 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.
INFORMATION_CATEGORY VARCHAR2 (30)
Developer Descriptive Flexfield Column
INFORMATION1 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION2 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION3 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION4 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION5 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION6 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION7 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION8 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION9 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION10 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION11 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION12 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION13 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION14 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION15 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION16 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION17 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION18 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION19 VARCHAR2 (150)
Developer Descriptive Flexfield Column
INFORMATION20 VARCHAR2 (150)
Developer Descriptive Flexfield Column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number column used for HRMS locking purposes
COMMENTS LONG (0)
General remark.
SHORT_NAME VARCHAR2 (30)
Short Name
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:

SchemaAPPS
SynonymPER_GRADES
TriggerPER_GRADES_WHO
SchemaPUBLIC
SynonymPER_GRADES