IDM - HR

person_type_pk

long

True

Surrogate key as primary key.

-

id

string

True

id

uuid

ID (used for joins).

tenant_id

string

True

tenant_id

dim_tenant.id

-

name

string

name

The name of the person type.

edw_start_time

timestamp

True

-

edw_row_is_last

boolean

ETL internal usage

-

history_start_time

timestamp

The timestamp from published UDM message mandatory header: timestamp

ETL or PowerBI could use it to sort and order the data.

The date this site type was first published.

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

The date this site type was archived or deleted.

row_is_current

boolean

True

The row data is current or not.

True if the row is still active.

person_pk

long

True

surrogate key as primary key

-

id

string

True

id

uuid

ID (used for joins).

tenant_id

string

True

tenant_id

dim_tenant.id

-

code

string

code

The HR code that represents this person.

first_name

string

 True

first_name

The person's preferred name.

actual_first_name

string

actual_first_name

The person’s actual first name, may be different from first_name.

middle_names

string

middle_names

The person’s middle name, if they have any.

last_name

string

 True

last_name

The person’s surname

full_name

string

full_name

First name, middle name(s) and last name combined.

login_name

string

login_name

The person’s username.

email

string

 True

email

The person’s email.

phone_number

string

phone_number

The landline phone number for this person

phone_extension

string

phone_extension

The extension for the phone number for this person.

cell_number

string

cell_number

The mobile phone number for this person.

job_title

string

job_title

The person’s job title.

org_unit_id

string

org_unit_id

dim_org_unit.id

The ID for the persons org unit. Joins to dim_org_unit.

person_type_id

string

person_type_id

dim_person_type.id

The id for the person type. Joins to dim_person_type.

work_mode

enum

work_mode

Enum: one of office, hybrid or remote

Enumerator representing the way this person works. One of: office, hybrid or remote.

manager_person_id

string

manager_person_id

dim_person.id

The ID of this person's manager. Joins to dim_person.

location

string

location

The location of this person as imported. This is a string and does not join to other Envision data.

image_url

string

image_url

The URL to an image representing this person.

is_active

boolean

 True

is_active

default: True

external_id

string

external_id

The ID of this person from external systems, typically HR systems such as

edw_start_time

timestamp

True

ETL internal usage

-

edw_row_is_last

boolean

ETL internal usage

-

history_start_time

timestamp

 True

The date this site type was first published.

history_end_time

timestamp

The date this site type was archived or deleted.

row_is_current

boolean

True

the row data is current or not.

True if the row is still active.

custom_field_pk

long

True

surrogate key as primary key

-

id

string

True

id

uuid

ID (used for joins).

tenant_id

string

True

tenant_id

dim_tenant.id

-

entity

string

True

entity

name

string

True

name

data_type

string

True

data_type

data_type_json

string

data_type_json

group_id

string

group_id

dim_custom_field_group.id

default_value

string

default_value

sequence

int

sequence

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.

person_custom_field_value_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

custom_field_id

string

True

custom_field_id

dim_custom_field.id

person_id

string

True

person_id

dim_person.id

value

string

value

edw_start_time

timestamp

True

ETL internal usage

edw_row_is_last

boolean

ETL internal usage

history_start_time

timestamp

history_end_time

timestamp

row_is_current

boolean

True

The row data is current or not.

group_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

group_type_id

string

True

group_type_id

dim_group_type.id

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.

group_member_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

group_id

string

True

group_id

dim_group.id

person_id

string

True

person_id

dim_person.id

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.

org_unit_pk

long

True

surrogate key as primary key

id

string

True

id

uuid

tenant_id

string

True

tenant_id

dim_tenant.id

parent_id

string

parent_id

dim_org_unit.id

name

string

name

code

string

code

color

string

color

cost_center_id

string

cost_center_id

dim_cost_center.id

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.