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.