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

TABLE: HR.PER_GRADE_DEFINITIONS

Object Details
Object Name: PER_GRADE_DEFINITIONS
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_GRADE_DEFINITIONS
Subobject Name:
Status: VALID


PER_GRADE_DEFINITIONS is a key flexfield combinations table. It
stores segment combinations for grades that are stored in PER_GRADES.
Oracle Applications do not support code combination IDs that exceed 2,
000,000,000.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_GRADE_DEFINITIONS_PK
  1. ColumnGRADE_DEFINITION_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_GRADE_DEFINITIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_DEFINITION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TablePER_GRADES PER_GRADES_FK2 PER_GRADE_DEFINITIONS PER_GRADES GRADE_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
GRADE_DEFINITION_ID NUMBER (15) Yes System-generated primary key column.
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.
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 before which key flexfield combination is invalid.
END_DATE_ACTIVE DATE

Date after which key flexfield combination is invalid.
SEGMENT1 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT2 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT3 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT4 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT5 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT6 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT7 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT8 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT9 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT10 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT11 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT12 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT13 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT14 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT15 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT16 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT17 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT18 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT19 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT20 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT21 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT22 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT23 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT24 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT25 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT26 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT27 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT28 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT29 VARCHAR2 (60)
Key flexfield segment column.
SEGMENT30 VARCHAR2 (60)
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.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number used by HRMS for locking purposes
Query Text

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


SELECT GRADE_DEFINITION_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
FROM HR.PER_GRADE_DEFINITIONS;

Dependencies

[top of page]

HR.PER_GRADE_DEFINITIONS does not reference any database object

HR.PER_GRADE_DEFINITIONS is referenced by following:

SchemaAPPS
SynonymPER_GRADE_DEFINITIONS
TriggerPER_GRADE_DEFINITIONS_WHO
SchemaPUBLIC
SynonymPER_GRADE_DEFINITIONS