[Home] [Help] [Dependency Information]
Object Name: | PA_EMP_BILL_RATE_OVERRIDES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_EMP_BILL_RATE_OVERRIDES |
Subobject Name: | |
Status: | VALID |
PA_EMP_BILL_RATE_OVERRIDES stores employee bill rates
that are negotiated for a project or task. An
employee bill rate override takes precedence over the
job bill rate and the employee's bill rate on the
standard bill rate schedule.
See the Bill Rate Precedence diagram in the Oracle
Projects User's Guide for more information.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_EMP_BILL_RATE_OVERRIDES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
TASK_ID PERSON_ID START_DATE_ACTIVE |
PA_EMP_BILL_RATE_OVERRIDES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EMP_BILL_RATE_OVERRIDE_ID |
PA_EMP_BILL_RATE_OVERRIDES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (9) | Yes | The identifier of the employee that will be billed according to the bill rate override |
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 |
RATE | NUMBER | (22) | The bill rate used to determine the item's revenue or bill amount. Revenue = bill rate * quantity | |
BILL_RATE_UNIT | VARCHAR2 | (30) | The code of the bill rate unit. This value is always 'HOURS' because 'HOURS' is the only unit supported for labor items | |
START_DATE_ACTIVE | DATE | Yes | First effective date of the bill rate | |
PROJECT_ID | NUMBER | (15) | The identifier of the project for which the bill rate override is entered | |
TASK_ID | NUMBER | (15) | The identifier of the task for which the bill rate override is entered | |
END_DATE_ACTIVE | DATE | Last effective date of the bill rate | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | Record version number. | |
EMP_BILL_RATE_OVERRIDE_ID | NUMBER | (15) | Yes | Uniqely identifies an employee bill rate override. |
RATE_CURRENCY_CODE | VARCHAR2 | (15) | Currency of the bill rate override. | |
DISCOUNT_PERCENTAGE | NUMBER | Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate | ||
RATE_DISC_REASON_CODE | VARCHAR2 | (30) | Reason code for dicount,discount override or rate override |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RATE
, BILL_RATE_UNIT
, START_DATE_ACTIVE
, PROJECT_ID
, TASK_ID
, END_DATE_ACTIVE
, RECORD_VERSION_NUMBER
, EMP_BILL_RATE_OVERRIDE_ID
, RATE_CURRENCY_CODE
, DISCOUNT_PERCENTAGE
, RATE_DISC_REASON_CODE
FROM PA.PA_EMP_BILL_RATE_OVERRIDES;
PA.PA_EMP_BILL_RATE_OVERRIDES does not reference any database object
PA.PA_EMP_BILL_RATE_OVERRIDES is referenced by following:
|
|
|