JOBCODE

The JOBCODE dimension table includes records for all of the JobCodes within your organization. Each JobCode represents a job position or role within the organization.

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

Column

Description
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.
Description The job code description from the payroll system. Do not type descriptions using all capital letters. To remove the all-caps format in the spreadsheet, use the Proper formula =Proper().
GLAcct The GL account where regular dollars are posted on the GL. If your payroll data maps to the GL based upon pay type, type 0(zero).
HRAcct The GL account where regular hours are posted on the GL. If your payroll hours map to the GL based upon pay type, type 0(zero).
FICAAcct The FICA account code to use for each job code. You can use this to allocate FICA expense to different accounts by job code.
JobClass

The major job classes of individual job codes. You can use this to apply salary increases for specific groups. Commonly used entries include the following:

  • Management
  • Physician
  • Professional
  • Technical
  • RN
  • LPN
  • Assistant
  • Support
  • Other
  • Clerical
  • Contract
GLClass Used to identify the GL Class each job code is assigned to for budget and reporting salary-mapping purposes. The exception-mapping table is located in the GLPayrollMapping table. If mapping payroll by job code or pay type is not an option, this mapping table allows for special exceptions for payroll mapping.
Variable Used to identify JobCodes, which are sensitive to volume changes. Valid entries include Fixed and Variable.
KHABgtCode Used for combining accounts together during budget plan file creation. If there are historical values for two accounts that you want to budget as one combined account, list the surviving account number on both lines. If not combining accounts, this value should match value in the Account column. The default value is 0 (zero).
KHAInt

Used to identify which tab an account should be interfaced to during the budget plan file create process. Valid entries include the following:

  • JOBCODE
  • PROVIDER

  • To exclude an account from all budget plan files, type NA.
PhyInt Used to create an alternative to the KHAInt classification for the associated job code.

Valid entries include the following:

  • JOBCODE
  • PROVIDER

  • NAindicates the value will default to the value currently in the KHAInt column.
FTEFactor (Optional depending on license) Defines the FTE factor for a two week period. Generally, this is set to 80 for all job codes. If your organization uses varying FTE Factors by job code, this may be different.
StdHours Used to identify the standard FTE hours worked in a year. Options include Default, which is 2086 hours, and 2080. For more information, see "Working with FTE standard working hours" in the online help.
RFCODEGL In Axiom Rolling Forecast, this may be used to allocate salaries to specific salary related RFCodes.
RFCODEHR In Axiom Rolling Forecast, this may be used to allocate hours to specific hours related RFCodes.
FPCategory Used to identify the name of the Financial Planning category to be used for transferring the financial plan targets during the integration process with Axiom Financial Planning. If Axiom Financial Planning is not used, the default is NA.
CostHR The Prod Hours Account Definitions for Costing
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 Not used at this time.
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.
CM_PlanCode Used for combining job codes during reporting and plan file creation in Axiom Cost Management. If there are historical values for two job codes that you want to report as one combined job code, list the surviving job code on both lines.