GetEmployeeMasterSpecificData

Get Employee Master Specific Data Item

Minor Business Rule

Object Name: B0800168

Parent DLL: CHRM

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of this function is to fetch any field from an employee's record in F060116 based on the
Data Item passed in.

Setup Notes and Prerequisites
Input Variables
AN8Employee Address Book
DATIData Item

Return variables
szDataTypeOneWorldData ItemData Type Description
11jdDate01Date
if a date data item is passed in the value will be passed back in this var

1cEverestEventPoint01char
if a char data item is passed in the value will be passed back in this var

2szDescription001String
if a string data item is passed in the value will be passed back in this var

9mnMathNumeric01Numeric
if a Numeric data item is passed in the value will be passed back in this var

Special Logic

Technical Specifications

Get the data type for the passed in data item from F9210.
The data types are 1 Char, 2 String, 9 Math Numeric, 11 Date

Issue error if the Table could NOT be opened or if no record is found and exit the BSFN

Use GetTableColValue to get the value in the OWTP column in F9210, this is the actual data type for
the data item passed in

if the name passed in, szNameObject, = "F060116" then get the following value from f060116 if it
equals f060120 then get the value from f060120

Issue error if the Table could NOT be opened or if no record is found and exit the BSFN

The value from the table is passed back in a different data dictionary item depending upon its data
type

If  DATA TYPE = '1' (CHAR)pass back in cEverestEventPoint01

If  DATA TYPE = '2' (STRING)pass back in szDescription001

If  DATA TYPE = '11' (DATE)pass back in jdDate01

If  DATA TYPE = '9' (DATE)pass back in mnMathNumeric01

Data Structure

D0800168 - Get Employee Master Specific Data Item

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.

szDataItem DTAI char REQ INPUT

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.

cEverestEventPoint01 EV01 char OPT OUTPUT

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

jdDate01 DATE01 JDEDATE OPT OUTPUT

Event point for JDE Date.

szDescription001 DL01 char OPT OUTPUT

A user defined name or remark.

mnMathNumeric01 MATH01 MATH_NUMERIC OPT OUTPUT

- - - Good Performance Low Value.

szDataTypeOneWorld OWTP char OPT OUTPUT

The style or classification of data, such as numeric, alphabetic, and date. Do not change the data item type if it is used within an existing
application. Otherwise, you must regenerate your table and review all business functions that use this data item. Data types include the
following: Character A single letter, always the size of one. Date A date. Integer An integer. Character (Blob) An item that can be translated from EBCDIC
(8-bit character code commonly used on IBM mainframes) to ASCII (7-bit character code). Binary (Blob) An item that cannot be translated,
appears in machine code, and is found as an executable file under Win.help. Binary An option that represents two choices. It is usually a
combination of the digits 1 and 0 to represent on and off or true and false. String An item that is always the same size or length. Variable String An item of
variable size. JDE UTime An item that allows business process to span several time zones. Identifier (ID) An item that is used within the
program logic for controls. An ID is used to write a C program and reference third-party software that returns a pointer. A JDE API then saves the
pointer that references the ID. The parameter that the system passes to the C program is the ID. Numeric A long integer.

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

szNameObject OBNM char REQ INPUT

The name that identifies a system object. J.D. Edwards ERP architecture is object-based. Discrete software objects are the building blocks
for all applications, and developers can reuse the objects in multiple applications. The Object Librarian tracks each object. Examples of
system objects include: o Batch Applications (such as reports) o Interactive Applications o Business Views o Business Functions o
Business Functions Data Structures o Event Rules o Media Object Data Structures

Related Functions

None

Related Tables

F060116 Employee Master Information

F060120 Employee Master Additional Information File

F9210 Data Field Specifications (OneWorld)

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.
szDataItem	DTAI	char	REQ	INPUT
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.
cEverestEventPoint01	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
jdDate01	DATE01	JDEDATE	OPT	OUTPUT
Event point for JDE Date.
szDescription001	DL01	char	OPT	OUTPUT
A user defined name or remark.
mnMathNumeric01	MATH01	MATH_NUMERIC	OPT	OUTPUT
- - - Good Performance Low Value.
szDataTypeOneWorld	OWTP	char	OPT	OUTPUT
The style or classification of data, such as numeric, alphabetic, and date. Do not change the data item type if it is used within an existing application. Otherwise, you must regenerate your table and review all business functions that use this data item. Data types include the following: Character A single letter, always the size of one. Date A date. Integer An integer. Character (Blob) An item that can be translated from EBCDIC (8-bit character code commonly used on IBM mainframes) to ASCII (7-bit character code). Binary (Blob) An item that cannot be translated, appears in machine code, and is found as an executable file under Win.help. Binary An option that represents two choices. It is usually a combination of the digits 1 and 0 to represent on and off or true and false. String An item that is always the same size or length. Variable String An item of variable size. JDE UTime An item that allows business process to span several time zones. Identifier (ID) An item that is used within the program logic for controls. An ID is used to write a C program and reference third-party software that returns a pointer. A JDE API then saves the pointer that references the ID. The parameter that the system passes to the C program is the ID. Numeric A long integer.
szError	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.
szNameObject	OBNM	char	REQ	INPUT
The name that identifies a system object. J.D. Edwards ERP architecture is object-based. Discrete software objects are the building blocks for all applications, and developers can reuse the objects in multiple applications. The Object Librarian tracks each object. Examples of system objects include: o Batch Applications (such as reports) o Interactive Applications o Business Views o Business Functions o Business Functions Data Structures o Event Rules o Media Object Data Structures

F060116 Employee Master Information
F060120 Employee Master Additional Information File
F9210 Data Field Specifications (OneWorld)