PAYTYPE

The PAYTYPE dimension table 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.

For more information on how to set up the PAYTYPE dimension for reporting, budgeting, and GL mapping, see Mapping the PAYTYPE dimension.

NOTE: Some dimension tables are shared across multiple Axiom products. As a result, some of the columns listed in the following table may not display in the dimension, depending on the Axiom products for which your organization is licensed.

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

Column	Description
PAYTYPE	The Axiom 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.
Description	Identifies the pay type description from the payroll system. Be as explicit as possible, avoid abbreviations, and use layman’s terms. Do not enter a description using all capital letters. To remove the all-caps format in the spreadsheet, use the Proper formula =Proper().
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
LaborDist	The variation of PayDetail used in Labor Distribution reporting. Valid entries include the following: Regular Education PTO Overtime OnCall Other Contract Stat NA
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.
Empl_Detail	Used to identify pay types that are FTE related for employee-level budgeting. Select one of the valid entries: If it is FTE-related, select Z_Employee. If it is not FTE-related, select NA.
KHAInt	Used to identify pay types to include in plan file processing. Select one of the valid entries: To assign pay types to include in the JobCode block (generally FTE=Yes), select JobCode. To assign pay types to include in the JobCode block as additional dollars (generally FTE=No; examples include call pay, differentials, bonus, etc.), select Dollars. To assign pay types to budget at the department (not job code) level, select Dept. To assign pay types to exclude from the budget workbooks such as PTO sellback, reimbursement\adoption reimbursement, car allowance, benefit expenses, and so on, select NA.
GLAcct	Used to identify the account number to use for dollars on the GL. Do one of the following: If your payroll data maps to the GL-based upon job code, type 0 (zero). If your payroll data does not map to the GL-based on job code, type the GL salary account from the ACCT dimension table.
HrAcct	Used to identify the account number to use for hours on the GL. Do one of the following: If your payroll hours map to the GL-based upon job code, type 0 (zero). If your payroll hours do not map to the GL-based on job code, type the GL hours account from the ACCT dimension table.
JobCode	The pay type summary groupings used for plan-file processing when using the Jobcode labor method. The code used must be a valid pay type.
Staffing	The pay type summary groupings used for plan-file processing when using the Staffing labor method. The code used must be a valid pay type.
Employee	The pay type summary groupings used for plan-file processing when using the Employee labor method. The code used must be a valid pay type.
Provider	The pay type summary groupings used for plan-file processing when using the ProviderComp labor method. The code used must be a valid pay type.
KHAStdLine	Used to identify default budget methodology used in budget plan files during budget plan file creation. Refer to the calc methods for the Stat_Rev sheet and Expense sheet in the Axiom Budgeting and Performance Reporting Administrator's Guide (Budget Plan Files chapter) for valid entries and definitions. The default value is NA.
RF_Pay26_Include_Exclude	Select whether to include or exclude option from monthly payroll to GL.
ResourceCalculation	Determines the calculation behavior for the hours or dollars within the PAYTYPE when using the payroll information within the RVU development process. When labor rates are calculated for the Resource Table, the designation here determines if the Hours, Dollars, or Both are to be used in the numerator and denominator in the average.
PHYStdLine	Identifies the default budget methodology used in budget plan files during budget plan file creation. Options include: CM_Jobcode Dept_AvgPerProdHr Dept_InputMonthly Input_Monthly JobCode NA
CDMStdLine	Used to identify default budget methodology for CDM budget plan files (departments which have CDMStdLine in KHACMDimGrp column of DEPT Dimension) during budget plan file creation. It is used similarly to KHAStdLine in Budget Planning workbooks. Valid entries include the following: Statistical accounts = CDMStatistic IP Revenue accounts = CDMIPRevenue OP Revenue accounts = CDMOPRevenue Copy the remaining account assignments from KHAStdLine column.
Accrue	Used to identify paytypes to be included when using the payroll accrual utility. Valid entries include the following: • To accrue during monthly payroll accrual process, type Yes. • To not accrue during monthly payroll accrual process, type No or NA.
RFPAYCLASS	Not used at this time.
Cost Variable	Not used at this time.
CM_PlanCode	Used for combining pay types during Axiom Cost Management reporting and plan-file creation. If there are historical values for two pay types that you want to report as one combined pay type, list the surviving pay type on both lines.
KHAStandardClass	Grouping column that can be used to report on paytype usage across your organization.
NewDeptStdLine	New department standard CM Line.
CM_PayCategory	Used in Axiom Cost Management to group individual pay types into summary categories for planning purposes. Examples include the following: Regular, Overtime, Education, PTO, Contract, Other, Stat.
CM_Paid	Used to identify the pay type to include in the Paid Hours calculations in Axiom Cost Management. Valid entries include the following: For paytypes that will be included in paid hours, select Yes. For paytypes that will not be included in paid hours, select No.
CM_Worked	Used to identify the pay type to include in the Worked Hours calculations in Axiom Cost Management. For Pay Types that will be included in worked hours, select Yes. For Pay Types that will not be included in worked hours, select No.
CM_PaidDLLRS	Used to identify the pay type to include in the Paid Dollars calculations in Axiom Cost Management. For Pay Types that will be included in paid dollars, select Yes. For Pay Types that will not be included in paid dollars, select No.
CM_WorkedDLLRS	Used to identify the pay type to include in the Worked Dollars calculations in Axiom Cost Management. For Pay Types that will be included in worked dollars, select Yes. For Pay Types that will not be included in worked dollars, select No.
CMStdLine	Used during the interface process to assign the standard planning method to use for each pay type. In other words, this identifies the desired formula to use to calculate Axiom Cost Management initiatives. It is used similarly to KHAStdLine in Budget Planning workbooks.