RetrieveAlphaNameorEENumbers

Retrieve Alpha Name and/or Employee Numbers - F060116

Minor Business Rule

Object Name: N0700032

Parent DLL: CPAY

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this NER is to retrieve the Employee Alpha Name (ALPH), Social Security Number (SSN),
Third Employee Number (OEMP) from the Employee Master using a Business View that just includes AN8,
ALPH, SSN, and OEMP.

The Return Code (EV01) will have the following codes returned:
'0' Record does exist
'1' Record does not exist

Note*  A typical use for this NER is found in many reports where based on a processing option the
user only wants to see Address Number, Social Security Number, or the Third Employee Number on their
report.

Setup Notes and Prerequisites

Special Logic

Technical Specification
Parameters

Data Item Data Structure Description  I/O  Required Table Notes
AN8         mnAddress Number            I    Y              Employee Address Number
ALPH        szAlphaName                 O    N              Employee Alpha Name
SSN         szSocialSecuirtyNumber      O    N              Employee Social Security Number
OEMP        szThirdEmployeeNumber       O    N              Third Employee Number
EV01        cReturnCode                 O    N              ReturnCode

Related Tables/Business Views

Table Table Description
V060116AERetrieve Employee Name and/or Employee Numbers

Processing
//     Retrieve Alpha Name and/or the Employee Numbers from the Employee Master
V060116AE.FetchSingle
// ****************************************************************
//     Set Return Error Code
//     Possible Values are:
//     1 = Address Book Number not Found
// ****************************************************************
//
If SV File_IO_Status is equal to CO ERROR
     BF cReturnCode = "1"
End If

Data Structure

D0700032 - Retrieve Alpha Name and/or Employee Numbers - F060116

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

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.

szNameAlpha ALPH char OPT NONE

The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.

szSocialSecurityNumber SSN char OPT NONE

A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number.
If you add employee information for a non-US or non-Canadian company, you can leave this field blank. However, if the international code is
set to Y and the default company is non-Canadian and non-United States, you can enter a 16-character number for the tax ID. The system
does not permit duplicate tax ID numbers. Also, the number cannot include dashes. For example, if a social security number of nn-nn-nnnn is
used, the number should be entered as follows: 123456789.

szEmployeeNumberThird OEMP char OPT NONE

An alternate employee number, typically the number from the employee tracking system that your organization used prior to converting to
the J.D. Edwards system. To search using this number, preface the number with a slash (/).

cReturnCode EV01 char OPT NONE

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

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
szNameAlpha	ALPH	char	OPT	NONE
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter dashes, commas, and other special characters, but the system cannot search on them when you use this field to search for a name.
szSocialSecurityNumber	SSN	char	OPT	NONE
A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number. If you add employee information for a non-US or non-Canadian company, you can leave this field blank. However, if the international code is set to Y and the default company is non-Canadian and non-United States, you can enter a 16-character number for the tax ID. The system does not permit duplicate tax ID numbers. Also, the number cannot include dashes. For example, if a social security number of nn-nn-nnnn is used, the number should be entered as follows: 123456789.
szEmployeeNumberThird	OEMP	char	OPT	NONE
An alternate employee number, typically the number from the employee tracking system that your organization used prior to converting to the J.D. Edwards system. To search using this number, preface the number with a slash (/).
cReturnCode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.