Module: Service Request Management
CATEGORY_ID
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.