Accounting Configuration in HRM
Accounting Detail at the Employee LevelAccounting Detail at the Employee Level
PAM retrieves the Accounting details for the pay event from the Pay Detail table. PAM looks for Accounting data in a particular order:
-
Employee Pay Period [EPPA for employee’s pay period] - The PAY_DETL table contains pay details for a check by Pay Event Type and Event Date. Accounting overrides can be established for an employee for a single pay period and pay event. Within the EPPA transaction, multiple overrides may be entered for the employee for the pay period. Each override line defines the pay event being overridden. The same pay event may be defined on multiple lines, with the priority identifying the sequence in which the overrides are applied, and the amount (hour or dollar based depending upon the type defined on EVNT) for the portion of the total expenses related to the pay event in that pay period. The valid values for the Labor Distribution Override Option are:
-
Use Entered Accounting Values - The accounting details for the employee and pay period must be specified. PAM posts the pay detail based on these values.
-
Use Entered Labor Distribution Profile - A Labor Distribution Profile must be specified. PAM locates this Labor Distribution and posts the pay detail based on the accounting details on Labor Distribution Profile (LDPR).
-
Event Accounting Matrix [EVAM for employee, organization, event and classification] – If PAM cannot retrieve accounting details from EPPA, it defaults to the settings on the Event Accounting Matrix (EVAM). The matrix provides the ability to define parameters on which the override will be based. The only required parameters are the Home Department Code and effective date range. Optionally, EVAM can be configured with the following additional selection criteria: Home Unit, Event Type Code, Employee ID, Appointment ID and Labor Distribution Classification. For a specific event type code to be used with EVAM, it must be defined as Event Matrix Eligible in the Accounting Information section on the EVNT page. The valid values for the Labor Distribution Override Option are:
-
Use Entered Accounting Values - The accounting details for the event matrix must be specified. PAM posts the pay detail based on these values.
-
Use Entered Labor Distribution Profile - A Labor Distribution Profile must be specified. PAM locates this Labor Distribution and posts the pay detail based on the accounting details on Labor Distribution Profile (LDPR).
-
Use Appointment Accounting Values - The accounting details defined for the employee’s appointment on the Employee Accounting Data (DEPTA) transaction are used by PAM to post the pay detail accounting
-
Use Position Accounting Values - The accounting details defined for the employee’s position on the Position Status Maintenance (PSMT) transaction are used by PAM to post the pay detail accounting.
-
Use Timesheet Accounting Values - The accounting details for the eligible event type codes can also be configured to follow the accounting for other event codes on the check’s pay details. When this option is selected, applicable event type codes (which cannot themselves be Event Matrix Eligible) are defined on the Related Timesheet Events tab. The accounting assigned to these event type codes within the same check are used to define the pay detail accounting for the event matrix code(s).
-
Labor Distribution Override [EVNT for the pay event] - If PAM cannot retrieve accounting details from EVAM, it looks to the EVNT page for the pay event.
PAM retrieves the accounting details for the pay event based on the value provided in the Cost Accounting field on EVNT for the pay event. These are the values you can enter:
-
Object/Sub-object - The event posts to the Object and Sub-Object you specified on EVNT.
-
Obj/Sub-obj-Unless Transaction Ovrd - The event posts to the Object and Sub-Object specified on EVNT, unless overrides are entered on transactions such as TADJ, TIMEI, OPAY, and OTPAY. In this case, PAM posts the event based on the overrides specified on the transaction.
-
Labor Distribution Profile - The event posts to the Labor Distribution Profile specified on EVNT.
-
LDPR - Unless Transaction Override - The event posts to the Labor Distribution Profile specified on EVNT, unless overrides are entered on transactions such as TADJ, TIMEI, OPAY, and OTPAY. In this case, PAM posts the event based on the overrides specified on the transaction.
-
LDPR w/ Home Dept - The event posts to the employee’s Home Department and the Labor Distribution Profile specified on EVNT.
-
LDPR w/ Home Dept-Unlss Transaction Ovd - The event posts to the employee’s Home Department and the Labor Distribution Profile specified on EVNT, unless overrides are entered on transactions such as TADJ, TIMEI, OPAY, and OTPAY. In this case, PAM posts the event based on the overrides specified on the transaction.
-
Reserve Pay/Accrual Acct - This event is a reserve accrual or payout event. In this case, a BSA code must be specified on EVNT. PAM then posts the event to this BSA.
-
Exclude from Acct Interface - The event is not processed by PAM.
-
No Override - No accounting attributes are specific to this event. Accounting details for the pay detail default to those on the profile for the position in which the employee is enrolled.
Note: With the Transaction Override on the EVNT, if you specify Accounting details for Timesheet (TIMEI), Timesheet Adjustments (TADJ), One Time Pays (OTPAY), or any other transaction for the pay, these details would also override the accounting details on the EVNT, but only for the pay details on those transactions. Refer to Accounting Overrides for additional information.
-
Department Event [DEACC for the department and event] - If PAM cannot retrieve all accounting details from EVNT, it defaults to the details for the event type code within the employee’s Home Department. If the event type code from pay details exists on the Department Event Accounting (DEACC) page for the employee’s organization, the override rules defined here will be used by PAM to set the accounting. The organization match would be on the employee’s Home Department along with either an exact match on the employee’s Home Unit or a Home Unit code with a wildcard value on DEACC. The valid Labor Distribution Override Option values are:
-
Use Entered Accounting Values - The accounting details for the Department, Unit and Event Type code must be specified. PAM posts the pay detail based on these values.
-
Use Entered Labor Distribution Profile - A Labor Distribution Profile must be specified. PAM locates this Labor Distribution and posts the pay detail based on the accounting details on Labor Distribution Profile (LDPR).
-
Employee Event [DEPTE for the employee and event] - If PAM cannot retrieve accounting details from DEACC, it defaults to the details for the employee and Event code. These overrides are specified on the Employee Event Accounting Information (DEPTE) transaction. The transaction defines the employee appointment and the date range associated with the overrides. One or more event type code overrides can be defined within a single DEPTE transaction. All overrides will be effective based upon the date range defined on the DEPTE header. The valid values for the Labor Distribution Override Option are:
-
>Use Entered Accounting Values - The accounting details for the employee and event type code must be specified. PAM posts the pay detail based on these values.
-
Use Entered Labor Distribution Profile - A Labor Distribution Profile must be specified. PAM locates this Labor Distribution and posts the pay detail based on the accounting details on Labor Distribution Profile (LDPR).
-
Employee ID [DEPTA for the employee] - If PAM cannot retrieve accounting details from DEPTE, it defaults to the details for the employee. To do this, PAM retrieves the Internal Employee ID from the PAY_DETL table and looks up the accounting details for the employee on the EMPL_APPT_ACTG table. Any accounting details that are found will be used. The empl_appt_actg table is populated from the Employee Accounting Data (DEPTA) transaction for the employee.
-
Position ID [PSMT for the position] - If PAM cannot retrieve accounting details from DEPTA, it defaults to the details for the position in which the employee is enrolled. PAM retrieves the Internal Position ID from the pay_detl table and looks up the accounting details for the position on the posn_hist_actg table. Any accounting details that are found will be used. These accounting details for the position are set up in the Accounting Source, Fund Accounting, and Detail Accounting sections of the Position Maintenance (PSMT) transaction or on the Position Distribution Profile (PDPR) for the position. The valid values for Labor Distribution Override Option are:
-
Use Entered Accounting Values - The accounting details for the position must be specified. PAM posts the pay detail based on these values.
-
Use Entered Labor Distribution Profile - A Labor Distribution Profile must be specified. PAM locates this Labor Distribution and posts the pay detail based on the accounting details on Labor Distribution Profile (LDPR).
-
Use Appointment Accounting Values - No accounting attributes are specific for this position. Accounting details for the pay detail default to those on the profile for the employee.
-
Extended Department [DEPTX for the employee] - If PAM is not able to retrieve accounting details from the EVNT, DEPTA, PSMT, PDPR, or from an override transaction (TADJ, TIMEI, OPAY, or OTPAY), it defaults to the details for the Department to which the employee belongs. PAM retrieves this information from the empl_asgnmt table. Using the Department ID in this table, the Accounting details for the Department is retrieved from the extended_dept table. This is the table that populates Extended Department (DEPTX).
-
Site Specific Parameters (SPAR) - Finally, if PAM cannot retrieve accounting details from DEPTX for the employee’s Department, it uses the Default Value on the DEFAULT LDPR CD FOR PAY entry on SPAR. This parameter allows you to specify the Labor Distribution Profile to which HRM defaults to retrieve accounting details for pay, when needed. Accounting details for this Labor Distribution Profile can be verified on LDPR. When the GLOBAL LEVEL DEFAULT DEPT entry on SPAR is True with a Text Value of G, PAM gets the Department to be used for this Labor Distribution Profile from this GLOBAL LEVEL DEFAULT DEPT SPAR entry. When the GLOBAL LEVEL DEFAULT DEPT entry on SPAR is False, PAM gets the Department to be used for this Labor Distribution Profile from the PAM DOC DEPT DEFAULT entry on SPAR. LDPR must be established when using this SPAR parameter.
-
Infer Object for Classification [IOLDC for classification] - Once detail accounting has been established for the pay detail, PAM will check the Infer Object by Labor Distribution Classification (IOCLD) page to determine if any Object and Sub-Object overrides have been defined for the Event Type code and the employee’s Labor Distribution Classification. The employee’s classification is defined on the Department Specific Data (DEPTD) transaction. If a match is found, PAM will always override both the Object and Sub-Object values found on IOCLD regardless of any other overrides for these values.
-
If no employee appointment accounting and position accounting attributes can be found due to an employee not being active for the entire pay period, the USE HISTORICAL POSITION ACCTG parameter can be used to determine the employee’s historical position accounting values.
Note: The FUND CODE FOR RESERVE PAY and DEPT CODE FOR RESERVE PAY are used as the ultimate default values regardless of whether USE HISTORICAL POSITION ACCTG is set to Y or N. The purpose of USE HISTORICAL POSITION ACCTG is to enable the application to perform additional look-ups for the historical position accounting IF and ONLY IF no employee appointment accounting and position accounting attributes can be found since the employee is not active for the entire pay period. If any of the employee appointment accounting or position accounting attributes can be found for the current pay period, that accounting code is used. If no employee appointment accounting and position accounting (current and historical) attributes can be found, the FUND CODE FOR RESERVE PAY and DEPT CODE FOR RESERVE PAY are used as the final fail-safe default values. In another words, the USE HISTORICAL POSITION ACCTG parameter only enables additional look-ups for historical position accounting attributes and does not dictate whether the FUND CODE FOR RESERVE PAY and DEPT CODE FOR RESERVE PAY are used or not, as they are used if all attempts to look for the employee appointment accounting and position accounting attributes (current and historical) produce no results.
-
Infer Object for Classification [IOLDC for classification] – Once detail accounting has been established for the pay detail, PAM will check the Infer Object by Labor Distribution Classification (IOCLD) page to determine if any Object and Sub-Object overrides have been defined for the Event Type code and the employee’s Labor Distribution Classification. The employee’s classification is defined on the Department Specific Data (DEPTD) transaction. If a match is found, PAM will always override both the Object and Sub-Object values found on IOCLD regardless of any other overrides for these values.
-
Payroll Check Processor Accounting Overrides (PCPAO) - The Payroll Check Processor Accounting Overrides (PCPAO) page allows users to configure a set of accounting overrides to be executed by the Payroll Check Processor batch process. This page works with the Payroll Check Processor Accounting Overrides Configuration (PCPAOC) page to designate when fields should be overridden. Users designate a set of selection criteria. When the Payroll Check Processor batch process is executed, employees who match the selection criteria will have the designated Chart of Account fields overridden to the values selected.
Accounting Detail at the Deduction/Benefit Plan LevelAccounting Detail at the Deduction/Benefit Plan Level
The Deduction Detail table contains deduction details for a check by deduction type and deduction plan. Accounting details for a deduction are generally specified on the Deduction Plan for the deduction. For a standard deduction, these details are specified on Deduction Plan (DPLN). For a benefit, these details are specified on BENP for the benefit. For the employer side of a benefit, these details are specified on EFBP for the benefit.
Accounting information is set up in the following sections of these windows:
Payment Voucher InformationPayment Voucher Information
This section controls the type of payment voucher transaction that is created by the Payroll Labor Distribution Consolidation process IF enabled on the table for a deduction (or benefit) record.
-
External
-
Inter Fund Revenue
-
Inter Fund Expenditure
-
Intra Fund Revenue
-
Liabilities Only
-
Intra Fund Expenditure
Note: Types 2 through 6 are considered Internal deductions.
External deductions are deductions that are paid to external vendors such as health care providers. They are set up with the following information:
Payment Voucher Type |
1 (External) |
BSA code |
The balance sheet account that tracks the money paid to this external vendor |
Vendor code |
The vendor ID for the external vendor being paid |
Internal deductions are deductions that are paid to sources within the organization and can therefore be referenced by a COA.
Inter Fund |
This is used when the Fund of the Deduction is different from the Fund of the employee’s COA. |
Intra Fund |
This is used when the Fund of the Deduction is the same as the Fund of the employee’s COA |
Revenue |
This is used to determine whether a deduction should have a payment voucher type of revenue or not. This depends on how the information is to be tracked on the financial side. If a payment voucher type is revenue, then a revenue source is required. |
Expenditure |
This is used to determine whether a deduction should have a payment voucher type of Expenditure or not. This depends on how the information is to be tracked on the financial side. If a payment voucher type is expenditure, then an expenditure source or appropriation is required |
Liabilities only |
This is used to determine whether or not a deduction is Liabilities Only. A Liabilities Only deduction does not require a revenue source or appropriation. |
The Payment Voucher Information Section also allows you to determine whether or not a Payment Voucher must be generated for this deduction. This is done by means of the Generate Payment Voucher flag. This flag has two basic functions:
-
Indicate whether or not Payment Vouchers are to be automatically generated for External deductions.
-
Indicate whether or not an Internal deduction is to be processed by PAM. If the Generate Payment Voucher flag is unchecked for an Internal deduction, the deduction will not be processed by PAM, and no transaction will be generated.
Note: Internal deductions generally have the Generate Payment Voucher flag set to Y.
Fund Accounting/Detail AccountingFund Accounting/Detail Accounting
These sections contain the COA elements you need to enter for an Internal Deduction.
Clearing FundClearing Fund
A Clearing Fund is a fund or sub fund in Financial that is used to track payroll liabilities and cash reserved until checks are cleared. The Use Clearing Fund flag determines whether the Cash transactions for the DPLN/BENP/EFBP are processed one at a time Cash, or if they are stored in a Clearing Fund and processed at specified intervals Cash in Clearing Fund. The Clearing Fund is typically specified in SPAR. You can also override this SPAR setting.
If the Use Clearing Fund flag is checked, this deduction posts to a Clearing Fund when processed. If the Override Clearing Fund is not specified, the Clearing Fund to which the deduction posts will be the one specified in the CLEARING FUND DEFAULT VALUE parameter on SPAR.
To enable the Clearing Fund functionality, the following must be done:
-
Specify a Cash Balance Sheet Account
-
Set the SPAR entry JV OFFSET BS ACCT CD.
-
Set the SPAR entry CLEARING FUND DEFAULT VALUE.
-
Check the Use Clearing Fund flag.
-
Specify the following entries in the Clearing Fund section of the Deduction/Benefit Plan window:
Clearing Fund flag |
Clearing funds will be used on PAM transactions created for this deduction |
Override Clearing fund/sub fund |
If a clearing fund is entered here, the clearing fund specified on SPAR will be overridden and the clearing fund/sub fund entered will be used. |
The clearing fund is written to PYRL transactions in different locations depending on the transaction type:
-
PREXP - Funds are never overridden by clearing funds.
-
PRLIA - Override Clearing Fund is written to the clearing fund field (clrng_fund_cd) and the normal fund is in the operating fund field (fund_cd).
-
PRLNP - For Net Pay, the Override clearing fund is written to the fund_cd field.
-
PRLID - Funds are never overridden by clearing funds.
-
PRLVP - The Override Clearing Fund is written to both the fund_cd and the override clearing fund field (clrng_fund_cd).
Note: Accounting details at the Deduction/Benefit Plan level can be found in ded_plan DB table: