IDM - Tenant

Last updated
Save as PDF

Contents

Dimension Tables
- dim_module
- dim_license
- dim_tenant
- dim_tenant_product
- dim_product
- dim_license_subtype
Calculated Tables
- cal_tenants

Dimension Tables

dim_module


Column	Type	Mandatory	UDM mapping	Note
module_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
name	string	True	name
parent_id	string		parent_id	dim_module.id
edw_start_time	timestamp	True		ETL internal usage PowerBI should never use it for any report
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True		the timestamp from published UDM message mandatory header: timestamp ETL or PowerBI could use it to sort and order the data
history_end_time	timestamp			the timestamp from published UDM optional message header history_time if data is historical data, otherwise, it’s 9999-12-31 00:00:00 similar as NULL
row_is_current	boolean	True		the row data is current or not.

dim_license


Column	Type	Mandatory	UDM mapping	Note
license_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
tenant_id	string	True	tenant_id	dim_tenant.id
module_id	string	True	module_id	dim_module.id
product_id	string	True	product_id	dim_product.id
tier	enum	True	tier	Enum: [“core”, “advanced”, ”power”]
type	enum		type	Enum: [“users”, “resources”, ”locations”, ”device”]
subtype_id	string		subtype_id	dim_license_subtype.id
mode	enum	True	mode	Enum: [“trial”, “regular“]
quantity	integer	True	quantity
start_date	date	True	start_date
end_date	date		end_date
edw_start_time	timestamp	True		ETL internal usage
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True
history_end_time	timestamp
row_is_current	boolean	True		the row data is current or not.

dim_tenant


Column	Type	Mandatory	UDM mapping	Note
tenant_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
code	string	True	code
name	string		name
disabled	boolean	True	disabled	default: false
edw_start_time	timestamp	True		ETL internal usage
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True
history_end_time	timestamp
row_is_current	boolean	True		the row data is current or not.

dim_tenant_product


Column	Type	Mandatory	UDM mapping	Note
tenant_product_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
tenant_id	string	True	tenant_id	dim_tenant.id
product_id	string	True	product_id	dim_product.id
is_provisioned	boolean	True	is_provisioned	default: false
url	string		url
database_host	string		database_host
database_name	string		database_name
edw_start_time	timestamp	True		ETL internal usage
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True
history_end_time	timestamp
row_is_current	boolean	True		the row data is current or not.

dim_product


Column	Type	Mandatory	UDM mapping	Note
product_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
name	string	True	name
edw_start_time	timestamp	True		ETL internal usage
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True
history_end_time	timestamp
row_is_current	boolean	True		the row data is current or not.

dim_license_subtype


Column	Type	Mandatory	UDM mapping	Note
license_subtype_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
subtype	enum	True	subtype	Enum: [“operator_user”, “regular_user“ , “mobile_user”, “room“, “desk“, “touchscreen", “kiosk”, “sensor", “building”]
edw_start_time	timestamp	True		ETL internal usage
edw_row_is_last	boolean			ETL internal usage
history_start_time	timestamp	True
history_end_time	timestamp
row_is_current	boolean	True		the row data is current or not.

Calculated Tables

cal_tenants

Description: a list of live tenant id with valid Envision license. It’s used by power bi data mart to filter target tenant


Column	Type	Mandatory	UDM mapping	Note
cal_tenants_pk	long	True		surrogate key
tenant_id	string	True		dim_tenant.id