User Schema

• File Name: user.parquet
• Type: Full
• Schema Versions: 01.00, 01.01
• Last Updated: 2026-10-25

Description

Contains user account information including contact details, role assignments, organizational assignments, and notification preferences.

Version compatibility

Version 01.00 retains EmployerName in its original column position as a nullable compatibility field. Its value is always null; employer values are no longer exported. Version 01.01 omits that column and retains the other columns in the same order. Choose the version explicitly when migrating a consumer; existing jobs are not automatically upgraded.

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	Version 01.00 only: always null for compatibility; omitted in 01.01
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