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	Description
FirstName	varchar	User first name
LastName	varchar	User last name
PrimaryEmail	varchar	Primary email address
Phone	varchar	Primary phone number
EmployerName	varchar	Employer name
Role	varchar	User role name
PreferedNotificationTypeIds	varchar	Preferred notification type IDs
MarketId	varchar	Comma-separated market IDs
Market	varchar	Comma-separated market names
KeyAccount	varchar	Comma-separated key account names
ClassificationId	varchar	Comma-separated classification IDs
Classification	varchar	Comma-separated classification names
DistributorId	varchar	Comma-separated distributor IDs
Distributor	varchar	Comma-separated distributor names
ClientName	varchar	Name of the client
ClientCode	varchar	Code of the client
ReportingManager	varchar	Reporting manager first name
LastLoginOnUTC	datetime	Last login timestamp (UTC)
CreatedByUser	varchar	Email of creator
CreatedOn	datetime	Record creation timestamp
ModifiedByUser	varchar	Email of last modifier
ModifiedOn	datetime	Record modification timestamp
ExternalClientUserCode	varchar	External system user code