Map materialized user information for audit
Data model
Fields
| Field | Type | Description |
|---|---|---|
| end_date | DATETIME | Date on which the materialized registration ended its validity |
| id* | INT | Primary Table Key |
| is_current* | BIT | Flag indicating whether the current registration is current |
| start_date* | DATETIME | Date on which the materialized registration began its validity |
| user_email | NVARCHAR (510) | User Email |
| user_id* | INT | User ID |
| user_name* | NVARCHAR (510) | Username |
| user_nick_name | NVARCHAR (510) | Username used to log in |
| user_phone1 | NVARCHAR (510) | The person’s first phone number |
Primary Key
| PK_AVS_AUDIT_USERS |
|---|
| id |