[Home] [Help] [Dependency Information]
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.
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | 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. |
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;
PA.PA_REP_UTIL_SCREEN_TMP does not reference any database object
PA.PA_REP_UTIL_SCREEN_TMP is referenced by following:
|
|
|