YRMO
The YRMO dimension is a simpler version of the CALDATE dimension table, which helps processing and performance speed of the system.
The following table lists all of the options available in this dimension:
Column | Description |
---|---|
YRMO | Zero (0) is a default value, 999999 is used in costing to denote a current effective date range (To /FROM). |
CYear | The calendar year. |
CMonth | The calendar month. |
CQtr | The calendar quarter. |
CQtrCount | The month counter within a quarter period. |
FYear | The fiscal year. |
FMonth | The fiscal month. It is the same as the GL Period associated with YRMO to link patient centric tables with the CGL tables. |
FQtr | The fiscal quarter. |
FQtrCount | The month counter within a quarter period. |
DaysInMth | The number of days in a month. |
CopyPass | [Year Month Copy Pass] |
MonthName | The name of the month. |
LongName | Month, yyyy |
ShortName | mmm-yyyy |
FLongName | Month, Fiscal yyyy |
FShortName | mmm-Fiscal yyyy |