DBACalcAdd

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Functional Description

Purpose

This is a Generic Function used by the Pre-Payroll DBA Calculation Function.
The Purpose of this function is to determine the difference between two dates.

Setup Notes and Prerequisites

The Dates must be passed in through Date Variable 1 and Date Variable 2.

Special Logic

Technical Specification

Date Variable 2 is the Greater Date, Date Variable 1 is the Lesser Date.
^

Data Structure

DN0700003 - DBA Calculation Generic Functions

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szSecondaryTable	STAB	char	OPT	BOTH
A code that specifies the method under which the DBA is to be calculated. This calculation table serves as the secondary calculation table for the system. You must enter a code in this field if you enter a code in the secondary method field.
cSubsequentDedMethod	DEDS	char	OPT	BOTH
A user defined code (system 06, type DS) that indicates what method is used for the calculation of DBAs.
cHardSoftErrorFlag	ER2	char	OPT	OUTPUT
Hard/Soft Error Flag
mnVariableName01	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName02	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName03	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName04	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName05	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName06	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName07	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName08	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName09	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName10	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName11	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName12	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName13	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName14	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName15	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName16	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName17	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName18	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName19	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnVariableName20	GNUM5	MATH_NUMERIC	OPT	INPUT
This field is used for Numeric Specification Data.
mnReturnResult01	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult02	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult03	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult04	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult05	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult06	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult07	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult08	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult09	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult10	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult11	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult12	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult13	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult14	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult15	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult16	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult17	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult18	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnReturnResult19	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
mnRetrunResult20	GNUM5	MATH_NUMERIC	OPT	OUTPUT
This field is used for Numeric Specification Data.
cCharVariable01	Q1	char	OPT	INPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharVariable02	Q1	char	OPT	INPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharVariable03	Q1	char	OPT	INPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharVariable04	Q1	char	OPT	INPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharVariable05	Q1	char	OPT	INPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharReturn01	Q1	char	OPT	OUTPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharReturn02	Q1	char	OPT	OUTPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharReturn03	Q1	char	OPT	OUTPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharReturn04	Q1	char	OPT	OUTPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
cCharReturn05	Q1	char	OPT	OUTPUT
The character that the system uses to fill the position defined by the difference between the Begin Position and End Position when the attribute value does not fill the position.
szStringVariable01	DS40	char	OPT	INPUT
A 40-character description.
szStringVariable02	DS40	char	OPT	INPUT
A 40-character description.
szStringVariable03	DS40	char	OPT	INPUT
A 40-character description.
szStringVariable04	DS40	char	OPT	INPUT
A 40-character description.
szStringVariable05	DS40	char	OPT	INPUT
A 40-character description.
szStringReturn01	DS40	char	OPT	OUTPUT
A 40-character description.
szStringReturn02	DS40	char	OPT	OUTPUT
A 40-character description.
szStringReturn03	DS40	char	OPT	OUTPUT
A 40-character description.
szStringReturn04	DS40	char	OPT	OUTPUT
A 40-character description.
szStringReturn05	DS40	char	OPT	OUTPUT
A 40-character description.
jdDate1	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
jdDate2	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
jdDate3	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
jdDate4	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
jdDate5	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cDeductionBasisDESQ	DESQ	char	OPT	NONE
A user defined code (07/DB) that specifies the basis of a deduction, benefit, or accrual. When the system calculates the gross amount for disposable net wages, it does not use the basis of calculation. The gross amount includes all earnings that have a positive effect on the gross and net payment. For wage attachments use one of the following codes: 1-8 Garnishment, tax levy, wage assignment (child support and maintenance) R Loan, interest 0 Fees Note: When using the following codes (L = Prior Year, I= Inception to Date or P = Prior Month), it is required to roll over pdba amounts at year end for any pdba code that is included in the basis of calculation. Rollover (P07390) is required to create historical summary records (F06145 or F06146) in the new year that summarize amounts used for these calculations.
cDeductionBenefitMethodDEDM	DEDM	char	OPT	NONE
A user defined code (07/DM) that specifies the method that the system uses to perform certain calculations. For example, the system uses a method of calculation to calculate deductions, benefits, and accruals (DBAs) and workers' compensation insurance.
cOptionalStateCalcuCALC	CALC	char	OPT	NONE
A code that specifies whether the system calculates a DBA in the absence of gross pay. Valid values are: Y Yes, calculate this DBA when an employee has no gross pay, and no PDBA codes exist in the basis of calculation. N No, do not calculate this DBA when an employee has no gross pay, and no PDBA codes exist in the basis of calculation. Note: When an employee has no gross pay, the system calculates the DBA when the following conditions exist: o Calculate if no gross is set to Y. o Source of calculation is set to G. o Method of calculation is set to $. The system then records the resulting amount in arrears and performs one of the following functions: o Creates an overpayment for a deduction. o Calculates it as a benefit or an accrual. Note: If PDBA codes exist in the basis of calculation, the system attempts to calculate the DBA regardless of this setting.
mnAmountMaximumNetPayYA	NMAX	MATH_NUMERIC	OPT	NONE
The lowest amount to be generated as a check, bank advice, or payslip. The system does not allow zero amount checks if you have specified a minimum check amount. You can leave this field blank. Generally, this field's value will specify the minimum amount that must be paid to the employee.
mnAmountMaximumNetPayYD	NMAX	MATH_NUMERIC	OPT	NONE
The lowest amount to be generated as a check, bank advice, or payslip. The system does not allow zero amount checks if you have specified a minimum check amount. You can leave this field blank. Generally, this field's value will specify the minimum amount that must be paid to the employee.
mnAmountNetPay	NPAY	MATH_NUMERIC	OPT	NONE
The net amount of the payment. Before the net-deduction phase of the pre-payroll process runs, this amount equals gross pay, less taxes, less deductions that are based on gross pay. After the net-deduction phase, this amount represents the true net pay. For additional information that is related to this calculation process, see data items NPY1 and DESQ.
mnAmountNetPay_1	NPAY	MATH_NUMERIC	OPT	NONE
The net amount of the payment. Before the net-deduction phase of the pre-payroll process runs, this amount equals gross pay, less taxes, less deductions that are based on gross pay. After the net-deduction phase, this amount represents the true net pay. For additional information that is related to this calculation process, see data items NPY1 and DESQ.
mnAmountNetPay_2	NPAY	MATH_NUMERIC	OPT	NONE
The net amount of the payment. Before the net-deduction phase of the pre-payroll process runs, this amount equals gross pay, less taxes, less deductions that are based on gross pay. After the net-deduction phase, this amount represents the true net pay. For additional information that is related to this calculation process, see data items NPY1 and DESQ.
mnAmtOrRateRTAM	RTAM	MATH_NUMERIC	OPT	NONE
A value that is a percentage, a monetary amount, or an hourly rate, depending on where it is used. Valid values are: 1 For a deduction, benefit, or accrual, the meaning of this value depends on the method of calculation. The method determines whether the deduction is a flat monetary amount, a percentage, or a multiplication rate. Table method DBAs, depending on which table method they use, can either use this amount in the calculation or ignore it. If there are exceptions to the table calculation, you can override the table code in the detail area, set up a flat monetary DBA amount, or override the amount with a one-time override for a timecard. 2 For a pay type, amounts entered in this field override the hourly rate.
mnAmtGrossPayGPA	GPA	MATH_NUMERIC	OPT	NONE
The actual gross pay amount for an employee. This amount is to be distinguished from the distributed gross pay amount used for labor distribution. See data item DPAY. When using Work Order Time Entry, this field is used to record miscellaneous pay for an employee, (for example, piece rate bonus).
mnHoursWorkPHRW	PHRW	MATH_NUMERIC	OPT	NONE
The number of hours associated with each transaction.
mnRtBaseHourlyBHRT	BHRT	MATH_NUMERIC	OPT	NONE
This is the employee's base hourly rate as retrieved from either the Employee Master or the Union Rates Table. This number would not be modified by multipliers, differentials, etc. It is saved in the time entry file (F0611) for the express purpose of being able to account for premium pay separate from base pay. (See also: HRT, PWRT, BRT) *Important Note* If you change the number of DATA DISPLAY DECIMAL digits for the field "PHRT", "SHRT" you MUST also change this field's data display decimals to be the same number.
mnRtDistributionOrBillPBRT	PBRT	MATH_NUMERIC	OPT	NONE
A number that specifies the rate that the system uses to bill for labor services. This rate is often referred to as the billing or recharge rate. The system charges the resulting amount, based on this rate, to the primary distribution account for the timecard. The system also enters an offset to an account that is derived from automatic accounting instructions. This rate does not affect employee payroll. To allow billing rates in time entry, the employee record type must be set to 2 (payroll and recharge processing) or 3 (recharge processing only) with the Employee Payroll program (P0801PRL).
mnRtHourlyPHRT	PHRT	MATH_NUMERIC	OPT	NONE
The employee's hourly rate, which is retrieved during time entry. If you enter a rate in this field on any other form, that rate can override the value in the Employee Master table. In the Employee Master table, this number is the employee's base hourly rate. In the Union Rates table, it is the straight time rate. NOTE: If you change the number of the data display decimal digits for this field, you must also change fields Rate - Base Hourly (BHRT) and Rate - Hourly (SHRT) so that they have exactly the same number of data display decimal digits.
mnArrearageAmountARRA	ARRA	MATH_NUMERIC	OPT	NONE
The amount of the deduction that is being or has been reduced because the employee did not receive wages that could cover the payroll taxes and deductions calculated within the payroll cycle.

DBACalcAdd

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcAge

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcDateDifference

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcDivide

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcFetchF060117

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcFetchF069026

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcFetchF09116

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables

DBACalcFetchNextF09026LimitRange

DBA Generic Calculation Functions

Minor Business Rule

Object Name: N0700003

Parent DLL: CPAY

Location: Client/Server

Language: NER

Data Structure

Related Functions

Related Tables