1 person found this helpful
The only numerical codes with any meaning are the activity event codes and object type codes. These codes are all documented here: Analytics DB Data Model
All other id's are just system generated surrogate keys and have no meaning - they are used for table join purposes. E.g., month_id is the key of the record in jivedw_month representing that month period and is used to join the the corresponding month_id column in the aggregate table. The attributes in jivedw_month can be used to select those time periods.
It all makes sense now. I updated my SQL query to bring in jivedw_month.month_of_year and jivedw_month.year where jivedw_activity_agg_month.month_id = jivedw_month.month_id instead of just trying to make sense of the month_id. Thanks for the clarification.