[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_ASSIGNMENTS_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_ASSIGNMENTS_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
PA_ASSIGNMENTS_HISTORY stores details on all approved assignments for a project.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_ASSIGNMENTS_HISTORY_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ASSIGNMENT_ID
CHANGE_ID
|
| PA_ASSIGNMENTS_HISTORY_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ASSIGNMENT_ID
LAST_APPROVED_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | Yes | The system-generated number that uniquely identifies the assignment | |
| ASSIGNMENT_NAME | VARCHAR2 | (80) | Yes | The user-defined name that identifies the assignment |
| ASSIGNMENT_TYPE | VARCHAR2 | (30) | Yes | Indicates whether it is a assignment |
| MULTIPLE_STATUS_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the underlying schedule for the assignment has more than one status |
| RECORD_VERSION_NUMBER | NUMBER | Yes | Indicates the version of the assignment record. The column increments by one upon each saved modification to the assignment record. | |
| CHANGE_ID | NUMBER | Yes | ID to show the order of the changes made | |
| APPRVL_STATUS_CODE | VARCHAR2 | (30) | Indicates the approval status of the assignment. | |
| STATUS_CODE | VARCHAR2 | (30) | Indicate the schedule status of the assignment. This column may be null if the underlying schedule has multiple status codes. | |
| PROJECT_ID | NUMBER | The identifier of the project to which this assignment belongs | ||
| PROJECT_ROLE_ID | NUMBER | The identifier of the project role for the assignment | ||
| RESOURCE_ID | NUMBER | The identifier of the project resource | ||
| PROJECT_PARTY_ID | NUMBER | The identifier of the project party on an assignment | ||
| DESCRIPTION | VARCHAR2 | (2000) | The free text description of the assignment | |
| NOTE_TO_APPROVER | VARCHAR2 | (240) | The descriptive reason for modification | |
| START_DATE | DATE | The start date of the assignment | ||
| END_DATE | DATE | The end date of the assignment | ||
| ASSIGNMENT_EFFORT | NUMBER | (15) | Total number of hours of the assignment | |
| EXTENSION_POSSIBLE | VARCHAR2 | (1) | Indicates whether it is possible to extend the assignment | |
| SOURCE_ASSIGNMENT_ID | NUMBER | Identifies the requirement from which the assignment record originated | ||
| ASSIGNMENT_TEMPLATE_ID | NUMBER | The identifier of the requirement template to which this requirement belongs | ||
| MIN_RESOURCE_JOB_LEVEL | NUMBER | Indicates the minimum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup. | ||
| MAX_RESOURCE_JOB_LEVEL | NUMBER | Indicates the maximum acceptable job level for a requirement. The default value for this column on new requirement records is retrieved from the project role setup. | ||
| ASSIGNMENT_NUMBER | NUMBER | A reference number that uniquely identifies a requirement | ||
| ADDITIONAL_INFORMATION | VARCHAR2 | (2000) | The free text for additional information on a assignment | |
| WORK_TYPE_ID | NUMBER | Identifies the type of work being carried out. The default value for this column is retrieved from the project for both requirements and assignments not created from a requirement. | ||
| REVENUE_CURRENCY_CODE | VARCHAR2 | (15) | Identifies the currency of the override revenue bill rate. The default value is the project currency. | |
| REVENUE_BILL_RATE | NUMBER | The overriding revenue rate for the assignment | ||
| EXPENSE_OWNER | VARCHAR2 | (30) | The owner of the expenses for the assignment | |
| EXPENSE_LIMIT | NUMBER | (15) | The maximum amount that expense owner is willing to pay | |
| EXPENSE_LIMIT_CURRENCY_CODE | VARCHAR2 | (15) | The currency code of the expense limit | |
| FCST_TP_AMOUNT_TYPE | VARCHAR2 | (30) | Indicates whether the assignment is classified as cost transfer or revenue transfer for forecasting | |
| FCST_JOB_ID | NUMBER | The identifier for the job for the forecast of the requirement. This column would be used to determine cost, revenue, and transfer price rates for the requirement during forecast processing. | ||
| FCST_JOB_GROUP_ID | NUMBER | Indicates the job group associated with the forecasting job. This value defaults from the Team Role. | ||
| EXPENDITURE_ORG_ID | NUMBER | Indicates the default operating unit for requirements and assignments. For assignments, this value represents the operating unit of the assigned resource. | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | Indicates the expenditure organization for the assignment. It defaults to the project organization for requirements and to the resource organization for assignments. | ||
| EXPENDITURE_TYPE_CLASS | VARCHAR2 | (30) | Identifies the Expenditure Type Class to use to generate forecast transactions. This value defaults from Forecasting Options. | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Identifies the expenditure type that will be used for this team role for generating forecast transactions. This value defaults from the Forecasting Options. | |
| LOCATION_ID | NUMBER | The identifier of the location of the assignment. The default value for this column on new assignment records is retrieved from the project. | ||
| CALENDAR_TYPE | VARCHAR2 | (30) | Indicates the base calendar used for generating schedules. | |
| CALENDAR_ID | NUMBER | The identifier of the calendar for the assignment. The default value for this column on new assignment records is retrieved from the project. | ||
| RESOURCE_CALENDAR_PERCENT | NUMBER | The percentage of the resource calendar that the resource is allocated on the assignment | ||
| PENDING_APPROVAL_FLAG | VARCHAR2 | (1) | Indicates whether workflow approval is pending for the assignment | |
| LAST_APPROVED_FLAG | VARCHAR2 | (1) | Indicates if the record is the last approved change. If the user decides to revert the last made changes, the record with this flag enabled is used. | |
| 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 | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| STAFFING_PRIORITY_CODE | VARCHAR2 | (30) | The staffing priority of the requirements | |
| PROJECT_SUBTEAM_ID | NUMBER | Identifier of a project subteam on the assignment | ||
| NO_OF_ACTIVE_CANDIDATES | NUMBER | Holds the number of candidates with a system status of PENDING_REVIEW or UNDER_REVIEW or SUITABLE. | ||
| TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates if the requirement is a template requirement. | |
| COMPETENCE_MATCH_WEIGHTING | NUMBER | Indicates the competence match weighting for a requirement | ||
| AVAILABILITY_MATCH_WEIGHTING | NUMBER | Indicates the availability match weighting for a requirement | ||
| JOB_LEVEL_MATCH_WEIGHTING | NUMBER | Indicates the job level match weighting for a requirement | ||
| SEARCH_MIN_AVAILABILITY | NUMBER | The minimum required availability of a resource to be returned in the search result | ||
| SEARCH_COUNTRY_CODE | VARCHAR2 | (2) | Identifies the country for the search | |
| SEARCH_EXP_ORG_STRUCT_VER_ID | NUMBER | (15) | Identifies the organization hierarchy for the search | |
| SEARCH_EXP_START_ORG_ID | NUMBER | (15) | Identifies the starting organization for the search | |
| SEARCH_MIN_CANDIDATE_SCORE | NUMBER | The minimum score required for a resource to be nominated as candidate on a requirement | ||
| LAST_AUTO_SEARCH_DATE | DATE | The most recent date and time when the automated process was run to nominate system generated candidates for the requirement | ||
| ENABLE_AUTO_CAND_NOM_FLAG | VARCHAR2 | (1) | Indicates whether or not automated candidate nomination for the requirement is enabled | |
| MASS_WF_IN_PROGRESS_FLAG | VARCHAR2 | (1) | Indicates whether or not mass workflow processes is pending for this assignment | |
| BILL_RATE_OVERRIDE | NUMBER | The overriding bill rate used to determine the revenue or bill amount for the item | ||
| BILL_RATE_CURR_OVERRIDE | VARCHAR2 | (30) | The overriding currency code of the overriding bill rate | |
| MARKUP_PERCENT_OVERRIDE | NUMBER | The overriding markup percentage over raw cost used to determine the revenue or bill amount for the item | ||
| TP_RATE_OVERRIDE | NUMBER | The overriding transfer price rate used to determine the cross charge amount of the assignment | ||
| TP_CURRENCY_OVERRIDE | VARCHAR2 | (30) | The overriding currency code of the overriding transfer price rate | |
| TP_CALC_BASE_CODE_OVERRIDE | VARCHAR2 | (30) | The overriding transaction amount on which the transfer price will be based when calculated using applied percentage | |
| TP_PERCENT_APPLIED_OVERRIDE | NUMBER | Identifies the overriding percentage applied on the selected transaction amount to determine the cross charge amount | ||
| MARKUP_PERCENT | NUMBER | The markup percent | ||
| STAFFING_OWNER_PERSON_ID | NUMBER | Identifier of the staffing owner of the team role | ||
| TRANSFER_PRICE_RATE | NUMBER | The transfer price rate of the assignment or requirement | ||
| TRANSFER_PR_RATE_CURR | VARCHAR2 | (15) | Currency of the transfer price rate | |
| 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 discount, discount override or rate override. |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, ASSIGNMENT_NAME
, ASSIGNMENT_TYPE
, MULTIPLE_STATUS_FLAG
, RECORD_VERSION_NUMBER
, CHANGE_ID
, APPRVL_STATUS_CODE
, STATUS_CODE
, PROJECT_ID
, PROJECT_ROLE_ID
, RESOURCE_ID
, PROJECT_PARTY_ID
, DESCRIPTION
, NOTE_TO_APPROVER
, START_DATE
, END_DATE
, ASSIGNMENT_EFFORT
, EXTENSION_POSSIBLE
, SOURCE_ASSIGNMENT_ID
, ASSIGNMENT_TEMPLATE_ID
, MIN_RESOURCE_JOB_LEVEL
, MAX_RESOURCE_JOB_LEVEL
, ASSIGNMENT_NUMBER
, ADDITIONAL_INFORMATION
, WORK_TYPE_ID
, REVENUE_CURRENCY_CODE
, REVENUE_BILL_RATE
, EXPENSE_OWNER
, EXPENSE_LIMIT
, EXPENSE_LIMIT_CURRENCY_CODE
, FCST_TP_AMOUNT_TYPE
, FCST_JOB_ID
, FCST_JOB_GROUP_ID
, EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE_CLASS
, EXPENDITURE_TYPE
, LOCATION_ID
, CALENDAR_TYPE
, CALENDAR_ID
, RESOURCE_CALENDAR_PERCENT
, PENDING_APPROVAL_FLAG
, LAST_APPROVED_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, STAFFING_PRIORITY_CODE
, PROJECT_SUBTEAM_ID
, NO_OF_ACTIVE_CANDIDATES
, TEMPLATE_FLAG
, COMPETENCE_MATCH_WEIGHTING
, AVAILABILITY_MATCH_WEIGHTING
, JOB_LEVEL_MATCH_WEIGHTING
, SEARCH_MIN_AVAILABILITY
, SEARCH_COUNTRY_CODE
, SEARCH_EXP_ORG_STRUCT_VER_ID
, SEARCH_EXP_START_ORG_ID
, SEARCH_MIN_CANDIDATE_SCORE
, LAST_AUTO_SEARCH_DATE
, ENABLE_AUTO_CAND_NOM_FLAG
, MASS_WF_IN_PROGRESS_FLAG
, BILL_RATE_OVERRIDE
, BILL_RATE_CURR_OVERRIDE
, MARKUP_PERCENT_OVERRIDE
, TP_RATE_OVERRIDE
, TP_CURRENCY_OVERRIDE
, TP_CALC_BASE_CODE_OVERRIDE
, TP_PERCENT_APPLIED_OVERRIDE
, MARKUP_PERCENT
, STAFFING_OWNER_PERSON_ID
, TRANSFER_PRICE_RATE
, TRANSFER_PR_RATE_CURR
, DISCOUNT_PERCENTAGE
, RATE_DISC_REASON_CODE
FROM PA.PA_ASSIGNMENTS_HISTORY;
PA.PA_ASSIGNMENTS_HISTORY does not reference any database object
PA.PA_ASSIGNMENTS_HISTORY is referenced by following:
APPS
PA_ASSIGNMENTS_HISTORY
|
|
|
|