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


TABLE: HR.PER_VALID_GRADES

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


PER_VALID_GRADES stores valid grades for positions and/or valid grades
for jobs. This information is used to give users a warning message if
the grade is not in the list of valid grades for the job or position
on entry or change of an employee assignment. Each PER_VALID_GRADES
row has either a JOB_ID, or a POSITION_ID, but not both.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_VALID_GRADES_PK
  1. ColumnVALID_GRADE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_VALID_GRADES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVALID_GRADE_ID
SYS_IL0000043448C00039$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PER_VALID_GRADES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_VALID_GRADES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_ID
PER_VALID_GRADES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PER_VALID_GRADES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_VALID_GRADES PER_VALID_GRADES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_VALID_GRADES BUSINESS_GROUP_ID
PER_VALID_GRADES PER_VALID_GRADES_FK2 TablePER_GRADES PER_VALID_GRADES GRADE_ID
PER_VALID_GRADES PER_VALID_GRADES_FK50 TablePER_JOBS PER_VALID_GRADES JOB_ID
TablePER_COMPETENCE_ELEMENTS PER_COMPETENCE_ELEMENTS_FK19 PER_VALID_GRADES PER_COMPETENCE_ELEMENTS VALID_GRADE_ID
Columns
Name Datatype Length Mandatory Comments
VALID_GRADE_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
GRADE_ID NUMBER (15) Yes Foreign key to PER_GRADES.
DATE_FROM DATE
Yes First date on which the grade is valid for the job or position.
DATE_TO DATE

The last date on which the grade is valid for the job or position.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
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.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
COMMENTS CLOB (4000)
General remark.
Query Text

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


SELECT VALID_GRADE_ID
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      DATE_FROM
,      DATE_TO
,      JOB_ID
,      POSITION_ID
,      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
,      OBJECT_VERSION_NUMBER
,      COMMENTS
FROM HR.PER_VALID_GRADES;

Dependencies

[top of page]

HR.PER_VALID_GRADES does not reference any database object

HR.PER_VALID_GRADES is referenced by following:

SchemaHR
ViewPER_VALID_GRADES#