Job Codes dimension

The Job Codes dimension includes records for all of the job codes within your organization. Each job code represents a job position or role within the organization.

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 Jobcode dimension

From the Enterprise Decision Support home page, in the Data Control section, click Data Management > Core Dimensions > Job Codes.

Click image to view full size

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.

Modifying the Job Codes dimension

To modify the Job Codes dimension:

  1. In the Filter panel, type the number of records to display in the Maximum Records field. The default is 1000.

    NOTE: Due to the large number of records that this table may contain, the page can only display a maximum of 10,000 records.

  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.
  4. In the table, do any of the following:

    • To add a job code, click Add Row. The new row displays at the bottom of the table. Enter information in each column. After you save, the table will display the new row in order by the JOBCODE column.

      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 job code, click in the cell(s) to make your changes.

      NOTE: Columns that are grayed out cannot be edited.

    • To delete a job code, select the row to highlight it, and then click Delete Row. At the Continue? prompt, click OK.
    • To undo your changes, click the left arrow icon .
    • To redo your changes, click the right arrow icon .
  5. When you finish making changes, click Save.

Column descriptions

The following section describes the areas and columns in the Job Codes dimension 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.

JOBCODE - The Axiom Software job code. This entry must be an alpha-numeric field so that during the import process a J is prepended to all job codes 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 - The job code description from the payroll system.

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.

CostHr - The Prod Hours Account Definitions for Costing.

ResourceJobClass - Used in the RVU developer process by the mapping of job codes to a Resource Job Class, which determines the level of detailed RVU development for labor resources. This attribute is also used in the mapping of payroll hour and dollar into an average wage rate in the resource table that then drives the calculation of the RVU.

CostCat - The cost category for the job code.

CostGL - The Prod Dollars Account Definitions for Costing.

CostClass - An alternative grouping column used in the costing process that is invoked during the loading of payroll information into the CGL as statistics to support a payroll related reclassification of GL dollars or hours.

CostVariable - Determines whether the job code is a fixed or variable cost.