DW_FA_KEY_SEGMENT1_D

This table contains asset key segment information.

Details

Module: Assets

Key Columns

KEY_SEGMENT_VALUESET_CODE, KEY_SEGMENT_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
KEY_SEGMENT_VALUESET_CODE VARCHAR2 64 True Asset Key segment value set identifier.
KEY_SEGMENT_CODE VARCHAR2 512 True Asset Key segment code.
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of accounting segment value set identifier and accounting segment code.
KEY_SEGMENT_ID VARCHAR2 512 Asset Key segment identifier, Value is derived by combining Asset Key segment value set identifier and segment code.