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_PROGRESS_ROLLUP

Object Details

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

PA_PROGRESS_ROLLUP stores rolled up progress information for tasks and structures.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_PROGRESS_ROLLUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROGRESS_ROLLUP_ID
PA_PROGRESS_ROLLUP_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID OBJECT_ID OBJECT_TYPE STRUCTURE_TYPE AS_OF_DATE PROJ_ELEMENT_ID CURRENT_FLAG STRUCTURE_VERSION_ID CBS_ELEMENT_ID
PA_PROGRESS_ROLLUP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID STRUCTURE_VERSION_ID
PA_PROGRESS_ROLLUP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID AS_OF_DATE CURRENT_FLAG
PA_PROGRESS_ROLLUP_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJ_ELEMENT_ID
PA_PROGRESS_ROLLUP_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRESS_ROLLUP_ID	NUMBER	(15)	Yes	Unique identifier for rolled-up progress
PERCENT_COMPLETE_ID	NUMBER	(15)		Percent_Complete_Id of the published progress record on or before the As_Of_Date
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project to which the structure version or task version belongs
OBJECT_ID	NUMBER	(15)	Yes	Indentifier of the object
OBJECT_TYPE	VARCHAR2	(30)	Yes	Type of the object. For example 'PA_TASKS' or 'PA_STRUCTURES'
AS_OF_DATE	DATE		Yes	As of date for the rolled-up progress
OBJECT_VERSION_ID	NUMBER	(15)	Yes	Identifier for the object version
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
PROGRESS_STATUS_CODE	VARCHAR2	(150)		Progress_Status_Code denormalized from the PA_Percent_Completes table
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
INCREMENTAL_WORK_QUANTITY	NUMBER	(17)		The incremental Actual Work Quantity performed since the last progress entry.
CUMULATIVE_WORK_QUANTITY	NUMBER	(17)		The cumulative or total Actual Work Quantity performed
BASE_PERCENT_COMPLETE	NUMBER			% Complete derived from lowest level tasks and rolled up through summary tasks and the project.
EFF_ROLLUP_PERCENT_COMP	NUMBER			% Complete based on the Base % Complete and user entered % Complete for all subtasks of a summary task or a project.
COMPLETED_PERCENTAGE	NUMBER			Completed_Percentage denormalized from Pa_Percent_Completes table
ESTIMATED_START_DATE	DATE			Estimated start date of the object
ESTIMATED_FINISH_DATE	DATE			Estimated finisht date of the object
ACTUAL_START_DATE	DATE			Actual start date of the object
ACTUAL_FINISH_DATE	DATE			Actual finish date of the object
ESTIMATED_REMAINING_EFFORT	NUMBER	(17)		Estimated remaining effort in hours for the object.
RECORD_VERSION_NUMBER	NUMBER	(15)		Record version number
BASE_PERCENT_COMP_DERIV_CODE	VARCHAR2	(30)		The Base % Complete derivation method used for calculating Base % Complete for the record
BASE_PROGRESS_STATUS_CODE	VARCHAR2	(150)		The Progress Status derived for lowest level tasks and rolled up for summary tasks.
EFF_ROLLUP_PROG_STAT_CODE	VARCHAR2	(150)		The Progress Status based on the Base Progress Status and user entered Progress Status for all subtasks of a summary task or the project level
STRUCTURE_TYPE	VARCHAR2	(30)		Structure Type
PROJ_ELEMENT_ID	NUMBER	(15)		Task Identifier
STRUCTURE_VERSION_ID	NUMBER	(15)		To identify progress record entered from Workplan flow.
PPL_ACT_EFFORT_TO_DATE	NUMBER			Actual people effort incurred during the progress cycle
EQPMT_ACT_EFFORT_TO_DATE	NUMBER			Actual equipment effort incurred during the progress cycle
EQPMT_ETC_EFFORT	NUMBER			Estimate to Complete Effort
OTH_ACT_COST_TO_DATE_TC	NUMBER			Actual cost incurred during the progress cycle (in Transaction Currency).
OTH_ACT_COST_TO_DATE_FC	NUMBER			Actual cost incurred during the progress cycle (in Project Functional Currency).
OTH_ACT_COST_TO_DATE_PC	NUMBER			Actual cost incurred during the progress cycle (in Project Currency).
OTH_ETC_COST_TC	NUMBER			Estimate to Complete Cost (in Transaction Currency).
OTH_ETC_COST_FC	NUMBER			Estimate to Complete Cost (in Project Functional Currency).
OTH_ETC_COST_PC	NUMBER			Estimate to Complete Cost (in Project Currency).
PPL_ACT_COST_TO_DATE_TC	NUMBER			Actual cost incurred during the progress cycle (in Transaction Currency).
PPL_ACT_COST_TO_DATE_FC	NUMBER			Actual cost incurred during the progress cycle (in Project Functional Currency).
PPL_ACT_COST_TO_DATE_PC	NUMBER			Actual cost incurred during the progress cycle (in Project Currency).
PPL_ETC_COST_TC	NUMBER			Estimate to complete for people assignments (in Transaction Currency).
PPL_ETC_COST_FC	NUMBER			Estimate to complete for people assignments (in Project Functional Currency).
PPL_ETC_COST_PC	NUMBER			Estimate to complete for people assignments (in Project Currency).
EQPMT_ACT_COST_TO_DATE_TC	NUMBER			Actual equipment cost incurred during the progress cycle (in Transaction Currency).
EQPMT_ACT_COST_TO_DATE_FC	NUMBER			Actual equipment cost incurred during the progress cycle (in Project Functional Currency).
EQPMT_ACT_COST_TO_DATE_PC	NUMBER			Actual equipment cost incurred during the progress cycle (in Project Currency).
EQPMT_ETC_COST_TC	NUMBER			Estimate to complete equipment cost (in Transaction Currency).
EQPMT_ETC_COST_FC	NUMBER			Estimate to complete equipment cost (in Project Functional Currency).
EQPMT_ETC_COST_PC	NUMBER			Estimate to complete equipment cost (in Project Currency).
EARNED_VALUE	NUMBER			Earned Value(Budgeted Cost of Work Performed)
TASK_WT_BASIS_CODE	VARCHAR2	(30)		Progress Rollup Method(Denorm)
SUBPRJ_PPL_ACT_EFFORT	NUMBER			Total effort incurred to date from subprojects.
SUBPRJ_EQPMT_ACT_EFFORT	NUMBER			Total effort incurred to date for people assignments from subprojects.
SUBPRJ_PPL_ETC_EFFORT	NUMBER			Estimate to Complete Effort for people assignments from subprojects
SUBPRJ_EQPMT_ETC_EFFORT	NUMBER			Estimate to Complete Effort for equipment assignments from subprojects.
SUBPRJ_PPL_ACT_COST_TC	NUMBER			Total cost incurred to date for people assignments from subprojects (in Transaction Currency).
SUBPRJ_PPL_ACT_COST_FC	NUMBER			Total cost incurred to date for people assignments from subprojects (in Project Functional Currency).
SUBPRJ_PPL_ACT_COST_PC	NUMBER			Total cost incurred to date for people assignments from subprojects (in Project Currency).
SUBPRJ_EQPMT_ACT_COST_TC	NUMBER			Total cost incurred to date for equipment assignments from subprojects (in Transaction Currency).
SUBPRJ_EQPMT_ACT_COST_FC	NUMBER			Total cost incurred to date for equipment assignments from subprojects (in Project Functional Currency).
SUBPRJ_EQPMT_ACT_COST_PC	NUMBER			Total cost incurred to date for equipment assignments from subprojects (in Project Currency).
SUBPRJ_OTH_ETC_COST_TC	NUMBER			Estimate to complete cost for material and financial element type assignments from subprojects (in Transaction Currency).
SUBPRJ_OTH_ETC_COST_FC	NUMBER			Estimate to complete cost for material and financial element type assignments from subprojects (in Project Functional Currency).
SUBPRJ_OTH_ETC_COST_PC	NUMBER			Estimate to complete cost for material and financial element type assignments from subprojects (in Project Currency).
SUBPRJ_PPL_ETC_COST_TC	NUMBER			Estimate to complete cost for people assignments from subprojects (in Transaction Currency).
SUBPRJ_PPL_ETC_COST_FC	NUMBER			Estimate to complete cost for people assignments from subprojects (in Project Functional Currency).
SUBPRJ_PPL_ETC_COST_PC	NUMBER			Estimate to complete cost for people assignments from subprojects (in Project Currency).
SUBPRJ_EQPMT_ETC_COST_TC	NUMBER			Estimate to complete cost for equipment assignments from subprojects (i n Transaction Currency).
SUBPRJ_EQPMT_ETC_COST_FC	NUMBER			Estimate to complete cost for equipment assignments from subprojects (i n Project Functional Currency).
SUBPRJ_EQPMT_ETC_COST_PC	NUMBER			Estimate to complete cost for equipment assignments from subprojects (i n Project Currency).
SUBPRJ_EARNED_VALUE	NUMBER			Earned Value(Budgeted Cost of Work Performed)
CURRENT_FLAG	VARCHAR2	(1)		The Current Flag denotes the latest record for a task
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)		The project functional cost rate type
PROJFUNC_COST_EXCHANGE_RATE	NUMBER			The project functional cost exchange rate
PROJFUNC_COST_RATE_DATE	DATE			The cost rate date for project functional currency
PROJ_COST_RATE_TYPE	VARCHAR2	(30)		The project cost rate type
PROJ_COST_EXCHANGE_RATE	NUMBER			The project cost exchange rate
PROJ_COST_RATE_DATE	DATE			The cost rate date for project currency
TXN_CURRENCY_CODE	VARCHAR2	(15)		The transaction currency code of the amount
PROG_PA_PERIOD_NAME	VARCHAR2	(30)		The PA period name
PROG_GL_PERIOD_NAME	VARCHAR2	(30)		The GL period name
OTH_QUANTITY_TO_DATE	NUMBER			Actual quantity incurred during the progress cycle.
OTH_ETC_QUANTITY	NUMBER			Estimated remaining quantity for the object.
OTH_ACT_RAWCOST_TO_DATE_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements and derived for cost.
OTH_ACT_RAWCOST_TO_DATE_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements and derived for cost.
OTH_ACT_RAWCOST_TO_DATE_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements and derived for cost.
OTH_ETC_RAWCOST_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements, and derived for cost
OTH_ETC_RAWCOST_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements, and derived for cost.
OTH_ETC_RAWCOST_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for non-effort resources such as material and financial elements, and derived for cost.
PPL_ACT_RAWCOST_TO_DATE_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
PPL_ACT_RAWCOST_TO_DATE_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
PPL_ACT_RAWCOST_TO_DATE_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
PPL_ETC_RAWCOST_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
PPL_ETC_RAWCOST_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
PPL_ETC_RAWCOST_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for people assignments.
EQPMT_ACT_RAWCOST_TO_DATE_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment
EQPMT_ACT_RAWCOST_TO_DATE_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment.
EQPMT_ACT_RAWCOST_TO_DATE_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment.
EQPMT_ETC_RAWCOST_TC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment assignments.
EQPMT_ETC_RAWCOST_FC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment assignments.
EQPMT_ETC_RAWCOST_PC	NUMBER			This information is stored in Budgets Model.Tasks: Derived from assignments. Assignments: Entered for equipment assignments.
SUBPRJ_PPL_ACT_RAWCOST_TC	NUMBER			Rolled Up from sub project.
SUBPRJ_PPL_ACT_RAWCOST_FC	NUMBER			Rolled Up from sub project.
SUBPRJ_PPL_ACT_RAWCOST_PC	NUMBER			Rolled Up from sub project.
SUBPRJ_EQPMT_ACT_RAWCOST_TC	NUMBER			Rolled Up from sub project.
SUBPRJ_EQPMT_ACT_RAWCOST_FC	NUMBER			Rolled Up from sub project.
SUBPRJ_EQPMT_ACT_RAWCOST_PC	NUMBER			Rolled Up from sub project.
SUBPRJ_OTH_ETC_RAWCOST_TC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_OTH_ETC_RAWCOST_FC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_OTH_ETC_RAWCOST_PC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_PPL_ETC_RAWCOST_TC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_PPL_ETC_RAWCOST_FC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_PPL_ETC_RAWCOST_PC	NUMBER			This is subprojects estimate to complete rawcost.Rolled Up from sub project.
SUBPRJ_EQPMT_ETC_RAWCOST_TC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_EQPMT_ETC_RAWCOST_FC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_EQPMT_ETC_RAWCOST_PC	NUMBER			This is subprojects estimate to complete raw cost.Rolled Up from sub project.
SUBPRJ_OTH_ACT_COST_TO_DT_TC	NUMBER			Total cost incurred to date for material and financial element type assignments from subprojects (in Transaction Currency).
SUBPRJ_OTH_ACT_COST_TO_DT_FC	NUMBER			Total cost incurred to date for material and financial element type assignments from subprojects (in Project Functional Currency).
SUBPRJ_OTH_ACT_COST_TO_DT_PC	NUMBER			Total cost incurred to date for material and financial element type assignments from subprojects (in Project Currency).
SPJ_OTH_ACT_RAWCOST_TO_DT_TC	NUMBER			Rolled Up from sub project.
SPJ_OTH_ACT_RAWCOST_TO_DT_FC	NUMBER			Rolled Up from sub project.
SPJ_OTH_ACT_RAWCOST_TO_DT_PC	NUMBER			Rolled Up from sub project.
CBS_ELEMENT_ID	NUMBER	(15)		This is the unique identifier of the cost code element.

