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


TABLE: HR.PER_PAY_BASES

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


PER_PAY_BASES holds the definitions of a specific salary basis. Each
salary basis is defined for a specific measure of time, for example,
weekly, bi-weekly, monthly, annual. An employee is linked to a salary
basis in PER_ALL_ASSIGNMENTS_F.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_PAY_BASES_PK
  1. ColumnPAY_BASIS_ID
Unique Key: PER_PAY_BASES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Unique Key: PER_PAY_BASES_UK3
  1. ColumnINPUT_VALUE_ID
  2. ColumnRATE_ID
  3. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_PAY_BASES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_BASIS_ID
PER_PAY_BASES_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
PER_PAY_BASES_UK3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINPUT_VALUE_ID
ColumnRATE_ID
ColumnBUSINESS_GROUP_ID
PER_PAY_BASES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRATE_ID
PER_PAY_BASES_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_PAY_BASES PER_PAY_BASES_FK3 TableHR_ALL_ORGANIZATION_UNITS PER_PAY_BASES BUSINESS_GROUP_ID
PER_PAY_BASES PER_PAY_BASES_FK2 TablePAY_RATES PER_PAY_BASES RATE_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK16 PER_PAY_BASES HR_ALL_POSITIONS_F PAY_BASIS_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK13 PER_PAY_BASES PAY_ELEMENT_LINKS_F PAY_BASIS_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK19 PER_PAY_BASES PER_ALL_ASSIGNMENTS_F PAY_BASIS_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK16 PER_PAY_BASES PQH_POSITION_TRANSACTIONS PAY_BASIS_ID
Columns
Name Datatype Length Mandatory Comments
PAY_BASIS_ID NUMBER (9) Yes System-generated primary key column.
INPUT_VALUE_ID NUMBER (9) Yes Foreign key to PAY_INPUT_VALUES_F. Identifies the input value to use for salary administration under this basis.
RATE_ID NUMBER (15)
Foreign key to PAY_RATES. Identifies the pay rate to use to validate salary values.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
NAME VARCHAR2 (30) Yes Name of the pay basis.
PAY_BASIS VARCHAR2 (30) Yes Time basis for recording actual salary values, for example, annual, monthly, hourly.
RATE_BASIS VARCHAR2 (30)
Time basis for the related grade rate values. Must be the same as PAY_BASIS.
ANNUALIZED_HOURS NUMBER

This column is obsolete.
PAY_ANNUALIZATION_FACTOR NUMBER

This is the factor by which the salary must multiplied to get an annual salary.
GRADE_ANNUALIZATION_FACTOR NUMBER

The factor by which the grade range must be multiplied to obtain an annual grade range.
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 (150)
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 used by HRMS for locking purposes
COMMENTS LONG (0)
General remark.
Query Text

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


SELECT PAY_BASIS_ID
,      INPUT_VALUE_ID
,      RATE_ID
,      BUSINESS_GROUP_ID
,      NAME
,      PAY_BASIS
,      RATE_BASIS
,      ANNUALIZED_HOURS
,      PAY_ANNUALIZATION_FACTOR
,      GRADE_ANNUALIZATION_FACTOR
,      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
FROM HR.PER_PAY_BASES;

Dependencies

[top of page]

HR.PER_PAY_BASES does not reference any database object

HR.PER_PAY_BASES is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_SUP_WRKFC_JX_MV
Materialized ViewHR_MBS_WRKFC_JCX_MV
Materialized ViewHR_MBS_WRKFC_JCX_SUPH_MV
SynonymPER_PAY_BASES
TriggerPER_PAY_BASES_WHO
SchemaPUBLIC
SynonymPER_PAY_BASES