Variable Description
Name
[br_empc_dim_month_key]
en-NZ
Label
Dimension Month Key
en-NZ
Description
For each distinct br_empc_pbn_nbr now on br_employee_count, populate br_empc_dim_month_key with:
one record per month in the format YYYYMM, beginning with the minimum of either:
- min(br_pbn_dim_start_month_key) where the br_pbn_pbn_live_ind = ‘y’, OR
- min(ir_ems_return_period_date) associated with the PBN number
to max(pbn.br_pbn_dim_end_month_key),
en-NZRepresentation
Representation Type
Date/Time
Type
YearMonth
Aggregation Method
Unspecified
Temporal
False
Geographic
False
Concept
Conceptual Variable

Concept
