Technical DB attributes
The technical attributes described below are not table-specific. As these attributes exist in most tables, they are not listed later on in this chapter.
| DB attribute | Java data type (max. size), Defaults | Description |
|---|---|---|
| ctl_cre_date | Date, not NULL | Creation date. |
| ctl_cre_uid | String(110), not NULL | LoginID of the user who created the entry. |
| ctl_mod_dat | Date, not NULL | Date of the latest modification. |
| ctl_mod_uid | String(110), not NULL | LoginID of the user who last modified the entry. |
| ctl_tcn | int, not NULL | Counter used for optimistic locking. |
The main purpose of the technical attributes listed in the table above is traceability and audit: who has changed an entry, and when. These technical attributes provide the base for the versioning feature, which collects the complete history of all entries within separate DB tables (see below in this chapter).
Another use case of these technical attributes is data provisioning from and to other systems. While the technical attributes are not shown in the nevisIDM web GUI, some methods of the SOAP interface allow to query nevisIDM data based on the technical attributes to, e.g., export lately changed nevisIDM data into an ActiveDirectory.