[Home] [Help] [Dependency Information]
Object Name: | PJI_DIS_RESWT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PJI.PJI_DIS_RESWT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Discoverer view of resource work type utilization data.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAPACITY_HRS | NUMBER | Actual capacity based on resources calendar | ||
RES_TOTAL_HRS | NUMBER | Resource total actual hours | ||
RES_CONF_HRS | NUMBER | Resource confirmed scheduled hours | ||
RES_REDUCE_CAP_HRS_A | NUMBER | Resource total actuals hours less reduce capacity hours | ||
RES_REDUCE_CAP_HRS_S | NUMBER | Resource total scheduled hours less reduce capacity hours | ||
TOTAL_HRS_A | NUMBER | Total actual hours (as per timecards) | ||
BILL_HRS_A | NUMBER | Billable actual hours | ||
CONF_HRS_S | NUMBER | Confirmed assignment hours | ||
PROV_HRS_S | NUMBER | Provisional assignment hours for the resource | ||
CONF_OVERCOM_HRS_S | NUMBER | Confirmed over committed hours | ||
PROV_OVERCOM_HRS_S | NUMBER | Provisional over committed hours | ||
PERIOD_NAME | VARCHAR2 | (119) | Period name | |
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) | Level of calendar rollup | |
CALENDAR_TYPE | VARCHAR2 | (1) | Type of calendar | |
TIME_ID | NUMBER | (15) | Time identifier | |
PERSON_ID | NUMBER | (15) | Person identifier | |
JOB_ID | NUMBER | (15) | Job identifier | |
WORK_TYPE_ID | NUMBER | Work type identifier | ||
ORGANIZATION_ID | NUMBER | Identifier for the organization | ||
SUB_ORGANIZATION_ID | NUMBER | Identifier for subordinate organization | ||
ORGANIZATION_LEVEL | NUMBER | Level of the organization | ||
SUB_ORGANIZATION_LEVEL | NUMBER | Subordinate organization level | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization name |
SUB_ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Subordinate organization name |
EXPENDITURE_ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations of expenditure item | |
PERIOD_ID | NUMBER | Identifier for the Period | ||
PERIOD_TYPE | VARCHAR2 | (19) | Identifier for the period type | |
QUARTER_ID | NUMBER | Identifier for quarter | ||
YEAR_ID | NUMBER | Identifier for the year | ||
CALENDAR_ID | NUMBER | Identifier for the calendar | ||
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 calculation method | |
PERSON_TYPE | VARCHAR2 | (30) | Yes | Person type |
Cut, paste (and edit) the following text to query this object:
SELECT CAPACITY_HRS
, RES_TOTAL_HRS
, RES_CONF_HRS
, RES_REDUCE_CAP_HRS_A
, RES_REDUCE_CAP_HRS_S
, TOTAL_HRS_A
, BILL_HRS_A
, CONF_HRS_S
, PROV_HRS_S
, CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S
, 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
, PERSON_ID
, JOB_ID
, WORK_TYPE_ID
, ORGANIZATION_ID
, SUB_ORGANIZATION_ID
, ORGANIZATION_LEVEL
, SUB_ORGANIZATION_LEVEL
, ORGANIZATION_NAME
, SUB_ORGANIZATION_NAME
, EXPENDITURE_ORG_ID
, PERIOD_ID
, PERIOD_TYPE
, QUARTER_ID
, YEAR_ID
, CALENDAR_ID
, LAST_ACT_EXTR_DATE
, ORG_UTIL_CALC_METH
, RES_UTIL_CALC_METH
, PERSON_TYPE
FROM APPS.PJI_DIS_RESWT_V;
APPS.PJI_DIS_RESWT_V is not referenced by any database object
|
|
|