[Home] [Help] [Dependency Information]
Object Name: | PA_JOB_ASSIGNMENT_OVERRIDES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_JOB_ASSIGNMENT_OVERRIDES |
Subobject Name: | |
Status: | VALID |
PA_JOB_ASSIGNMENT_OVERRIDES stores special employee
job assignments and/or billing titles that are
negotiated for specific projects or tasks. A job
assignment or billing title override takes precedence
over an employee's primary job title.
If job bill rates are used on a project, the Generate
Draft Revenue process uses the job assignment override
to calculate revenue instead of an employee's primary
job assignment. Also, the Generate Draft Invoice
process displays the billing title override and the
job title of the job assignment override on an invoice
line, providing that the invoice format for that
project invoice displays job and billing titles.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_JOB_ASSIGNMENT_OVERRIDES_U4 | NORMAL | UNIQUE | APPS_TS_TX_IDX | JOB_ASSIGNMENT_OVERRIDE_ID |
PA_JOB_ASSIGNMENT_OVERRIDES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
PERSON_ID |
PA_JOB_ASSIGNMENT_OVERRIDES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TASK_ID
PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (9) | Yes | The identifier of the employee that will be billed according to the job assignment 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 |
START_DATE_ACTIVE | DATE | Yes | First effective date of the job assignment override | |
PROJECT_ID | NUMBER | (15) | The identifier of the project for which the job assignment override is entered | |
TASK_ID | NUMBER | (15) | The identifier of the task for which the job assignment override is entered | |
JOB_ID | NUMBER | (15) | The identifier of the job that overrides the employee's primary job assignment | |
BILLING_TITLE | VARCHAR2 | (80) | The employee billing title override for the employee | |
END_DATE_ACTIVE | DATE | Last effective date of the job assignment override | ||
RECORD_VERSION_NUMBER | NUMBER | (15) | Record version number. | |
JOB_ASSIGNMENT_OVERRIDE_ID | NUMBER | (15) | Yes | Uniqely identifies a job assignment 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
, START_DATE_ACTIVE
, PROJECT_ID
, TASK_ID
, JOB_ID
, BILLING_TITLE
, END_DATE_ACTIVE
, RECORD_VERSION_NUMBER
, JOB_ASSIGNMENT_OVERRIDE_ID
FROM PA.PA_JOB_ASSIGNMENT_OVERRIDES;
PA.PA_JOB_ASSIGNMENT_OVERRIDES does not reference any database object
PA.PA_JOB_ASSIGNMENT_OVERRIDES is referenced by following:
|
|
|