[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECT_ASGMTS_AR |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PROJECT_ASGMTS_AR
|
| Subobject Name: | |
| Status: | VALID |
PA_PROJECT_ASSIGNMENTS stores details of assignments and requirements belonging to projects, as well as template requirements belong to team template.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_PROJECT_ASGMTS_AR_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 PURGE_PROJECT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
| PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purged project Id |
| PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
| ADDITIONAL_INFORMATION | VARCHAR2 | (2000) | The free text for additional information on a requirement or assignment | |
| APPRVL_STATUS_CODE | VARCHAR2 | (30) | Indicates the approval status of the assignment. | |
| ASSIGNMENT_EFFORT | NUMBER | Total number of hours of the requirement or assignment | ||
| ASSIGNMENT_ID | NUMBER | The system generated number that uniquely identifies the assignment | ||
| ASSIGNMENT_NAME | VARCHAR2 | (80) | The user-defined name that identifies the requirement or assignment | |
| ASSIGNMENT_NUMBER | NUMBER | A reference number that uniquely identifies a requirement | ||
| ASSIGNMENT_TEMPLATE_ID | NUMBER | The identifier of the team template to which this requirement belongs, if any. | ||
| ASSIGNMENT_TYPE | VARCHAR2 | (30) | Indicates whether it is a requirement or assignment | |
| ATTRIBUTE1 | 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 | |
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
| AVAILABILITY_MATCH_WEIGHTING | NUMBER | The availability match weighting for a requirement | ||
| BILL_RATE_CURR_OVERRIDE | VARCHAR2 | (30) | Bill Rate Currency Override | |
| BILL_RATE_OVERRIDE | NUMBER | Bill Rate Override | ||
| CALENDAR_ID | NUMBER | The identifier of the calendar for the requirement or assignment. The default value for this column on new requirement or assignment records is retrieved from the project. | ||
| CALENDAR_TYPE | VARCHAR2 | (30) | Indicates the base calendar used for generating schedules. | |
| COMPETENCE_MATCH_WEIGHTING | NUMBER | The competence match weighting for a requirement | ||
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| DESCRIPTION | VARCHAR2 | (2000) | The free text description of the requirement or assignment | |
| ENABLE_AUTO_CAND_NOM_FLAG | VARCHAR2 | (1) | Indicates whether or not automated candidate nomination for the requirement is enabled | |
| END_DATE | DATE | The end date of the requirement or assignment | ||
| 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_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_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. | |
| EXPENDITURE_TYPE_CLASS | VARCHAR2 | (30) | Identifies the Expenditure Type Class to use to generate forecast transactions. This value defaults from Forecasting Options. | |
| EXPENSE_LIMIT | NUMBER | The maximum amount that expense owner is willing to pay | ||
| EXPENSE_LIMIT_CURRENCY_CODE | VARCHAR2 | (15) | The currency code of the expense limit | |
| EXPENSE_OWNER | VARCHAR2 | (30) | The owner of the expenses for the requirement or assignment | |
| EXTENSION_POSSIBLE | VARCHAR2 | (1) | Indicates whether it is possible to extend the requirement or assignment | |
| FCST_JOB_GROUP_ID | NUMBER | Indicates the job group associated with the forecasting job. This value defaults from the Team Role. | ||
| 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_TP_AMOUNT_TYPE | VARCHAR2 | (30) | Indicates whether the requirement or assignment is classified as cost transfer or revenue transfer for forecasting | |
| JOB_LEVEL_MATCH_WEIGHTING | NUMBER | The job level match weighting for 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 | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| LOCATION_ID | NUMBER | The identifier of the location of the requirement or assignment. The default value for this column on new requirement or assignment records is retrieved from the project. | ||
| MARKUP_PERCENT | NUMBER | The markup percent | ||
| MARKUP_PERCENT_OVERRIDE | NUMBER | The overriding markup percentage over raw cost used to determine the revenue or bill amount for the item | ||
| MASS_WF_IN_PROGRESS_FLAG | VARCHAR2 | (1) | Mass Workflow in Progress Flag | |
| 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. | ||
| 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. | ||
| MULTIPLE_STATUS_FLAG | VARCHAR2 | (1) | Indicates whether the underlying schedule for the requirement or assignment has more than one status | |
| NOTE_TO_APPROVER | VARCHAR2 | (240) | The descriptive reason for modification. | |
| NO_OF_ACTIVE_CANDIDATES | NUMBER | Holds the number of candidates with a system status of PENDING_REVIEW or UNDER_REVIEW or SUITABLE. | ||
| PENDING_APPROVAL_FLAG | VARCHAR2 | (1) | Indicates whether workflow approval is pending for the assignment | |
| PROJECT_ID | NUMBER | The identifier of the project to which this requirement or assignment belongs | ||
| PROJECT_PARTY_ID | NUMBER | The identifier of the project party on an assignment | ||
| PROJECT_ROLE_ID | NUMBER | The identifier of the project role for the requirement or assignment | ||
| RECORD_VERSION_NUMBER | NUMBER | Indicates the version of the requirement or assignment record. The column increments by one upon each saved modification to the requirement or assignment record. | ||
| RESOURCE_CALENDAR_PERCENT | NUMBER | The percentage of the resource's calendar that the resource is allocated on the assignment | ||
| RESOURCE_ID | NUMBER | The identifier of the project resource | ||
| REVENUE_BILL_RATE | NUMBER | The revenue bill rate | ||
| REVENUE_CURRENCY_CODE | VARCHAR2 | (15) | The currency of the revenue bill rate | |
| SEARCH_COUNTRY_CODE | VARCHAR2 | (2) | Identifies the country for the search | |
| SEARCH_EXP_ORG_STRUCT_VER_ID | NUMBER | Identifies the organization hierarchy for the search | ||
| SEARCH_EXP_START_ORG_ID | NUMBER | Identifies the starting organization for the search | ||
| SEARCH_MIN_AVAILABILITY | NUMBER | The minimum required availability of a resource to be returned in the search result | ||
| SEARCH_MIN_CANDIDATE_SCORE | NUMBER | The minimum score required for a resource to be nominated as candidate on a requirement | ||
| SOURCE_ASSIGNMENT_ID | NUMBER | Identifies the requirement from which this requirement or assignment record originated | ||
| STAFFING_PRIORITY_CODE | VARCHAR2 | (30) | The staffing priority of the requirement | |
| START_DATE | DATE | The start date of the requirement or assignment | ||
| STATUS_CODE | VARCHAR2 | (30) | Indicates the status of the requirement or assignment. This column may be null if the underlying schedule has multiple status codes. | |
| TEMPLATE_FLAG | VARCHAR2 | (1) | Indicates the requirement is a template requirement. | |
| 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_CURRENCY_OVERRIDE | VARCHAR2 | (30) | The overriding currency code of the overriding transfer price rate | |
| TP_PERCENT_APPLIED_OVERRIDE | NUMBER | The overriding percentage applied on the selected transaction determine the cross charge amount for the assignment. | ||
| TP_RATE_OVERRIDE | NUMBER | The overriding transfer price rate used to determine the cross charge amount of the 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 | ||
| 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. | |
| 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 | |
| RESOURCE_LIST_MEMBER_ID | NUMBER | Planning resource associated with this team role |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_PROJECT_ID
, PURGE_RELEASE
, ADDITIONAL_INFORMATION
, APPRVL_STATUS_CODE
, ASSIGNMENT_EFFORT
, ASSIGNMENT_ID
, ASSIGNMENT_NAME
, ASSIGNMENT_NUMBER
, ASSIGNMENT_TEMPLATE_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, AVAILABILITY_MATCH_WEIGHTING
, BILL_RATE_CURR_OVERRIDE
, BILL_RATE_OVERRIDE
, CALENDAR_ID
, CALENDAR_TYPE
, COMPETENCE_MATCH_WEIGHTING
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, ENABLE_AUTO_CAND_NOM_FLAG
, END_DATE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID
, EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS
, EXPENSE_LIMIT
, EXPENSE_LIMIT_CURRENCY_CODE
, EXPENSE_OWNER
, EXTENSION_POSSIBLE
, FCST_JOB_GROUP_ID
, FCST_JOB_ID
, FCST_TP_AMOUNT_TYPE
, JOB_LEVEL_MATCH_WEIGHTING
, LAST_AUTO_SEARCH_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LOCATION_ID
, MARKUP_PERCENT
, MARKUP_PERCENT_OVERRIDE
, MASS_WF_IN_PROGRESS_FLAG
, MAX_RESOURCE_JOB_LEVEL
, MIN_RESOURCE_JOB_LEVEL
, MULTIPLE_STATUS_FLAG
, NOTE_TO_APPROVER
, NO_OF_ACTIVE_CANDIDATES
, PENDING_APPROVAL_FLAG
, PROJECT_ID
, PROJECT_PARTY_ID
, PROJECT_ROLE_ID
, RECORD_VERSION_NUMBER
, RESOURCE_CALENDAR_PERCENT
, RESOURCE_ID
, REVENUE_BILL_RATE
, REVENUE_CURRENCY_CODE
, SEARCH_COUNTRY_CODE
, SEARCH_EXP_ORG_STRUCT_VER_ID
, SEARCH_EXP_START_ORG_ID
, SEARCH_MIN_AVAILABILITY
, SEARCH_MIN_CANDIDATE_SCORE
, SOURCE_ASSIGNMENT_ID
, STAFFING_PRIORITY_CODE
, START_DATE
, STATUS_CODE
, TEMPLATE_FLAG
, TP_CALC_BASE_CODE_OVERRIDE
, TP_CURRENCY_OVERRIDE
, TP_PERCENT_APPLIED_OVERRIDE
, TP_RATE_OVERRIDE
, WORK_TYPE_ID
, DISCOUNT_PERCENTAGE
, RATE_DISC_REASON_CODE
, STAFFING_OWNER_PERSON_ID
, TRANSFER_PRICE_RATE
, TRANSFER_PR_RATE_CURR
, RESOURCE_LIST_MEMBER_ID
FROM PA.PA_PROJECT_ASGMTS_AR;
PA.PA_PROJECT_ASGMTS_AR does not reference any database object
PA.PA_PROJECT_ASGMTS_AR is referenced by following:
PA
PA_PROJECT_ASGMTS_AR#
|
|
|
|