Audit set definition for all name and address modifications
We recommend that you adopt this example as an initial base and perform any adjustments after viewing the resultant reports.
This table shows the information about what entities and fields should be selected to define
a complete audit set for the Name and Address application:
Entity path | Report field | If record Created | If record Deleted | If Record Updated | If value Changed | Entity link fields to report |
---|---|---|---|---|---|---|
CNAIDTY | FORMATNAME | Yes | Yes | No | Yes | |
NAMETYPE | Yes | Yes | No | Yes | ||
SALUTATION | Yes | Yes | No | Yes | ||
ACTIVE | Yes | Yes | No | Yes | ||
TFKCNACATG | Yes | Yes | No | Yes | DESCR | |
CNAIDTY > CNACPNY | COMPNAME | Yes | Yes | No | Yes | |
ISGOVT | Yes | Yes | No | Yes | ||
CNAMECASE | Yes | Yes | No | Yes | ||
CNAIDTY > CNACPNY > CNACCOM | DESCR | Yes | Yes | Yes | No | |
TFKCNACOMT | Yes | Yes | Yes | No | COMMTYPE | |
COMPANYSEQ | Yes | Yes | No | Yes | ||
CNAIDTY > CNACPNY > CNACINF | DESCR | Yes | Yes | Yes | No | |
TFKCNAINFT | Yes | Yes | Yes | No | INFOTYPE | |
COMPANYSEQ | Yes | Yes | No | Yes | ||
CNAIDTY > CNAIDTA | DATEEFFECT | Yes | Yes | Yes | No | |
TFKCNAADDR | Yes | Yes | Yes | No | FORMATADDR | |
CNAIDTY > CNAIDTA > CNAADDR | FORMATADDR | Yes | Yes | No | Yes | |
CNAIDTY > CNAPERS | TFKCNATITL | Yes | Yes | No | Yes | TITLE |
SURNAME | Yes | Yes | No | Yes | ||
GIVENNAME | Yes | Yes | No | Yes | ||
GENDER | Yes | Yes | No | Yes | ||
BIRTHDATE | Yes | Yes | No | Yes | ||
ISDECEASED | Yes | Yes | No | Yes | ||
ISPRIVATE | Yes | Yes | No | Yes | ||
SNAMECASE | Yes | Yes | No | Yes | ||
GNAMECASE | Yes | Yes | No | Yes | ||
CNAIDTY > CNAPERS > CNAPCOM | DESCR | Yes | Yes | Yes | No | |
TFKCNACOMT | Yes | Yes | Yes | No | COMMTYPE | |
PERSONSEQ | Yes | Yes | No | Yes | ||
CNAIDTY > CNAPERS > CNAPINF | DESCR | Yes | Yes | Yes | No | |
TFKCNAINFT | Yes | Yes | Yes | No | INFOTYPE | |
PERSONSEQ | Yes | Yes | No | Yes | ||
CNAIDTY > CNAROLE | FKCNAROLTA | Yes | Yes | Yes | No | |
FKCNAROLTN | Yes | Yes | Yes | No | DESCR | |
TFKAPPL | Yes | Yes | Yes | No | Calling Application Entity | |
STATUS | Yes | Yes | Yes | No | ||
FORMATNAME | Yes | Yes | No | Yes | ||
NAMEFORMAT | Yes | Yes | No | Yes | ||
CREATEDATE | Yes | Yes | No | Yes | ||
HISTDATE | Yes | Yes | No | Yes | ||
CNAIDTY > CNAROLE > CNAROLA | DATEEFFECT | Yes | Yes | Yes | No | |
TFKCNAADDR | Yes | Yes | Yes | No | FORMATADDR | |
ISACTIVE | Yes | Yes | No | Yes | ||
CNAIDTY > CNAROLE > CNAROLA > CNAADDR | FORMATADDR | Yes | Yes | No | Yes |