Pay types dimension

This dimension includes records for all of the possible categories of compensation that an employee might receive. For example, regular pay, paid time off, sick pay, incentive pay, and so on.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system. For more information, see Editing a dimension using a spreadsheet.

Accessing the dimension

From the Enterprise Decision Support home page, in the Data control section, click Maintain data > Core dimensions > Pay types.

The page can only display up to a maximum of 10,000 records.

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.

Adding or editing a pay type

Due to the large number of records that this table can contain, you might need to use the Filter function described above to find the desired records.

To add or edit a pay type:

  1. In the table, do any of the following:

    • To add a pay type, click + Add Row. The new row displays at the top of the table.

      IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.

    • To edit a pay type, click the edit icon in the Actions column to open cell(s) for changes.

      NOTE: Columns that are grayed out cannot be edited.

  2. Complete the columns, as needed. A description of each column is located in the "Column descriptions" section below.
  3. To cancel the changes made, click the cancel icon in the Actions column. Otherwise, click the save icon in the Actions column to save them.
  4. When you finish making changes, click Save. After you save, the table will display any new pay types in order by the PAYTYPE column.

Deleting a pay type

Due to the large number of records that this table can contain, you might need to use the Filter function described above to find the desired records.

To delete a pay type:

  1. Find the pay type to be deleted and click the delete icon in the Actions column.

  2. At the Confirm Delete prompt, click OK.
  3. When you finish making changes, click Save.

Column descriptions

This section provides descriptions for each column in the table:

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

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.

PAYTYPE - The Axiom Software pay type. This must be an alpha-numeric field, so that during the import process, a P is prepended to all pay types to ensure they are alpha numeric.

The system will not allow you to save the table if an entry includes one or more of the following:

  • More than the maximum allowed characters
  • Contains one of these characters: \\ / < > : ? | * ' \"
  • Begins with + - =.

Description - Identifies the pay type description from the payroll system. Be as explicit as possible, avoid abbreviations, and use layman’s terms.

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 Enterprise Decision Support.

CostVariable - Determines whether the pay type is a fixed or variable cost.

Other

PaySummary - Used in reporting to identify major pay categories. Select one of the valid entries:

  • Prod
  • NonProd
  • Other
  • Stat
  • NA

PayDetail - Used in reporting to identify detail pay categories. Select one of the valid entries:

  • Contract
  • NA
  • NonProd
  • Other
  • Overtime
  • Regular
  • Stat

FTE - Indicates whether to include hours in FTE calculations. Select one of the valid entries:

  • To assign to pay types to count for FTE calculations such as Regular, Overtime, Education, PTO, Jury Duty, Bereavement, Sick, and so on, select Yes.
  • To assign to pay types to not count for FTE calculations such as Differentials, Call Pay (not callback), Bonus, Benefits, and so on, select No.
  • To assign to your productivity stat pay types, select Stat.
  • If none of the above scenarios apply, select NA.