Collection Case

Collection Case Data Model

The following data model illustrates the Collection Case object.

Collection Case Data Model

Collection Case Table Names

*Data Model Name*	*Table Name*	*Generated Keys*	*Object Validation Batch Control*	*Referential Integrity Validation Batch Control*	*Key Assignment Batch Control*	*Insertion Batch Control*
Collection Case	CI_COLL_CASE	Yes. CI_COLL_CASE_K	VAL-CLCS	CIPVCCSV	CIPVCCSK	CIPVCCSI
Collection Case Characteristic	CI_COLL_CASE_CHAR	No. The key is Collection Case ID. Characteristic Type, and Sequence.		CIPVCCCV		CIPVCCCI
Collection Case Log	CI_COLL_CASE_LOG	No. The key is Collection Case ID and Sequence.		CIPVCCLV		CIPVCCLI
Collection Case Log Parameter	CI_COLL_CASE_LOG_PARM	No. The key is Collection Case ID, Sequence, and Message Parameter Sequence.		CIPVCCPV		CIPVCCPI
Collection Case Overdue Process	CI_COLL_CASE_OD	No. The key is Collection Case ID and Overdue Process ID.		CCIPVCCOV		CCIPVCCOI

Collection Case Suggestions

This maintenance object includes a character large object field that your organization may be using to capture implementation specific data as defined by your business objects. For records of this type, the process to insert the records to the staging table is responsible for populating the data in this CLOB as per the record's business object schema.