Human resources data covering people, employment, and roles.
Overview The Person Meta Dates view provides a structured temporal layer for the Person domain, representing key date-based attributes associated with a canonical PERSON_UID. It captures assignment-related validity and lifecycle dates in a consistent CDM meta format, enabling controlled and interpretable time-based analysis of person-level context. This view complements: Purpose Key Features 1. Structured Date … Read more
Overview The Person Meta Codes view provides a governed and curated attribute layer for the Person domain, representing identity, linkage, restricted classification, and limited mirrored assignment context for each canonical PERSON_UID. This view extends person.core_details by introducing structured attributes using the CDM meta pattern, enabling controlled person-based reporting and cross-system identity linkage. It is designed … Read more
Overview util.identity_personid provides a resolved and reusable identity mapping between source-system person records and a canonical PERSON_UID. It supports the Person domain by combining: into a single trusted identity layer. This process reduces duplication, improves cross-system linking, and provides a stable foundation for: Purpose How It Works 1. Extract Source Email Identities Source: Processing: Outcome: … Read more
Overview The Person Core Details view defines the canonical person object for the IFS and external app-aligned Person domain within the Common Data Model (CDM). It provides a controlled identity layer for representing a human individual independently of any single employment record, using a stable PERSON_UID and a small set of governed link attributes. This … Read more
Overview The Employee Meta Dates view provides a structured temporal layer for employee objects within the Common Data Model (CDM). It captures key lifecycle dates associated with employees and presents them in a standardised attribute format, aligned to the CDM meta pattern. This view complements: Purpose Key Features 1. Structured Date Model Each date is … Read more
Overview The Employee Meta Codes view provides a structured, extensible attribute layer for employee objects within the Common Data Model (CDM). It transforms employee-related attributes into a standardised code-based format, enabling consistent classification, filtering, and reporting across all employee-driven use cases. This view extends employee.core_details by introducing contextual attributes grouped by domain, without compromising the … Read more
Overview The Employee Core Details view defines the canonical employee object within the Common Data Model (CDM). It establishes a stable and consistent representation of each employee by combining identity, descriptive attributes, and system linkages into a single, governed structure. This view forms the foundation for all employee-related domains, enabling consistent joins, secure identity handling, … Read more
Purpose This view supports workforce capability management and planning by providing consistent, up-to-date insight into employee skills, certifications, and team structures. It enables HR, project managers, and business leaders to make better decisions about deployment, development, and compliance. Use Case Suggested dashboard insights: Source Primary Source(s): Load Path SkillsBase API (2FactAuth) → (ADF Pipeline) → … Read more
Purpose Produces attribute‑level metadata for people and skills sourced from skl.people and augmented with IFS person/employment lookups. Attributes include EMAIL, ID, TEAM_ID, ROLE_ID, LOCATION_ID, DOMAIN, and recent assessment dates. The view follows the CDS object + meta_codes pattern: the item is the Employee object and each row represents a single coded attribute/value, normalised for downstream … Read more
🧾 Overview This view provides attribute-level values related to employee absence and leave entitlements, enabling structured DataMart-level analysis across both transactional absence events and annual entitlement summaries. 📚 Description The Employee Item Codes Absence view translates raw absence and entitlement data into attribute-coded rows that support dimensional modelling. Each row identifies: 🏗️ Source Tables 📦 … Read more