# DW_FA_ASSET_KEYWORDS_D

This is the FA dimension table for Fixed asset Keywords details

## Details

Module: Assets

## Key Columns

ASSET_KEY_CCID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSET_KEY_CCID | NUMBER | 38 | 0 | True | Asset Keyword identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset Keyword identifier. |  |
ENABLED_FLAG | VARCHAR2 | 16 |  |  | Option indicating whether the asset keyword is active or not. |  |
START_DATE_ACTIVE | DATE |  |  |  | Date when the asset keyword became active. |  |
END_DATE_ACTIVE | DATE |  |  |  | Date when the asset keyword became inactive. |  |
STRUCTURE_INSTANCE_NUMBER | NUMBER | 38 | 0 |  |  |  |
CONCAT_SEGMENTS | VARCHAR2 | 999 |  |  |  |  |
KEY_SEGMENT1 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT2 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT3 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT4 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT5 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT6 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT7 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT8 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT9 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |
KEY_SEGMENT10 | VARCHAR2 | 32 |  |  | Key Flexfield: segment of the key flexfield. |  |
KEY_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  |  |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.