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.

[Home] [Help]

Table: PA_RESOURCE_ASSIGNMENTS

Product:	PA - Projects
Description:	Resource assignments for a budget version at a branch of project's work breakdown
Implementation/DBA Data:	PA.PA_RESOURCE_ASSIGNMENTS

Primary Key: PA_RESOURCE_ASSIGNMENTS_PK

RESOURCE_ASSIGNMENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_RESOURCE_ASSIGNMENTS	PA_BUDGET_VERSIONS	PA_RESOURCE_ASSIGNMENTS.BUDGET_VERSION_ID
PA_RESOURCE_ASSIGNMENTS	PA_SPREAD_CURVES_B	PA_RESOURCE_ASSIGNMENTS.SPREAD_CURVE_ID
PA_RESOURCE_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_RESOURCE_ASSIGNMENTS.ORGANIZATION_ID
PA_RESOURCE_ASSIGNMENTS	PER_JOBS	PA_RESOURCE_ASSIGNMENTS.JOB_ID
PA_RESOURCE_ASSIGNMENTS	PA_EXPENDITURE_TYPES	PA_RESOURCE_ASSIGNMENTS.EXPENDITURE_TYPE
PA_RESOURCE_ASSIGNMENTS	PA_EXPENDITURE_CATEGORIES	PA_RESOURCE_ASSIGNMENTS.EXPENDITURE_CATEGORY
PA_RESOURCE_ASSIGNMENTS	PA_EVENT_TYPES	PA_RESOURCE_ASSIGNMENTS.EVENT_TYPE
PA_RESOURCE_ASSIGNMENTS	PO_VENDORS	PA_RESOURCE_ASSIGNMENTS.SUPPLIER_ID
PA_RESOURCE_ASSIGNMENTS	PA_NON_LABOR_RESOURCES	PA_RESOURCE_ASSIGNMENTS.NON_LABOR_RESOURCE
PA_RESOURCE_ASSIGNMENTS	PA_PROJECTS_ALL	PA_RESOURCE_ASSIGNMENTS.PROJECT_ID
PA_RESOURCE_ASSIGNMENTS	PER_JOBS	PA_RESOURCE_ASSIGNMENTS.RATE_JOB_ID
PA_RESOURCE_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_RESOURCE_ASSIGNMENTS.RATE_ORGANIZATION_ID
PA_RESOURCE_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_RESOURCE_ASSIGNMENTS.RATE_INCURRED_BY_ORGANZ_ID
PA_RESOURCE_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_RESOURCE_ASSIGNMENTS.RATE_OVERRIDE_TO_ORGANZ_ID
PA_RESOURCE_ASSIGNMENTS	HR_ALL_ORGANIZATION_UNITS	PA_RESOURCE_ASSIGNMENTS.RATE_EXPENDITURE_ORG_ID
PA_RESOURCE_ASSIGNMENTS	PA_TASKS	PA_RESOURCE_ASSIGNMENTS.TASK_ID
PA_RESOURCE_ASSIGNMENTS	BOM_RESOURCES	PA_RESOURCE_ASSIGNMENTS.BOM_RESOURCE_ID
PA_RESOURCE_ASSIGNMENTS	MTL_CATEGORIES_B	PA_RESOURCE_ASSIGNMENTS.ITEM_CATEGORY_ID
PA_RESOURCE_ASSIGNMENTS	CST_COST_TYPES	PA_RESOURCE_ASSIGNMENTS.MFC_COST_TYPE_ID
PA_RESOURCE_ASSIGNMENTS	PA_RBS_ELEMENTS	PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID
PA_RESOURCE_ASSIGNMENTS	PA_RESOURCE_LIST_MEMBERS	PA_RESOURCE_ASSIGNMENTS.RESOURCE_LIST_MEMBER_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJECT_ASSIGNMENTS	PA_RESOURCE_ASSIGNMENTS.PROJECT_ASSIGNMENT_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJ_ELEMENT_VERSIONS	PA_RESOURCE_ASSIGNMENTS.WBS_ELEMENT_VERSION_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJ_ELEMENTS	PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID
PA_RESOURCE_ASSIGNMENTS	PA_PROJ_ELEMENT_VERSIONS	PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_VERSION_ID
PA_BUDGET_LINES	PA_RESOURCE_ASSIGNMENTS	PA_BUDGET_LINES.RESOURCE_ASSIGNMENT_ID
PA_FIN_PLAN_ADJ_LINES	PA_RESOURCE_ASSIGNMENTS	PA_FIN_PLAN_ADJ_LINES.RESOURCE_ASSIGNMENT_ID
PA_FP_ADJ_ELEMENTS	PA_RESOURCE_ASSIGNMENTS	PA_FP_ADJ_ELEMENTS.RESOURCE_ASSIGNMENT_ID
PA_PROJ_PERIODS_DENORM	PA_RESOURCE_ASSIGNMENTS	PA_PROJ_PERIODS_DENORM.RESOURCE_ASSIGNMENT_ID
PA_PROJ_PERIODS_DENORM	PA_RESOURCE_ASSIGNMENTS	PA_PROJ_PERIODS_DENORM.OBJECT_ID
PA_PROJ_PERIODS_DENORM	PA_RESOURCE_ASSIGNMENTS	PA_PROJ_PERIODS_DENORM.PARENT_ASSIGNMENT_ID