Purpose
The Employee Leave Entitlement fact table is designed to display quantitative data related to employees. This table integrates with dimension tables, such as employee_details_plus, to provide detailed insights into various aspects of employee performance, compensation, and other metrics. The primary purpose is to support data-driven decision-making across the organisation.
Use Case
Owner: Sam Jopson-White
Typical Use Case: Annual Leave (and carry over etc) Entitlement
Style: Fact, meaning it consists of the measurements, metrics or facts of a business process
Source
QFACT_BMT_ABSENCE_SUMMARY_IAS$Key Parameters
Company
Employee
Sample Exec
EXEC get.myView @dataMart = 'Employee', @viewName = 'LeaveEntitlement', @token = '<myToken>', @version = '<202404>'Response
COMPANY,
EMPLOYEE_ID as EMP_NO,SEQ
ABSENCE_TYPE_ID,Dates
CONVERT(varchar(10),try_parse(ABS_DATE_FROM as date),23) as ABS_DATE_FROM,
CONVERT(varchar(10),try_parse(ABS_DATE_TO as date),23) as ABS_DATE_TO,Measures
ABS_PROP_DAYS_LIMIT_USED,
ABS_PROP_DAYS_LIMIT_UNUSED,
ABS_DAYS_LIMIT_USED,
ABS_DAYS_LIMIT_UNUSED,
Codes
ABSENCE_TYPE_NAME,
ABS_LIMIT_DIMENSION,
PUR_ANNUAL_LEAVE_DAYS,
SOLD_ANNUAL_LEAVE_DAYS,
ABS_CURR_PROP_DAYS_LIMIT,
ABS_PROP_DAYS_LIMIT,
ABS_LIMIT_REDUCTION