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_GRADE_SPINES_F

Object Details

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

PER_GRADE_SPINES_F stores the relationship between a grade and a pay
scale, this is the grade scale. A pay scale, previously known as a p
arent spine, can be used for several different grades but a grade can
be associated with only one pay scale. The CEILING_STEP_ID holds the
highest step (from the pay scale) which can be used in this grade scal
e. PER_GRADE_SPINES_F is a DateTracked table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_GRADE_SPINES_F_PK

GRADE_SPINE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_GRADE_SPINES_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	GRADE_SPINE_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_GRADE_SPINES_F_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_GRADE_SPINES_F_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_SPINE_ID
PER_GRADE_SPINES_F_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_GRADE_SPINES_F	HR_ALL_ORGANIZATION_UNITS	PER_GRADE_SPINES_F BUSINESS_GROUP_ID
PER_GRADE_SPINES_F	PER_GRADES	PER_GRADE_SPINES_F GRADE_ID
PER_GRADE_SPINES_F	PER_PARENT_SPINES	PER_GRADE_SPINES_F PARENT_SPINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GRADE_SPINE_ID	NUMBER	(15)	Yes	System-generated primary key column.
EFFECTIVE_START_DATE	DATE		Yes	Effective start date.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
PARENT_SPINE_ID	NUMBER	(15)	Yes	Foreign key to PER_PARENT_SPINES.
GRADE_ID	NUMBER	(15)	Yes	Foreign key to PER_GRADES.
CEILING_STEP_ID	NUMBER	(15)		Foreign key to PER_SPINAL_POINTS.
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.
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
STARTING_STEP	NUMBER	(15)		Starting Step

Query Text

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


SELECT GRADE_SPINE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PARENT_SPINE_ID
,      GRADE_ID
,      CEILING_STEP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      STARTING_STEP
FROM HR.PER_GRADE_SPINES_F;

Dependencies

[top of page]

HR.PER_GRADE_SPINES_F does not reference any database object

HR.PER_GRADE_SPINES_F is referenced by following:

HR: PER_GRADE_SPINES_F#