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


TABLE: HR.PAY_GRADE_RULES_F

Object Details
Object Name: PAY_GRADE_RULES_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_GRADE_RULES_F
Subobject Name:
Status: VALID


PAY_GRADE_RULES_F stores the actual values defined for grade rates or
pay scales. The RATE_TYPE indicates the type, G for Grade and SP for
Progression Point, (formerly known as Spinal Point). For a type of G,
the table can hold values for VALUE, MINIMUM and MAXIMUM. For a type
of SP, only the VALUE column is appropriate. The foreign key
GRADE_OR_SPINAL_POINT_ID references either PER_GRADES or
PER_SPINAL_POINTS according to RATE_TYPE. PAY_GRADE_RULES_F is a
DateTracked table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_GRADE_RULES_F_PK
  1. ColumnGRADE_RULE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PAY_GRADE_RULES_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_RULE_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PAY_GRADE_RULES_F_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PAY_GRADE_RULES_F_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRATE_ID
PAY_GRADE_RULES_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_OR_SPINAL_POINT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_GRADE_RULES_F PAY_GRADE_RULES_F_FK1 TableHR_ALL_ORGANIZATION_UNITS PAY_GRADE_RULES_F BUSINESS_GROUP_ID
PAY_GRADE_RULES_F PAY_GRADE_RULES_F_FK2 TablePAY_RATES PAY_GRADE_RULES_F RATE_ID
Columns
Name Datatype Length Mandatory Comments
GRADE_RULE_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.
RATE_ID NUMBER (15) Yes Foreign key to PAY_RATES.
GRADE_OR_SPINAL_POINT_ID NUMBER (15) Yes Foreign key either to grades or to progression points, depending on RATE_TYPE.
RATE_TYPE VARCHAR2 (30) Yes Indicates progression point (SP) or grade (G) rule.
MAXIMUM VARCHAR2 (20)
User defined maximum value.
MID_VALUE VARCHAR2 (20)
User defined mid value.
MINIMUM VARCHAR2 (20)
User defined minimum value.
SEQUENCE NUMBER (15)
Sequence denormalized from PER_GRADES when RATE_TYPE is grade.
VALUE VARCHAR2 (20)
User defined value.
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
CURRENCY_CODE VARCHAR2 (15)
Currency identifier
Query Text

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


SELECT GRADE_RULE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      RATE_ID
,      GRADE_OR_SPINAL_POINT_ID
,      RATE_TYPE
,      MAXIMUM
,      MID_VALUE
,      MINIMUM
,      SEQUENCE
,      VALUE
,      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
,      CURRENCY_CODE
FROM HR.PAY_GRADE_RULES_F;

Dependencies

[top of page]

HR.PAY_GRADE_RULES_F does not reference any database object

HR.PAY_GRADE_RULES_F is referenced by following:

SchemaHR
ViewPAY_GRADE_RULES_F#