o ‘Change Filter (sub)’ (hidden): “Valid Date Diff” when “Date Check (sub) = 1” AND “Effective Last Change
= Y”; “Valid Seq Diff” when “Date Check (sub) = 0” AND “Sequence Check (sub)= 1”. Otherwise, the text
“Invalid” is provided
• Calculated columns relevant for the determination of the previous jobInfo-record. Note, that the “Global Job
Info (3)” is used for the previous jobInfo-record.
o ‘Date Check (prev)’ (hidden): “Effective Start Date” – “Effective End Date (3)”
o ‘Sequence Check (prev)’ (hidden): “Transaction Sequence Number” – “Transaction Sequence Number
(3)”
o ‘Change Filter (prev)’ (hidden): “Valid Date Diff” when “Date Check (prev) = 1” AND “Transaction
Sequence Number = 1”; “Valid Seq Diff” when “Date Check (prev) = 0” AND “Sequence Check (prev)= 1”.
Otherwise, the text “Invalid” is provided.
• Total headcount (12 months back): The company name is provided under following condition that (1) the Job
Info-record was valid 365 days back and (2) the employee was active (i.e. Employee Status (external code)
not equal “T”/ ”R”)
• Total headcount (As of Date): The company name is provided under following condition that (1) the Job Info-
record is valid at the day for which the report is executed and (2) the employee was active (i.e. Employee
Status (external code) not equal “T”/ ”R”)
• ‘Hire/Transfer In’: The company name is provided. This label is used in the Pivot evaluation to count the
overall number of “Hires/Transfer In”. The company name is only provided under following conditions:
o ‘Company’ not equal to ‘Company (3)’ (this represents a transfer-in) OR event is either ‘Hire’ or ‘Rehire’
(Event (external code) = ‘H’ / ‘R’)
o Event was happening within the last 364 days
• ‘Terminations/ Transfer Out’: The company name is provided. This label is used in the Pivot evaluation to
count the overall number of “Terminations/ Transfer Out”. The company name is only provided under
following conditions:
o Event is ‘Termination’ (Event (external code) = ‘26’) AND Event was happening within the last 364 days
(Reporting Date - 364 <= ‘effective start date’ <= Reporting Date)
o ‘Company’ not equal to ‘Company (2)’ (this represents a transfer-out) AND Event was happening within
the last 365 days (exactly: Reporting Date - 365 <= ‘effective end date’ <= Reporting Date -1)
• ‘Show only details relevant for turnover balance’ (only relevant for page 2): ‘Show only relevant details’
(hidden): It’s filled with an indicator “X” when (1) either ‘Total headcount (12 months back)’ is filled OR (2)
‘Hire/Transfer In’ is filled OR (3) ‘Terminations/ Transfer Out’ is filled OR (4) Total headcount (As of Date) is
filled. This indicator is used as runtime filter to avoid that records are shown which might be interesting to
understand the complete employee’s job history; which, however, don’t influence the workforce totals (12
months back and as of date) as well as the movements within the last 12 months (hires, transfers,
terminations).
Filters
The report contains following filters (see screenshot above with the respective boxes in the different colours):
• Filters relevant to avoid duplicates caused by the previous jobInfo- records (indicated by the red box)
• Filters relevant to avoid duplicates caused by the subsequent jobInfo- records (indicated by the blue box).
Note that both parts are connected with an “AND”.
• Each of the 2 parts consists of 3 sub-parts (indicated by the 3 yellow / 3 green boxes):
o Upper part (previous jobInfo- records):