[Home] [Help] [Dependency Information]
Object Name: | PA_COMPENSATION_DETAILS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_COMPENSATION_DETAILS_ALL |
Subobject Name: | |
Status: | VALID |
PA_COMPENSATION_DETAILS_ALL stores hourly cost rates
and compensation rules for employees.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_COMPENSATION_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
START_DATE_ACTIVE ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (9) | Yes | The identifier of the employee for which the compensation detail is entered |
COMPENSATION_RULE_SET | VARCHAR2 | (20) | The compensation rule which indicates how the employee is compensated, particularly for overtime hours | |
START_DATE_ACTIVE | DATE | Yes | First effective date of the compensation detail | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
HOURLY_COST_RATE | NUMBER | The hourly rate for the employee used in labor costing | ||
END_DATE_ACTIVE | DATE | Last effective date of the compensation detail | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
OVERRIDE_TYPE | VARCHAR2 | (150) | Yes | Type of override |
RATE_SCHEDULE_ID | NUMBER | (15) | The cost rate schedule that defines cost rates for the selected employee. | |
COST_RATE_CURRENCY_CODE | VARCHAR2 | (150) | Currency code for the cost rate | |
ACCT_RATE_DATE_CODE | VARCHAR2 | (150) | Functional Rate Date override for currency conversion. | |
ACCT_RATE_TYPE | VARCHAR2 | (150) | Functional Rate Type override for currency conversion. | |
ACCT_EXCHANGE_RATE | NUMBER | Exchange rate used for currency conversion | ||
BASE_HOURS | NUMBER | (15) | Number of hours that are used to enable accounting for uncompensated overtime hours. | |
RBC_ELEMENT_TYPE_ID | NUMBER | (9) | Pay element identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, COMPENSATION_RULE_SET
, START_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, HOURLY_COST_RATE
, END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ORG_ID
, OVERRIDE_TYPE
, RATE_SCHEDULE_ID
, COST_RATE_CURRENCY_CODE
, ACCT_RATE_DATE_CODE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, BASE_HOURS
, RBC_ELEMENT_TYPE_ID
FROM PA.PA_COMPENSATION_DETAILS_ALL;
PA.PA_COMPENSATION_DETAILS_ALL does not reference any database object
PA.PA_COMPENSATION_DETAILS_ALL is referenced by following:
|
|
|