Mgmt months table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "The {{PAGENAME}} contains months between ... It is used by queries such as Query Mgmt_EFT_total. It is used together with other Mgmt queries and the knowledge about the...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
The {{PAGENAME}} contains months between | The {{PAGENAME}} contains months between 2015-01-01 and 2025-12-31. | ||
It is used by queries such as [[Query Mgmt_EFT_total]]. | 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. | 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. | ||
Latest revision as of 18:07, 2019 November 17
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: |