DIMUSER

This dimension table stores user-related information.

Columns

Column	Data type	Description
BUILDID	NUMBER	Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows.
CUSTOMERKEY	NUMBER	A foreign key referencing the customer record in the DIMCUSTOMER table.
HCM	NUMBER	An indication of whether it is an HCM user or not.
OFFICEID	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
OFFICEKEY	NUMBER	A foreign key referencing the office in the DIMOFFICE table.
RESOURCEALO	NUMBER	Indicates whether the user is a resource allocation user for staffing company (1) or not (0).
USERACTIVE	NUMBER	An indication of whether the user record is active or not.
USERCLAIMTYPE	VARCHAR	The user category such as Recruiter, Admin, General, etc.
USERCREATEDATE	TIMESTAMP_NTZ	The date and time when the user record was created.
USEREMAIL	VARCHAR	The user's email.
USERFIRSTNAME	VARCHAR	The user's first name.
USERID	NUMBER	The identifier for the user.
USERKEY	NUMBER	The identifier for the user.
USERLASTNAME	VARCHAR	The user's last name.
USERTYPE	VARCHAR	The type of the user.
USERUPDATEDATE	TIMESTAMP_NTZ	The date and time when the user record was last updated.