PJO_XBS_DENORM_DELTA_GT

Global temporary table that identifies the differences in task structure after the last online summarization.

Details

  • Schema: FUSION

  • Object owner: PJO

  • Object type: TABLE

Columns

Name

PROJECT_IDNUMBER18YesIdentifier of the project.

STRUCT_VERSION_IDNUMBER18YesIdentifier of the task structure version.

SUP_VERSION_IDNUMBER18Task or element identifier of the summary task of the current task.

SUB_VERSION_IDNUMBER18Task or element identifier of the current task.

SUB_LEVELNUMBER3YesLevel of the subtask in the task hierarchy.

SUP_LEVELNUMBER3YesLevel of the summary task in the task hierarchy.

SUB_EMT_IDNUMBER18YesIdentifier of the subtask.

SUP_EMT_IDNUMBER18YesIdentifier of the parent task.

SIGNNUMBER3YesIndicates that the task must be added or deleted. Value is +1 if task is to be added and -1 if task must be deleted.