Dimension Month Key

Variable Description

Name
[br_empc_dim_month_key]
Label
Dimension Month Key
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),

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
Businesses
Concept
Businesses