Query Text

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


SELECT PROGRESS_ROLLUP_ID
,      PERCENT_COMPLETE_ID
,      PROJECT_ID
,      OBJECT_ID
,      OBJECT_TYPE
,      AS_OF_DATE
,      OBJECT_VERSION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      PROGRESS_STATUS_CODE
,      LAST_UPDATE_LOGIN
,      INCREMENTAL_WORK_QUANTITY
,      CUMULATIVE_WORK_QUANTITY
,      BASE_PERCENT_COMPLETE
,      EFF_ROLLUP_PERCENT_COMP
,      COMPLETED_PERCENTAGE
,      ESTIMATED_START_DATE
,      ESTIMATED_FINISH_DATE
,      ACTUAL_START_DATE
,      ACTUAL_FINISH_DATE
,      ESTIMATED_REMAINING_EFFORT
,      RECORD_VERSION_NUMBER
,      BASE_PERCENT_COMP_DERIV_CODE
,      BASE_PROGRESS_STATUS_CODE
,      EFF_ROLLUP_PROG_STAT_CODE
,      STRUCTURE_TYPE
,      PROJ_ELEMENT_ID
,      STRUCTURE_VERSION_ID
,      PPL_ACT_EFFORT_TO_DATE
,      EQPMT_ACT_EFFORT_TO_DATE
,      EQPMT_ETC_EFFORT
,      OTH_ACT_COST_TO_DATE_TC
,      OTH_ACT_COST_TO_DATE_FC
,      OTH_ACT_COST_TO_DATE_PC
,      OTH_ETC_COST_TC
,      OTH_ETC_COST_FC
,      OTH_ETC_COST_PC
,      PPL_ACT_COST_TO_DATE_TC
,      PPL_ACT_COST_TO_DATE_FC
,      PPL_ACT_COST_TO_DATE_PC
,      PPL_ETC_COST_TC
,      PPL_ETC_COST_FC
,      PPL_ETC_COST_PC
,      EQPMT_ACT_COST_TO_DATE_TC
,      EQPMT_ACT_COST_TO_DATE_FC
,      EQPMT_ACT_COST_TO_DATE_PC
,      EQPMT_ETC_COST_TC
,      EQPMT_ETC_COST_FC
,      EQPMT_ETC_COST_PC
,      EARNED_VALUE
,      TASK_WT_BASIS_CODE
,      SUBPRJ_PPL_ACT_EFFORT
,      SUBPRJ_EQPMT_ACT_EFFORT
,      SUBPRJ_PPL_ETC_EFFORT
,      SUBPRJ_EQPMT_ETC_EFFORT
,      SUBPRJ_PPL_ACT_COST_TC
,      SUBPRJ_PPL_ACT_COST_FC
,      SUBPRJ_PPL_ACT_COST_PC
,      SUBPRJ_EQPMT_ACT_COST_TC
,      SUBPRJ_EQPMT_ACT_COST_FC
,      SUBPRJ_EQPMT_ACT_COST_PC
,      SUBPRJ_OTH_ETC_COST_TC
,      SUBPRJ_OTH_ETC_COST_FC
,      SUBPRJ_OTH_ETC_COST_PC
,      SUBPRJ_PPL_ETC_COST_TC
,      SUBPRJ_PPL_ETC_COST_FC
,      SUBPRJ_PPL_ETC_COST_PC
,      SUBPRJ_EQPMT_ETC_COST_TC
,      SUBPRJ_EQPMT_ETC_COST_FC
,      SUBPRJ_EQPMT_ETC_COST_PC
,      SUBPRJ_EARNED_VALUE
,      CURRENT_FLAG
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE
,      PROJ_COST_RATE_TYPE
,      PROJ_COST_EXCHANGE_RATE
,      PROJ_COST_RATE_DATE
,      TXN_CURRENCY_CODE
,      PROG_PA_PERIOD_NAME
,      PROG_GL_PERIOD_NAME
,      OTH_QUANTITY_TO_DATE
,      OTH_ETC_QUANTITY
,      OTH_ACT_RAWCOST_TO_DATE_TC
,      OTH_ACT_RAWCOST_TO_DATE_FC
,      OTH_ACT_RAWCOST_TO_DATE_PC
,      OTH_ETC_RAWCOST_TC
,      OTH_ETC_RAWCOST_FC
,      OTH_ETC_RAWCOST_PC
,      PPL_ACT_RAWCOST_TO_DATE_TC
,      PPL_ACT_RAWCOST_TO_DATE_FC
,      PPL_ACT_RAWCOST_TO_DATE_PC
,      PPL_ETC_RAWCOST_TC
,      PPL_ETC_RAWCOST_FC
,      PPL_ETC_RAWCOST_PC
,      EQPMT_ACT_RAWCOST_TO_DATE_TC
,      EQPMT_ACT_RAWCOST_TO_DATE_FC
,      EQPMT_ACT_RAWCOST_TO_DATE_PC
,      EQPMT_ETC_RAWCOST_TC
,      EQPMT_ETC_RAWCOST_FC
,      EQPMT_ETC_RAWCOST_PC
,      SUBPRJ_PPL_ACT_RAWCOST_TC
,      SUBPRJ_PPL_ACT_RAWCOST_FC
,      SUBPRJ_PPL_ACT_RAWCOST_PC
,      SUBPRJ_EQPMT_ACT_RAWCOST_TC
,      SUBPRJ_EQPMT_ACT_RAWCOST_FC
,      SUBPRJ_EQPMT_ACT_RAWCOST_PC
,      SUBPRJ_OTH_ETC_RAWCOST_TC
,      SUBPRJ_OTH_ETC_RAWCOST_FC
,      SUBPRJ_OTH_ETC_RAWCOST_PC
,      SUBPRJ_PPL_ETC_RAWCOST_TC
,      SUBPRJ_PPL_ETC_RAWCOST_FC
,      SUBPRJ_PPL_ETC_RAWCOST_PC
,      SUBPRJ_EQPMT_ETC_RAWCOST_TC
,      SUBPRJ_EQPMT_ETC_RAWCOST_FC
,      SUBPRJ_EQPMT_ETC_RAWCOST_PC
,      SUBPRJ_OTH_ACT_COST_TO_DT_TC
,      SUBPRJ_OTH_ACT_COST_TO_DT_FC
,      SUBPRJ_OTH_ACT_COST_TO_DT_PC
,      SPJ_OTH_ACT_RAWCOST_TO_DT_TC
,      SPJ_OTH_ACT_RAWCOST_TO_DT_FC
,      SPJ_OTH_ACT_RAWCOST_TO_DT_PC
,      CBS_ELEMENT_ID
FROM PA.PA_PROGRESS_ROLLUP;

Dependencies

[top of page]

PA.PA_PROGRESS_ROLLUP does not reference any database object

PA.PA_PROGRESS_ROLLUP is referenced by following:

PA: PA_PROGRESS_ROLLUP#