Resource.Absence

Purpose

For the Calculation of Resource Utilisation

Use Case

Owner: Martyn Cole
Typical Use Case: Project Reporting Portal
Style: Fact

Code & Source related to Resource.Capacity

Source

FACT_ABSENCE_PERIOD_OL

Key Parameters

Company
Resource
Absence Group

Sample Exec

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

Response

COMPANY_ID,
POS_CODE as RESOURCE_ID,

SEQ

EMP_NO,
PERIOD_NO,
'Absence' as as ABSENCE_GROUP,
--abs_grp.[GROUP_NAME] as ABSENCE_GROUP,        

Entity

ent_res.resource_id as resource_item_id,
ent_emp.employee_id as employee_item_id,

Dates

convert(date,[PERIOD_DATE_FROM],23) as [PERIOD_DATE_FROM],
convert(date,[PERIOD_DATE_TO],23) as [PERIOD_DATE_TO],
convert(date,[ABSENCE_DATE_FROM],23) as [ABSENCE_DATE_FROM],
convert(date,[ABSENCE_DATE_TO],23) as [ABSENCE_DATE_TO],

Measures

cast(WORKING_HOURS as decimal(10,3)) as WORKING_HOURS,
cast(WORKING_DAYS as decimal(10,3)) as WORKING_DAYS,
cast(ABS_DURATION as decimal(10,3)) as ABS_DURATION,
cast(ABS_PERIOD_DURATION as decimal(10,3)) as ABS_PERIOD_DURATION,
cast(CALENDAR_DAYS as decimal(10,3)) as CALENDAR_DAYS,

Codes

Resource

RESOURCE_PARENT_ID = parent_res.item_code,
RESOURCE_DESCRIPTION = parent_res.item_desc,

Other Codes

SUBMITING_DATE,
PERIOD_PAYMENT_RATIO,
DOCUMENT_DATE,
ORG_CODE,
ORG_CODE_VALID_TO

SQL

BMT-DWH-DEV/Resource_Absence.sql