DW_CXSR_CATEGORIES_D_TL

Details

Module: Service Request Management

Key Columns

CATEGORY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CATEGORY_ID NUMBER 38 0 True Category    
SOURCE_RECORD_ID VARCHAR2 256     System    
CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    
PARENT_CATEGORY_ID NUMBER 38 0   Foreign key that references SVC_CATEGORIES(CATEGORY_ID). Defines category hierarchy by storing the parent category ID, or null if this is a root category.    
CATEGORY_SHORT_NAME VARCHAR2 256     Auto-generated from CATEGORY_NAME when new, but can be updated to make this value unique or for any other purpose.    
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 256     Specifies the original system reference if record was imported.    
ENABLED_FLAG VARCHAR2 16     Indicates whether the category is enabled (Y or N).    
DELETED_FLAG VARCHAR2 16     Indicates whether the category is logically deleted (Y or N).    
CSS_FLAG VARCHAR2 16     Indicates whether the category is visible in CSS portal (Y or N).    
STRIPE_CODE VARCHAR2 32     Lookup code that indicates the stripe code, such as CRM or HCM.    
BUSINESS_UNIT_ORGANIZATION_ID NUMBER 38 0   Stores the Business Unit Org Id of the category. DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
CATEGORY_NAME VARCHAR2 512     Category Name    
LANGUAGE VARCHAR2 16     Language    
SOURCE_LANGUAGE VARCHAR2 16     Source Language    

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