Departments dimension

This dimension contains records for each department within an organization. For example, radiology, emergency, finance, and so on. This dimension table is the core dimension table that all department dimension versions are based upon. For more information on how versions work, see Working with dimension versions. For more information on how versions work, see "Working with dimension versions" in the online help.

Accessing the dimension

From the Enterprise Decision Support home page, in the Data control section, select Maintain data > Core dimensions > Departments.

Filtering records

To filter records

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

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

Adding, editing, or deleting a department

To manage departments in this dimension, you must download the table to make your changes, and then upload the table to load the changes into the Axiom database. For instructions, see Editing dimension versions using a spreadsheet.

Column descriptions

This section provides descriptions for each column in the table:

NOTE: The table may show some columns that are related to other Syntellis products, or have been created specifically for your organization. If you need help with these columns, contact your Syntellis Implementation Consultant or Syntellis Support.

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 - Axiom Software department number, which is formed by combining the entity and cost center.

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

NOTE: For closed departments, add three asterisks to the beginning of the description. For example, MHS *** 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.

Other

These columns are specific to the set up and maintenance of Axiom Enterprise Decision Support.

Entity - Axiom entity code. The description lookup table is in the ENTITY dimension table. This should be the Business Unit, and match the first three to four characters of the department number.

CostCenter - Cost center portion of the department number. You can use this for comparative reporting across entities, such as comparing the cost per unit of all operating rooms across your health system.

RptMap - Consolidates departments for reporting.

VP - Vice President responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.

Director - Director responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.

Manager - Manager responsible for the department. Use the naming convention of FirstName LastName. This information is primarily used for rollup reporting.

Division - Division for rollup reporting, which is defined by your organization. You can use this information to consolidate types of departments together for reporting. For example, you can use the word Radiology to combine all radiology departments across all entities.

KeyStatDesc - Identifies the description of the primary statistic for each department.