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