← Back to Schema
Accounts

att_accounts

Stores a point-in-time copy of an account at campaign-start time for Saviynt's legacy attestation process. The snapshot preserves the version of that object that was included in the attestation so it can be reviewed independently of later changes to the live record.

Medium
34 Columns
1 Primary Keys
2 Indexed

Columns

Complete column definition for att_accounts

34 columns ›
⌕ 34
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 varchar 255 — —
3 varchar 255 — —
4 bigint 20 — —
5 varchar 255 — —
6 varchar 255 — —
7 datetime — — —
8 varchar 255 — —
9 varchar 255 — —
10 varchar 255 — —
11 varchar 255 — —
12 varchar 255 — —
13 varchar 255 — —
14 varchar 255 — —
15 varchar 255 — —
16 INDEX bigint 20 MUL —
17 bigint 20 — —
18 bigint 20 — —
19 datetime — — —
20 datetime — — —
21 varchar 255 — —
22 bit 1 — —
23 varchar 255 — —
24 datetime — — —
25 varchar 255 — —
26 varchar 255 — —
27 INDEX bigint 20 MUL —
28 varchar 255 — —
29 bigint 20 — —
30 datetime — — —
31 varchar 255 — —
32 bigint 20 — —
33 datetime — — —
34 datetime — — —