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 of the dimension options available in the JOBCODE dimension table:

Column Description
JOBCODE

The alphanumeric Axiom job code. During the import process, a J is prepended to all job codes to ensure they are alphanumeric.

Do not create job codes that begin with the following:

  • JAN

  • JUN

  • JUL

NOTE: Excel recognizes these as date acronyms and tries to convert job codes that begin with these letters to dates.
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.
CostHr The Prod Hours Account Definitions for Costing
PhyInt Used to create an alternative to the KHAInt classification for the associated job code.

Valid entries include the following:

  • JOBCODE
  • PROVIDER

  • NA – Indicates the value will default to the value currently in the KHAInt column.
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.
KHAStandardClass The KHA standard classification for jobcode to be used in reports to standardize across the organization. Double click to select the appropriate classification.
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.
CostGL The Prod Dollars Account Definitions for Costing
Retirement

Identifies the jobcodes to be used for retirement calculation. Used in Jobcode and ProviderComp (available on Labor tabs). Valid entries are:

  • NA
  • Qualified
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.
RFCODEGL In Axiom Rolling Forecast, this may be used to allocate salaries to specific salary related RFCodes.
CostVariable Not used at this time.
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.
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.