IDM - Space Management

Last updated
Save as PDF

Contents

Dimension Tables
- dim_assignment
- dim_allocation

Dimension Tables

dim_assignment

Partition By: tenant_id


Column	Type	Mandatory	UDM mapping	Note
assignment_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
tenant_id	string	True	tenant_id	dim_tenant.id
person_id	string	True	person_id	dim_person.id
location_id	string	True	location_id	location_id
is_primary	boolean
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_allocation

Partition By: tenant_id


Column	Type	Mandatory	UDM mapping	Note
allocation_pk	long	True		surrogate key as primary key
id	string	True	id	uuid
tenant_id	string	True	tenant_id	dim_tenant.id
org_unit_id	string	True	org_unit_id	dim_org_unit.id
space_id	string	True	space_id	dim_space.id
ratio	decimal	True	ratio
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.