RFGROUP

Rolling forecasting is normally done at a forecast group level.

Forecast group is a grouping of functional departments that define a hospital service such as Surgical Services, which would include the operating room, anesthesiology, recovery room, and any other departments that contribute to the provision of surgical services at the hospital. Normally, there are 20-25 forecast groups per facility.

The RFGROUP dimension contains records for groups in an organization.

The following table lists all of the options available in this dimension table:

NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table may not display, depending on the Axiom products in which your organization is licensed.

Column	Description
RFGROUP	Define your forecast groups. Consider: Management structure and cultural impact. Team concept versus individual department managers. The availability of a statistic that can be collected.
Description	A description for the RFGroup name.
Entity	The entity number assigned to each RFGroup.
RptMap	The RFGroup code used for grouping in reporting.
VP	The name of the VP responsible for the RFGroup.
Director	The name of the director responsible for the RFGroup.
Manager	The name of the manager responsible for the RFGroup.
Division	The name of the division under which the RFGroup falls.
Owner	Used to identify the network ID of the person responsible for initial input of the forecast (i.e. manager); It should be the same as their Axiom login ID. In general, this ID will be the same as your organizations network ID.
Reviewer	Used to identify the network ID of the person responsible for reviewing the forecast (i.e. Director); It should be the same as their KH_EPM login ID. In general, this ID will be the same as your organizations network ID.
Approver	Used to identify the network ID of the person responsible for approving the forecast (i.e., VP); It should be the same as their KH_EPM login ID. In general, this ID will be the same as your organizations network ID.
FinContact	Used to assign the financial contact for an RFGroup during the forecast process.
KeyStatDesc	Defines the type of statistic used as your key statistic. Type the description of the forecast group statistic to use for each new forecast group created.
CYFDimGrp	The dimensions group used to define the current year forecast method. Not currently being used.
RFRollup	Used to assign a rollup structure to use for drill downs and reporting on your forecast.
RFPlanGroup	The forecast planning group name.
BalanceSheetGrp	Grouping column for Balance Sheet Groups used in Rolling Forecasting. The RF Balance Sheet Group designates how the balance sheet in the Balance Sheet calculator is grouped together. The default value is “NA”. Field cannot be left empty.
KHABgtTemplate	Assign Rolling Forecast to each RFGroup. If no workbook should be generated, assign NA.
TplOptions	Template Options – Reserved for future use. The default code is NA.
ShowOnList_RF	Used to define which departments to build forecasts for. Valid entries include the following: TRUE – Type to build a plan file. FALSE – Type to exclude from plan file lists and build.
KHABgtCode	Assign a forecast group (must be a string) for each RFGroup. To exclude a forecast group from the forecast process, assign Z_Exclude in KHABgtCode.
ProviderDType	Used to define the key stat to use for the RF Provider template (must be licensed). Generally, fill with WRVU, Visit, or Encounter.
FPModel	The financial planning group code for each RFGroup.
FPType	The financial planning type for each forecast group.
FPNode	The financial planning node each RFGroup belongs to.
FPCode	Used by Axiom Financial Planning.
CMDimGrp	Assigns RFStdLine to each RFGroup.
DeductionsMapping	Used in multipass processing of the Deductions Model calculator. This column provides a way to designate the RFPlanGroups to process.
KHABgtMap	Not currently being used
KHACMDimGrp	Choices are RFStdLine or NA.
PlanType	Choices are Hospitals_Clinics and HigherEducation.