Case

Case Data Model

The following data model illustrates the Case object.

Case Data Model

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

Case

CI_​CASE

Yes. CI_​CASE_​K

VAL-CASE

CIPVCSEK

CIPVCSEI

Case Characteristic

CI_​CASE_​CHAR

No. The key is case id, char type code and a sequence number

CIPVCCHV

CIPVCCHI

Case Log

CI_​CASE_​LOG

No. The key is case id and a log sequence number

CIPVCLGV

CIPVCLGI

Case Log Parameter

CI_​CASE_​LOG_​PARM

No. The key is case id, log sequence number and a parameter sequence number

CIPVCPAV

CIPVCPAI

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.