Employee.Details

Purpose

The Common View for Employee Details provides a unified and reliable source for core employee data, suitable for integration across departments and systems. It focuses on maintaining essential and concise information, enabling integration with fact tables for reporting and analysis while ensuring compatibility with slicers and dashboards.

Use Case

Owner: Data Engineering
Typical Use Case: Provides contents for an Employee slicer with a consistent Title description style.
Style: Entity/Dimension-based, ensuring a single row per employee.

Why This Version?

• Focus on Essentials: It keeps the essential fields for a quick view without overloading the report with too many fields.
• This view is designed as a non-JSON table to ensure it is accessible and straightforward for direct querying, facilitating ease of use across different reporting tools and systems.

This version balances brevity with a bit of added context, and it provides a sufficient overview while remaining lightweight.

Source

DIM_EMPLOYEE_OL

Additional Tables:

• QFACT_EMP_JOB_ASSIGN_CFV_OL$
• QDIM_PERSON_INFO_OL$
• QDIM_FND_USER_PROPERTY_OL$
• DIM_WORK_LOCATION_OL
• QDIM_COMPANY_PERS_ASSIGN_C_OL$

Sample Exec

EXEC get.myView @dataMart = 'Employee', @viewName = 'Details', @token = '<myToken>', @version = '<202404>'

DataMart Integration

This view can be utilised across the following DataMarts:

• Employee
• Person
• Company

Response

Field Name	Description
COMPANY	Employee’s company ID.
EMP_NO	Employee number.
EMPLOYEE_SEQ	A JSON object uniquely identifying the employee.
EMPLOYEE_NAME	Full name of the employee.
EMAIL_ADDRESS	Employee’s email address.
PERSON_ID	Unique identifier for the Person.
PAYROLL_ID	Payroll identifier for the employee.
WORK_LOCATION	Employee’s office/work location.
EMP_CATEGORY	Employment category of the employee.
EMPLOYEE_STATUS	Current employment status (active, terminated, etc.).
Has_JobAssign	Flag indicating if the employee has a primary Job & Assignment.
Has_Assignment	Flag indicating if the employee has any assignment.
ASSIGNMENT_TYPE	Type of the employee’s current assignment.
ORG_LEVEL	Organisational level of the assignment.
Has_Job	Flag indicating if the employee has a primary job.
JOB_FAMILY	Family associated with the job.
JOB_GRADE	Grade level of the job.
JOB_TITLE	Title of the primary job.
SUPERVISOR_NAME	Name of the employee’s supervisor.
SUPERVISOR_EMAIL	Email address of the supervisor.

SQL

BMT-DWH-DEV/Employee_Details.sql