EndEEPDBACache

Create EE PDBA Cache

Minor Business Rule

Object Name: B0700020

Parent DLL: CPAY

Location: Client/Server

Language: C

Functional Description

Purpose
This Function is responsible for flushing information in the EE PDBA Cache.

Setup Notes and Prerequisites
The InitializeEEPDBACache and ProcessEEPDBACache functions must be called before calling this
function.
Special Logic
None

^

Data Structure

D0700020 - DS for Initialize/End EEPDBA Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEEPDBACacheID	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

None

Related Tables

F060116 Employee Master Information
F06106 Employee Pay Instructions
F069106 Union Benefits Master
F069116 Payroll Transaction Constants

InitializeEEPDBACache

Create EE PDBA Cache

Minor Business Rule

Object Name: B0700020

Parent DLL: CPAY

Location: Client/Server

Language: C

Functional Description

Purpose
The Purpose of this business function is to initialize the EEPDBA Cache for subsequent use by the
ProcessEEPDBACache and EndPDBACache Functions.
Setup Notes and Prerequisites
This function must be called before calling ProcessEEPDBACache and EndPDBACache function.Therefore,it
typically should be called in the Initialize Section event of the calling Program.

Special Logic
None

Data Structure

D0700020 - DS for Initialize/End EEPDBA Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEEPDBACacheID	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

None

Related Tables

F060116 Employee Master Information
F06106 Employee Pay Instructions
F069106 Union Benefits Master
F069116 Payroll Transaction Constants

ProcessEEPDBACache

Create EE PDBA Cache

Minor Business Rule

Object Name: B0700020

Parent DLL: CPAY

Location: Client/Server

Language: C

Original SAR: 2136972

Functional Description

Purpose

The purpose of the business function is to receive DBA information from F06106, F069106 and F069116
files and load that information into the EEPDBA Cache.

Setup Notes and Prerequisites

The InitializeEEPDBACache function must be called before calling this function.

Parameters

Data ItemDescriptionI/ORequiredNotes
PIDszEEPDBACacheID IxValue returned by InitializeEEPDBACache

AN8mnAddressNumber Ix

DISOcTransactionTypeTimePay IxD, B, A, or  or
all

DTjdDate IRetrieved DBA's will be valid on DTE
If not entered, all DBA's will be
retrieved

EV01cErrorCode OError code: = 0 No errors
= 1, No records found (cache
empty)

Cache Structure

See B0500027, Read Employee PDBA Cache, for the cache structure

Program Logic

1. F060116.FetchSingle (YAAN8 = mnAddressNumber)
Return YAALPH, YATARA, YAHMCO, YAHMCU, YANID, YASALY, YAUN, YAJBCD, YAJBST, YACCPR, YADIVC.

2. Get all PDBA records from F06016 (employee level), where
YMAN8 = mnAddressNumber
YMDISO = cTransactionTypeTimePay

  If  jdDate not blank, then choose records with YMPSDT <= hdDate <= YMPTDT
  [Blank dates are considered open]

  Get other information from F069116 for PDBA retrieved from F06106
  Add information to cache with cFileCode = "E"

3. Get all PDBA records from F069106 (Union level)
  if ((YAUN not= blank) & (YAHMCU not= blank) & (YAKBCD not= blank) & (YJBST not= blank))


  if ((YAUN not= blank) & (YAHMCU not= blank) & (YAKBCD = blank) & (YJBST = blank))


  if ((YAUN not= blank) & (YAHMCU = blank) & (YAKBCD not= blank) & (YJBST not= blank))


  if ((YAUN not= blank) & (YAHMCU = blank) & (YAKBCD = blank) & (YJBST = blank))


4. Get all PDBA records from F069116 (Company level), where YCTRPF = "Y" (calculate for all
employees)
Assign ValidFlag = "Y"

if YCHMCO not= blank
if YCHMCO not= YAHMCO then ValidFlag = "N"

if YCTARA not= blank
if YCTARA not= YATARA then ValidFlag = "N"

if YCSALY not= blank
if YCSALY not= YASALY then ValidFlag = "N"

if ValidFlag = "Y" then
if PDBA not in cache then Add information to cache with cFileCode = "D"

5. Close all tables

6. if cache counter >= 1 then
cErrorCode = '0'
    else
cErrorCode = '1'
    endif

Data Structure

D0700020B - DS for Process EEPDBA Cache

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEEPDBACacheID	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.
mnAddressNumber	AN8	MATH_NUMERIC	OPT	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cTransactTypeTimePay	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.
jdDate	DT	JDEDATE	OPT	NONE
The date that the employee was terminated, if applicable.
cErrorCode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnDateYr	DTEY	MATH_NUMERIC	OPT	NONE
A two-digit number that specifies the applicable year. If you leave this field blank, the program uses the system date.
szTaxIdentificationNo	TAXX	char	OPT	NONE
A number that identifies your company to the tax authority. This number can include the tax ID number for an individual, a federal or state corporate tax ID, a sales tax number, and so on. This number has specifically been established for the Payroll system to handle the requirements of taxing authorities that require more than 9 positions for the tax identification number. Do not enter hyphens (dashes), slashes, spaces, or other punctuation in the tax identification number.
cTaxHistoryType	THTY	char	OPT	NONE
A user defined code (07/TH) that specifies the type of information being tracked for the employee in the US Taxation Summary History table (F06136) or the Canadian Tax History table (F0713). The value in this field determines what type of year-end form the system generates.

Related Functions

None

Related Tables

F060116 Employee Master Information
F06106 Employee Pay Instructions
F069106 Union Benefits Master
F069116 Payroll Transaction Constants