PJO_XBS_DENORM_GT

Stores the new denorm structure of the project.

Details

• Schema: FUSION

• Object owner: PJO

• Object type: TABLE

Primary Key

Name	Columns
PJO_XBS_DENORM_GT_PK	STRUCT_VERSION_ID, SUB_EMT_ID, SUP_EMT_ID

Columns

Name
PROJECT_IDNUMBER18PROJECT_ID ***** STRUCT_VERSION_IDNUMBER18YesSTRUCT_VERSION_ID ***** SUB_LEVELNUMBER3SUB_LEVEL ***** SUP_LEVELNUMBER3SUP_LEVEL ***** SUB_EMT_IDNUMBER18YesSUB_EMT_ID ***** SUP_EMT_IDNUMBER18YesSUP_EMT_ID *****

Indexes

Index	Uniqueness	Columns
PJO_XBS_DENORM_GT_U1	Unique	STRUCT_VERSION_ID, SUB_EMT_ID, SUP_EMT_ID