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 This column is for Oracle Internal use only. 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