[Home] [Help] [Dependency Information]
Object Name: | PJI_RM_DNGL_RES |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_RM_DNGL_RES |
Subobject Name: | |
Status: | VALID |
PJI_RM_DNGL_RES stores information about dangling records of resource summarization.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 0 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | Worker identifier | ||
ROW_ID | ROWID | (10) | Row identifier | |
CAPACITY_HRS | NUMBER | Actual capacity based on resources calendar. | ||
TOTAL_HRS_A | NUMBER | Total actual hours (as per timecards). | ||
BILL_HRS_A | NUMBER | Total hours marked billable. | ||
CONF_HRS_S | NUMBER | Number of confirmed assignment hrs. | ||
PROV_HRS_S | NUMBER | No of provisional assignment hrs for the resource. | ||
UNASSIGNED_HRS_S | NUMBER | No of available hours for the resource. | ||
CONF_OVERCOM_HRS_S | NUMBER | Confirmed overcommitted hours | ||
PROV_OVERCOM_HRS_S | NUMBER | Provisional overcommitted hours | ||
PERIOD_TYPE_ID | NUMBER | Indicates the level of calendar rollup. | ||
CALENDAR_TYPE | VARCHAR2 | (1) | Type of calendar. | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | The identifier of the organization that incurred the charges. | ||
EXPENDITURE_ORG_ID | NUMBER | Operating unit identifier for multi-organization installations of expenditure item. | ||
TIME_ID | NUMBER | Time identifier | ||
PERSON_ID | NUMBER | Person identifier | ||
JOB_ID | NUMBER | Job identifier | ||
PROJECT_ID | NUMBER | Number that uniquely identifies the project. | ||
WORK_TYPE_ID | NUMBER | Identifier for work type. | ||
DANGLING_FLAG | VARCHAR2 | (1) | Indicates whether calendar data is defined for the current row. | |
RECORD_TYPE | VARCHAR2 | (1) | Identifies the type of record. | |
GL_CALENDAR_ID | NUMBER | (15) | Global calendar identifier | |
PA_CALENDAR_ID | NUMBER | (15) | PA calendar identifier |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, ROW_ID
, CAPACITY_HRS
, TOTAL_HRS_A
, BILL_HRS_A
, CONF_HRS_S
, PROV_HRS_S
, UNASSIGNED_HRS_S
, CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID
, TIME_ID
, PERSON_ID
, JOB_ID
, PROJECT_ID
, WORK_TYPE_ID
, DANGLING_FLAG
, RECORD_TYPE
, GL_CALENDAR_ID
, PA_CALENDAR_ID
FROM PJI.PJI_RM_DNGL_RES;
PJI.PJI_RM_DNGL_RES does not reference any database object
PJI.PJI_RM_DNGL_RES is referenced by following:
|
|
|