DW_FA_CAT_SEGMENT2_D

This table contains category segment 2 information.

Details

Module: Assets

Key Columns

CAT_SEGMENT_VALUESET_CODE, CAT_SEGMENT_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAT_SEGMENT_VALUESET_CODE VARCHAR2 64 True Category segment value set identifier.
CAT_SEGMENT_CODE VARCHAR2 512 True Category 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.
CAT_SEGMENT_ID VARCHAR2 512 Category segment identifier, Value is derived by combining category segment value set identifier and segment code.