Mgmt months table

From CCMDB Wiki
Jump to navigation Jump to search

The Mgmt months table contains months between 2015-01-01 and 2025-12-31.

It is used by queries such as Query Mgmt_EFT_total to turn ranges into actuals.

It is used together with other Mgmt queries and the knowledge about the current state of staffing levels and leaves to get an idea about our workflow.

Data Structure

field type description
YYMM text(15) what will be listed for that month
s date start dttm of that month
s date end dttm of that month

Related articles

Related articles: