Audit Case

Audit Case Data Model

The following data model illustrates the Audit Case object.

Audit Case Data Model

Audit 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*
Audit Case	C1_AUDIT_CASE	Yes. C1_AUDIT_CASE_K	VAL-AUDT	CIPVAUDV	CIPVAUDK	CIPVAUDI
Audit Case Related Person	C1_AUDIT_CASE_PER	No. The key is Audit Case ID, Relationship Type, and Person ID.		CIPVAUPV		CIPVAUPI
Audit Case Audited Obligation	C1_AUDIT_CASE_SA	No. The key is Audit Case ID and Obligation ID.		CIPVAUSV		CIPVAUSI
Audit Case Review	C1_AUDIT_CASE_REVIEW	No. The key is Audit Case ID and Review ID.		CIPVAURV		CIPVAURI
Audit Case Responsible User	C1_AUDIT_CASE_RESP_USER	No. The key is Audit Case ID, Assignment Role Flag, and User ID.		CIPVAUUV		CIPVAUUI
Audit Case Characteristic	C1_AUDIT_CASE_CHAR	No. The key is Audit Case ID, Characteristic Type, and Sequence.		CIPVAUCV		CIPVAUCI
Audit Case Log	C1_AUDIT_CASE_LOG	No. The key is Audit Case ID and Sequence.		CIPVAULV		CIPVAULI
Audit Case Log Parameter	C1_AUDIT_CASE_LOG_PARM	No. The key is Audit Case ID, Sequence, and Message Parameter Sequence.		CIPVAUMV		CIPVAUMI

Audit 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.