AccumulateDBAAmountForEmployee

Accumulate DBA Amount For Employee

Minor Business Rule

Object Name: N0800051

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

Calculates an Employee's Deduction Benefit and Accrual (DBA) amounts during a specified period.  The
dates passed in by the user are compared with the Check Date in the Benefit/Accrual Detail File.  The
F0719 is read if One World B7.3.3 payroll or later is being used.  If World payroll or an earlier
version of One World payroll is being used, the F0619 file is read.  If the Check Date is between the
jdDateBeginning and jdDateEnding, then the Gross Pay Amount (GPA) for that record is added to the
accumulated total.

Setup Notes and Prerequisites

Special Logic

Technical Specification

Select the records in the F0619 with the same Address Number and DBA ID as those passed in by the
user.  Go through each of the selected records and compare the Beginning and Ending Dates passed in by
the user with the record's Check Date.  If the Check Date falls within the Beginning and Ending Dates,
then add the Gross Pay Amount to the total.  Once all the records have been checked, pass the
Accumulated Total back to the user.  Error codes are used instead of hard errors.  The values of the error code
may be:  0 (No Errors), 1 (Could not open either the F0619 or F0719 depending on the version of
Payroll being used), 2 (Missing the Employee Address Number or DBA parameter).

Data Structure

DN0800051 - Accumulate DBA Amount For Employee

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnAddressNumber AN8 MATH_NUMERIC REQ INPUT

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

mnDBACode PDBA MATH_NUMERIC REQ INPUT

A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are
numbered from 1000 to 9999.

jdDateBeginning EFTB JDEDATE REQ INPUT

The date that an address, item, transaction, or table record becomes active.  The meaning of this field differs, depending on the program.
For example, the effective date could represent the following:   o When a change of address becomes effective.   o When a lease becomes
effective.   o When a price becomes effective.   o When the currency exchange rate becomes effective.   o When a tax rate becomes effective.

jdDateEnding EFTE JDEDATE OPT INPUT

The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used
generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective
date, or whatever is appropriate.

mnAmtAccumulated GPA MATH_NUMERIC OPT OUTPUT

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).

cErrorCode ERRC char OPT OUTPUT

Special Output Returned
0 (No Errors), 1 (Could not open either the F0619 or F0719 depending on the version of Payroll being
used), 2 (Missing the Employee Address Number or DBA parameter)

^

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
mnDBACode	PDBA	MATH_NUMERIC	REQ	INPUT
A code that defines the type of pay, deduction, benefit, or accrual. Pay types are numbered from 1 to 999. Deductions and benefits are numbered from 1000 to 9999.
jdDateBeginning	EFTB	JDEDATE	REQ	INPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdDateEnding	EFTE	JDEDATE	OPT	INPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnAmtAccumulated	GPA	MATH_NUMERIC	OPT	OUTPUT
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).
cErrorCode	ERRC	char	OPT	OUTPUT
Special Output Returned 0 (No Errors), 1 (Could not open either the F0619 or F0719 depending on the version of Payroll being used), 2 (Missing the Employee Address Number or DBA parameter) ^