DBA Data[Home] [Help] [Dependency Information]

TABLE: PJI.PJI_RM_DNGL_RES

Object Details
Object Name: PJI_RM_DNGL_RES
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_RM_DNGL_RES
Subobject Name:
Status: VALID


PJI_RM_DNGL_RES stores information about dangling records of resource summarization.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 0
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

PJI.PJI_RM_DNGL_RES does not reference any database object

PJI.PJI_RM_DNGL_RES is referenced by following:

SchemaPJI
ViewPJI_RM_DNGL_RES#