[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJI_DIS_MGRRES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PJI.PJI_DIS_MGRRES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Discoverer view of manager resource utilization data.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CAPACITY_HRS | NUMBER | Actual capacity based on resources calendar | ||
| TOTAL_HRS_A | NUMBER | Total Actual Hours (as per timecards) | ||
| MISSING_HRS_A | NUMBER | Capacity hours less total hours | ||
| TOTAL_WTD_ORG_HRS_A | NUMBER | Total actual weighted organization hours | ||
| TOTAL_WTD_RES_HRS_A | NUMBER | Total actual weighted resource hours | ||
| BILL_HRS_A | NUMBER | Billable actual hours | ||
| BILL_WTD_ORG_HRS_A | NUMBER | Billable actual weighted organization hours | ||
| BILL_WTD_RES_HRS_A | NUMBER | Billable actual weighted resource hours | ||
| TRAINING_HRS_A | NUMBER | Total hours that have work type as training | ||
| UNASSIGNED_HRS_A | NUMBER | Actual Unassigned Hours | ||
| REDUCIBLE_CAPACITY_HRS_A | NUMBER | Incremental actual reduce capacity hours | ||
| REDUCE_CAPACITY_HRS_A | NUMBER | Capacity hours less actual reduce capacity hours | ||
| CONF_HRS_S | NUMBER | Confirmed assignment hours | ||
| CONF_WTD_ORG_HRS_S | NUMBER | Confirmed assignment hours by organization | ||
| CONF_WTD_RES_HRS_S | NUMBER | Confirmed assignment hours by resource | ||
| CONF_BILL_HRS_S | NUMBER | Confirmed billable hours | ||
| CONF_BILL_WTD_ORG_HRS_S | NUMBER | Confirmed billable weighted organization hours | ||
| CONF_BILL_WTD_RES_HRS_S | NUMBER | Confirmed billable weighted resource hours | ||
| PROV_HRS_S | NUMBER | Provisional assignment hours for the resource | ||
| PROV_WTD_ORG_HRS_S | NUMBER | Provisional weighted organization hours | ||
| PROV_WTD_RES_HRS_S | NUMBER | Provisional weighted resource hours | ||
| PROV_BILL_HRS_S | NUMBER | Provisional billable hours | ||
| PROV_BILL_WTD_ORG_HRS_S | NUMBER | Provisional billable weighted organization hours | ||
| PROV_BILL_WTD_RES_HRS_S | NUMBER | Provisional billable weighted resource hours | ||
| TRAINING_HRS_S | NUMBER | Scheduled training hours | ||
| UNASSIGNED_HRS_S | NUMBER | Scheduled unassigned hours | ||
| REDUCIBLE_CAPACITY_HRS_S | NUMBER | Incremental scheduled reduce capacity hours | ||
| REDUCE_CAPACITY_HRS_S | NUMBER | Scheduled reduced capacity hours | ||
| CONF_OVERCOM_HRS_S | NUMBER | Confirmed overcommitted hours | ||
| PROV_OVERCOM_HRS_S | NUMBER | Provisional overcommitted hours | ||
| AVAILABLE_HRS_BKT1_S | NUMBER | Bucket 1 hours available | ||
| AVAILABLE_HRS_BKT2_S | NUMBER | Bucket 2 hours available | ||
| AVAILABLE_HRS_BKT3_S | NUMBER | Bucket 3 hours available | ||
| AVAILABLE_HRS_BKT4_S | NUMBER | Bucket 4 hours available | ||
| AVAILABLE_HRS_BKT5_S | NUMBER | Bucket 5 hours available | ||
| AVAILABLE_RES_COUNT_BKT1_S | NUMBER | Resources available as per bucket 1 | ||
| AVAILABLE_RES_COUNT_BKT2_S | NUMBER | Resources available as per bucket 2 | ||
| AVAILABLE_RES_COUNT_BKT3_S | NUMBER | Resources available as per bucket 3 | ||
| AVAILABLE_RES_COUNT_BKT4_S | NUMBER | Resources available as per bucket 4 | ||
| AVAILABLE_RES_COUNT_BKT5_S | NUMBER | Resources available as per bucket 5 | ||
| TOTAL_RES_COUNT | NUMBER | Total resource count | ||
| PERIOD_NAME | VARCHAR2 | (119) | Period Name. Can store different values depending on Period Type | |
| QUARTER_NAME | VARCHAR2 | (100) | Quarter Name | |
| YEAR | VARCHAR2 | (100) | Year | |
| PERIOD_START_DATE | DATE | Period Start Date | ||
| PERIOD_END_DATE | DATE | Period End Date | ||
| QUARTER_START_DATE | DATE | Quarter Start Date | ||
| QUARTER_END_DATE | DATE | Quarter End Date | ||
| YEAR_START_DATE | DATE | Year Start Date | ||
| YEAR_END_DATE | DATE | Year End Date | ||
| PERIOD_TYPE_ID | NUMBER | (15) | Yes | Level of calendar rollup: 1 - day level, 16 - week level, 32 - period level, 64 - quarter level, 128 - year level |
| CALENDAR_TYPE | VARCHAR2 | (1) | Yes | Specifies the calendar type: 'C' = Common (shared between ENT and GL), 'P' = PA calendar, 'G' = GL calendar, 'E' = Enterprise calendar |
| TIME_ID | NUMBER | (15) | Yes | Time Identifier |
| JOB_ID | NUMBER | (15) | Yes | Job Identifier |
| ORGANIZATION_ID | NUMBER | (15) | Yes | The identifier of the organization that incurred the charges |
| EXPENDITURE_ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations of expenditure item | |
| PERIOD_ID | NUMBER | Identifier for the period. Concatenation of Calendar ID, Year, Quarter, Month | ||
| PERIOD_TYPE | VARCHAR2 | (19) | Identifier for the period type. Possible values are: Week, Period, Quarter, Year | |
| QUARTER_ID | NUMBER | Quarter Identifier | ||
| YEAR_ID | NUMBER | Year Identifier | ||
| CALENDAR_ID | NUMBER | Calendar Identifier | ||
| MGR_ABSOLUTE_LEVEL | NUMBER | (15) | Yes | Manager Level |
| PERSON_ABSOLUTE_LEVEL | NUMBER | (15) | Yes | Person Level |
| PERSON_RELATIVE_LEVEL | NUMBER | Yes | Person Relative Level | |
| MANAGER_ID | NUMBER | (15) | Yes | Manager Identifier |
| PERSON_ID | NUMBER | (15) | Yes | Person Identifier |
| SUP_ASSIGNMENT_ID | NUMBER | (15) | Yes | Identifier for supervisor assignment |
| SUB_ASSIGNMENT_ID | NUMBER | (15) | Yes | Identifier for subordinate assignment |
| LAST_ACT_EXTR_DATE | NUMBER | Date of last actuals summarization run. | ||
| ORG_UTIL_CALC_METH | VARCHAR2 | (4000) | Organization utilization calculated method | |
| RES_UTIL_CALC_METH | VARCHAR2 | (4000) | Resource utilization calculated method | |
| PERSON_TYPE | VARCHAR2 | (30) | Yes | Person Type: Employee, Contingent Worker |
Cut, paste (and edit) the following text to query this object:
SELECT CAPACITY_HRS
, TOTAL_HRS_A
, MISSING_HRS_A
, TOTAL_WTD_ORG_HRS_A
, TOTAL_WTD_RES_HRS_A
, BILL_HRS_A
, BILL_WTD_ORG_HRS_A
, BILL_WTD_RES_HRS_A
, TRAINING_HRS_A
, UNASSIGNED_HRS_A
, REDUCIBLE_CAPACITY_HRS_A
, REDUCE_CAPACITY_HRS_A
, CONF_HRS_S
, CONF_WTD_ORG_HRS_S
, CONF_WTD_RES_HRS_S
, CONF_BILL_HRS_S
, CONF_BILL_WTD_ORG_HRS_S
, CONF_BILL_WTD_RES_HRS_S
, PROV_HRS_S
, PROV_WTD_ORG_HRS_S
, PROV_WTD_RES_HRS_S
, PROV_BILL_HRS_S
, PROV_BILL_WTD_ORG_HRS_S
, PROV_BILL_WTD_RES_HRS_S
, TRAINING_HRS_S
, UNASSIGNED_HRS_S
, REDUCIBLE_CAPACITY_HRS_S
, REDUCE_CAPACITY_HRS_S
, CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S
, AVAILABLE_HRS_BKT1_S
, AVAILABLE_HRS_BKT2_S
, AVAILABLE_HRS_BKT3_S
, AVAILABLE_HRS_BKT4_S
, AVAILABLE_HRS_BKT5_S
, AVAILABLE_RES_COUNT_BKT1_S
, AVAILABLE_RES_COUNT_BKT2_S
, AVAILABLE_RES_COUNT_BKT3_S
, AVAILABLE_RES_COUNT_BKT4_S
, AVAILABLE_RES_COUNT_BKT5_S
, TOTAL_RES_COUNT
, PERIOD_NAME
, QUARTER_NAME
, YEAR
, PERIOD_START_DATE
, PERIOD_END_DATE
, QUARTER_START_DATE
, QUARTER_END_DATE
, YEAR_START_DATE
, YEAR_END_DATE
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, TIME_ID
, JOB_ID
, ORGANIZATION_ID
, EXPENDITURE_ORG_ID
, PERIOD_ID
, PERIOD_TYPE
, QUARTER_ID
, YEAR_ID
, CALENDAR_ID
, MGR_ABSOLUTE_LEVEL
, PERSON_ABSOLUTE_LEVEL
, PERSON_RELATIVE_LEVEL
, MANAGER_ID
, PERSON_ID
, SUP_ASSIGNMENT_ID
, SUB_ASSIGNMENT_ID
, LAST_ACT_EXTR_DATE
, ORG_UTIL_CALC_METH
, RES_UTIL_CALC_METH
, PERSON_TYPE
FROM APPS.PJI_DIS_MGRRES_V;
APPS
FND_GLOBAL
- show dependent code
FND_PROFILE
- show dependent code
HRI_CS_SUPH_V
PER_PERSON_TYPES
PER_PERSON_TYPE_USAGES_F
PJI_ORG_EXTR_INFO
PJI_RM_RES_F
PJI_TIME_DAY_MV
PJI_UTILS
- show dependent code
PUBLIC
DUAL
APPS.PJI_DIS_MGRRES_V is not referenced by any database object
|
|
|
|