eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_RESOURCE_ASSIGNMENTS

Object Details

Object Name:	PA_RESOURCE_ASSIGNMENTS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_RESOURCE_ASSIGNMENTS
Subobject Name:
Status:	VALID

PA_RESOURCE_ASSIGNMENTS stores the resource assignments for a budget
version at a branch of a project's work breakdown structure. A user
can enter budget at project, top task, or lowest task levels.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_RESOURCE_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESOURCE_ASSIGNMENT_ID
PA_RESOURCE_ASSIGNMENTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID PROJECT_ID TASK_ID RESOURCE_LIST_MEMBER_ID PROJECT_ASSIGNMENT_ID
PA_RESOURCE_ASSIGNMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TASK_ID
PA_RESOURCE_ASSIGNMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ASSIGNMENT_ID
PA_RESOURCE_ASSIGNMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WBS_ELEMENT_VERSION_ID RESOURCE_LIST_MEMBER_ID
PA_RESOURCE_ASSIGNMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID WBS_ELEMENT_VERSION_ID
PA_RESOURCE_ASSIGNMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID PM_PRODUCT_CODE PM_RES_ASSIGNMENT_REFERENCE
PA_RESOURCE_ASSIGNMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_LIST_MEMBER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)	Yes	The system-generated number that uniquely identifies the resource assignment
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The identifier of the budget version that the resource is assigned to
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project that the resource is assigned to
TASK_ID	NUMBER	(15)	Yes	The identifier of the task that the resource is assigned to. This is set to 0 if the budget is entered at the project level
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)	Yes	The identifier of the resource list member within the resource list that is assigned to the budget
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who Column
UNIT_OF_MEASURE	VARCHAR2	(30)		The unit of measure of the resource. This is a denormalized column
TRACK_AS_LABOR_FLAG	VARCHAR2	(1)		Flag that indicates if the resource is a labor item. This is a denormalized column
STANDARD_BILL_RATE	NUMBER			This column applies to Project Forecasting. It stores the Standard Bill Rate for the relevant project assignment
AVERAGE_BILL_RATE	NUMBER			This column applies to Project Forecasting. It stores the Average Bill Rate for the relevant project assignment
AVERAGE_COST_RATE	NUMBER			This column applies to Project Forecasting. It stores the Average Cost Rate for the relevant project assignment
PROJECT_ASSIGNMENT_ID	NUMBER	(15)	Yes	This column applies to Project Forecasting. It stores the unique identifier of the project assignment
PLAN_ERROR_CODE	VARCHAR2	(30)		This column applies to Project Forecasting. It stores the message code that is applicable whenever an error is encountered during generation of a project forecast
TOTAL_PLAN_REVENUE	NUMBER			This column applies to Project Forecasting. It Stores the total planned revenue for the relevant project assignment.
TOTAL_PLAN_RAW_COST	NUMBER			This column applies to Project Forecasting. It Stores the total raw cost for the relevant project assignment.
TOTAL_PLAN_BURDENED_COST	NUMBER			This column applies to Project Forecasting. It Stores the total raw cost for the relevant project assignment.
TOTAL_PLAN_QUANTITY	NUMBER			This column applies to Project Forecasting. It Stores the total quantity for the relevant project assignment. In current release, only labor hours are stored.
AVERAGE_DISCOUNT_PERCENTAGE	NUMBER			This column applies to Project Forecasting. It Stores the average discount percentage for the relevant project assignment.An assignment may have different bill rates for different periods, some of which may be greater than or less than the standard bill rate. The average discount is with respect to the standard bill rate for that assignment.
TOTAL_BORROWED_REVENUE	NUMBER			The total borrowed revenue of resource assignment
TOTAL_TP_REVENUE_IN	NUMBER			The total transfer-price revenue in of resource assignment
TOTAL_TP_REVENUE_OUT	NUMBER			The total transfer-price revenue out of resource assignment
TOTAL_REVENUE_ADJ	NUMBER			The total revenue adjustment of resource assignment
TOTAL_LENT_RESOURCE_COST	NUMBER			The total lent resource cost of resource assignment
TOTAL_TP_COST_IN	NUMBER			The total transfer-price cost in of resource assignment
TOTAL_TP_COST_OUT	NUMBER			The total transfer-price cost out of resource assignment
TOTAL_COST_ADJ	NUMBER			The total cost adjustment of resource assignment
TOTAL_UNASSIGNED_TIME_COST	NUMBER			The total unassigned time cost of resource assignment
TOTAL_UTILIZATION_PERCENT	NUMBER			The total utilization percent of resource assignment
TOTAL_UTILIZATION_HOURS	NUMBER			The total utilization hours of resource assignment
TOTAL_UTILIZATION_ADJ	NUMBER			The Total utilization percent adjustment of resource assignment
TOTAL_CAPACITY	NUMBER			The total capacity of resource assignment
TOTAL_HEAD_COUNT	NUMBER			The total head count of resource assignment
TOTAL_HEAD_COUNT_ADJ	NUMBER			The total head count adjustment of resource assignment
RESOURCE_ASSIGNMENT_TYPE	VARCHAR2	(30)		Indicates the type of the resource assignment record. Used internally in Organization Forecasts.
TOTAL_PROJECT_RAW_COST	NUMBER			The raw cost in project currency
TOTAL_PROJECT_BURDENED_COST	NUMBER			The burdened cost in project currency
TOTAL_PROJECT_REVENUE	NUMBER			'The revenue in project currency
PARENT_ASSIGNMENT_ID	NUMBER			The resource assignment id of the immediate parent of the record
WBS_ELEMENT_VERSION_ID	NUMBER	(15)		Indicates the work breakdown structure element version id. Maintained only for workplan versions.
RBS_ELEMENT_ID	NUMBER	(15)	Yes	Indicates the resource breakdown structure element id.
PLANNING_START_DATE	DATE			Indicates the planning start date.
PLANNING_END_DATE	DATE			Indicates the planning end date.
SPREAD_CURVE_ID	NUMBER	(15)		Indicates the spread curve id.
ETC_METHOD_CODE	VARCHAR2	(30)		Indicates the estimate to complete method code.
RES_TYPE_CODE	VARCHAR2	(30)		Indicates the resource type code for the resource.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield.
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield.
FC_RES_TYPE_CODE	VARCHAR2	(30)		Indicates the financial resource category type code.
RESOURCE_CLASS_CODE	VARCHAR2	(30)		Indicates the resource class code.
ORGANIZATION_ID	NUMBER	(15)		Indicates the organization.
JOB_ID	NUMBER	(15)		Indicates the job.
PERSON_ID	NUMBER	(15)		Indicates the person.
EXPENDITURE_TYPE	VARCHAR2	(30)		The expenditure for which the alias is created.
EXPENDITURE_CATEGORY	VARCHAR2	(30)		The expenditure category that classifies the expenditure type into a cost group.
REVENUE_CATEGORY_CODE	VARCHAR2	(30)		The revenue category that classifies the expenditure type into a revenue group.
EVENT_TYPE	VARCHAR2	(30)		Implementation-defined name that uniquely identifies the event type.
SUPPLIER_ID	NUMBER	(15)		Indicates the vendor.
PROJECT_ROLE_ID	NUMBER	(15)		Indicates the project role.
PERSON_TYPE_CODE	VARCHAR2	(30)		Indicates the person type.
NON_LABOR_RESOURCE	VARCHAR2	(20)		Indicates the project non labor resource.
BOM_RESOURCE_ID	NUMBER	(15)		Indicates the BOM labor resource.
INVENTORY_ITEM_ID	NUMBER	(15)		Indicates the inventory item.
ITEM_CATEGORY_ID	NUMBER	(15)		Indicates the inventory category.
RECORD_VERSION_NUMBER	NUMBER			Indicates the record version number.
BILLABLE_PERCENT	NUMBER			It stores the billable percent of the assignments.
TRANSACTION_SOURCE_CODE	VARCHAR2	(30)		Indicates the transaction source code.
MFC_COST_TYPE_ID	NUMBER	(15)		Indicates the manufacturing source code.
PROCURE_RESOURCE_FLAG	VARCHAR2	(1)		Indicates whether this assignments allows a procured resource.
ASSIGNMENT_DESCRIPTION	VARCHAR2	(240)		It stores the description of the assignment.
INCURRED_BY_RES_FLAG	VARCHAR2	(1)		Indicates whether the resource columns(job_id, project_role_id, person_type_code, person_id) are used to tracked the incurred by Resources on financial element assignments.
RATE_JOB_ID	NUMBER	(15)		Indicates the job used to derive the rates.
RATE_EXPENDITURE_TYPE	VARCHAR2	(30)		Y indicates that planned effort is being held at task and resource level, N indicates that planned effort is being held at task level.
TA_DISPLAY_FLAG	VARCHAR2	(1)		Y indicates that planned effort is being held at task and resource level, N indicates that planned effort is being held at task level.
SP_FIXED_DATE	DATE			Indicates the fixed date to be used when using a fixed date spread curve.
RATE_BASED_FLAG	VARCHAR2	(1)		Indicates whether transactional is rate based
USE_TASK_SCHEDULE_FLAG	VARCHAR2	(1)		Indicates whether assignment duration is same as task duration.
RATE_EXP_FUNC_CURR_CODE	VARCHAR2	(30)		Indicates rate expenditure functional currency
RATE_EXPENDITURE_ORG_ID	NUMBER	(15)		Indicates rate expenditure organization
INCUR_BY_RES_CLASS_CODE	VARCHAR2	(30)		Indicates the incurring resource class
INCUR_BY_ROLE_ID	NUMBER	(15)		Indicates the incurring role.
RESOURCE_CLASS_FLAG	VARCHAR2	(1)		Indicates the resource is a resource class
NAMED_ROLE	VARCHAR2	(80)		Indicates the named role
TXN_ACCUM_HEADER_ID	NUMBER	(15)		Identifier for the transaction accum header used for RBS mapping
PM_PRODUCT_CODE	VARCHAR2	(30)		The identifier of the external project management system from which the budget was imported
PM_RES_ASSIGNMENT_REFERENCE	VARCHAR2	(25)		The identifier of the planning transaction in the external project management system from which the planning transaction was imported.
SCHEDULE_START_DATE	DATE			Scheduled start date of the planning transaction
SCHEDULE_END_DATE	DATE			Scheduled end date of the planning transaction
UNPLANNED_FLAG	VARCHAR2	(1)		Indicates that the planning transaction was created by the system as a result of actual costs being incurred
SCHEDULED_DELAY	NUMBER			Scheduled delay for assignment
RESOURCE_RATE_BASED_FLAG	VARCHAR2	(1)		"Flag to indicate planning transaction is rate-based"

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESOURCE_ASSIGNMENT_ID
,      BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      RESOURCE_LIST_MEMBER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UNIT_OF_MEASURE
,      TRACK_AS_LABOR_FLAG
,      STANDARD_BILL_RATE
,      AVERAGE_BILL_RATE
,      AVERAGE_COST_RATE
,      PROJECT_ASSIGNMENT_ID
,      PLAN_ERROR_CODE
,      TOTAL_PLAN_REVENUE
,      TOTAL_PLAN_RAW_COST
,      TOTAL_PLAN_BURDENED_COST
,      TOTAL_PLAN_QUANTITY
,      AVERAGE_DISCOUNT_PERCENTAGE
,      TOTAL_BORROWED_REVENUE
,      TOTAL_TP_REVENUE_IN
,      TOTAL_TP_REVENUE_OUT
,      TOTAL_REVENUE_ADJ
,      TOTAL_LENT_RESOURCE_COST
,      TOTAL_TP_COST_IN
,      TOTAL_TP_COST_OUT
,      TOTAL_COST_ADJ
,      TOTAL_UNASSIGNED_TIME_COST
,      TOTAL_UTILIZATION_PERCENT
,      TOTAL_UTILIZATION_HOURS
,      TOTAL_UTILIZATION_ADJ
,      TOTAL_CAPACITY
,      TOTAL_HEAD_COUNT
,      TOTAL_HEAD_COUNT_ADJ
,      RESOURCE_ASSIGNMENT_TYPE
,      TOTAL_PROJECT_RAW_COST
,      TOTAL_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_REVENUE
,      PARENT_ASSIGNMENT_ID
,      WBS_ELEMENT_VERSION_ID
,      RBS_ELEMENT_ID
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      SPREAD_CURVE_ID
,      ETC_METHOD_CODE
,      RES_TYPE_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      FC_RES_TYPE_CODE
,      RESOURCE_CLASS_CODE
,      ORGANIZATION_ID
,      JOB_ID
,      PERSON_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_CATEGORY
,      REVENUE_CATEGORY_CODE
,      EVENT_TYPE
,      SUPPLIER_ID
,      PROJECT_ROLE_ID
,      PERSON_TYPE_CODE
,      NON_LABOR_RESOURCE
,      BOM_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      RECORD_VERSION_NUMBER
,      BILLABLE_PERCENT
,      TRANSACTION_SOURCE_CODE
,      MFC_COST_TYPE_ID
,      PROCURE_RESOURCE_FLAG
,      ASSIGNMENT_DESCRIPTION
,      INCURRED_BY_RES_FLAG
,      RATE_JOB_ID
,      RATE_EXPENDITURE_TYPE
,      TA_DISPLAY_FLAG
,      SP_FIXED_DATE
,      RATE_BASED_FLAG
,      USE_TASK_SCHEDULE_FLAG
,      RATE_EXP_FUNC_CURR_CODE
,      RATE_EXPENDITURE_ORG_ID
,      INCUR_BY_RES_CLASS_CODE
,      INCUR_BY_ROLE_ID
,      RESOURCE_CLASS_FLAG
,      NAMED_ROLE
,      TXN_ACCUM_HEADER_ID
,      PM_PRODUCT_CODE
,      PM_RES_ASSIGNMENT_REFERENCE
,      SCHEDULE_START_DATE
,      SCHEDULE_END_DATE
,      UNPLANNED_FLAG
,      SCHEDULED_DELAY
,      RESOURCE_RATE_BASED_FLAG
FROM PA.PA_RESOURCE_ASSIGNMENTS;

Dependencies

[top of page]

PA.PA_RESOURCE_ASSIGNMENTS does not reference any database object

PA.PA_RESOURCE_ASSIGNMENTS is referenced by following:

APPS: PA_RESOURCE_ASSIGNMENTS