PJO_PLANNING_ELEMENT_GT

Global temporary table used during forecast generation to store planning element details for the target version.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

Columns

Name
TASK_IDNUMBERIdentifier of the task. RBS_ELEMENT_IDNUMBERIdentifier of the resource breakdown structure element. PLANNING_ELEMENT_IDNUMBERIdentifier of the planning element. TOP_TASK_IDNUMBERIdentifier of the top task associated with the task for the planning element. PLANNING_START_DATEDATEStart date of the planning element. PLANNING_END_DATEDATEEnd date of the planning element.

Indexes

Index	Uniqueness	Columns
PJO_PLANNING_ELEMENT_GT_N1	Non Unique	TASK_ID
PJO_PLANNING_ELEMENT_GT_N2	Non Unique	RBS_ELEMENT_ID