Dimension Month Key

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:

  1. min(br_pbn_dim_start_month_key) where the br_pbn_pbn_live_ind = ‘y’, OR
  2. min(ir_ems_return_period_date) associated with the PBN number

to max(pbn.br_pbn_dim_end_month_key),

en-NZ
This variable is not part of a dataset.

Representation

Representation Type
Date/Time
Type
YearMonth
Aggregation Method
Unspecified
Temporal
False
Geographic
False

Concept

Conceptual Variable
conceptual-variable-16.png Businesses en-NZ
Concept
concept-16.png Businesses en-NZ

Appears Within

Information

History

View Full History
Revision Date Responsibility Rationale
2 15/12/2021 8:28:16 AM
1 30/11/2021 4:11:37 PM