F060146ValidateBeginAndEndDates

F060146 Validate Begin and End Dates

Minor Business Rule

Object Name: N0500061

Parent DLL: CFND

Location: Client/Server

Language: NER

Functional Description
This business function will determine if a beginning and/or ending date overlap with other similar
records in the Employee Pay Rates (F060146) table.  Values from parameters for Address Book Number
(AN8), Job Type (JBCD) and Job Step (JBST) will be used to select similar records.

The function can automatically display errors or display can be suppressed by passing a value of 1
(one) in the appropriate parameter.  Errors are returned by the function regardless of errors being
displayed.  The values returned are as follows:
1 = End date is on or before the begin date.
2 = Both the begin and end date overlap dates from
    existing record(s).
3 = End date overlaps date from existing record(s).
4 = Begin date overlaps date from existing record(s)

Purpose
Prevent records with overlapping dates from being created.

Setup Notes and Prerequisites
The address book number, job type, job step and beginning date are required parameters in the data
structure.

Special Logic
None.

Technical Specification

Parameters

Data Item Data Structure DescriptionI/ORequiredNotes
AN8mnAddressNumber_AN8IY
JBCDszJobCategory_JBCDIY
JBSTszJobType_JBSTIY
EFTBjdDateBeginningEffective_EFTBIY
EFTEjdDateEndingEffective_EFTEIN
VC01AcSuppressErrorMessage_VC01AIN
VC01AcErrorFlag_VC01AON

Processing

Check to see if DateEndingEffective is before or on DateBeginning Effective

If so, set error flag to 1 and if errors are to displayed then display error 1111.

Select records in F060146 with same address book number, job type, and job step.

If the DateEndingEffective or DateBeginningEffective overlap with any other record's begin and end
date then set the appropriate error value and display error, if appropriate.

Data Structure

D0500061 - F060146 Validate Begin and End Dates

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber_AN8	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.
szJobCategory_JBCD	JBCD	char	REQ	INPUT
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and apply that information to the employees who are linked to that job type.
szJobStep_JBST	JBST	char	REQ	INPUT
A user defined code (07/GS) that designates a specific level within a particular job type. The system uses this code in conjunction with job type to determine pay rates by job in the Pay Rates table.
jdDateBeginningEffective_EFTB	EFTB	JDEDATE	REQ	INPUT
The date that an address, item, transaction, or table record becomes active. The meaning of this field differs, depending on the program. For example, the effective date could represent the following: o When a change of address becomes effective. o When a lease becomes effective. o When a price becomes effective. o When the currency exchange rate becomes effective. o When a tax rate becomes effective.
jdDateEndingEffective_EFTE	EFTE	JDEDATE	OPT	INPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
cSuppressErrorMesssage_VC01A	VC01A	char	OPT	INPUT
This is a generic field used for video constants display.
cErrorFlag_VC01A	VC01A	char	OPT	OUTPUT
This is a generic field used for video constants display.
jdOrigDateEndingEffective_EFTE	EFTE	JDEDATE	OPT	INPUT
The date on which the item, transaction, or table becomes inactive, or through which you want transactions to appear. This field is used generically throughout the system. It could be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
cUpdateFlag_VC01A	VC01A	char	OPT	INPUT
This is a generic field used for video constants display.
szCostCenter	MCU	char	REQ	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szUnionCode	UN	char	REQ	INPUT
A user defined code (06/UN) that represents the union or plan in which the employee or group of employees work or participate.

Related Functions

None

Related Tables

None