EndDBASummaryReportCache

D/B/A Transaction Audit Summary Report Cache

Minor Business Rule

Object Name: B0700062

Parent DLL: CPAY

Location: Client/Server

Language: C

End DBA Summary Report Cache

Object Name: B0700062 D/B/A Transaction Audit Summary Report Cache

Parent DLL: CHRM

Location Client/Server

Language: NER

Functional Description

Purpose

This function will clear and remove the D/B/A transaction Audit Summary Report Cache.

Special Logic

The cache name must be passed into the business function, in order to remove the proper cache.

^

Data Structure

D0700062A - DS for Initialize/End D/B/A Summary Report Cache

Special Input Expected

If the business function is called in Initialize mode, then no input parameters are necessary. If
the business function is called in End mode, the cache name must be passed into the business function.

Special Output Expected

If the business function is called in Initialize mode, the cache name will be returned from the
business function. If the business function is called in End mode, no output parameters are returned.
^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szDBACodeCache	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.

Related Functions

B0000564 Get Internal Next Number

Related Tables

None

InitializeDBASummaryReportCache

D/B/A Transaction Audit Summary Report Cache

Minor Business Rule

Object Name: B0700062

Parent DLL: CPAY

Location: Client/Server

Language: C

Initialize DBA Summary Report Cache

Object Name: B0700062 D/B/A Transaction Audit Summary Report Cache

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

Create a cache for use by the D/B/A transaction summary report (R073053). The information in the
cache is grouped by PDBA code.

Special Logic

The cache name is returned from this function call.
^

Data Structure

D0700062A - DS for Initialize/End D/B/A Summary Report Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szDBACodeCache	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.

Related Functions

B0000564 Get Internal Next Number

Related Tables

None

ProcessDBASummaryReportCache

D/B/A Transaction Audit Summary Report Cache

Minor Business Rule

Object Name: B0700062

Parent DLL: CPAY

Location: Client/Server

Language: C

Process DBA Summary Report Cache

Object Name: B0700062 D/B/A Transaction Audit Summary Report Cache

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose

This function performs a simple caching procedure to summarize and report DBA information by DBA
code. The function will take each record passed to it and add it to the cache, or if the DBA code already
exists, update the cache record.  After loading of the cache is completed, the function may be called
again to retrieve the summary DBA cache records.

Setup Notes and Prerequisites

The 'Initialize DBA Summary Report Cache' function must be called first, before any records may be
added or retrieved from the cache.  The 'Initialize DBA Summary Report Cache' function only creates the
cache, and returns the cache name.  No pre-loading of records from any table is performed.

Special Logic

When adding/updating records from the cache, only the passed parameters are used to update the cache.
No additional information is retrieved and then loaded into the cache.  When retrieving cache
records, only the cache name is a required parameter.  No retrieval of cache records by index key is
allowed.  Retrieval is by next record in the cache.  So, 'Process DBA Summary Report Cache' must be called,
multiple times, for retrieval of each record in the cache.

Addition and retrieval are both performed within this function, so a parameter must be populated to
tell the cache whether or not the mode is addition or retrieval.  The parameter is the processing mode
field.  A '0' in the processing mode field, means the function is to perform adds/updates.  A '1' in
the processing mode field, means the function is to perform retrievals.

After the entire cache process has completed, the 'End DBA Summary Report Cache' must be called to
clear and remove the cache.

Data Structure

D0700062B - DS for Process D/B/A Summary Report Cache

Special Input Expected

If the business function is called in Add/Update mode, the cache name, PDBA code, PDBA description,
DBA type, rate, and amount must be passed into the business function.  If the business fucntion is
called in retrieval mode, only the cache name is passed into the business function.  Add/Update mode
versus Retrieval mode, is a value placed in the processing mode field.

Special Output Expected

If the business function is called in Add/Update mode, only the return code will be returned.  If the
business function is called in retrieval mode, the PDBA code, description, DBA type, rate, amount and
return code are returned from the business function.

Significant Data Values

Processing Mode = 0 (Add/Update Mode)
Processing Mode = 1 (Retrieval Mode)
^

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szDBACodeCache	PID	char	OPT	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
mnPDBACode	PDBA	MATH_NUMERIC	OPT	NONE
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.
szPDBADescription	EXA	char	OPT	NONE
A description, remark, explanation, name, or address.
cDBAType	DISO	char	OPT	NONE
A code used to distinguish between the following types of payroll entries: P Time Cards (Earnings) D Deductions withheld B Benefit (both cash and non cash) A Accrual of sick, vacation, comp, and so forth Note: These codes may only be changed by J.D. Edwards If you enter an * in this field the system displays all four types of PDBAs.
mnRate	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.
mnAmtGrossPay	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).
cProcessingMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.

Related Functions

B0000564 Get Internal Next Number

Related Tables

None