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_REP_UTIL_SCREEN_TMP

Object Details

Object Name:	PA_REP_UTIL_SCREEN_TMP
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

PA_REP_UTIL_SCREEN_TMP is a view to provide Capacity and Total Hours values for resources across organizations for all the period types. This information is used by OA Screens.

Temporary Table Details

PA.PA_REP_UTIL_SCREEN_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Internal Identifier of the Expenditure Organization.
PERSON_ID	NUMBER		Internal Identifier of the Person Resource.
RESOURCE_ID	NUMBER		Internal Identifier of the Resource.
RESOURCE_NAME	VARCHAR2	(240)	Language Specific name of the Person Resource.
RESOURCE_TYPE	VARCHAR2	(60)	The resource type of the Person Resource.
RESOURCE_TYPE_CODE	VARCHAR2	(15)	The resource type code of the Person Resource.
CALLING_MODE	VARCHAR2	(15)	The mode in which the OA screen is called.
JOB_LEVEL	NUMBER		The job level of the Person Resource.
ACTUALS_CAPACITY	NUMBER		The Actual Capacity of the Person Resource after taking into consideration the reduced capacity
ACTUALS_HOURS	NUMBER		The Total Actual Hours of the Person Resource.
ACTUALS_WEIGHTED_HOURS	NUMBER		The Total Actual Hours of the Person Resource weighted by the weighting percentages of the Organization/Resource Utilization Categories.
ACTUALS_WEIGHTED_HOURS_P	NUMBER		The percentage value of the Actual Weighted Hours with respect to Capacity or Total Hours whichever is selected.
ACTUALS_CAP_OR_TOT_HRS	NUMBER		The Actual Capacity or Total Hours of the Person Resource.
FORECAST_CAPACITY	NUMBER		The Forecast Capacity of the Person Resource after taking into consideration the reduced capacity
FORECAST_HOURS	NUMBER		The Total Forecast Hours of the Person Resource.
FORECAST_WEIGHTED_HOURS	NUMBER		The Total Forecast Hours of the Person Resource weighted by the weighting percentages of the Organization/Resource Utilization Categories.
FORECAST_WEIGHTED_HOURS_P	NUMBER		The percentage value of the Forecast Weighted Hours with respect to Capacity or Total Hours whichever is selected.
FORECAST_CAP_OR_TOT_HRS	NUMBER		The Forecast Capacity or Total Hours of the Person Resource.

Query Text

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


SELECT ORGANIZATION_ID
,      PERSON_ID
,      RESOURCE_ID
,      RESOURCE_NAME
,      RESOURCE_TYPE
,      RESOURCE_TYPE_CODE
,      CALLING_MODE
,      JOB_LEVEL
,      ACTUALS_CAPACITY
,      ACTUALS_HOURS
,      ACTUALS_WEIGHTED_HOURS
,      ACTUALS_WEIGHTED_HOURS_P
,      ACTUALS_CAP_OR_TOT_HRS
,      FORECAST_CAPACITY
,      FORECAST_HOURS
,      FORECAST_WEIGHTED_HOURS
,      FORECAST_WEIGHTED_HOURS_P
,      FORECAST_CAP_OR_TOT_HRS
FROM PA.PA_REP_UTIL_SCREEN_TMP;

Dependencies

[top of page]

PA.PA_REP_UTIL_SCREEN_TMP does not reference any database object

PA.PA_REP_UTIL_SCREEN_TMP is referenced by following:

APPS: PA_REP_UTIL_SCREEN_TMP