Variable Description
Name
[br_empc_idi_employee_count_nbr]
en-NZ
Label
IDI Employee Count
en-NZ
Description
Number of employees (fulltime and parttime). For each record, populate br_empc_idi_employee_count_nbr with:
- = ‘NULL’ for all br_empc_dim_month_key > than the system parameter IR_LAST_MONTH_KEY
- = sum of distinct snz_ird_uids associated with the ird_ems.pbn_nbr for the month
- ELSE = ‘0’. Notes: A PBN may be live but have nobody allocated to it, in this instance the employee allocation count should equal zero, rather than NULL. Due to the tax data embargo, the EMS will not contain records within 3 months of IDI product, whereas the BR production cycle is monthly. This will result in the latest months containing BR employee counts and no corresponding allocation counts.
Representation
Representation Type
Numeric
Type
Integer
Variable is a Weight
False
Aggregation Method
Unspecified
Temporal
False
Geographic
False
Concept
Conceptual Variable
Businesses
en-NZ
Concept
Businesses
en-NZ