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     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, 2023, Oracle and/or its affiliates.