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.

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

Column	Description
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.
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. Valid entries include the following: Prod NonProd Other Stat NA
PayDetail	Used in reporting to identify detail pay categories. Valid entries include the following: 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. Valid entries include the following: To assign to pay types to count for FTE calculations such as Regular, Overtime, Education, PTO, Jury Duty, Bereavement, Sick, and so on, type Yes. To assign to pay types to not count for FTE calculations such as Differentials, Call Pay (not callback), Bonus, Benefits, and so on, type No. To assign to your productivity stat pay types, type Stat. If none of the above scenarios apply, type NA
Empl_Detail	Used to identify pay types that are FTE related for employee-level budgeting. Valid entries include the following: If it is FTE-related, type Z_Employee. If it is not FTE-related, type NA.
KHAInt	Used to identify which tab an account should be interfaced to during the budget plan file create process. Valid entries include the following: To assign to all statistics, revenue, and deduction accounts that will be budgeted in the budget plan files, type Stat_Rev. To assign to all expense and hours for accounts that will be budgeted in the budget plan files, type Expense. To exclude an account from all budget plan files, type NA.
GLAcct	Used to identify the account number to use for dollars on the GL. Valid entries include 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. Must be a valid pay type.
Staffing	The pay type summary groupings used for plan-file processing when using the Staffing labor method. Must be a valid pay type.
Employees	The pay type summary groupings used for plan-file processing when using the Employee labor method. Must be a valid pay type.
Providers	The pay type summary groupings used for plan-file processing when using the ProviderComp labor method. 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. Default is 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.
CostVariable	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.
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.
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.
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.