eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PJI.PJI_FM_EXTR_PLNVER3_T

Object Details

Object Name:	PJI_FM_EXTR_PLNVER3_T
Object Type:	TABLE
Owner:	PJI
Subobject Name:
Status:	VALID

This table stores information about plan versions that are processed by extraction.

Temporary Table Details

PJI.PJI_FM_EXTR_PLNVER3_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER		Project Identifier.
PLAN_VERSION_ID	NUMBER		Plan version identifier.
WBS_STRUCT_VERSION_ID	NUMBER		WBS Structure version identifier.
RBS_STRUCT_VERSION_ID	NUMBER		RBS Structure version identifier.
PLAN_TYPE_ID	NUMBER		Plan type identifier.
PLAN_TYPE_CODE	VARCHAR2	(30)	Plan type code based on financial plan type identifier for this project. Eg: Revenue, cost, both revenue and cost, etc.
TIME_PHASED_TYPE_CODE	VARCHAR2	(30)	Time phased code by which entries are made into budget lines table. Valid values are: P- PA calendar, G- GL calendar, N- Non time phased, R- Date range.
TIME_DANGLING_FLAG	VARCHAR2	(1)	Flag for whether TIME dangling record exists for this plan version: valid values T/F
RATE_DANGLING_FLAG	VARCHAR2	(1)	Flag for whether RATE dangling record exists for this plan version: valid values T/F
PROJECT_TYPE_CLASS	VARCHAR2	(1)	Project type class: valid values are: C- Capital, B- Contract or I- Indirect.
WP_FLAG	VARCHAR2	(1)	Flag for whether this is a Work Plan (Y) or Financial plan (N).
CURRENT_FLAG	VARCHAR2	(1)	Flag for whether this plan version is current (Y/N).
ORIGINAL_FLAG	VARCHAR2	(1)	Flag for whether this plan version is original (Y/N).
CURRENT_ORIGINAL_FLAG	VARCHAR2	(1)	Flag for whether this plan version is current original (Y/N).
BASELINED_FLAG	VARCHAR2	(1)	Flag for whether this plan version is baselined (Y/N).
SECONDARY_RBS_FLAG	VARCHAR2	(1)	Secondary RBS Flag
LP_FLAG	VARCHAR2	(1)	Latest Published Structure flag
WORKER_ID	NUMBER	(15)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT_ID
,      PLAN_VERSION_ID
,      WBS_STRUCT_VERSION_ID
,      RBS_STRUCT_VERSION_ID
,      PLAN_TYPE_ID
,      PLAN_TYPE_CODE
,      TIME_PHASED_TYPE_CODE
,      TIME_DANGLING_FLAG
,      RATE_DANGLING_FLAG
,      PROJECT_TYPE_CLASS
,      WP_FLAG
,      CURRENT_FLAG
,      ORIGINAL_FLAG
,      CURRENT_ORIGINAL_FLAG
,      BASELINED_FLAG
,      SECONDARY_RBS_FLAG
,      LP_FLAG
,      WORKER_ID
FROM PJI.PJI_FM_EXTR_PLNVER3_T;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_PLNVER3_T does not reference any database object

PJI.PJI_FM_EXTR_PLNVER3_T is referenced by following:

APPS: PJI_FM_EXTR_PLNVER3_T