Departments dimension

The Departments dimension contains records for each department within an organization. For example, radiology, emergency, finance, and so on.

Accessing the Department dimension

In the Guide View, click Data Management > Core Dimensions > Departments > Edit DEPT Dimension.

Click image to view full size

NOTE: At this time, you can only add or delete records in this dimension table directly through Axiom Explorer > Table Library > !Dimensions > DEPT in the Windows or Excel Client. For more information, see Opening dimension tables in spreadsheet mode.

Filtering records

To filter records:

  1. Click the funnel icon in the upper left corner of the page.

  2. In the Filter box, you can narrow down the records to display by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, click Edit. If you are familiar with writing filter statements, you can type the statement syntax directly in the Filter box.
  3. Click Apply.

Editing a department

Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.

To edit a department:

  1. Click in the cell(s) to edit, and make your changes.

    NOTE: Columns that are grayed out cannot be edited.

  2. After you finish making changes, click Save.

Column descriptions

This section provides descriptions for each column in the Departments dimension table:

NOTE: The table may display some columns that are related to other Kaufman Hall products or have been created specifically for your organization. Contact your Kaufman Hall Implementation Consultant or Kaufman Hall Support if you need help with these columns.

TIP: In this dimension, you can add custom "grouping" columns to customize the data you want to query into reports. For more information, see Creating or modifying custom columns in dimensions.

Keys

Every table in the database must have at least one key column. Key columns define unique records of data in the table. If a table has one key column, then each value in that key column must be unique and defines a unique record in the table. If a table has multiple key columns, then each combination of values in those key columns defines a unique record in the table.

DEPT - The Axiom Software department number, which is formed by combining the entity and cost center.

Description - The department description. The naming convention is entity abbreviation with department description. For example, Operating Room.

NOTE: For closed departments, add three asterisks to the beginning of the description. For example, *** Operating Room. Descriptions should not be in all capital letters.

TIP: To help make reports more readable, we recommend that you do not use all capital letters in the description content.

Cost

These columns are specific to the set up and maintenance of Axiom Cost Accounting.

ActivityGroup - Reserved for future use.

CostMap - Allows departments to process as a group in the unit cost processing phase of cost accounting. All costs for the group are combined and allocated to all of the cost items within the group. In most cases, the first or largest department of the groups becomes the target CostMap definition to which the other members are mapped.

DeptType - Determines the direct or indirect department category. Direct departments are those that generally provide patient care services and generate revenue, while indirect departments are involved in support services and do not generate patient care related revenue.

MarkupName - The specified markup table to use when processing unit costs using the Reverse Markup method.