XLE_HISTORY_COLUMNS_B

XLE_HISTORY_COLUMNS_B contains the information about tracked legal entity and establishment attributes.

Details

  • Schema: FUSION

  • Object owner: XLE

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

XLE_HISTORY_COLUMNS_B_PK

HISTORY_COLUMN_ID

Columns

Name Datatype Length Precision Not-null Comments
HISTORY_COLUMN_ID NUMBER 18 Yes Unique identifier of the table XLE_HISTORY_COLUMNS_B. Not currently used.
SOURCE_TABLE VARCHAR2 30 Yes Name of the table containing the tracked column.
SOURCE_COLUMN_NAME VARCHAR2 30 Yes Name of the tracked column. Not currently used.
GEOGRAPHY_ID NUMBER 18 Geography Identifier. For tracking country dependent columns.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
ENTERPRISE_ID NUMBER 18 Enterprise or business group identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
XLE_HISTORY_COLUMNS_B hz_geographies GEOGRAPHY_ID
xle_history_columns_tl xle_history_columns_b HISTORY_COLUMN_ID

Indexes

Index Uniqueness Tablespace Columns
XLE_HISTORY_COLUMNS_B_U1 Unique Default HISTORY_COLUMN_ID