# DW_AC_IEX_CASE_FOLDERS_D (Preview)

This table requires activation of Advanced Collections functional area. Stores case folder header details sourced from IEX_CASE_FOLDERS.

## Details

Module: Advanced Collections

## Key Columns

CASE_FOLDER_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CASE_FOLDER_ID | NUMBER | 38 | 0 | True | Unique identifier of the case folder. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CASE_FOLDER_NUMBER | VARCHAR2 | 32 |  |  | Case folder number. |  |
CASE_FOLDER_STATUS_CODE | VARCHAR2 | 32 |  |  | Status code of the case folder. | DW_AC_AR_CMGT_CASE_FOLDER_STATUS_TL | AR_CMGT_CASE_FOLDER_STATUS_CODE
CASE_FOLDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Type code of the case folder. | DW_AC_IEX_UNPAID_REASON_TL | IEX_UNPAID_REASON_CODE
COMMENTS | VARCHAR2 | 999 |  |  | Comments captured for the case folder. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: timestamp when the row was created. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: timestamp of the last update. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.