User Schema
- File Name:
user.parquet - Type: Full
- Schema Version: 01.00
- Last Updated: 2026-02-25
Description
Contains user account information including contact details, role assignments, organizational assignments, and notification preferences.
Fields
📋 Includes Common Fields: Client Information, Audit Fields
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FirstName | nvarchar(50) | NOT NULL | User first name |
| LastName | nvarchar(50) | NOT NULL | User last name |
| PrimaryEmail | nvarchar(255) | NOT NULL | Primary email address |
| Phone | varchar(50) | NOT NULL | Primary phone number |
| EmployerName | varchar(500) | NULL | Employer name |
| Role | varchar(100) | NULL | User role name |
| PreferedNotificationTypeIds | varchar(100) | NOT NULL | Preferred notification type IDs |
| MarketId | varchar | NULL | Comma-separated market IDs |
| Market | varchar | NULL | Comma-separated market names |
| KeyAccount | varchar | NULL | Comma-separated key account names |
| ClassificationId | varchar | NULL | Comma-separated classification IDs |
| Classification | varchar | NULL | Comma-separated classification names |
| DistributorId | varchar | NULL | Comma-separated distributor IDs |
| Distributor | varchar | NULL | Comma-separated distributor names |
| ClientName | nvarchar(50) | NOT NULL | Name of the client |
| ClientCode | varchar(10) | NOT NULL | Code of the client |
| ReportingManager | nvarchar(50) | NOT NULL | Reporting manager first name |
| LastLoginOnUTC | datetime | NULL | Last login timestamp (UTC) |
| CreatedByUser | varchar(50) | NOT NULL | Email of creator |
| CreatedOn | datetime | NOT NULL | Record creation timestamp |
| ModifiedByUser | varchar(50) | NOT NULL | Email of last modifier |
| ModifiedOn | datetime | NOT NULL | Record modification timestamp |
| ExternalClientUserCode | nvarchar(250) | NULL | External system user code |