Employee Dim

Employee Dim ============================== The Employee Dimension provides a consolidated and comprehensive profile of employees within the organization. It integrates demographic, employment, and contact details sourced from the Infor LN system, giving a clear perspective on each employee's identity, role, and status. This dimension is designed to support business analytics by delivering consistent and interpretable employee information for decision-makers.

Output Column	Database Logic	Description
City	The 'City' is derived from the LN_tccom130 data, which holds address-related information linked to employees via address codes.	This field identifies the city portion of the employee's registered address, which helps in understanding the employee's geographical location.
Country	The 'Country' is sourced from LN_tccom130, capturing the country associated with the employee's address.	This indicates the country where the employee is based, which is important for regional reporting and compliance.
County	County information comes from LN_tccom130, reflecting the county associated with the employee's address.	This shows the county subdivision related to the employee's location, refining the geographical granularity.
Date of Birth	The 'Date of Birth' is retrieved from LN_bpmdm001.daob, representing the employee's birthdate.	This field documents the employee's birth date, which is useful for age-related analytics and compliance purposes.
Deleted	The 'Deleted' flag originates from LN_tccom001.deleted, indicating whether the employee record is marked as deleted.	This indicates if the employee's record has been removed or deactivated in the system, helping maintain data accuracy.
Department	Department information comes from LN_tccom001.cwoc, representing the organizational unit the employee is assigned to.	This shows the department where the employee works, supporting organizational and workforce analysis.
Email	The 'Email' field is taken from LN_bpmdm001.mail, capturing the employee's email address.	This provides the contact email for the employee, facilitating communication within and outside the organization.
Employee	The 'Employee' identifier is from LN_bpmdm001.emno, a unique code for each employee.	This is the unique identifier assigned to the employee to distinctly track and reference their records.
Employee Key	Constructed by concatenating LN_bpmdm001.compnr and LN_bpmdm001.emno values, trimmed and combined to form a unique composite key.	This composite key uniquely identifies an employee within the company, ensuring precise record referencing.
Employee Name	Derived from LN_tccom001.nama, providing the full name of the employee.	This field displays the official name of the employee as registered in the HR system.
Employee Type	Retrieved from a lookup on LN_bpmdm001.emtp_kw matched to LN_Enum.description, explaining the type of employment.	This defines the category of the employee’s role, such as full-time, part-time, or contractor, which is critical for workforce classification.
First Date of Employment	Taken from LN_bpmdm001.sdte, marking when the employee commenced employment.	This indicates the start date of the employee's tenure with the organization.
Gender	Determined by looking up LN_bpmdm001.sexe_kw in LN_Enum.description to describe the employee's gender.	This provides the gender classification of the employee, used for demographic analysis.
Job Title	Sourced from LN_bpmdm001.jobt, indicating the employee's job position.	This states the role or position held by the employee within the organization.
Last Date of Employment	From LN_bpmdm001.edte, documenting the end of employment date if applicable.	This specifies when an employee’s employment ended, useful for tracking workforce changes.
Last Modified Datetime	Determined by calculating the most recent modification timestamp from relevant underlying LN tables using infor.lastmodified functions.	This timestamp shows the most recent update to the employee’s data, ensuring reports reflect current information.
Mobile Phone	Retrieved from LN_bpmdm001.telm, capturing the employee's mobile contact number.	This provides the mobile phone number for direct communication with the employee.
State/Province	Derived from LN_tccom130.cste, indicating the state or province component of the employee's address.	This shows the state or province of the employee’s residence for regional insights.
Street	Taken from LN_tccom130.namc, representing the street address details.	This gives the specific street part of the employee's physical address.
Telephone	Sourced from LN_bpmdm001.telw, representing the employee's telephone number.	This provides a landline telephone contact for the employee.