BLS Age Group

From CSUMB Data Glossary
Jump to navigation Jump to search

BLS Age Groups are groupings of individuals' ages into groupings used by the U.S. Department of Labor's Bureau of Labor Statistics in their reporting of demographics in labor force statistics.

Where Term Appears
CSUMB Data Warehouse Dashboards:Trends by College Dashboard
Data Custodian
Institutional Assessment and Research
Data Source
Source System:CMS - HR
Source Table Name:PS_MB_CENSUS
Source Field Name:Age
Census Process:Yes
Logical Transformation / Calculation
Calculated using case statement and following transformationː ROUND(CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"CSU Person"."Birth Date", "CSU Snapshot Day"."Snapshot Calendar Date") AS REAL)/365,0)
OBIEE Folder and Column
Folder Heading:Calculated
Column Heading:Calculated

BLS Age Groups are calculated by taking the difference between an individual's birth date and the snapshot calendar date, dividing by 365 days to get the age in years, and rounding.


Examples of BLS Age Group include:

  • 16 to 19
  • 20 to 24
  • 25 to 34
  • 35 to 44
  • 45 to 54
  • 55 to 64
  • 65 years and over