AliasFunctionToCalculateDBAs

Cache Alias Functions To Calculate DBA's

Minor Business Rule

Object Name: B0800099

Parent DLL: CHRM

Location: Client/Server

Language: C

Functional Description

This function will Update and Get records from the DBA Alias cache.

Purpose

Setup Notes and Prerequisites

First call B0700003 to initialize the payroll caches and retrieve the Job ID's.  Use the DBA Alias
Job ID when using this function.  When finished with the cache, call B0700003 again to terminate the
Payroll caches.

Special Logic

Technical Specification

cCacheActionCode Values are as follows:
1 = Get Cache record
3 = Update Cache record

The function to Initialize the cache will add all the applicable records, therefore, add is not
necessary.  An Error ID will be passed back if there is an error in processing.  The alias from UDC 07/VN
is the only key.

Data Structure

D0800099 - Cache Alias Functions To Calculate DBA's

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

szDBAAliasCacheName PID char REQ INPUT

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.

szAlias DTAI char OPT BOTH

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cFlag EV01 char OPT BOTH

An option that specifies the type of processing for an event.

mnValue MATH01 MATH_NUMERIC OPT BOTH

- - - Good Performance Low Value.

cCharacter EV02 char OPT BOTH

An option that specifies the type of processing for an event.

szString CH01 char OPT BOTH

Variable column headings are used in management reporting. These headings are centered and stacked on each other. There are four
lines of column headings available. Centering is controlled by the column size. The Description column heading can be between 1 and 60
characters and is a single line heading. Centering is controlled by the column size. Use a keyword phrase delimited by a colon (:) to place a
month (or ending date for 53 period reporting) in the heading. For example, :PA places the current month, based on the current financial reporting
date, in the column heading. If the current month is 01, the heading is January. If the column size is less than nine characters, the heading
would be "Jan." :PA012 would place December in the column heading, :PA+01 would place February in the heading, and so on.

jdDate DATE01 JDEDATE OPT BOTH

Event point for JDE Date.

szCacheActionCode CACTN char REQ INPUT

A code that indicates the activity you want to perform. Valid codes:     o Get - Retrieve the cache element     o Add - Add a cache element     o
Update - Update a cache element     o Delete - Delete a cache element     o Delete All - Delete all cache elements     o Get Next - Retrieve the
next cache element     o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist     o Terminate -
Terminate Cache

szErrorMessageID DTAI char OPT OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

Related Functions

B0800099 Cache Alias Functions To Calculate DBA's

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szDBAAliasCacheName	PID	char	REQ	INPUT
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.
szAlias	DTAI	char	OPT	BOTH
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cFlag	EV01	char	OPT	BOTH
An option that specifies the type of processing for an event.
mnValue	MATH01	MATH_NUMERIC	OPT	BOTH
- - - Good Performance Low Value.
cCharacter	EV02	char	OPT	BOTH
An option that specifies the type of processing for an event.
szString	CH01	char	OPT	BOTH
Variable column headings are used in management reporting. These headings are centered and stacked on each other. There are four lines of column headings available. Centering is controlled by the column size. The Description column heading can be between 1 and 60 characters and is a single line heading. Centering is controlled by the column size. Use a keyword phrase delimited by a colon (:) to place a month (or ending date for 53 period reporting) in the heading. For example, :PA places the current month, based on the current financial reporting date, in the column heading. If the current month is 01, the heading is January. If the column size is less than nine characters, the heading would be "Jan." :PA012 would place December in the column heading, :PA+01 would place February in the heading, and so on.
jdDate	DATE01	JDEDATE	OPT	BOTH
Event point for JDE Date.
szCacheActionCode	CACTN	char	REQ	INPUT
A code that indicates the activity you want to perform. Valid codes: o Get - Retrieve the cache element o Add - Add a cache element o Update - Update a cache element o Delete - Delete a cache element o Delete All - Delete all cache elements o Get Next - Retrieve the next cache element o Add/Update - Add a cache element if it does not exist; Update a cache element if it does exist o Terminate - Terminate Cache
szErrorMessageID	DTAI	char	OPT	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.