1. Tables and Views for Financials
  2. FUN_DATA_SLICES_B_

FUN_DATA_SLICES_B_

FUN_DATA_SLICES_B contains data slice definitions. Each data slice in your application is assigned a unique data slice name. This table has no foreign keys other than the standard Who columns.

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FUN_DATA_SLICES_B_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, DATA_SLICE_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_SLICE_ID NUMBER 18 Yes Data slice definition identifier.
DATA_SLICE_CODE VARCHAR2 30 Code for the data slice definition name.
DATA_SOURCE_OBJECT_TYPE VARCHAR2 30 Data source of a data slice. Possible values are AV, BV, and Extraction Query.
DATA_SOURCE_OBJECT_ID NUMBER 18 Data source definition identifier.
ENABLED_FLAG VARCHAR2 1 Indicates whether the data slice is enabled.
ATTRIBUTE_LIST BLOB Data sources dimensions and measures used in this data slice.
DERIVED_ATTRIBUTE_LIST BLOB Derived attributes used in this data slice.
FILTER_CRITERIA BLOB Data slice filter criteria across all attributes.
EXTRACT_QUERY BLOB Extraction query used in defining the data slice.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
APPLICATION_ID NUMBER 18 Yes Identifier associated with the application.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates 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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Used 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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
FUN_DATA_SLICE_B_N1 Non Unique Default DATA_SLICE_ID
FUN_DATA_SLICE_B_U1 Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, DATA_SLICE_ID