PJF_ORG_DENORM_MSG

This table is a processing table created for storing the possible error and warning message entries for the organization hierarchy tree de-normalization process. This is created for the BIP report of the errors and warnings.

Details

Schema: FUSION
Object owner: PJF
Object type: TABLE

Primary Key

Name	Columns
PJF_ORG_DENORM_MSG_PK	MESSAGE_ID

Columns

Name
MESSAGE_IDNUMBER18YesMESSAGE_ID MESSAGE_NAMEVARCHAR230YesMESSAGE_NAME ERROR_WARNINGVARCHAR21YesERROR_WARNING TREE_STRUCTURE_CODEVARCHAR230TREE_STRUCTURE_CODE TREE_CODEVARCHAR230TREE_CODE TREE_VERSION_IDVARCHAR232TREE_VERSION_ID CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row. CREATED_BYVARCHAR264YesWho column: indicates the user who created the row. LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row. LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row. LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row. OBJECT_VERSION_NUMBERNUMBER9YesUsed to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Name

MESSAGE_IDNUMBER18YesMESSAGE_ID

MESSAGE_NAMEVARCHAR230YesMESSAGE_NAME

ERROR_WARNINGVARCHAR21YesERROR_WARNING

TREE_STRUCTURE_CODEVARCHAR230TREE_STRUCTURE_CODE

TREE_CODEVARCHAR230TREE_CODE

TREE_VERSION_IDVARCHAR232TREE_VERSION_ID

CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row.

CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.

LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row.

LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row.

LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row.

OBJECT_VERSION_NUMBERNUMBER9YesUsed to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Columns
PJF_ORG_DENORM_MSG_U1	Unique	MESSAGE_ID