DetermineDateByDateCode

Determine Date By Date Code

Minor Business Rule

Object Name: N0800039

Parent DLL: CHRM

Location: Client/Server

Language: NER

Functional Description

Purpose
The purpose of this Named ER is to determine the date, based on a Date Code.
Setup Notes and Prerequisites

Special Logic

Technical Specification
Validate the szEnrollmentDateCode against F08395

If the szEnrollmentDateCode is invalid szErrorCode = 2336

Validate mnAddressNumber against F060116 If mnAddressNumber is invalid szErrorCode = 0270

If DTF1 is not equal to ' ' use DTF1 as the data item to base date on
If DTF1 is equal to ' ' and if DTF2 is not equal to ' ' use DTF2 as the data item to base date on

Call Function "Determine Eligiblity Based From Date" to get one of the employee dates as the Based
From Date, as indicated by the data item to base date on.

If no Based From Date is returned by function, default jdDateEffectiveRates as the Based From Date
// Process by Day of Month//
If DYMO (Day of month) is not equal to 0 Determine date by day of the month (see Named ER for logic
details)
//Process by End of Month//
If ENDM (End Of Month) is not equal to 0 Determine day by end of month (see Named ER for logic
details)
//Process by number of days, months or years from the Based From Date//
If DTF2 (Date To Follow 2) is not equal to Blank and if  ELGB (Eligibility Basis) = 'D' Determine
Date by Number of Days(BAMT) from the Based From Date (see NER for logic details)

If DTF2 (Date To Follow 2) is not equal to Blank and if ELGB (EligibilityBasis) = 'M' Determine Date
by Number of Months(BAMT) from the Based From Date (see NER for details)

If DTF2 (Date To Follow 2) is not equal to Blank and if  ELGB (ElgibilityBasis) = 'Y'
Determine Date by Number of Years (BAMT) from the Based From Date (see NER for details)

//Process by enrollment dates//
If END1 (EnrollmentDate1) is not equal to 0 Determine Date by enrollment dates  (see NER for logic
details)

Data Structure

DN0800039 - Determine Date By Date Code

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

szEnrollmentDateCode DACD char NONE NONE

A code used to identify the terms for beginning and ending enrollment dates.

jdDateEffectiveRates EFT JDEDATE NONE NONE

The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost
effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.

mnAddressNumber AN8 MATH_NUMERIC NONE NONE

A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
location.

jdDeterminedDate DELG JDEDATE NONE NONE

The date on which the employee is eligible to enroll in the benefit plan. This date is not necessarily the date that the employee begins
participating in the plan. For example: The XYZ Company requires that employees work for the company for six months before they are eligible to
participate in the 401(k) plan. Employees can enroll in 401(k) two times per year, on January 1 and July 1. Therefore, an employee who
begins working for XYZ Company on 03/01/05 has an eligibility date of 01/01/06. The eligibility date is the date on which the employee becomes
eligible, provided that eligibility continues. If the employee changes to a non-eligible status, the eligibility date on the new record is set to
blank.

szErrorCode VC04A char NONE NONE

This is a generic field used as a work field in Everest.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szEnrollmentDateCode	DACD	char	NONE	NONE
A code used to identify the terms for beginning and ending enrollment dates.
jdDateEffectiveRates	EFT	JDEDATE	NONE	NONE
The date that identifies when a date is first valid. The effective date is used generically. It can be a lease effective date, a price or cost effective date, a currency effective date, a tax rate effective date, or whatever is appropriate.
mnAddressNumber	AN8	MATH_NUMERIC	NONE	NONE
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
jdDeterminedDate	DELG	JDEDATE	NONE	NONE
The date on which the employee is eligible to enroll in the benefit plan. This date is not necessarily the date that the employee begins participating in the plan. For example: The XYZ Company requires that employees work for the company for six months before they are eligible to participate in the 401(k) plan. Employees can enroll in 401(k) two times per year, on January 1 and July 1. Therefore, an employee who begins working for XYZ Company on 03/01/05 has an eligibility date of 01/01/06. The eligibility date is the date on which the employee becomes eligible, provided that eligibility continues. If the employee changes to a non-eligible status, the eligibility date on the new record is set to blank.
szErrorCode	VC04A	char	NONE	NONE
This is a generic field used as a work field in Everest.