DW_FA_CATEGORIES_D

This is the FA dimension table for Fixed asset Category details

Details

Module: Assets

Key Columns

CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_ID NUMBER 38 0 True Unique identification number for each asset category you defined.
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Category identifier.
CATEGORY_TYPE VARCHAR2 32 Indicates the category type Oracle Assets uses to classify assets in this asset category
DESCRIPTION VARCHAR2 64 Category Description
ENABLED_FLAG VARCHAR2 16 Indicates whether this category is still valid
START_DATE_ACTIVE DATE Date that you can begin using this asset category
END_DATE_ACTIVE DATE Last date you can add assets to this asset category
CAPITALIZE_FLAG VARCHAR2 16 YES if assets in this category are capitalized assets
STRUCTURE_INSTANCE_NUMBER NUMBER 38 0
CONCAT_SEGMENTS VARCHAR2 999
CAT_SEGMENT1 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT1_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT2 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT2_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT3 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT3_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT4 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT4_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT5 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT5_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT6 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT6_VALUESET_CODE VARCHAR2 64
CAT_SEGMENT7 VARCHAR2 32 Key Flexfield: segment of the key flexfield.
CAT_SEGMENT7_VALUESET_CODE VARCHAR2 64