This table requires activation of Advanced Collections functional area. Stores case folder header details sourced from IEX_CASE_FOLDERS.
Module: Advanced Collections
CASE_FOLDER_ID
| 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.