[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJI_RM_RES_F |
|---|---|
| Object Type: | TABLE |
| Owner: | PJI |
| FND Design Data: |  PJI.PJI_RM_RES_F
|
| Subobject Name: | |
| Status: | VALID |
This table stores summarized data for utilization and availabilty measures by resources for project intelligence
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 0 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PJI_RM_RES_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
 TIME_ID
EXPENDITURE_ORGANIZATION_ID
CALENDAR_TYPE
|
| PJI_RM_RES_F_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
PERSON_ID
TIME_ID
CALENDAR_TYPE
|
| 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 hrs that have work type as training. | ||
| UNASSIGNED_HRS_A | NUMBER | Actual unassigned hours | ||
| REDUCE_CAPACITY_HRS_A | NUMBER | Capacity hours less actual reduce capacity hours. | ||
| CONF_HRS_S | NUMBER | No of confirmed assignment hrs. | ||
| CONF_WTD_ORG_HRS_S | NUMBER | No of confirmed assignment hrs by org. | ||
| CONF_WTD_RES_HRS_S | NUMBER | No of confirmed assignment hrs 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 | No of provisional assignment hrs 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 | ||
| REDUCE_CAPACITY_HRS_S | NUMBER | Scheduled reduced capacity hours | ||
| CONF_OVERCOM_HRS_S | NUMBER | Confirmed over committed hours | ||
| PROV_OVERCOM_HRS_S | NUMBER | Provisional over committed 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_TYPE_ID | NUMBER | (15) | Yes | Level of calendar rollup |
| CALENDAR_TYPE | VARCHAR2 | (1) | Yes | Type of calendar |
| EXPENDITURE_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. | |
| TIME_ID | NUMBER | (15) | Yes | Time identifier |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
| JOB_ID | NUMBER | (15) | Yes | Job identifier |
| CREATION_DATE | DATE | Yes | Standard who column | |
| CREATED_BY | NUMBER | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
| REDUCIBLE_CAPACITY_HRS_A | NUMBER | Actual reduce capacity hours | ||
| REDUCIBLE_CAPACITY_HRS_S | NUMBER | Scheduled reduce capacity hours |
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
, 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
, 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_TYPE_ID
, CALENDAR_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID
, TIME_ID
, PERSON_ID
, JOB_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REDUCIBLE_CAPACITY_HRS_A
, REDUCIBLE_CAPACITY_HRS_S
FROM PJI.PJI_RM_RES_F;
PJI.PJI_RM_RES_F does not reference any database object
PJI.PJI_RM_RES_F is referenced by following:
APPS
PJI_RM_JOB_F_MV
PJI_RM_ORG_F_MV
PJI_RM_RES_F
|
|
|
|